Advanced Excel Training in Nepal

Advanced Excel

Course Overview
Link Copied!

Advance MS-Excel Training course is targeted for data analysts, business managers, accountants, research scientists, students and other professionals for enhancing their analytical skills and strategic decision making ability. The course aims to make trainees familiar with advance MS-Excel features that are useful in performing complex business operations and overall management functions.

Skills you’ll learn

Worksheet Management : Rename, copy, hide/unhide sheets; adjust rows/columns; freeze panes; split and hyperlink sheets.
Data Entry & Formatting : Work with AutoFill, named ranges, date/time formatting, Paste Special, text formatting, filters, and grouping.
Data Sorting and Filtering : Sort by different columns, sort by custom lists, apply filters (standard and advanced), and remove duplicate entries.
Formatted Tables : Make ranges into tables, style them, add or remove rows and columns, and consolidate data.
Data Validation and Rules : Set up a validation rule which controls entries in the data.

Benefits of Advanced Excel

  • High demand for data analysts.
  • Data-oriented individuals are given more attention to details.
  • Future of data analysts is always on the rise.
  • Chances to work in international companies.

Benefits of Advanced Excel at Broadway Infosys

We have designed the course after assessing the genuine need for Advanced Excel training in Nepal. The key benefits of pursuing the Advanced Excel course at Broadway are:

  • Experts with a decade of experience as instructors.
  • Availability of Excel certifications.
  • Placement opportunity for deserving trainees.
  • Career opportunities as data analysts, data entry operators, accountants, and more.
  • Sufficient training resources.
  • Regular practical classes to implement Advanced Excel skills in real work scenarios.

Our graduates are hired by 350+ companies in Nepal

Time for you to be the next hire. With our advanced and industry relevant courses, you are on the right stage to start your dream career.
Our graduates are hired by

