Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Formatting PivotTables Values & Layout: Excel for Beginners

Formatting PivotTables Values & Layout: Excel for Beginners

Streamline your data analysis process with PivotTables for Beginners.
Created bySimon Sez IT
Last updated 4/2025
English

What you'll learn

  • Apply number formatting to PivotTable values.
  • Replace blank cells with specified values.
  • Customize subtotal and grand total display.
  • Create and apply custom PivotTable styles.

Course content

1 section • 16 lectures • 51m total length

  • Introduction5:01
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Applying Number Formatting4:45
  • Handling Cells with No Data4:00
  • Exercise2:17
  • Subtotals and Grand Totals4:26
  • Choosing a Report Layout4:43
  • Inserting Blank Rows2:13
  • Exercise1:57
  • Applying Pivot Table Styles4:15
  • Modifying Pivot Table Styles4:19
  • Creating a Custom Pivot Table Style5:37
  • Exercise3:30
  • Course Close1:52
  • Course Quiz

Requirements

  • Basic Excel knowledge.
  • Understanding of basic data concepts.
  • No prior PivotTable experience needed.
  • Access to a version of Excel that supports PivotTables.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**


Welcome to PivotTables for Beginners, your gateway to mastering one of Excel's most powerful data analysis tools. In this beginner-friendly course, you'll learn essential techniques to effectively analyze and present your data, from formatting values to handling cells with no data.


PivotTables are essential for anyone looking to gain insights from data, whether for business decisions, measuring KPIs, or spotting trends. Explore sorting, filtering, grouping, and using calculated fields to summarize information more clearly. Gain confidence as you create PivotTables from various data sources and learn how to refresh your reports with updated data.


Join us and transform how you handle data with PivotTables, making your analysis more dynamic and efficient. Course files are included and available to download, allowing you to follow along and practice as you learn. Whether you're working with financial reports, sales figures, or project metrics, this course equips you with a practical toolset to manage and interpret data with clarity and ease.


In this course, you will learn how to:

  • Apply number formatting to PivotTable values.

  • Replace blank cells with specified values.

  • Customize subtotal and grand total display.

  • Create and apply custom PivotTable styles.


This course includes:

  1. 51 minutes of video tutorials

  2. 13 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Individuals new to Excel who want to develop foundational skills in using PivotTables.
  • Professionals working with large datasets who want to gain actionable insights.
  • Students seeking to boost their academic or professional skills in data management.
  • Individuals transitioning into roles that require a basic understanding of data analytics.
  • Anyone looking to enhance their resume by adding a valuable, practical data analysis skill.

Report abuse