
- Instructor: TDIGlobal
- Students: 34
- Duration: 2 days
Course Modules for this advanced excel class:
- Spreadsheet Design and Documentation – N10,000
- Advanced Formula Techniques – N10,000
- Financial Functions and Working with Dates – N10,000
- Advanced Lookup Functions – N10,000
- Data Cleaning and Preparation – N10,000
REGISTER NOW:
Time: 9am
Total Module Fee: Â NGN 50,000
Venue: Virtual/Webinar
REGISTER HERE TO ATTEND
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.
Course Modules for this advanced excel class:
- Spreadsheet Design and Documentation – N10,000
- Advanced Formula Techniques – N10,000
- Financial Functions and Working with Dates – N10,000
- Advanced Lookup Functions – N10,000
- Data Cleaning and Preparation – N10,000
What you will learn from this advanced excel class:
- 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.
- You will learn to apply date formulas in calculations, create loan schedules with financial functions, as well as use depreciation functions.
- 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.
- 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.
- 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