Reporting and Analytics with Excel

  • by Emmanuel Bassey
  • English

Course Description

We live in a world of data. You engage with data when you publish on Facebook or LinkedIn. You engage with data when you leave a comment on a friend's post or like their photos or comments. Every day, we generate and use data. By sharing content, like photographs, and leaving comments, you generate data that is used to analyze patterns in your behavior and of course your buying habits. Have you ever observed that, occasionally, when you click on something online, it appears to be following you across several web pages or websites? That is an example of Data and analytics 

Microsoft Excel is a powerful tool for Data Analytics and the built-in pivot tables are arguably the most popular analytic tool that allows you to analyze data easily.

 

What You’ll Learn?
  • Excel Basic
  • Excel functions and Formula
  • Pivot tables
  • Pivot chart
  • Data visualization
  • Data transformation 
  • Data Modeling
  • Reporting in Excel

Course Curriculum

Module 2: How to work with functions, formulas and tables
  • 6. Working with IF function
  • 7. Working with Conditional Formatting
  • 8. Working with AUTOSUM function
  • 9. Working with SUMIF function
  • 10. Working with Excel tables
  • 11. Working with table slicer
Module 3: Working with VLOOKUP and XLOOKUP
  • 1. Module introduction
  • 2. Download resources
  • 3. Combining data with VLOOKUP
  • 4. Combining data with XLOOKUP
Module 4: Basic data transformation
  • 1. Module introduction
  • 2. Download resources
  • 3. Data Identification
  • 4. Data transformation part 1
  • 5. Data transformation part 2
  • 6. Data transformation part 3
  • 7. Data transformation part 4
  • 8. Data transformation part 5
  • 9. Data transformation part 6
  • 10. Data transformation part 7
  • 11. Close and load data
  • 12. Creating a data model
  • 13. Module review
Module 5: Advanced data transformation
  • 1. Module introduction
  • 2. Download resources
  • 3. Data identification
  • 4. Loading the data into Excel
  • 5. Merge queries
  • 6. How to Unpivot columns
  • 7. How to pivot data
  • 8. How to work with Fill
  • 9. Close and load data
  • 10. Module review
Module 6: Data Modeling
  • 1. Module introduction
  • 2. Download resources
  • 3. Understanding data modeling
  • 4. Create calendar table part 1
  • 5. Create calendar table part 2
  • 6. Identify matching columns
  • 7. Create table relationships
  • 8. Dashboard layout part 1 - Area section
  • 9. Dashboard layout part 2 - Title section
  • 10. Dashboard layout part 3 - Profit MOM section
  • 11. Dashboard layout part 4 - Product profit section
  • 12. Dashboard layout part 5 - Other KPIs section
  • 13. Dashboard layout part 6 - Profit YOY section
  • 14. Dashboard layout part 7 - Add title text
Module 7: Data Calculations and Dashboard
  • 1. Module introduction
  • 2. Download resources
  • 3. Create a revenue calculation
  • 4. Link Revenue calculation to dashboard
  • 5. Create Cost calculation
  • 6. Link Cost calculation to dashboard
  • 7. Create Profit calculation
  • 8. Link Profit calculation to dashboard
  • 9. Create Profit percent calculation
  • 10. Link Profit percent to dashboard

Emmanuel Bassey

Instructor Image

Experienced technical product manager, software engineer and data analyst, helping organizations to leverage on Data and AI for digital transformation.

Instructor's LinkedIn profile

Course image

Course Includes:

  • Price:
    ₦ 30,000.00
  • Instructor: Emmanuel Bassey
  • Duration: 1 Month
  • book icon Lessons: 57
  • Enrolled: 1 students
  • Certificate: Yes
Enroll Now

Related Courses