Have any question? +91 7503962162
OVERVIEW
Well come to Apple
Tree Infotech
come with us,
This Advanced Microsoft Excel Course Syllabus is designed by Industry Experts. Our Advanced Excel Course Syllabus covers in-depth knowledge of pivot tables, audit and analyze worksheet data,VBA Macro, utilize data tools, collaborate with others, and create and manage macros with live Projects. This advanced Excel course syllabus is designed for the intermediate Excel user who desires to learn more advanced skills. Learn the most advanced formulas, functions, charts and types of financial analysis to be an Excel power user.
ADVANCED MICROSOFT EXCEL SYLLABUS
Advance Microsoft Excel
- • Goal Seek
- • Scenario Analysis
- • Data Tables (PMT Function)
- • Solver Tool
- • If Function
- • How to Fix Errors – if error
- • Nested If
- • Complex if and or functions
- • Number, Date & Time Validation
- • Text and List Validation
- • Custom validations based on formula for a cell
- • Dynamic Dropdown List Creation using Data Validation – Dependency List
- • Vlookup / HLookup
- • Index and Match
- • Creating Smooth User Interface Using Lookup
- • Nested VLookup
- • Reverse Lookup using Choose Function
- • Worksheet linking using Indirect
- • Vlookup with Helper Column
- • Creating Simple Pivot Tables
- • Basic and Advanced Value Field Setting
- • Classic Pivot table
- • Choosing Field
- • Filtering PivotTables
- • Modifying PivotTable Data
- • Grouping based on numbers and Dates
- • Calculated Field & Calculated Items
- • Arrays Functions
- • What are the Array Formulas, Use of the Array Formulas?
- • Basic Examples of Arrays (Using ctrl+shift+enter).
- • Array with if, len and mid functions formulas.
- • Array with Lookup functions.
- • Advanced Use of formulas with Array.
- • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
- • Using SLICERS, Filter data with Slicers
- • Manage Primary and Secondary Axis
- • Planning a Dashboard
- • Adding Tables and Charts to Dashboard
- • Adding Dynamic Contents to Dashboard
VBA Macro
- • What Is VBA?
- • What Can You Do with VBA?
- • Recording a Macro
- • Procedure and functions in VBA
- • What is Variables?
- • Using Non-Declared Variables
- • Variable Data Types
- • Using Const variables
- • Customizing Msgboxes and Inputbox
- • Reading Cell Values into Messages
- • Various Button Groups in VBA
- • Simple If Statements
- • The Elseif Statements
- • Defining select case statements
- • Introduction to Loops and its Types
- • The Basic Do and For Loop
- • Exiting from a Loop
- • Advanced Loop Examples
- • Using Outlook Namespace
- • Send automated mail
- • Outlook Configurations, MAPI
- • Worksheet / Workbook Operations
- • Merge Worksheets using Macro
- • Merge multiple excel files into one sheet
- • Split worksheets using VBA filters
- • Worksheet copiers
Skills and Experience
