Advanced Microsoft Excel Training

Taught by Microsoft Certified Trainers

  • (987)

It is a 15 hours (Instructor-Led) activity-based program, covering core fundamentals of Excel to the most Advanced Level including 60+ Formulae, Dashboards, Pivots, Charting, What-If Analysis, Grouping, Data Protection, etc. coupled with 50+ real-time Assignments, 350+ Video Lessons (Study material), Excel Shortcut Tool and On-job post-training support.

Talk to the Trainer

Know your current Excel skills through a quick pre-assessment, discuss your requirements (if any) with the Trainer and, feel your comfort level before registering for the program.

Course Fee

$499
Join a Excel Batch at $299 Click here
  • Levels Covered:
  • Basic, Intermediate and Advanced
  • Course Duration:
  • 15 Hours (5 Sessions, each of 3 Hours)
  • Mode of Training:
  • Virtual Classroom (Instructor-Led)

Our 5 Step Learning Process

Excel Learning Redefined.

Learn Excel from Microsoft Certified Trainers

LEARN from Microsoft Certified Trainers

Practice Excel with Assignments

PRACTICE with 50+ Assignments

Revise Excel with Video Lessons

REVISE with 350+ Video lessons

Speedup Excel with Tools

SPEED-UP with our Excel Shortcut Tool

Excel Onjob Support

ON-JOB Support to implement learnings

Course Content - Overview

EXCEL INTRODUCTION :
  1. A overview of the screen, navigation and basic spreadsheet concepts
  2. Understanding workbooks, worksheets, rows, columns, cells
  3. Various selection techniques
ENTERING DATA
  1. Entering, Editing and Deleting Text, Numbers, Dates
  2. Using Auto Lists
  3. Moving and Copying data
  4. Inserting, Deleting and Hiding Rows & Columns
  5. Inserting, Deleting, Moving and Copying Sheets
  6. Using navigation techniques
Customizing Excel
  1. Customizing the Ribbon
  2. Customizing the Quick Access Toolbar
  3. Using and Customizing AutoCorrect
  4. Changing Excel’s Default Options
  5. Creating a Custom AutoFill List
  6. Creating a Custom Number Format
  7. Customizing Excel Review
Managing and Navigating large Workbooks
  1. Using Workbook Views
  2. Selecting and Switching Between Worksheets
  3. Splitting and Freezing a Window
  4. Creating Headers and Footers
  5. Hiding Rows, Columns, Worksheets, and Windows
  6. Working with Multiple Workbook Windows
  7. Creating a Template
  8. Managing Workbooks Review
Creating and Editing Formulae
  1. Concept of Formulae
  2. Creating Formulae, Editing Formulae
  3. Bodmas : Mathematical Order
  4. Copying Formulae
  5. Using Functions - Sum, Average, Max,Min, Count, Counta
  6. Applying Absolute (Fixed) Referencing
Referencing Techniques
  1. Relative Reference
  2. Absolute Reference
  3. Mixed Reference
  4. Moving Range Reference
Formatting and Proofing
  1. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  2. Basic conditional formatting
  3. Copying and Clearing Formats
  4. Working with Styles
  5. Spell Check, Find & Replace and AutoCorrect
MATHEMATICAL FUNCTIONS
  1. SumIf, SumIfs
  2. CountIf, CountIfs
  3. AverageIf, AverageIfs
  4. SumProduct, Subtotal
LOOKUP FUNCTIONS
  1. Vlookup / HLookup
  2. Match
  3. Dynamic Two Way Lookup
  4. Creating Smooth User Interface Using Lookup
  5. Offset
  6. Index
  7. Dynamic Worksheet linking using Indirect
LOGICAL FUNCTIONS
  1. Nested If ( And Conditions , Or Conditions )
  2. Alternative Solutions for Complex IF Conditions to make work simple
  3. And, Or, Not
TEXT FUNCTIONS
  1. Upper, Lower, Proper
  2. Left, Mid, Right
  3. Trim, Len
  4. Concatenate
  5. Find, Substitute
DATE AND TIME FUNCTIONS
  1. Today, Now
  2. Day, Month, Year
  3. Date, DateDif, DateAdd
  4. EOMonth, Weekday
ROUNDING FUNCTIONS
  1. Round
  2. RoundUp
  3. RoundDown
  4. MRound
ERROR HANDLING FUNCTIONS
  1. isNa
  2. isErr
  3. isError
ADVANCED PASTE SPECIAL TECHNIQUES
  1. Paste Formulas
  2. Paste Formats
  3. Paste Validations
  4. Paste Conditional Formats
  5. Add / Subtract / Multiply / Divide
  6. Merging Data using Skip Blanks
  7. Transpose Tables
SORTING
  1. Sorting on Multiple Fields
  2. Dynamic Sorting of Fields
  3. Bring Back to Ground Zero after Multiple Sorts
