This event has been UPDATED since it was first published. View the UPDATED & Detailed Advanced Microsoft Excel Training course for beginners Information here.

16 Hours Advanced Microsoft Excel training is a 4 weeks long Instructor-led and guided training with Practical Hands-On Lab exercises to be taught over 16 hours, 2 sessions per week, 2 hours per session.

• The medium of instruction is English.
• All Published Ticket Prices are in US Dollars.

16 Hours Advanced Microsoft Excel Training Course Schedule

• April 27, 2021 - May 20, 2021 US Pacific time
• 4 Weeks | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time
• 8:30 AM - 10:30 AM US Pacific time each of those days
• Please click here to add your city name and check your local date and time for the first session to be held on April 27, 2021 at 8:30 AM US Pacific Time.

Features and Benefits

• 4 weeks, 8 sessions, 16 hours of total Instructor-led and guided training
• Training material, instructor handouts and access to useful resources on the cloud provided
• Practical Hands-on Lab exercises provided
• Actual code and scripts provided
• Real-life Scenarios

What you will learn?

• Basic Excel
• Intermediate Excel
• Advanced Excel

Who should attend

• Anyone who is interested in learning Advanced Microsoft Excel.
• Accountants

Course Outline

1. Basic Excel

• Introduction

• Basic Calculations

• Microsoft Office Button

• Using worksheets effectively

• Formatting text and numbers

• Saving Excel 2007 files

• Saving an Excel file as a PDF file

• Inbuilt Functions

• Sort Function

• More on sort data

• Formatting data as tables

• Absolute and relative cell reference

• Page layout and print preview

• Printing: display grid lines

• Conditional Formatting

• Charts

• Text to columns

• Auto-filter

2. Intermediate Excel

• Library functions use

• How to avoid auto hyperlinks

• Fill data across worksheets

• How to use comments

• How to remove duplicates

• Template based workbook

• Themes and smartart diagrams

• ‘IF’ function

• Countif

• Nested IF functions

• Advanced filter

• Named ranges

• Subtotals

• Formatting in-cell graphs(conditional format)

• Data validation

• Custom Data Validation

3. Advanced Excel

• Pivot Tables

• Vlookup/Hlookup

• Absolute range calculations

• Goal Seek

• Get external data – text files

• Import data from databases

• Import data from an Excel file

• Array Formulas

• Calculations in Word

• Data tables and sensitivity analysis

• Printing: Repeat specific rows

• Excel Help – Vlookup