Advance Excel – Beginner
Information Technology Council Certification. In Advanced Excel Short term program you will learn the most advanced formulas, functions and types of financial analysis which will help you be power user of MS Excel. This Advanced MS Excel training course will build on MS Excel Crash Course and is designed specifically for Excel Spreadsheet users who are already proficient and looking to take their skills to an advanced level. This advanced tutorial will help you become a great MS Excel user. Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.
Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.
- Overview
-
Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.
BEGINNER LEVEL 1
Overview of the Basics of Excel
Designing the structure of a template
Sorting and Filtering Data
Multiple-level sorting
Custom sorting
Auto Filter
Advanced Filter
Multiple-level subtotal
Working with Reports
Data Validations
Custom validations based on formula
Protecting and unprotecting worksheets and cells
Conditional expressions
BEGINNER LEVEL 2
Vlookup
Vlookup with Exact Match, Approximate Match
VLookUP to consolidate Data
Hlookup
Xlookup
Pivot Table
Pivot charts
Formatting and customizing Pivot tables
Viewing Subtotal under Pivot
Charts
Formatting Charts
