Microsoft
Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot
Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot — Microsoft training aligned to Microsoft End User skills and certification paths.
LevelAssociate
Duration3 days
ModesIn Person,Virtual
CategoryMicrosoft 365
About this course
This Microsoft course from TORQUE IT prepares learners for real-world microsoft end user scenarios.
Programme focus: Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot.
Catalogue path: Microsoft › Microsoft End User.
Skills developed: End User.
Available delivery locations include Cape Town, Johannesburg, MHD Cape Town, MHD Woodmead, Virtual.
Delivered by accredited instructors with hands-on labs, practical exercises and post-course support.
What you'll learn
- End User
- Microsoft Excel
- Office 365/2021 – Data Analysis
- Power Pivot
- Microsoft End User fundamentals
- Practical labs and exercises
- Best practices and exam preparation
Microsoft 365 learning path
82 courses across 4 vendors in Microsoft 365.
Microsoft 365 learning path
- Build a Foundation to Build AI Agents and Extend Microsoft 365 Copilot
- Copilot Immersion Experience
- Introduction to Finance in Dynamics 365
- Introduction to Microsoft 365 and AI Administration
- Introduction to Microsoft Power Platform
- Introduction to Sales in Dynamics 365
- Introduction to Service in Dynamics 365
- Introduction to Supply Chain Management in Dynamics 365
- Microsoft Office 365 Introduction
- Microsoft Sway Introduction
- Microsoft Windows 10 Introduction
- Accelerate Sales Pipelines with AI in Dynamics 365
- Architecting Aagentic AI Business Solutions
- Build Intelligent Applications
- Collaboration Communications Systems Engineer
- Configure and Govern Entitlement with Microsoft Entra ID
- Configure SIEM Security Operations using Microsoft Sentinel
- Create And Extend Custom Copilots in Microsoft Copilot Studio
- Create and Manage Automated Processes by using Power Automate
- Create and Manage Canvas Apps with Power Apps
- Data Analysis and Visualization with MS Excel
- Design and Build Integrated AI Agent Solutions in Copilot Studio
- Design and Manage Analytics Solutions using Power BI
- Draft, Analyze, and Present with Microsoft 365 Co-Pilot
- Empower your workforce with Copilot for Microsoft 365 Use Cases
- Enhance Endpoint Security with Microsoft Intune and Microsoft Copilot for Security
- Get started with Microsoft Copilot for Security
- Getting the Most from Your Documents with GenAI
- Getting the Most from your Presentations with GenAI
- Getting the Most from Your Spreadsheets with GenAI
- GitHub Copilot
- Implement Information Protection and Data Loss Prevention by using Microsoft Purview
- Implement Retention, eDiscovery, and Communication Compliance in Microsoft Purview
- Information Security Administrator
- Manage and Extend Microsoft 365 Copilot
- Managing Microsoft Teams
- Microsoft 365 Administrator
- Microsoft 365 Endpoint Administrator
- Microsoft 365 Security Administration
- Microsoft Access for Office 365: Part 1
- Microsoft Access for Office 365: Part 2
- Microsoft Access for Office 365: Part 3
- Microsoft Excel for Office 365 – Data Analysis with PivotTables
- Microsoft Excel for Office 365 (Desktop or Online): Part 1
- Microsoft Excel for Office 365 (Desktop or Online): Part 2
- Microsoft Excel for Office 365 (Desktop or Online): Part 3
- Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot You are here
- Microsoft Identity and Access Administrator
- Microsoft Outlook for Office 365 (Desktop or Online): Part 1
- Microsoft Outlook for Office 365 (Desktop or Online): Part 2
- Microsoft Power Automate RPA Developer
- Microsoft Power BI: Data Analysis Practitioner
- Microsoft Power Platform Developer
- Microsoft PowerPoint for Office 365 (Desktop or Online): Part 1
- Microsoft PowerPoint for Office 365 (Desktop or Online): Part 2
- Microsoft Project 2019
- Microsoft Publisher for Office 365/2021
- Microsoft Security Compliance and Identity Fundamentals
- Microsoft Security Operations Analyst
- Microsoft Teams (Desktop and Browser)
- Microsoft Windows 10 Intermediate
- Microsoft Word for Office 365 (Desktop or Online): Part 1
- Microsoft Word for Office 365 (Desktop or Online): Part 2
- Microsoft Word for Office 365 (Desktop or Online): Part 3
- Power Platform Functional Consultant
- Prepare Security and Compliance to Support Microsoft 365 Copilot
- Programming and Data Wrangling with VBA and Excel
- Secure and Govern your AI Agent Workforce
- Secure Azure Services and Workloads with Microsoft Defender for Cloud Regulatory Compliance Controls
- Transform Contact Center Experiences with AI in Dynamics 365
- Transform your Everyday Business Processes with Agents
- Using Microsoft Windows 11
- Using Microsoft Windows 11 (with Copilot)
- Work Smarter with Copilot in Microsoft Fabric
- Working with Copilot in Windows and Microsoft Edge
Course content
| Module | What's covered |
|---|---|
| Module 1: End User | Explore end user within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
| Module 2: Microsoft Excel | Explore microsoft excel within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
| Module 3: Office 365/2021 – Data Analysis | Explore office 365/2021 – data analysis within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
| Module 4: Power Pivot | Explore power pivot within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
| Module 5: Microsoft End User fundamentals | Explore microsoft end user fundamentals within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
| Module 6: Practical labs and exercises | Explore practical labs and exercises within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
| Module 7: Best practices and exam preparation | Explore best practices and exam preparation within the context of Microsoft Excel for Office 365/2021 – Data Analysis with Power Pivot. |
Certification
On successful completion of this course students receive a TORQUE IT attendance certificate.
Certification exams may be booked separately through the relevant vendor or Pearson VUE testing centres.
Course dates
—
MonTueWedThuFriSatSun
Date with a session
Related courses