Overview
Curriculum
Instructor
FAQs

Instructor: TDIGlobal
Students: 34
Duration: 2 days

Categories: Business

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

Curriculum is empty

TDIGlobal

What version of Excel do you teach?

In this course, we are using Microsoft Excel 2016 (Office 365) on a Windows PC with all options set to default. The Office 365 version of Excel is the latest version at the time of writing and developing this course. If you have a different version of Excel or you are using a Mac, some tools and buttons will look different, they may be located in a different spot, or some might be missing altogether. If there are any major differences, we usually point them out during the practice videos. If you cannot find a tool that we mention, you can always ask in the forums or search the Internet. Most of the functionality we demonstrate is also available in other spreadsheet programs, although the interface will look different. Most other spreadsheet software can import and export files in the Microsoft Excel format. If you are not sure which version of Excel you are using, check the Microsoft support pages for help. If you cannot use Excel 2016 on a PC, you will be able to follow along with the videos, however, please note that some of the assessment tasks will require Excel. Where possible, we have designed assessment tasks so that users of older versions of Excel (such as 2013) can still solve them.