Advanced Excel – Module 1



Module 1 – 3 hours

  1. Analysis ToolPak – financial data analysis.
  2. Analysis ToolPak – statistical data analysis.
  3. Analysis ToolPak – engineering data analysis.
  4. Range: AutoFill and Fibonacci Sequence
  5. Tricks in Custom Lists, Comments, Hide Columns or Rows, Skip Blanks, AutoFit, Transpose, Union
    and Intersect and Flash Fill
  6. Few Formulas and Functions, Names in Formulas, Dynamic Named Range, Paste Options, Status
    Bar, Quick Operations, Not Equal To, Cm to inches and Discount
  7. Customizing the Ribbon, Quick Access Toolbar and Developer Tab
  8. Tricks in Worksheets – Zoom, Split, Freeze Panes, Group Worksheets, Consolidate, View Multiple
    Worksheets, Get Sheet Name and Spelling


There are no reviews yet.

Be the first to review “Advanced Excel – Module 1”

Your email address will not be published. Required fields are marked *