Curriculum
- 9 Sections
- 77 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Module 1: Introduction to Data Analysis & Excel Fundamentals13
- 1.11.1 introduction to data_analysis24 Minutes
- 1.21.2 Introduction to Microsoft Excel – Excel interface and navigation essentials23 Minutes
- 1.31.3 Data Types in MS Excel9 Minutes
- 1.41.4 Data Entry in Ms Excel9 Minutes
- 1.51.5 Formatting I10 Minutes
- 1.61.6 Formatting II9 Minutes
- 1.71.7 Formatting III – Conditional Formatting I9 Minutes
- 1.81.8 Formatting III – Conditional Formatting II8 Minutes
- 1.91.9 Structured Datasets3 Minutes
- 1.101.10 Unstructured Datasets4 Minutes
- 1.111.11 Protecting a Sheet9 Minutes
- 1.121.12 Protecting a Document4 Minutes
- 1.131.13 Printing an Excel Document11 Minutes
- Module 2: Essential Excel Functions for Analysis15
- 2.12.1 Number Functions I18 Minutes
- 2.22.2 Number Functions II17 Minutes
- 2.32.3 Consolidation9 Minutes
- 2.42.4 Logical Funtions I – IF, SUMIF, COUNTIF16 Minutes
- 2.52.5 Logical Funtions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR19 Minutes
- 2.62.6 TEXT Functions15 Minutes
- 2.72.7 Time and Date Functions I9 Minutes
- 2.82.8 Time and Date Functions II13 Minutes
- 2.92.9 Time Intelligence Functions18 Minutes
- 2.102.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP10 Minutes
- 2.112.11 Lookup Functions – INDEX AND MATCH8 Minutes
- 2.122.12 Lookup Functions – WILDCARDS6 Minutes
- 2.132.13 Error Handling Functions7 Minutes
- 2.142.14 Lookup Functions – Multiple VLOOKUP6 Minutes
- 2.152.15 Other Data Analysis Functions13 Minutes
- Module 3: Data Cleaning & Preparation (ETL in Excel)10
- 3.13.1 Removing Duplicates5 Minutes
- 3.23.2 Removing Blank Rows8 Minutes
- 3.33.3 Removing Blank Columns7 Minutes
- 3.43.4 Text to Columns5 Minutes
- 3.53.5 Find and Replace3 Minutes
- 3.63.6 Data Validation I16 Minutes
- 3.73.7 Data Validation – Custom Formula19 Minutes
- 3.83.8 Searcheable Dropdown List9 Minutes
- 3.93.9 Handling Missing and Inconsistent Records9 Minutes
- 3.103.10 Introduction to Power Query24 Minutes
- Module 4: Exploratory Data Analysis (EDA)6
- Module 5: Advanced Excel Tools for Data Analysis15
- 5.15.1 Power Query – Data Cleaning7 Minutes
- 5.25.2 Power Query – Transformation6 Minutes
- 5.35.3 Power Query – Transpose1 Minute
- 5.45.4 Power Query – Unpivot3 Minutes
- 5.55.5 Data Scraping with Power Query7 Minutes
- 5.65.6 Multiple Files Combination – Append13 Minutes
- 5.75.7 Multiple Files Combination – Merge7 Minutes
- 5.85.8 Group and Aggregate3 Minutes
- 5.95.9 M Language in Power Query5 Minutes
- 5.105.10 Data Normalization I6 Minutes
- 5.115.11 Data Normalization II14 Minutes
- 5.125.12 Data Modeling8 Minutes
- 5.135.13 What IF Analysis – Scenario Manager10 Minutes
- 5.145.14 What IF Analysis – Goal Seek and Solver13 Minutes
- 5.155.15 What IF Analysis – Data Table8 Minutes
- Module 6: Data Visualization & Dashboards9
- 6.16.1 Introduction to Visualizations10 Minutes
- 6.26.2 Visualization – Pie Charts and Donought Chart14 Minutes
- 6.36.3 Visualization – Column Chart and Bar Chart6 Minutes
- 6.46.4 Visualization – Funnel Chart5 Minutes
- 6.56.5 Visualization – Waterfall Chart4 Minutes
- 6.66.6 Visualization – Line Chart8 Minutes
- 6.76.7 Visualization – Cards14 Minutes
- 6.86.8 Interactive Dashboard25 Minutes
- 6.96.9 Executive Summary8 Minutes
- Module 7: Excel Automation with Macros & AI5
- Module 8: Real-World Business Applications3
- Module 9: Capstone Project1
30 Comments
It was awesome like your name. Hoping for visual improvement like for example when you say type CTRL+SHIFT+L we should see the visual etc if you understand me.
I had an excellent tutorial in the tutorial modules. And it was delivered in a moderately easy-to-understand paste.
I can’t forget in a hurry, the day I stumbled into your Facebook advert.
Thank you and have my assurance to recommend AQSKILL to my friends.
Hello, Awesome!
I can’t find any button to get my certificate
Your email address pls
Good day Mr. Awesome,
This lesson was really awesome, thank you.
I just completed my course. How do I get my certificate?
amusanpeju@gmail.com
Thank you Mr awesome, I had a great time learning from your well arranged tutorial modules. Looking forward to learning more from your nexts courses.
Thanks.
Hello Mr Awesome, I have completed the course but having a challenge downloading the certificate.
kindly assist.
here’s my Email: diyoenoch26@gmail.com
Thanks.
I complete a course (Data analysis with Microsoft excel) but having problems with the certificate, I can’t get the certificate.
My email address
hassanbashir0979@gmail.com
Thanks
Well done JOB!!
Am really excited to complete this lesson, never know i could understand excel as explicit as this.
am grateful, Thank you.
Thank you Mr Awesome for taking your time to explain the course data analysis with excel. I have completed the course but can’t find where to download the certificate. My email is nsidibeumodioh@gmail.com
Thank you.
I really learnt a lot of new thing to up skill myself. So amazing and impressive lessons! However I am not able to see the link for certificate downloads.
I am also interested in learning other tech courses like Python, Tableau and so on.
Looking forward for your responses.
Thank you.
Thank God for coming across AQskill. I acquired more knowledge on data analysis using Excel. Thanks to Mr. Awesome for sharing your knowledge. God bless.
I had a great time with the course, learnt a lot and gained a skill. Though i feel, on the pivot tables you were a bit fast. i have completed the course but am having a challenge downloading my certificate.
Thanks for this awesome classes like your name implies. Please how do i get my certificate caause there is a mistake on the email i used to register on the platform.
All have say is to thank you (ibrahimtee24@gmail.com)
I want to sincerely appreciate the facilitator for this beautiful impactful lesson. I give this 10/10.
I want to sincerely appreciate Mr Awesome for this lesson I have been using excel but with this lesson my knowledge have improved the more thank you very much and more Grace to you on this work Mr Awesome.
I want to say a very big thanks to you Mr. Awesome Emmanuel as your name best describes you.I have actually learned alot from this course,it wolth more than it cost.
but please will like you treat course on SPSS for me.
also, am from Ghana and like to have some personal conversation with you. Email: alidumumin87@gmail.com.
Thank you once again 🙏🙏
please sir, am having a trouble in downloading my certificate.
Email: alidumumin87@gmail.com
I thoroughly enjoyed the course and had an excellent experience learning data analysis with Excel. Overall, my experience in this course was outstanding.
Thank you for this great tutorial, I have lean a lot from this lesson which have help me to complete my daily task more easily and faster.
Thank you so much for this training. It was very insightful. I will remain plugged in to your link so that I can learn more.
A VERY BIG THANK YOU FOR THIS IMPACTFUL TRAINNING
thank you so much and i have completed this course
Thank you . Very clear.
What a course, I enjoyed every part of it, you are good at what you do sir🫡🫡I just finished the course I can’t see where to get my certificate tho bandaharrison41@gmail.com
Kindly help me. Up next SQL🫡🫡
Great teaching skills, is been quit a profitable journey, God bless u Mr awesome 👏
It was such an Awesome experience going through the course materials from start to finish. Great teaching abilities and the entire materials were made easy to understand. May God bless you immensely sir. Looking forward to taking the next course.
Tutor Awesome you are more than awesome. I have watched Youtube looking for solutions to my problems. You know what I found it here. Am on my way to finish and polish my project. Thank you very much I can never regret. use waltsnyahu@hotmail.com