MS Excel

Basic - Working with Functions – Formula’s

Building a strong foundation
  • Introduction about Excel & why we are using excel
  • What is function and formula
  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options
  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP)
  • 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
  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells.
  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Date and time functions
  • Text functions
  • Creating Pivot tables
  • How to create report using with formulas
  • Create Report using with multiple function and formulas

Advance - Working with Reports along with formulas and Macro

The road to deep drive
  • Introduction about excel macro vba
  • Creating subtotals
  • 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
  • Viewing Subtotal under Pivot
  • Creating Slicers ( Version 2010 & Above)
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Data Modified in Excel, Chart would automatically get updated
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Absolute and relative cells
  • Protecting and un-protecting worksheets and cells
  • The Final Assignment would test contains questions to be solved at the end of the Course
  • Intro about Vba_macro
  • Create program in Excel vba for Excel automation
  • Live project based on organization through excel VBA automation