Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 15 Minute(s)
Language
English
Taught by
Ismaila Omeiza Mumuni
Rating
Course Overview
Master everything you need to know to use Microsoft Excel like a Pro. Build Dashboard and Inventory Management system
Microsoft Excel Skill for Data Analyst 2022
Scratch the surface of Microsoft of Excel to the Advanced level and become relevant in the Data ANALYTICS Industry
Why Should I Take this course?
This Excel course covers all you need to know in Microsoft Excel to the Advance level.
It is for you even if you don’t have a piece of prior knowledge about Microsoft EXCEL.
We are not just going to teach you basic functions and formulas but also help you learn how to combine Microsoft EXCEL functions to create amazing projects like Reports, Dashboards, and Inventory Management Systems plus other ways to practically use Functions and Formulas in Excel.
This course is prepared to help you gain industry knowledge on how Excel is used daily to make decisions in an organization.
What you will Learn
v Learn how to think like an advanced Excel user and write powerful and dynamic formulas and functions in Excel from the scratch.
v Master some tips you won’t find in any other courses
v How to apply formulas and functions in your project
v Create your own formulas that go according to Microsoft Excel rules
By the end of this course, you will go out there and confidently say to Employers that you are an Excel Expert without shaking of mind.
Our aim is to make you believe in yourself as we are going to take you by hand step by step on how to navigate Microsoft Excel like a pro.
After this course, you will never have problems creating dynamic and easy-to-update Excel Reports and you will create a very elegant, clean, interactive, and outstanding dashboard.
To get started all you have to do is to sign up and get the Resources file downloaded to your system. The resources are in a zip file, unzip it and join us in the class as we take you step by step on what you need to know about Microsoft Excel. See you There!
Course Content
- 10 section(s)
- 144 lecture(s)
- Section 1 Watch me First
- Section 2 Data Entry in Excel (Pro level)
- Section 3 Understand Worksheet Navigation for swift work in Excel
- Section 4 Work and get Advanced with Excel Functions
- Section 5 Understand Excel conditional functions for dynamic Report Creation
- Section 6 Data Cleaning and Transformation
- Section 7 Advanced Excel Formatting
- Section 8 Effective and Efficient way to Write Formulas and Function in Excel
- Section 9 Combining Functions to Create a Dynamic Report
- Section 10 Pivot Table for Data Analysis from the scratch to the Advanced Level
What You’ll Learn
- Learn how to use Microsoft Excel like an expert
- Learn how to help companies make better decision with data using Microsoft Excel
- Learn how to use function to analyze data
- Analyze data with Pivot Table in Microsoft Excel
- Learn how to create better charts in Excel
- Learn all the tricks you need to get better
Skills covered in this course
Reviews
-
IIbrahimOyetunji
Great
-
MMarcos Bratti Gonzalez
fue una buena experiencia pero el acento del profesor era dificil de entender
-
JJoshua Ovuakporaye
The classes are very easy to comprehend. I had no prior knowledge of excel before this class but now I know so much. Thanks to the tutor
-
OOwolaiye Adeola Stephen
the teaching is great, well done
