Excel for Beginners: Pivot Tables

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Excel for Beginners: Pivot Tables

Coursera · Beginner ·📊 Data Analytics & Business Intelligence ·3mo ago

Key Takeaways

Creates pivot tables using Excel on the Web for data analysis and visualization

Original Description

This 1-hour, project-based course introduces learners to the powerful pivot table feature of most spreadsheet applications. We’ll be using Excel on the Web in this project, which is the free spreadsheet application offered by Microsoft. However, many of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets. We will cover the following concepts in a hands-on manner: - Introduction to the functionality of pivot tables. - Application of pivot tables to quickly summarize large amounts of raw data in detail. - Visualize generated data from pivot tables for accessible information at a glance using charts. Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.
Watch on External: Coursera ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
Python Excel Automation: Create, Edit, and Format Text Boxes
Automate Excel tasks using Python to create, edit, and format text boxes in spreadsheets
Medium · Programming
📰
From Spreadsheets to Spark: Why Traditional Analytics Tools Reach Their Limits
Learn why traditional analytics tools like spreadsheets reach their limits and how to transition to more scalable solutions like Spark
Medium · Data Science
📰
Skill Verification for Data Roles: What Employers Should Know
Employers can verify data skills through practical assessments to ensure candidates can apply their knowledge in real-world scenarios, making hiring more effective
Dev.to AI
📰
The Data Engineering Skills Matrix AI Just Broke!
Discover how AI is changing data engineering skills and what it means for your team's SQL expertise
Medium · AI
Up next
This could be the most perfect data frontend
Matt Williams
Watch →