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.

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 training.ng@tdi-global.com