Data Analysis With Excel & Power BI (Subscription-Based)
Subscribe to our monthly membership of just N10,000 to get full access to the course. WHY IS IT SO IMPORTANT TO LEARN TECH EASILY NOW? JOB LOSS/UNEMPLOYMENT: According to the World Economic Forum’s Alarming Future of Jobs Report 2023, …
Subscribe to our monthly membership of just N10,000 to get full access to the course.
WHY IS IT SO IMPORTANT TO LEARN TECH EASILY NOW?
- JOB LOSS/UNEMPLOYMENT: According to the World Economic Forum’s Alarming Future of Jobs Report 2023, nearly a quarter of all jobs (23%) globally will change in the next five years. Across 45 economies, covering 673 million workers, and 83 million jobs will be eliminated. Technology, Automation and Artificial intelligence will replace some 85 million jobs by 2025.
- ECONOMIC HARDSHIP/POOR PURCHASING POWER: Nigeria’s economy has hit boiling point with over 150 million Nigerians living below the poverty line. With the current economy, the naira has lost 70% of its value and fuel costs are soaring and the prices of food and transport have tripled.
- LOSS OF OPPORTUNITIES: Sadly, without a tech skill you can hardly appeal for promotions or get job growth opportunities, work remotely from the comfort of your home, increase your earnings, or even take advantage of global opportunities that technology has to offer.
WHAT YOUR TRANSFORMATION WOULD LOOK LIKE IN FEW DAYS
- CONFIDENCE, REDUCED ANXIETY AND INTIMIDATION IN LEARNING TECH: As a platform that demystifies the complications of learning a tech skill, we will make you confident as a technology professional in a few days with our easy to learn and convenient learning.
- AN EMPOWERED TECH PROFESSIONAL: As an empowered tech professional your earning status and income will change immediately as you can earn in foreign currencies or get an increase in your salary, transition to a new job/company, get the needed promotion, get a global/international job and relocate abroad, travel the world as a digital nomad, travel for vacation, have more purchasing power and spend more quality time with family.
- CONTROL YOUR LIFE WITH REMOTE WORK: You now have the power to control your life and time as you can work remotely at the comfort of your home.
COURSE DESCRIPTION
This course is designed to provide participants with the essential skills and knowledge required to analyze large data sets using Microsoft Excel. The course covers advanced Excel functions, data visualization, and data modeling techniques.
Students will learn how to import, clean, and transform data, and how to apply statistical methods to analyze data. They will also learn how to create charts, graphs, and dashboards using Excel and Power BI.
What You’ll Learn
- Essential Excel functions for data analysis.
- Creating pivot tables and charts.
- Data cleaning and manipulation techniques.
- Advanced formulas for data analysis.
- Statistical analysis in Excel.
- Visualizing data trends with charts and graphs.
- Data wrangling and preprocessing techniques.
- Machine learning algorithms and applications.
- Evaluating and fine-tuning models.
- Data visualization and storytelling.
- Real-world data science projects.
- Presenting data-driven recommendations.
Ready to get started? Click on the subscribe now button. You can also get started with our free trial here.
Curriculum
- 8 Sections
- 72 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- 0
- Module 113
- 2.101 Introduction to Ms Excel
- 2.202 Exploring Excel Interface
- 2.303 Understanding Excel IntterfacePractical
- 2.404 How excel inerprets inputs & basic formula’s
- 2.505 Working with Shortcuts
- 2.606 Basic Excel Functions
- 2.707 Basic Excel Functions 2
- 2.808 Using Paste special
- 2.909 Sorting & filtering
- 2.10010 Advanced Filtering
- 2.11011 Cell Referencing Intro
- 2.12012 Cell Referencing Demo
- 2.13Excel – Week 1 Assessment1 Question
- Module 219
- 3.101 Creating Basic Charts
- 3.202 Creating Column Charts
- 3.303 Formatting your Chart
- 3.404 Formatting Chart II
- 3.505 Moving Chart To Another Sheet
- 3.606 Working with Pie Chart
- 3.707 Name Ranges in Excel
- 3.808 Advantage and Disadvantages of Name ranges
- 3.909 If function & Named Range
- 3.1010 Using the And Logical Function
- 3.1111 Combining If & AND logical functions
- 3.1212 Using COUNTIF
- 3.1313 Working with SUMIF
- 3.1414 Working with IFERROR
- 3.1515 Working with Vlook UP
- 3.1616 Working with Hlook Up
- 3.1717 Intro to Pivot Tables
- 3.1818 Creating a Pivot
- 3.1919 Grouping & Formatting your PIVOT
- Module 35
- Module 49
- Module 58
- Module 68
- Module 711
- 8.101 DAX Introduction
- 8.202 Creating your first Measure
- 8.303 Using Iteraring Aggregators
- 8.404 Why Creating a Date Table is Important
- 8.505 Generating our DateTable with CalenderAuto & Year
- 8.606 Creating other Month Attribute & Commenting on Dax code
- 8.707 Testing Column Sort
- 8.808 Calculate function
- 8.909 Using the OR operator
- 8.1010 Time Intelligence functions
- 8.1111 Creating a folder for Measures