top of page

Advance Excel Training 

Advanced Excel Course - Overview of the Basics of Excel

~ Customizing common options in Excel
~ Absolute and relative cells
~ Protecting and un-protecting worksheets and cells

 

Advanced Excel Course - Working with Functions

~ Writing conditional expressions (using IF)
~ Using logical functions (AND, OR, NOT)
~ Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
~ VlookUP with Exact Match, Approximate Match
~ Nested VlookUP with Exact Match
~ VlookUP with Tables, Dynamic Ranges
~ Nested VlookUP with Exact Match
~ Using VLookUP to consolidate Data from Multiple Sheets

 

Advanced Excel Course - Data Validations

~ Specifying a valid range of values for a cell
~ Specifying a list of valid values for a cell
~ Specifying custom validations based on formula for a cell

 

Advanced Excel Course - Working with Templates

~ Designing the structure of a template
~ Using templates for standardization of worksheets

 

Advanced Excel Course - Sorting and Filtering Data

~ Sorting tables
~ Using multiple-level sorting
~ Using custom sorting
~ Filtering data for selected view (AutoFilter)
~ Using advanced filter options

 

Advanced Excel Course - Working with Reports

~ Creating subtotals
~ Multiple-level subtotals
~ Creating Pivot tables
~ Formatting and customizing Pivot tables
~ Using advanced options of Pivot tables
~ Pivot charts
~ Consolidating data from multiple sheets and files using Pivot tables
~ Using external data sources
~ Using data consolidation feature to consolidate data
~ Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
~ Viewing Subtotal under Pivot

 

Advanced Excel Course - More Functions

~ Date and time functions
~ Text functions
~ Database functions
~ Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Advanced Excel Course - Formatting

~ Using auto formatting option for worksheets
~ Using conditional formatting option for rows, columns and cells

 

Advanced Excel Course - Macros

~ Relative & Absolute Macros
~ Editing Macro's

 

Advanced Excel Course - WhatIf Analysis

~ Goal Seek
~ Data Tables
~ Scenario Manager

 

Advanced Excel Course - Charts

~ Using Charts
~ Formatting Charts
~ Using 3D Graphs
~ Using Bar and Line Chart together
~ Using Secondary Axis in Graphs
~ Sharing Charts with PowerPoint / MS Word, Dynamically
~ (Data Modified in Excel, Chart would automatically get updated)

 

Advanced Excel Course - New Features Of Excel

~ Sparklines, Inline Charts, data Charts
~ Overview of all the new features

 

Advanced Excel Course - Final Assignment

~ The Final Assignment would test contains questions to be solved at the end of the Course

Contact Us

Follow

  • LinkedIn
  • YouTube
  • Facebook
  • Twitter
  • Pinterest

SBMC SCF- 44, 3rd Floor,

Phase 3B2, Mohali, Sector 60, 160055, India

SBMC , 16  6638 152A Street, Highland Business Centre, Surrey, BC , V3S 5X5, Canada 

SBMC, 75 Alder St, Unit III, Orangeville, ON L9W5A9, Canada

Email : hr@sbmc.co.in

Call Now : +1-289-622-0971

+91-9781027900, +91-9878967677

SBMC is affiliated with 

CPHR Canada encompassing
Entire APAC Region

©2004 by SBMC

bottom of page