Position yourself for a data analyst entry role with this Advanced Microsoft Excel Online course. This Excel course will show you how to format spreadsheets, use excel formulas, create charts, Vlookup, Hlookup, Pivot tables and Pivot Charts, Data Validation etc
What you will learn
Join this excel training before the offer goes away. Get 50% discount on the course. New Cohort Starts June 3rd, 2023
Fee: ₦30,000 . Limited time offer ₦15,000
Course Content
Lesson 1 - Introduction to Microsoft Excel
Students are introduced to Microsoft Excel spreadsheet application, basic formatting, cell and column manipulation
Lesson 2 - Conditional Formatting & tables
Students learn how to use conditional formatting, create tables and more
Lesson 3 - Excel Formulas
Learn to use simple to advanced formulas like Sum, if, average, Sumif, Count, Countif, Max, Min Sumifs, Countifs, Vlookup, Hlookup, Match & index etc
Lesson 4 - Creating charts in Excel
Create different types of excel charts such as line charts, bar charts, pie charts and more
Lesson 6 - Using sort and Filter, Flash fill
Learn to use sort and filter, flash fill and more
Lesson 7 - Data cleaning, Validation & text to columns
Learn how to perform data cleaning, use data validation in excel, and text to column
Lesson 8 - Pivot Tables & Pivot Charts
Learn how to use Pivot tables and charts to summarise data effectively. Create beautiful excel dashboards
Lesson 9 - Power Pivot & Power Query
Optimize your pages to rank for hot keywords, check your page speed and setup google search console.
Lesson 10 - Course Wrapup & Capstone Project
In conclusion we take a summary of the excel course. Students are expected to complete a capstone project.
You don’t need any prior Knowledge of Excel. Start manipulating excel data like a pro. This Online Excel course will make it happen in 2 weekends of classes (Saturday 10am -12pm & Sunday 3pm – 5pm)
Join this excel training before the offer goes away. Get 50% discount on the course.
Fee: ₦30,000 . Limited time offer ₦15,000
Email us here
Send us an email and a company representative will to get back to you.
Call us Now
If you prefer, you can call or chat with a company representative
Chat Now
Save time by contacting us on Whatsapp. Hit the chat Now button below