Data Analysis Fundamentals using Excel
This course is for anyone who wants to bring data analysis technologies to Excel beyond formulas and add more advanced features such as dashboards, hierarchies and relationships.
SKU : MOC 10994
Categories : Microsoft
Teaching methodology
The course includes educational laboratories in which each student will be able to work in order to complete training exercises that will provide practical experience in using the instrument, for each of the topics covered during the course.
Who should participate
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its main features.
- Advanced working knowledge of Excel spreadsheets, including formulas
Outgoing knowledge/skills
By the end of the course, you should be able to achieve the following objectives:
- Create an Excel report
- Create an Excel table
- Create a PivotTable and PivotChart
- Create a dashboard and analyze the data
- Create hierarchies
- Create an Excel data model and connect to external data
Educational program
The main purpose of the course is to give students the ability to add analytics to Excel spreadsheets and to give students a foundation for learning about more advanced data analysis with Excel or Power BI.
- Reporting in Excel
- Excel tables
- Pivot tables and pivot charts
- Dashboards
- hierarchies
- Excel data model
Duration – 2 days
Delivery – in Classroom, On Site, Remote
PC and SW requirements:
- Internet connection
- Web browser, Google Chrome
- Zoom
Language
Instructor: English
Workshop: English
Slides: English
