MS Excel (Basic & Advanced)

Participant profile: Professionals (Operations,HR,Finance ,Payroll,Marketing,Sales etc)  looking to enhance their analytical skills and effective data management.

Course Outline:

  • Excel Basics
  • File Management
  • Worksheets and Tabs
  • Data Entry
  • Formatting Data-for different uses of Excel
  • Copy-Paste/Drag and Drop
  • Worksheet Formulas
  • Typical “Cross functional” Functions
  • Charts in Excel-Types and Uses
  • Finishing Touches-Spelling and Printing
  • Review of Formulas and Functions
  • Conditional Formatting and Data Validation
  • Logic and VLookup Functions
  • Text Management 1:Functions
  • Using Excel for Databases
  • Sorting and Filtering Data
  • Text Management 2:Wizards,MS Word
  • Pivot Tables
  • VBA & Macros(Basic and Advanced)

MS Office Training in Bangalore