EXCEL ADVANCED LEVEL TRAINING (Intermediate and Advanced)
Overview:
Our Excel Advanced training will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, advanced IF conditions formulas, dashboards, pivot tables, pivot charts, goal seek, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. We also teach you how to develop these advanced solutions on the worksheet and to assemble the proper Excel tools in ways you have never thought of before. Find out how you can utilise advanced ‘IF’ statements.

Class Syllabus Training Details
Session - 1 ADVANCED EXCEL FUNCTIONS Uses of Advance Excel Formulas
VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, DSUM, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, OR, AND, SEARCH, INDEX, MATCH etc

Session - 2 ADVANCED EXCEL FUNCTIONS
Session - 3 ADVANCED EXCEL FUNCTIONS Various Methods and Uses of IF Conditions
When should use the "IF" Conditions?
Creation of Multiple IF Conditions in One Cell
Use the IF Conditions with the Other Advance Functions
How to use nested IF statements in Excel with AND, OR Functions

Session - 4
ADVANCED EXCEL OPTIONS Various Methods of Filter and Advance Filter options
Creating and Updating Subtotals
Various Methods of Text to Column options
Uses of Data Grouping and Consolidation options
Uses of Goal Seek and Scenarios Manager
Various Method of Sorting Data
Creating, Formatting and Modifying Chart
Data Validation, Creating drop down lists using different data sources
Linking Workbooks and Uses of Edit Link options
Excel Options, Customizing the Quick Access Tool Bar
Formula Auditing features and Trace formula error

Session - 5
ADVANCED EXCEL OPTIONS Pivot Tables
Various Methods and Options of Pivot Table
Using the Pivot Table Wizard
Changing the Pivot Table Layout
Subtotal and Grandtotal Options
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Select, Move & Clear Pivot data
Creating and Modifying a PivotChart

Session - 6 ACCESS DATABASE & RECORD MACRO Create a New Table and Database in MS Access
Load the Data into Access Database
Create a Query in Access Database
Create Single and Multiple Mapping Tables
Filter Single and Multiple criteria using Access Query
Create Query for Data Grouping
Create Query to Select required Columns
Retrive specific data using Logical Access Query
Create Access Query to Update, Change and Delete the Information in Access
Recording, Viewing and Editing Macro VBA code


Contact:
9941246766
9789024023
www.excelsense.com
Nungambakkam