FILTERING
  1. Filtering on Text, Numbers & Date
  2. Filtering on Colors
  3. Copy Paste while filter is on
  4. Advanced Filters
  5. Custom AutoFilter
PRINTING WORKBOOKS
  1. Working with Themes
  2. Setting Up Print Area
  3. Printing Selection
  4. Branding with Backgrounds
  5. Adding Print Titles
  6. Fitting the print on to a specific defined size
  7. Customizing Headers & Footers
IMPORT & EXPORT OF INFORMATION
  1. From Web Page
  2. Exporting to XML
  3. Creating Dynamic Dashboards and Reports Using Data on Other Applications
  4. Using Text To Columns
WHAT IF ANALYSIS
  1. Goal Seek
  2. Scenario Analysis
  3. Data Tables
GROUPING & SUBTOTALS DATA VALIDATION
  1. Number, Date & Time Validation
  2. Text Validation
  3. List Validation
  4. Handling Invalid Inputs
  5. Dynamic Dropdown List Creation using Data Validation
PROTECTING EXCEL
  1. File Level Protection
  2. Workbook Level Protection
  3. Sheet & Cell Level Protection
  4. Setting Permissions for Specific Tasks
  5. Track changes
CONSOLIDATION
  1. Consolidating data with identical layouts
  2. Consolidating data with different layouts
  3. Consolidating data with different Sheets
CONDITIONAL FORMATTING
  1. Creating Basic Conditional Formats
  2. Managing Conditions Created
  3. Dynamic Formatting using Formulas in Conditional Formatting
PIVOT TABLES
  1. Creating Simple Pivot Tables
  2. Basic and Advanced Value Field Setting
  3. Sorting based on Labels and Values
  4. Filtering based on Labels and Values
  5. Grouping based on numbers and Dates
  6. Drill-Down of Data
  7. GetPivotData Function
  8. Calculated Field & Calculated Items
CHARTS & PIVOT CHARTS
  1. Bar Charts / Pie Charts / Line Charts
  2. Dual Axis Charts
  3. Dynamic Charting
  4. Other Advanced Charting Techniques
EXCEL DASHBOARD
  1. Bar Charts / Pie Charts / Line Charts
  2. Planning a Dashboard
  3. Adding Tables to Dashboard
  4. Adding Charts to Dashboard
  5. Adding Dynamic Contents to Dashboard

What will you be able to do post-training?

  1. Have high comfort working with Excel leading to quick turnaround time
  2. Use right formulas for the given scenario
  3. Write Complex Formulae with ease
  4. Handle Excel related situations more maturely
  5. Present data with better interpretation

What's included in your training?

  1. Pre-Course Assessment
  2. Hands-On Instructor Led Training
  3. 50+ Assignments and Real-time exercises
  4. 30 Days Post Training Support (On Job)
  5. Free Study material (Online Excel Help) for 30 Days

Course Fee

For One-to-One
personalized training
$499
Join a Group or
Batch at

Contact Us

  • Mr. Perrie Smith, Business Associate
  • (650) 491-3131, (315) 633-4414
  • inquiry_excel@excelgoodies.com

Connect us on

About the Trainer

Mr.Sami (MCT, MOS, MEE)

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance and IT brings in 14 years of Industry experience. He has successfully trained 3000+ professionals by now, and the counting is still on.

He has undertaken the renowned VBA assignments with IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Learner stories around the world!

Reviews

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

Richard Carter

Data Coordinator

To sum it all, It was one on the finest sessions I've come across recently. Thanks, Sami! I am been able to approach Excel scenarios more confidently. I kind of enjoyed your Dashboard session the most.

I will surely share some work of mine soon to you. Cheers!...

Mathew L

Salesforce Data Analyst

Learning can be made really simple when you have trainers like Sami & Andrew, who can just make you good with Excel.

I truly appreciate your efforts on giving us exciting assignments to reinforce our learning. I kind of liked my whole learning process with you both...

Kathy Parker

Sr. Account Executive

I have enjoyed taking up challenging assignments in class. Looking forward to get more of it on a weekly basis to keep me always active with Excel concepts.

Since the classes are highly informative, I would insist on planning 6-7 sessions instead of 5. I would like to highlight the patience...

Brian Clark

Jr. Data Steward

What I learned in the course is when to use what formulae.

This greatly helped me to structure my worksheet in a required format and come up with some wonderful visual analysis...



Jacques Allrich

Data Control

An excellent program - I learned a lot. I am inspired to rethink the way I approach Excel tasks. Thanks, Sami & Andrew.







Other Excel Courses offered

Powerpivot - Data Analytics

View Details

Excel VBA Macro Training

View Details

Excel Training For HR

View Details

MIS Reporting with Excel

View Details