Advance Excel Training

About this course

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

Additionally,  a deeper understanding of the functions and features available in Microsoft Excel. While each participant of this course learns how to use different logical and statistical functions. They will also get knowledge on importing and exporting data.  Using simple database access and creating and using 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 a great opportunity to add practical Excel focus to what you learn in the program.

The depth and breadth of Advanced Excel Training topics we selected is 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 things are applied in practice.

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

Things You Might Need for this Course

Course Objective

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

 

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 your own functions