Advanced Excel

Learn advanced Excel skills like Pivot Tables, VLOOKUP, Macros!

Introduction

This course will provide you with the essential skills and knowledge to master the Microsoft Excel program. You will learn how to use the powerful features of Microsoft Excel to create professional spreadsheets. Our experienced instructors will guide you through each program step-by-step, helping you develop the confidence to use and apply these programs to any project or task. By the end of this course, you will be able to work with Microsoft Excel quickly and efficiently.

The main goal of the course is to provide the students with advanced knowledge of Microsoft Excel. This course covers the advanced features of Microsoft Excel.

Schedule

Duration: 4 weeks (24 Hours)

(2 hours per session) - (3 sessions per week)

Course Outline

Working with VLOOKUP
Using Macros
Using Excel Addins
Importing and Exporting Data
Workbook Protection
Data Validation
Statistical Functions
Financial Functions
Working with Charts
Using Pivot Tables
Summarizing Data