Advanced Excel Course In Mumbai
Duration: 2 Days
Microsoft Excel, Level 2 (Office 356, Office 2016, Office 2013, Office 2010)
Participants should be using Excel, and the common formula’s like Min, Max, Sum, Average, functions such as Sort & Filter.
Having additional knowledge of VLOOKUP & Pivot Table’s would be an advantage.
Audience
Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.
Prerequisites
Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.
This Advanced Excel Course will empower the participants to be able to do the following:
- Performing complex calculations more efficiently, using various Excel functions.
- Organizing and analyzing large volumes of data.
- Creating MIS reports.
- Designing and using templates.
- Consolidating and managing data from multiple workbooks.
Advanced Excel Course Module 1: Overview of the Basics
- Customizing common options in Excel
- Absolute and relative cells
- Protecting and un-protecting worksheets and cells
Advanced Excel Course Module 2: Working With Functions
- Writing conditional expressions (using IF, NESTED IF)
- Using logical functions (AND, OR, NOT, COMPOUND IF)
- Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH,
- INDEX, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH)
Advanced Excel Course Module 3: Data Validations
- Specifying a valid range of values for a cell
- Specifying a list of valid values for a cell
- Specifying custom validations based on formula for a cell
Advanced Excel Course Module 4: Working with Templates
- Using templates for standardization of worksheets
Advanced Excel Course Module 5: Sorting and Filtering Data
- Sorting tables
- Using multiple-level sorting
- Using custom sorting Filtering data for selected view (AutoFilter) • Using advanced filter options
Advanced Excel Course Module 6: Designing the structure of a template
- Creating subtotals
- Multiple-level subtotals
- Creating Pivot tables
- Formatting and customizing Pivot tables
- Using advanced options of Pivot tables
- Pivot charts
- Consolidating data from multiple sheets and files using Pivot tables
- Using external data sources
- Using data consolidation feature to consolidate data
Advanced Excel Course Module 7: More Functions
- Date and time functions
- Text functions
- Database functions
Advanced Excel Course Module 8: Formatting
- Recording a Macro
- Assigning a macro to a button
- Relative & Absolute reference for a macro
Advanced Excel Course Module 9: Macros
- Using auto formatting option for worksheets
- Using conditional formatting option for rows, columns and cells