Lesson 1:

  • Set file properties
  • Define custom properties
  • Add a button to the Quick Access Toolbar
  • Customize the Ribbon
  • Change default number of worksheets, fonts and default view in the workbook
  • Protect Workbook
  • Protect Sheet
  • Set a password for a workbook
  • Saving a worksheet as a PDF file

  • Creating a new workbook is a straightforward process
  • Rename a worksheet
  • Copy a worksheet to another workbook
  • Change the order of worksheets in a workbook
  • Hide a worksheet
  • Unhide a worksheet
  • Make a sheet very hidden
  • Delete a worksheet
  • Change a row's height or column's width
  • Insert a column or row
  • Delete a column or row
  • Hide a column or row
  • Unhide a column or row
  • Insert a cell
  • Delete a cell
  • Move a group of cells to a new location
  • Zoom in or out to a specific zoom level
  • Change to another open workbook
  • Arrange all open workbooks in the program window
  • Display copies of the same workbook
  • Activate a worksheet
  • Change the color of a sheet tab
  • Create a hyperlink
  • Edit a hyperlink
  • Delete a hyperlink
  • Comparing sheets side by side
  • Splitting the worksheet window into panes
  • Keeping the titles in view by freezing panes

  • Entering data automatically with autofill
  • Selecting Ranges
  • Selecting special types of cells
  • Placing Information into multiple cells simultaneously
  • Check spelling
  • Using AutoCorrect for shorthand data entry
  • Hiding or grouping rows and columns
  • Entering numbers with fractions
  • Formatting numbers
  • Formatting numbers using the Format Cells dialogue box
  • Changing text alignment
  • Create a name using name dialogue box
  • Create a named range from a selection
  • Display the Name Manager
  • Edit a named range
  • Working with dates and time
  • Pasting in special ways
  • Performing mathematical operations without formulas
  • Skipping blanks when pasting
  • Transposing a range
  • Paste Link

  • Sort a data list
  • Sort a data list by values in multiple columns
  • Add a sorting level
  • Delete a sorting level
  • Sort worksheet data by a custom list of values
  • Organize worksheet data into groups
  • Show and hide levels of detail in a grouped data list
  • Remove grouping levels from a data list
  • Apply a filter to a worksheet
  • Clear a filter
  • Display the top or bottom values in a column
  • Create a custom filter
  • Special Filter for Dates, Text, and Numbers
  • Advanced Filter
  • Calculating formulas across worksheets
  • Import data from an external source

  • Create a data table
  • Changing the Look of a Table
  • Add new rows or columns
  • Setting table options
  • Removing duplicate rows from a table
  • Multiple-column sorting
  • Converting a table back to a range

  • Data Validation
  • Create a validation rule
  • Dynamic Validation List

  • Creating Formats on the basis of Data
  • Setting rules for Conditional formats
  • Using multiple Formatting
  • Removing or clearing Formatting

  • Display data bars in one or more cells
  • Display a color scale in one or more cells
  • Display icon sets in one or more cells
  • Apply a conditional format to a cell
  • Edit a conditional formatting rule
  • Delete a conditional formatting rule
  • Create a PivotTable from a data list
  • Pivot a PivotTable
  • Show or hide the PivotTable Field List task pane
  • Rename a PivotTable
  • Control how and where subtotals and grand totals appear in your PivotTable
  • Change the PivotTable summary function
  • Filter a PivotTable
  • Apply a number format to a PivotTable
  • Apply a conditional format to a PivotTable
  • Create a new PivotTable style
  • Apply a PivotTable Style to a PivotTable
  • Consolidate data with Pivot Table
  • Change Pivot Table Calculations
  • Make manual calculation in Pivot Table
  • Setting Geographical data in 3D map

  • Using auditing to diagram
  • Using Evaluation in Excel
  • Working with Goal Seek
  • Predict data and generating Visual Forecast sheet
  • Using Scenarios in formula

  • Printing row and column titles
  • Scaling printed output
  • Force Excel to print using a specific number of pages
  • Printing cell gridlines
  • Change the order in which worksheets print
  • Print part of a worksheet
  • Center material on the printed page
  • Print a chart
  • Add a header or footer to a worksheet
  • Create an Auto Header
  • Add an image to a header or footer
  • Format an image in a header or footer

  • Basic principles of using functions and formula
  • Practice with Basic calculations
  • Creating Reference and absolute cells in using Formula
  • Building links among the cells
  • Practice with various Formulas and Functions
  • Nested functions in creating advance formulas
  • Tricks and techniques of using multiple formulas for returning desired output

  • Add a comment to a cell
  • Edit a comment
  • Delete a comment
  • Adding Comments to Cells
  • Changing a comment’s shape
  • Printing Comments

  • Create a chart
  • Choosing Chart types
  • Change how Excel plots your data
  • Remove a series from an axis
  • Add a series to an axis
  • Move a chart to its own worksheet
  • Apply a Chart Style to a chart
  • Apply a different layout to a chart
  • Change the appearance of a chart's gridlines
  • Select a chart element for formatting
  • Select a data point in a series
  • Format a chart element
  • Save a chart as a chart template
  • Add a trendline to a chart
  • Create a PivotChart
  • Change the chart type of a chart or PivotChart
  • Setting Geographical data in 3D map

  • Understanding macros
  • Recording macros
  • Running and editing macros
  • Assigning macros to buttons

  • Using Excel keyboard shortcuts

  • Using conditional formatting
  • Formatting numbers and dates
  • Formatting text

  • Using Excel templates
  • Using Excel tables
  • Using named ranges
  • Using data validation

  • Customizing the Quick Access Toolbar
  • Customizing the Ribbon
  • Customizing Excel options
Earn a High Value Industry Certificate

Add this credential to your LinkedIn profile, resume, or CV to stand out to recruiters.

Upcoming Classes (7)
03 Aug 2025
06 Aug 2025
11 Aug 2025
17 Aug 2025
18 Aug 2025
24 Aug 2025
25 Aug 2025