Students who got hired learning with us
Hear from graduates who have completed our courses.
Advanced Excel Training in Nepal
Basic and Advanced Microsoft Excel Training in Kathmandu, Nepal
Thousands of students have started their careers after getting certified by Broadway Infosys
Updated On: 17/07/2026
Created On: 05/09/2017
Course Overview
The Advanced MS Excel training course is for data analysts, business managers, accountants, research scientists, students, and other professionals. The course starts from basic Excel concepts and moves step by step to advanced levels. It helps participants build strong analytical skills and improve strategic decision-making.
The training focuses mostly on advanced Excel features for complex business operations and management tasks. Participants practically acquire the ability to handle data, produce reports, analyze trends, and perform everyday business activities more efficiently.
Tools Covered
Some of the major industry-relevant tools you'll work with in this course include:
-
PivotTables
-
Macros/VBA
-
Data Validation
-
Conditional Formatting
-
Goal Seek
-
PivotCharts
-
3D Maps
What Our Students Say About Advanced Excel Training
Ms. Rojina Rai
Advanced Excel
After completing the Advanced Excel class, I have significantly improved my knowledge and confidence in using Excel. The class provided practical learning opportunities covering formulas, functions, Pivot Tables, charts, and other important Excel features. The concepts were explained clearly and...
Ms. Rabita Ray
Advanced Excel
Good experience, a friendly teacher, and a nice study environment. Definitely recommend it to anyone trying to learn.
Ms. Tenzin Dolkar
Advanced Excel
The classes are engaging, and the tutors are incredibly supportive and knowledgeable. It will be worth your time to take classes here.
College/Faculty: Benedictine Academy / BBA
Working At: MayaHold Group
Position: Work Force Management
College/Faculty: Apex College / MBA
Working At: Bella Casa International
Position: Logistics and Procurement Officer
College/Faculty: Tribhuvan University / BBS
Working At: Islington College
Position: External Partnership Officer
Our graduates are hired by 470+ 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.
Earn a High Value Industry Certificate
Add this credential to your LinkedIn profile, resume, or CV to stand out to recruiters.
Already earned a certificate?
Verify it here
Frequently Asked Questions
Basic knowledge of Microsoft Excel is recommended. Familiarity with formulas and basic spreadsheet operations will help you get the most out of the advanced topics.
The training is designed for learners who already have basic Excel knowledge and want to develop advanced skills for data analysis, reporting, and workplace productivity.
You will learn advanced formulas and functions, data analysis, PivotTables, charts, dashboards, data cleaning, reporting, automation, and other techniques for working efficiently with large datasets.
You will work with advanced functions such as XLOOKUP, INDEX-MATCH, IF functions, SUMIFS, COUNTIFS, TEXT functions, dynamic arrays, and other functions used for complex data analysis.
Yes. You will learn how to create and customize PivotTables and PivotCharts, summarize large datasets, identify trends, and generate meaningful business insights.
Yes. You will learn how to create professional and interactive dashboards using charts, PivotTables, slicers, formulas, and other visualization techniques.
Yes. The training introduces automation techniques that can reduce repetitive tasks and improve efficiency when working with large datasets and recurring reports.
Yes, where applicable, you will learn techniques for importing, cleaning, transforming, and preparing data for analysis and reporting.
Yes. You will learn how to use Excel to prepare financial reports, sales reports, performance reports, analytical dashboards, and other business reports.
You will be able to analyze large datasets, create advanced formulas, build dashboards, automate repetitive tasks, prepare professional reports, and present data-driven insights using Excel.
The training is useful for accountants, finance professionals, business analysts, data analysts, managers, administrators, students, and working professionals who use Excel for reporting and data analysis.
You will receive hands-on guidance from trainers throughout the course, including support with formulas, data analysis, dashboards, practical exercises, assignments, and real-world Excel tasks.
Yes. Depending on your requirements, you can discuss suitable schedules with the training team. One-to-one training and group-based learning options may also be available.
Our course is available in hybrid training mode. You can attend classes in person or join online, whichever works best for you. If you cannot attend in person on a particular day, you can simply join the class online instead.
The course pricing varies depending on the subject and level. For detailed information on the course price, please contact us directly at +977-9841002000 / +977-1-4111849. Our team will be happy to guide you, or you can email us at [email protected].
Our syllabus outlines are only the headlines of the major modules. To ensure a complete understanding of the course, we offer free counseling. Also, if you have specific modules in mind, you can customize the course. Send your inquiry today!
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
Lesson 2: Advanced Excel Skills
- Understanding macros
- Recording macros
- Running and editing macros
- Assigning macros to buttons
Lesson 3: Excel Tips and Tricks
- 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
Tally Training
Manual Accounting Training
Power BI Training
SPSS Training
Income Tax Vat Training
STAAD - Pro Training
Upcoming Classes (5)
Why Advanced Excel?
Essential Workplace Skill: Build advanced Excel skills for handling data, reporting, analysis, and everyday business tasks.
Advanced Data Analysis: Learn formulas, functions, PivotTables, charts, dashboards, and other tools to work with complex data.
Automation & Efficiency: Use advanced Excel features to reduce repetitive work and improve accuracy.
Practical Learning: Attend regular hands-on classes to apply Advanced Excel skills to real-world work scenarios.
Career-Ready Skills: Strengthen your Excel knowledge for roles in finance, accounting, administration, management, data analysis, and other fields.
Experienced Instructors: Learn from instructors with over a decade of teaching experience.
Quick Inquiry
Choose class schedule(s)
-
13 Sep 2026
-
14 Sep 2026
-
20 Sep 2026
-
22 Sep 2026
-
28 Sep 2026