Analyzing Data with Excel
Course Code: |
Duration: 3 days 9.00am to 5.00pm |
Location: 80 Jurong East Street 21 #04-04 Devan Nair Institute Singapore 609607 |
Course Fees: S$1,800 (excl of G.S.T) |
2020 Course Dates 6 – 8 Jan 2020 2 – 4 Mar 2020 11 – 13 May 2020 13 – 15 Jul 2020 14 – 16 Sep 2020 9 – 11 Nov 2020 |
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training. |
Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device. |
Course Overview
The main purpose of the course is to give participants 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.
Program Objective
• 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
Course Outline
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
Click Here for full course outline