Elev8 Logo

Where digital leaders are made

Select your location to see the
training and programs in your region

ANALYZING DATA WITH MICROSOFT EXCEL

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. 

WHAT YOU’LL LEARN

On this course you will learn how to:

  • Explore and extend a classic Excel dashboard 
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Import data from a SQL Server database 
  • Import data from a report
  • Create measures using advanced DAX functions 
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel

MORE ABOUT THIS COURSE

The course is made up of the following modules:

  • Module 1: Data analysis in Excel 
  • Module 2: The Excel data model 
  • Module 3: Importing data from files 
  • Module 4: Importing data from databases 
  • Module 5: Importing data from Excel reports 
  • Module 6: Creating and formatting measures 
  • Module 7: Visualizing data in Excel 
  • Module 8: Using Excel with Power BI 

WHAT THE TUTOR SAYS

“This course is ideal for students who are experienced in analyzing data with Excel and who wish to master BI techniques. This course will be of particular interest to SQL Server report creators, who are interested in alternative methods of presenting data.”

WHAT YOU’LL NEED BEFORE STARTING THIS COURSE

Before attending this course, students must have: 


  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of relational databases
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals
  • Basic knowledge of data analytics

"Companies that partner with elev8 understand having an engaged and talented workforce is crucial to their success. They recognise that everyone is not the same, but each person has skills that can be enhanced to deliver better results. "

ENQUIRE

I agree that I have read and understood the Website’s Terms of Use, Cookies policy and Privacy Policy

We use cookies to personalize content, to provide social media features and to analyze our traffic. We also share information about your use of our site with our social media and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services. You consent to our cookies if you continue to use this website. You can view our Privacy and Cookies Policies for more details.