Advanced Excel
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.
Talk to us

COURSE OVERVIEW

Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool.

Advanced Excel Courses aid students in becoming world-class financial analysts in firms such as private equity, investment banking, equity research, corporate development, and Financial Planning and Analysis sectors.

Pre-requisite: Advanced Excel Courses aid students in becoming world-class financial analysts in firms such as private equity, investment banking, equity research, corporate development, and Financial Planning and Analysis sectors.

ADVANCED EXCEL COURSE MODULES

DESIGN AND RISK IN EXCEL

• Addressing modes in formulae
• Efficiency and Risk
• Data Validation

ADVANCED TECHNIQUES

• Functions
• Array Formulae
• LOOKUP functions
• Advanced Range Names
• What If Analysis
• Problem Solving

EXCEL INTERACTIVITY

• Form Controls
• Visual Basic and Macros
• VBA Programming

SPREADSHEET IMPACT

• Practical Interactivity with VBA
• Conditional Formatting
• Graphics Tricks and Techniques

TURNING DATA INTO DECISIONS

• Working with External Data
• Advanced Uses of PivotTables
• PowerPivot
• Reporting with PowerPivot

COURSE ORGANISATION & TIMING

We have created a schedule for this course to match with most availabilities.

The course is modular. Courses are hands-on(25% theory, 75% practice)

BENEFITS OF THIS COURSE

There are many benefits in taking an Advanced Excel course. 

RELATED COURSES - ARTICLES

IOT Application – Smart Home

A smart home is a residence that uses internet-connected devices to enable the remote monitoring and management of appliances and systems, such as lighting and heating.

Read More »

Vacation Courses

Sharpen Your IT Skills and make your holidays more productive Summer Vacation Courses Table of Contents LEVEL 1  LEVEL 2  Course Organisation Level 1 This set of topics is best

Read More »

GET IN TOUCH

Infoclub Ltd has proudly served IT Professionals seeking to enhace their skillsets with the latest certification in IT with excellence for over 30 years.

You can contact us through the following:

Email: Infoclubltd@yahoo.com

Phone & Whatsapp: +230 2411533

Or fill in the form on the right.

FOR PRICING & REGISTRATION, SEND US A MESSAGE

error: Active Learning Copyright content