Microsoft Excel offers simple data solutions for a variety of organizations and users, such as basic calculations, advanced data analysis, and data visualization.

A high level of proficiency in Excel gives you a competitive edge at work because it is a highly sought-after skill.

The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions

Join our training on ADVANCED MICROSOFT EXCEL to utilize the business intelligence tools in Excel for easy data analysis, manipulation and combining.

[b]Course Modules for this advanced excel class:[/b]

Module 1. Spreadsheet Design and Documentation – N10,000
Module 2. Advanced Formula Techniques – N10,000
Module 3. Financial Functions and Working with Dates – N10,000
Module 4. Advanced Lookup Functions – N10,000
Module 5. Data Cleaning and Preparation – N10,000


What you will learn from this advanced excel class:

1. You will learn how to use dynamic and automated fixes, clean messy data, automate these processes through functions, and ensure data remains clean dynamically. We will use functions to fix dates, replaces blanks, and remove unwanted characters from data – all to help us build an efficient solution that lasts.
2. You will learn to apply date formulas in calculations, create loan schedules with financial functions, as well as use depreciation functions.
3. You will learn how to build on your array capabilities and explores a range of functions to create dynamic lookup ranges – INDIRECT, ADDRESS, OFFSET, and INDEX.
4. You will learn how to design flexible and auditable spreadsheets, construct transparent calculations, create user-friendly navigation, and use styles, themes, and formatting to tie it all up in a nice bow.
5. You will learn how to use dynamic and automated fixes, clean messy data, automate these processes through functions, and ensure data remains clean dynamically.
As a valued professional, you will also get:

A certificate of completion
A digital training badge
Access to internationally top-rated Self-Discovery Assessment
Membership of TDI’s International Affiliate Program
Opportunity for a redeemable gift card
REGISTER NOW:

Time: 9am

Total Module Fee: NGN 50,000

Venue: Virtual/Webinar

This advanced excel class is designed for:

Individuals and Professionals who want to be proficient using Microsoft Excel.

This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.

HOW TO MAKE PAYMENTS FOR THE ADVANCED EXCEL CLASS

Make payment to our bank using the details below:

TDI Global Limited
1216906531
Zenith Bank

For more enquiries, call/WhatsApp 08129071529 or mail to digital2@my3dcoach.net