Excel Training Modules

Module 1 - Excel Basic Hours

1.Exploring Excel Features

  • Exploring Excel and its application     
  • Formatting options - basic formats and conditional formatting
  • Multiple sort and advanced filter options
  • Data validation and Subtotals

2.Functions and Formulas
  • Frequently used Math and Stat fucntions    
  • Text functions
  • Logical and Information functions
  • Date and Time functions
  • Lookup and Reference Functions
  • Consolidating and Evaluating functions
  • Named Ranges

3.Reporting and Charts
  • What-If Analysis   
  • Excel Solver
  • Pivot Tables and Charts
  • Introduction to Form controls - Dynamic Charts

Module 2 - Excel Advanced        

1.VBA Macros
  • Introduction to Macros - Recording and running macros 
  • Brief insight into VBA and OOPs concept
  • Understanding Excel objects and events
  • Customizing recorded Macros
  • Variable declaration and data types
  • Conditional Statements and Looping
  • Writing simple macros and User Defined Functions (UDF's)
  • Troubleshooting and debugging

  • Form Controls and ActiveX Controls   
  • Using Combo box, Scrolls, List box, Frames and User forms
  • Building a simple dashboard

Module 3 - Excel Connection with other Applications Hours

1.Excel and PowerPoint       
  • Understanding different connections 
  • Invoking PowerPoint from Excel
  • Creating a simple dashboard with Excel and PowerPoint connectivity

2.Excel and Access     
  • Understanding different connections 
  • Reading reading from and to Access
  • Creating a simple dashboard with Excel and Access connectivity

3.Excel and SAS 
  • Invoking SAS from Excel
  • Executing SAS codes from Excel
  • Creating a simple dashboard with Excel and SAS connectivity

No comments:

Post a Comment