Analyzing Data
with Excel
Overview
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.
Course Objective
Upon Successful of this course, you will be able 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.
Who Should Attend
This course is intended for students who are experienced with analysing data with Excel and who wish to add BI techniques. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
Prerequisites
Participants that attending this training session 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 equivalent to having attended course 10994.
Training Calendar
Intake
Duration
Program Fees
Module
Module 1 - Data Analysis in Excel
- Classic Data Analysis with Excel
- Excel Pivot Tables
- Limitations of Classic Data Analysis
- Lab: Building a Classic Excel Dashboard
Module 2 - The Excel Data Model
- Using an Excel Data Model
- DAX
- Lab: Explore an Excel Data Model
Module 3 - Importing Data from Files
- Importing Data into Excel
- Shaping and Transforming Data
- Loading Data
- Lab: Importing Data from a CSV File
Module 4 - Importing Data from Databases
- Available Data Sources • Previewing, Shaping, and Transforming Data
- Table Relationships and Hierarchies
- Loading Data
- Lab: Import Data from Multiple Sources
FAQs
General Questions:
Q: What is this course about?
A: This course teaches you how to use Microsoft Excel to analyze data effectively. You’ll learn to import, clean, organize, analyze, visualize, and interpret data to make informed decisions.
Q: Who is this course for?
A: This course is designed for anyone who works with data, regardless of their background. It’s beneficial for business professionals, students, researchers, analysts, project managers, and anyone wanting to improve their data analysis skills.
Q: What are the prerequisites for this course?
A: A basic understanding of Microsoft Excel is recommended. You should be comfortable navigating the interface, entering data, and using basic formulas. No prior experience with data analysis is required.
Q: What software do I need
A: You will need Microsoft Excel installed on your computer. The specific version of Excel might be specified by the instructor or training provider (e.g., Excel 2016, 2019, 365).
Q: How is the course structured?
A: The course structure will vary depending on the format (in-person, online, self-paced). Generally, it covers data import, cleaning, manipulation, analysis, visualization, and reporting. Check the course syllabus for specifics.
Q: How long is the course?
A: The duration varies depending on the format and depth of the course. It can range from a few days to several weeks. Check the course details for the exact duration.
Q: Will I receive a certificate upon completion?
A: Certificates of completion.
Course Content & Skills:
Q: What specific topics are covered in the course?
A: Common topics include data import and cleaning, data manipulation with formulas and functions, descriptive statistics, data visualization with charts and graphs, PivotTables and PivotCharts, statistical analysis, and potentially an introduction to macros. Refer to the course syllabus for a detailed list.
Q: Will I learn statistical analysis in this course?
A: Yes, the course typically covers basic statistical concepts and how to apply them in Excel, including descriptive statistics, hypothesis testing, and regression analysis.
Q: Will I learn how to use PivotTables?
A: Absolutely! PivotTables are a core component of data analysis in Excel and are usually covered extensively in the course.
Q: Will I learn how to create charts and graphs?
A: Yes, data visualization is a key part of the course. You’ll learn to create various types of charts and graphs to effectively communicate data insights.
Q: Will I learn about macros or VBA?
A: Some courses may include a brief introduction to macros or VBA for automating tasks, but this is not always a core component. Check the course description to see if it’s included.
Q: What kind of data will I be working with?
A: The course may use sample datasets or case studies from various industries. The focus is on the techniques, not necessarily a specific industry.
Technical & Practical Questions:
Q: What if I have trouble with the software or course materials?
A: Most courses provide support through instructors, online forums, or technical assistance.
Q: What if I miss a class? (For in-person or live online courses)
A: The policy for missed classes varies. We may offer recordings or make-up sessions. Check with us for more details
Q: What kind of computer do I need?
A: You’ll need a computer/laptop that can run the version of Microsoft Excel used in the course. Specific system requirements will be listed by us prior for the course.
Q: How much practice time is required outside of class?
A: The more you practice, the better you’ll become at data analysis. Plan to dedicate some time outside of class to work on exercises and projects.
Q: Will I be able to apply these skills in my job?
A: Yes! The skills you learn in this course are highly practical and transferable to many roles that involve working with data.
Submit your interest today !
