Microsoft Excel: A Beginners’ Guide to Pivot Tables in Excel

سرفصل های دوره

We need to analyze data these days since we live in a very data-driven world. Therefore, data is important in any business, whether you are looking for trends or forecasting future business needs. As there is a lot of importance placed on data analysis, you must have the relevant skills to analyze data effectively. Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating data sets and analyzing data clearly and effectively. This course will discuss the importance of cleaning your data before creating your first Pivot Table. You’ll also learn how to create Pivot Charts and how to format your Pivot Tables and Charts. This course includes downloadable Excel data files that the instructor uses in the guide to follow along. By the end of this course, you'll learn the skills required to be able to clean the data, put it in the Pivot Table, analyse the data efficiently, and keep it updated with a single click. Therefore, by opting for this course, you’ll be able to take your own information and leverage Pivot Tables to answer questions with ease. All the resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Microsoft-Excel-A-Beginners-Guide-to-Pivot-Tables-in-Excel

Chapter 1 Introduction to the Course

001. Course Introduction

002. What are Pivot Tables and Why are they Useful

Chapter 2 Preparing Data for Analysis

001. The Importance of Cleaning Data

002. Removing Blank Rows

003. Removing Duplicate Rows

004. Clearing Formatting

005. Applying Number Formatting

006. Changing the Case

007. Removing Spaces and Non-printing Characters

008. Merging and Splitting Columns

009. Convert Numbers Stored as Text

010. Finding and Replacing Text

011. Spell Check

012. Exercise 01

Chapter 3 The Importance of Excel Tables

001. Excel Tables versus Pivot Tables

002. Format Data as a Table

003. Exercise 02

Chapter 4 Creating a Basic Pivot Table Report

001. Using Recommended Pivot Tables

002. Creating a Pivot Table from Scratch

003. Pivot Table Ribbons and Fields

004. Pivoting the Fields

005. Adding Multiple Dimensions

006. Deleting Fields and Locking the Report Layout

007. Exercise 03

Chapter 5 Aggregation and Grouping

001. Methods of Aggregation

002. Combining Methods of Aggregation

003. Grouping and Ungrouping Data

004. Exercise 04

Chapter 6 Formatting Values

001. Applying Number Formatting

002. Handling Cells with No Data

003. Exercise 05

Chapter 7 Layout Options

001. Subtotals and Grand Totals

002. Choosing a Report Layout

003. Inserting Blank Rows

004. Exercise 06

Chapter 8 Formatting Pivot Tables

001. Applying Pivot Table Styles

002. Modifying Pivot Table Styles

003. Creating a Custom Pivot Table Style

004. Exercise 07

Chapter 9 Sorting and Filtering

001. Sorting Pivot Table Data

002. Filtering Pivot Table Data

003. Top 10 Filter

004. Exercise 08

Chapter 10 Creating Pivot Charts

001. Selecting the Right Chart Type

002. Clustered Column and Bar Charts

003. Line Charts

004. Pie and Donut Charts

005. Map Charts

006. Applying Chart Layouts

007. Exercise 09

Chapter 11 Formatting Pivot Charts

001. Adding a Slicer

002. Formatting a Slicer

003. Adding a Timeline

004. Connecting Slicers and Timelines

005. Exercise 10

Chapter 12 Applying Conditional Formatting

001. Highlight Cell Rules

002. Data Bars

003. Color Scales

004. Icon Sets

005. Exercise 11

Chapter 13 Updating Pivot Tables and Pivot Charts

001. Adding Data to the Dataset

002. Updating Pivot Tables and Pivot Charts

003. Exercise 12

Chapter 14 Course and Next Steps

001. Course and Next Steps

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PacktPub