Data Analytics and Presentation
Using Microsoft Excel and Powerpoint
MOS 77 – 727 Certification exam prep
Data Analytics and Presentation
Overview
Data analytics and presentation are essential skills in today’s data-driven world. Excel and PowerPoint are two powerful tools that can help users extract insights from data and communicate them effectively to others.
Excel is a versatile tool for data analytics that offers a wide range of capabilities such as data cleaning, manipulation, and exploration. It allows users to perform statistical analyses, create charts and graphs, and generate pivot tables to summarize and visualize data.
PowerPoint, on the other hand, is an excellent tool for creating presentations that communicate insights and tell a story. With PowerPoint, users can create slides that display visualizations created in Excel or other tools, add text to explain key insights, and use animations to create engaging presentations.
In this training, we’ll cover data analytics using Excel from basics to advanced and how to create compelling presentations using PowerPoint. We’ll start with Excel and cover topics such as data cleaning, filtering, and sorting. We’ll also explore how to use Excel’s functions and pivot tables to perform data analysis and create charts and graphs.
Next, we’ll dive into PowerPoint and cover topics such as creating effective presentations, using graphics and animations to engage the audience, and designing slides to tell a story. We’ll also explore how to create dynamic and interactive presentations using Excel charts and graphs.
Throughout the training, we’ll emphasize the importance of effective communication and storytelling with data. We’ll provide tips and guidance on how to craft a compelling narrative that highlights key insights and engages the audience.
By the end of this training, participants will have a solid understanding of how to use Excel and PowerPoint for data analytics and presentation, and will be equipped with the skills and tools necessary to extract insights from data and effectively communicate them to others.
Course Learning Outcome
In this course, you will analyze and visualize data using Microsoft Excel and associated tools.
You will…
- Perform data analysis fundamentals.
- Visualize data with Excel.
- Analyze data with formulas and functions.
- Analyze data with PivotTables.
- Present visual insights with dashboards in Excel.
- Create geospatial visualization with Excel.
- Perform statistical analysis.
- Get and transform data.
- Model and analyze data with Power Pivot.
In this course, you will create and deliver an engaging PowerPoint presentation.
You will:
- Identify the basic features and functions of PowerPoint.
- Develop a PowerPoint presentation.
- Perform advanced text editing operations.
- Add graphical elements.
- Format graphical elements.
- Prepare to deliver your presentation.
- Customize design templates.
- Use ink to hand draw elements.
- Add tables.
- Add charts.
- Work with media.
- Build advanced transitions and animations.
- Finalize a presentation.
- Customize presentation navigation.
Secure and distribute a presentation
Course Audience Profile
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel as well as gain an understanding of PowerPoint 2019 that is necessary to create and develop engaging multimedia presentations.
Course Outline
- Module 1: Getting started with Excel 2019
- Module 2: Performing Calculations
- Module 3: Modifying Worksheets
- Module 4: Formatting a Worksheet
- Module 5: Printing Workbooks
- Module 6: Managing Workbook
Basic Excel Customization
- Module 1: Working with Functions
- Module 2: Working with Lists
- Module 3: Analyzing Data
- Module 4: Visualizing Data with Charts
- Module 5: Using PivotTables and PivotCharts
Financial Functions
Working with Graphical Objects
Using Array Formulas
- Module 1: Working with Multiple Worksheets and Workbooks
- Module 2: Sharing and Protecting Workbooks
- Module 3: Automating Workbooks Functionality
- Module 4: Using Lookup functions and Formula Auditing
- Module 5: Forecasting Data
- Module 6: Creating Sparklines and Mapping Data
Importing and Exporting Data
Internationalizing Workbooks
Working with Power Pivot
Advanced Customization Options
Working with Forms and Controls
p
- Module 1: Getting started with Powerpoint 2019
- Module 2: Developing a PowerPoint Presentation
- Module 3: Performing Advanced Text Editing Operations
- Module 4: Adding and Arranging Graphical Elements
- Module 5: Modifying Graphical Elements
- Module 6: Preparing to Deliver Your Presentation
- Module 1: Customizing Design Templates
- Module 2: Using Ink to Hand Elements
- Module 3: Adding Tables
- Module 4: Adding Charts
- Module 5: Working with Media
- Module 6: Building Advanced Transitions and Animations
- Module 7: Finalizing a Presentation
- Module 8: Customizing Presentation Navigation
- Module 9: Securing and Distribution a Presentation