• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
No Classes Available in this Courses.

10994: Data Analysis Fundamentals using Excel Course Overview

The principle reason for the course is to give understudies the capacity to add examination abilities to Excel spreadsheets and to give understudies an establishment to find out about more propelled information investigation with Excel or Power BI. 

10994: Data Analysis Fundamentals using Excel Audience Pofile 

10994: Data Analysis Fundamentals using Excel course is proposed for any individual who needs to take the information investigation innovations in Excel past recipes and include more propelled abilities, for example, dashboards, progressions, and connections. 

10994: Data Analysis Fundamentals using Excel At course completion

In the wake of finishing this course, understudies will have the capacity to: 

  • Make an Excel report 
  • Make an Excel table 
  • Make a turn table and rotate diagram 
  • Make a dashboard and investigate information 
  • Make Hierarchies 
  • Make an Excel information model and associate with outer information 

10994: Data Analysis Fundamentals using Excel Course Outline

1 - REPORTING IN EXCEL 

  • Sifting and Formatting Data 
  • Graphs 
  • Lab : Create an Excel report 

2 - EXCEL TABLES 

  • Exceed expectations Data Tables 
  • Compressing Data 
  • Lab : Create an Excel Table 

3 - PIVOT TABLES AND PIVOT CHARTS 

  • Turn Tables 
  • Turn Charts 
  • Altering Pivot Tables and Pivot Charts 
  • Lab : Importing Data from a CSV File 

4 - DASHBOARDS 

  • Making a Dashboard 
  • Information Analysis in Excel Pivot Tables 
  • Lab : Create a Dashboard 

5 - HIERARCHIES 

  • Lessons 
  • Chains of importance 
  • Time Data 
  • Lab : Creating Hierarchies 

6 - THE EXCEL DATA MODEL 

  • Utilizing an Excel Data Model 
  • Outside Data 
  • Lab : Explore an Excel Data Model

Before going to 10994: Data Analysis Fundamentals using Excel course, understudies must have: 

  • Essential learning of the Microsoft Windows working framework and its center usefulness. 
  • Propelled working information of Excel spreadsheets including equations.

Awards