Advanced Excel Training

Advanced Excel Training

Course Description

Participants who have basic and intermediate knowledge of Excel should take Advanced Excel Training. This course will enhance their understanding of the use of Excel.

Additionally, the facilitator will discuss, in detail, the functions and features available in Microsoft Excel. At the same time, each participant of this course learns how to use different logical and statistical functions. They will also learn to import and export data, use simple database access, and create and use macros.

The course will then keep you engaged by providing a combination of video lectures, course notes, take-away templates, quizzes, exercises, and even homework. Also, this is an excellent opportunity to add practical Excel focus to what you learn in the program.

The depth and breadth of Advanced Excel Training topics we selected are challenging and rewarding, providing a 360-degree approach to modeling in Excel. Our strong focus on real-world examples ensures a super hands-on Excel experience. We design a process that allows you to learn and see how participants apply this in practice.

Advanced Excel Training is by professionals for professionals, so if you are looking to improve your knowledge and use hands-on practical applications of Microsoft Excel in the workplace.

Course Objectives

At the end of this 1 day course participants are expected to learn the following:

• Use Logical Functions
• Use Other Math Functions
• Use DATE Functions
• Use TIME Functions
• Using Arrays
• Use Lookup functions
• Data Validation
• Use Database Functions
• Import & export text files, XML data
• Create scenarios
• Using Macros

Course Modules

To achieve these objectives, Advanced Learning Programs (ALPs) will use the below Lesson Plan:

Lesson 1 – Introduction

• Introduction
• Participants Expectations
• Plan and Execution

Lesson 2 – Logical and statistical functions

• Logical functions
• Math and statistical functions

Lesson 3 – Data functions

• Financial functions
• Date and time functions
• Using Arrays
• Displaying Formulas

Lesson 4 – Lookups and data tables

• Using lookup functions
• Using MATCH and INDEX
• Using data tables

Lesson 5 – Advanced data management

• Cell Validation
• Database functions

Lesson 6 – Exporting and importing

• Exporting and importing text files
• Exporting and importing XML data
• Getting external data

Lesson 7 – Analytical Tools and Scenarios

• Goal Seek and Solver
• The ToolPak
• Using Scenarios

Lesson 8 – Macros

• Using Macros
• Working with VBA code
• Creating Functions