MS EXCEL & ADVANCED EXCEL TRAINING

Syllabus:

MS Excel:

  • Introduction to Microsoft Excel
  • Entering and Amending Data
  • Saving and Opening Workbooks
  • Navigating and Selecting Ranges
  • Entering Formulas
  • Inserting/Deleting Rows and Columns
  • Formatting Worksheets
  • Using Simple Functions
  • Copying, Moving and AutoFill
  • Relative vs. Absolute References
  • Previewing and Printing
  • Find and Replace
  • Introduction to Range Names
  • Using Multiple Worksheets
  • Cell Styles and Conditional Formatting
  • Paste Special
  • Text and Date Formulas
  • IF Function
  • Using Charts
  • Sorting and Filtering Lists
  • Using Tables
  • SmartArt and Drawings
  • Comments and Hyperlinks
  • Importing and Exporting Data
  • Managing Range Names
  • Date and Time Formulas
  • Custom Formats
  • IF and Related Functions
  • VLOOKUP and Related Functions
  • Advanced Filter / Subtotals
  • Database Functions
  • Multiple Workbooks / Consolidation
  • Data Validation
  • Auditing
  • Pivot Tables
  • Shared Workbooks / Tracking
  • Protecting Worksheets
  • Using Templates