EXCEL PROGRAMMING

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

2.Controls

• 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