Complete Guide to Excel Pivot Tables
A 79-part course with MyExcelOnline
Start Free Preview Start CourseCourse Overview
Teacher
My name is John Michaloudis and I am the founder of MyExcelOnline.com and long time lover of Excel. I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish. I... View ProfileDetails
- Total Time 9 hr, 53 min
- Lessons 79
- Attachments 173
- Exercises 207
-
337 CQ
79 Lessons in This Course
-
5 minFREEComputer Science lesson 1Free3 CQ
Begin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.
with MyExcelOnlineBegin your Microsoft Excel journey with this lesson on how to use supplemental documents and spreadsheets while learning how to use pivot tables.
-
11 minComputer Science lesson 26 CQ
In this lesson, learn what is required to convert Excel data into a pivot table. Review the steps for formatting, removing gaps, creating tables, and more!
with MyExcelOnlineIn this lesson, learn what is required to convert Excel data into a pivot table. Review the steps for formatting, removing gaps, creating tables, and more!
-
14 minMicrosoft Office lesson 38 CQ
Learn how to create Excel pivot tables. MyExcelOnline explains how to insert pivot tables and designate which information to share using the Field List menu.
with MyExcelOnlineLearn how to create Excel pivot tables. MyExcelOnline explains how to insert pivot tables and designate which information to share using the Field List menu.
-
15 minMicrosoft Office lesson 48 CQ
In this lesson from MyExcelOnline, find out more about how pivot tables connect to data sources, and learn about several methods for refreshing pivot tables.
with MyExcelOnlineIn this lesson from MyExcelOnline, find out more about how pivot tables connect to data sources, and learn about several methods for refreshing pivot tables.
-
5 minMicrosoft Office lesson 53 CQ
Learn about the Excel pivot table Options menu, focusing on Actions. Follow along to clear pivot table filters or completely clear a pivot table to start fresh.
with MyExcelOnlineLearn about the Excel pivot table Options menu, focusing on Actions. Follow along to clear pivot table filters or completely clear a pivot table to start fresh.
-
9 minMicrosoft Office lesson 65 CQ
Default Excel pivot table styles are pretty dull. MyExcelOnline explains how to apply and edit pivot table styles to improve data visualization.
with MyExcelOnlineDefault Excel pivot table styles are pretty dull. MyExcelOnline explains how to apply and edit pivot table styles to improve data visualization.
-
6 minMicrosoft Office lesson 74 CQ
Continue exploring Excel pivot table design with layouts. Learn how to apply and edit pivot table layouts in order to visually emphasize data set highlights.
with MyExcelOnlineContinue exploring Excel pivot table design with layouts. Learn how to apply and edit pivot table layouts in order to visually emphasize data set highlights.
-
7 minMicrosoft Office lesson 84 CQ
Pivot tables in MS Excel can get long and text heavy, especially with large data sets. Find out how to collapse and expand data fields in Excel pivot tables.
with MyExcelOnlinePivot tables in MS Excel can get long and text heavy, especially with large data sets. Find out how to collapse and expand data fields in Excel pivot tables.
-
7 minMicrosoft Office lesson 94 CQ
It's not enough to slap on a theme to make an MS Excel pivot table easy to read; customizing fields is an important part of facilitating comprehension.
with MyExcelOnlineIt's not enough to slap on a theme to make an MS Excel pivot table easy to read; customizing fields is an important part of facilitating comprehension.
-
10 minMicrosoft Office lesson 106 CQ
The options for formatting and customizing MS Excel pivot tables are virtually limitless. Get an in-depth overview of the Pivot Table Options menu.
with MyExcelOnlineThe options for formatting and customizing MS Excel pivot tables are virtually limitless. Get an in-depth overview of the Pivot Table Options menu.
-
15 minMicrosoft Office lesson 118 CQ
Value fields perform the kinds of auto calculations that have made Excel ubiquitous. Learn how to customize value fields to perform different functions.
with MyExcelOnlineValue fields perform the kinds of auto calculations that have made Excel ubiquitous. Learn how to customize value fields to perform different functions.
-
12 minMicrosoft Office lesson 127 CQ
Now that you've learned how to access and edit MS Excel pivot table value settings, learn more about helpful calculations you can apply to a data set.
with MyExcelOnlineNow that you've learned how to access and edit MS Excel pivot table value settings, learn more about helpful calculations you can apply to a data set.
-
13 minMicrosoft Office lesson 137 CQ
Learn how to add statistical calculation functions, including standard deviation and variance, to MS Excel pivot tables using the Value Field Settings menu.
with MyExcelOnlineLearn how to add statistical calculation functions, including standard deviation and variance, to MS Excel pivot tables using the Value Field Settings menu.
-
14 minMicrosoft Office lesson 148 CQ
This lesson from MyExcelOnline explains how to add value fields for running total and rank, as well as how to create an index and compare revenue and margins.
with MyExcelOnlineThis lesson from MyExcelOnline explains how to add value fields for running total and rank, as well as how to create an index and compare revenue and margins.
-
15 minMicrosoft Office lesson 158 CQ
MS Excel percent calculations can shed a lot of light on a data set. Learn how to apply percent calculations to pivot tables with the Value Field Settings menu.
with MyExcelOnlineMS Excel percent calculations can shed a lot of light on a data set. Learn how to apply percent calculations to pivot tables with the Value Field Settings menu.
-
17 minMicrosoft Office lesson 169 CQ
Get more percent-based data to clarify relationships between data fields. FInd out how to add percentage of parent calculations in an Excel pivot table.
with MyExcelOnlineGet more percent-based data to clarify relationships between data fields. FInd out how to add percentage of parent calculations in an Excel pivot table.
-
17 minMicrosoft Office lesson 179 CQ
Learn how to create pivot tables in MS Excel that group data by calendar years, fiscal years, quarters, and months, and other custom date ranges.
with MyExcelOnlineLearn how to create pivot tables in MS Excel that group data by calendar years, fiscal years, quarters, and months, and other custom date ranges.
-
16 minMicrosoft Office lesson 189 CQ
Quarter over quarter analysis is a staple of data visualization. In this lesson, learn how to create quarterly comparative reports using MS Excel pivot tables.
with MyExcelOnlineQuarter over quarter analysis is a staple of data visualization. In this lesson, learn how to create quarterly comparative reports using MS Excel pivot tables.
-
14 minMicrosoft Office lesson 198 CQ
In this third lesson on grouping by dates in Excel pivot tables, get tips and shortcuts for grouping data sets by date, time, day of the week, and more!
with MyExcelOnlineIn this third lesson on grouping by dates in Excel pivot tables, get tips and shortcuts for grouping data sets by date, time, day of the week, and more!
-
13 minMicrosoft Office lesson 207 CQ
Sorting helps us identify patterns and trends in a data set. Learn how to sort Excel pivot table data using automated as well as manual sorting methods.
with MyExcelOnlineSorting helps us identify patterns and trends in a data set. Learn how to sort Excel pivot table data using automated as well as manual sorting methods.
-
15 minMicrosoft Office lesson 218 CQ
In this first of three Excel filtering lessons, learn how to use Excel filters to sort pivot table data, as well as customizing settings for easy filtering.
with MyExcelOnlineIn this first of three Excel filtering lessons, learn how to use Excel filters to sort pivot table data, as well as customizing settings for easy filtering.
-
14 minMicrosoft Office lesson 228 CQ
This lesson from MyExcelOnline covers how to search a channel by percent values, and explains methods for filtering by date and filtering column labels.
with MyExcelOnlineThis lesson from MyExcelOnline covers how to search a channel by percent values, and explains methods for filtering by date and filtering column labels.
-
15 minMicrosoft Office lesson 238 CQ
Learn about more helpful MS Excel filters to help you understand pivot table data, including filtering by top and bottom values and sorting by report filters.
with MyExcelOnlineLearn about more helpful MS Excel filters to help you understand pivot table data, including filtering by top and bottom values and sorting by report filters.
-
4 minMicrosoft Office lesson 243 CQ
Sometimes it's difficult to know what filters are applied in an Excel pivot table. Find out how slicers can help create a more transparent format.
with MyExcelOnlineSometimes it's difficult to know what filters are applied in an Excel pivot table. Find out how slicers can help create a more transparent format.
-
9 minMicrosoft Office lesson 255 CQ
Learn how to use the Excel slicer tool menu to select and apply slicer styles, as well as how to create, modify, or duplicate custom slicer styles.
with MyExcelOnlineLearn how to use the Excel slicer tool menu to select and apply slicer styles, as well as how to create, modify, or duplicate custom slicer styles.
-
4 minMicrosoft Office lesson 263 CQ
Now that you've learned how to use slicer styles, find out how to apply MS Excel slicer settings to optimize how information is displayed within the slicer.
with MyExcelOnlineNow that you've learned how to use slicer styles, find out how to apply MS Excel slicer settings to optimize how information is displayed within the slicer.
-
3 minMicrosoft Office lesson 272 CQ
MyExcelOnline explains how to adjust slicer size, columns, and alignment using the slicer properties dialogue box and properties ribbon menu.
with MyExcelOnlineMyExcelOnline explains how to adjust slicer size, columns, and alignment using the slicer properties dialogue box and properties ribbon menu.
-
3 minMicrosoft Office lesson 282 CQ
MyExcelOnline demonstrates how to use the Pivot Table Connections tool to create clear relationships between multiple pivot tables and slicers.
with MyExcelOnlineMyExcelOnline demonstrates how to use the Pivot Table Connections tool to create clear relationships between multiple pivot tables and slicers.
-
4 minMicrosoft Office lesson 293 CQ
Excel slicers not only display pivot table filters, they also function as filtering devices. Learn how to select slicer items in order to filter a pivot table.
with MyExcelOnlineExcel slicers not only display pivot table filters, they also function as filtering devices. Learn how to select slicer items in order to filter a pivot table.
-
9 minMicrosoft Office lesson 305 CQ
Put a name to a face with MS Excel slicers! In this lesson, MyExcelOnline explains how to add interactive employee photos to slicers using an offset function.
with MyExcelOnlinePut a name to a face with MS Excel slicers! In this lesson, MyExcelOnline explains how to add interactive employee photos to slicers using an offset function.
-
4 minMicrosoft Office lesson 313 CQ
MS Excel pivot tables help businesses understand profit and loss metrics. In this lesson, learn how to use pivot table slicers for easy-to-read P&L reports.
with MyExcelOnlineMS Excel pivot tables help businesses understand profit and loss metrics. In this lesson, learn how to use pivot table slicers for easy-to-read P&L reports.
-
5 minMicrosoft Office lesson 323 CQ
Get the most out of Excel's forecast functions by using pivot tables and slicers to graph business forecasts for base, best-, and worst-case scenarios.
with MyExcelOnlineGet the most out of Excel's forecast functions by using pivot tables and slicers to graph business forecasts for base, best-, and worst-case scenarios.
-
4 minMicrosoft Office lesson 333 CQ
Learn to add custom calculations to an Excel pivot table. There's no need to stick to the standard field values; edit pivot tables to fit your needs.
with MyExcelOnlineLearn to add custom calculations to an Excel pivot table. There's no need to stick to the standard field values; edit pivot tables to fit your needs.
-
2 minMicrosoft Office lesson 342 CQ
Explore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.
with MyExcelOnlineExplore additional options for data analysis based on custom calculations. Learn how to use one calculated field to formulate yet another calculated field.
-
4 minMicrosoft Office lesson 353 CQ
A calculated item is a virtual data item based on a row or column label. MyExcelOnline demonstrates how to add calculated items to MS Excel pivot tables.
with MyExcelOnlineA calculated item is a virtual data item based on a row or column label. MyExcelOnline demonstrates how to add calculated items to MS Excel pivot tables.
-
2 minMicrosoft Office lesson 362 CQ
Calculated items allow you to generate helpful data, but in order to preserve MS Excel pivot table functionality, it's important to understand the limitations.
with MyExcelOnlineCalculated items allow you to generate helpful data, but in order to preserve MS Excel pivot table functionality, it's important to understand the limitations.
-
4 minMicrosoft Office lesson 373 CQ
In this lesson, MyExcelOnline explains how to use the Excel pivot table solve order function to troubleshoot a common problem with calculated items.
with MyExcelOnlineIn this lesson, MyExcelOnline explains how to use the Excel pivot table solve order function to troubleshoot a common problem with calculated items.
-
3 minMicrosoft Office lesson 382 CQ
MyExcelOnline explains the List Formulas view format, and demonstrates how to work within this view to temporarily remove calculated items and edit solve order.
with MyExcelOnlineMyExcelOnline explains the List Formulas view format, and demonstrates how to work within this view to temporarily remove calculated items and edit solve order.
-
8 minMicrosoft Office lesson 395 CQ
Create a comprehensive P&L report with MS Excel pivot tables! In this lesson, MyExcelOnline demonstrates how to build a P&L report, step by step.
with MyExcelOnlineCreate a comprehensive P&L report with MS Excel pivot tables! In this lesson, MyExcelOnline demonstrates how to build a P&L report, step by step.
-
6 minMicrosoft Office lesson 404 CQ
Create a variance report with Excel pivot tables! MyExcelOnline demonstrates how to build a variance report to express sales according to regions and products.
with MyExcelOnlineCreate a variance report with Excel pivot tables! MyExcelOnline demonstrates how to build a variance report to express sales according to regions and products.
-
3 minMicrosoft Office lesson 412 CQ
Enhance MS Excel data visualization through pivot charts! In this lesson, MyExcelOnline explains how to insert a pivot chart to graphically represent data.
with MyExcelOnlineEnhance MS Excel data visualization through pivot charts! In this lesson, MyExcelOnline explains how to insert a pivot chart to graphically represent data.
-
2 minMicrosoft Office lesson 422 CQ
Add more functionality to pivot charts by inserting pivot chart slicers! In this lesson, MyExcelOnline demonstrates how to quickly add slicers to pivot charts.
with MyExcelOnlineAdd more functionality to pivot charts by inserting pivot chart slicers! In this lesson, MyExcelOnline demonstrates how to quickly add slicers to pivot charts.
-
3 minMicrosoft Office lesson 432 CQ
Make the most out of Excel pivot charts by editing their design. MyExcelOnline explains how to modify pivot chart design to facilitate data visualization.
with MyExcelOnlineMake the most out of Excel pivot charts by editing their design. MyExcelOnline explains how to modify pivot chart design to facilitate data visualization.
-
5 minMicrosoft Office lesson 443 CQ
Learn how to use the MS Excel pivot chart tools layout menu to make charts as attractive and informative as possible, with minimal time and effort.
with MyExcelOnlineLearn how to use the MS Excel pivot chart tools layout menu to make charts as attractive and informative as possible, with minimal time and effort.
-
5 minMicrosoft Office lesson 453 CQ
Learn how to use the MS Excel pivot chart tools format menu to improve data visualization and apply attractive chart styles for color and font.
with MyExcelOnlineLearn how to use the MS Excel pivot chart tools format menu to improve data visualization and apply attractive chart styles for color and font.
-
6 minMicrosoft Office lesson 464 CQ
Pivot charts have come a long way since Excel 2010, but some limitations remain, even in Excel 2013. Find out about some pivot chart workarounds and shortcuts.
with MyExcelOnlinePivot charts have come a long way since Excel 2010, but some limitations remain, even in Excel 2013. Find out about some pivot chart workarounds and shortcuts.
-
10 minMicrosoft Office lesson 476 CQ
Now that you've learned how to create attractive, informative pivot charts, learn how to copy and paste them within workbooks and across the MS Office platform.
with MyExcelOnlineNow that you've learned how to create attractive, informative pivot charts, learn how to copy and paste them within workbooks and across the MS Office platform.
-
8 minMicrosoft Office lesson 485 CQ
Learn how to use slicers to filter data in Excel pivot charts. MyExcelOnline explains how to set up slicers for pivot charts and link data. Pretty nifty!
with MyExcelOnlineLearn how to use slicers to filter data in Excel pivot charts. MyExcelOnline explains how to set up slicers for pivot charts and link data. Pretty nifty!
-
8 minMicrosoft Office lesson 495 CQ
You've already learned the basics of creating P&L reports using MS Excel pivot tables; now find out how to add pivot charts to graphically represent this data.
with MyExcelOnlineYou've already learned the basics of creating P&L reports using MS Excel pivot tables; now find out how to add pivot charts to graphically represent this data.
-
15 minMicrosoft Office lesson 508 CQ
Find out how to use MS Excel pivot table charts and slicers to create a sales dashboard that can be filtered by year, region, or numerical range.
with MyExcelOnlineFind out how to use MS Excel pivot table charts and slicers to create a sales dashboard that can be filtered by year, region, or numerical range.
-
2 minMicrosoft Office lesson 512 CQ
Get an overview of how to use conditional formatting options available in MS Excel 2010 and later, including data bars, color scales, and icon sets.
with MyExcelOnlineGet an overview of how to use conditional formatting options available in MS Excel 2010 and later, including data bars, color scales, and icon sets.
-
3 minMicrosoft Office lesson 522 CQ
You've dabbled in Highlight Cells Rules in the previous lesson; now continue mastering this MS Excel function in this lesson from MyExcelOnline.
with MyExcelOnlineYou've dabbled in Highlight Cells Rules in the previous lesson; now continue mastering this MS Excel function in this lesson from MyExcelOnline.
-
3 minMicrosoft Office lesson 532 CQ
Find out how to use conditional formatting to highlight the top and bottom values of a data set in an MS Excel pivot table containing quarterly revenue data.
with MyExcelOnlineFind out how to use conditional formatting to highlight the top and bottom values of a data set in an MS Excel pivot table containing quarterly revenue data.
-
5 minMicrosoft Office lesson 543 CQ
Data bars, color scales, and icon sets are new formatting features in MS Excel 2010 and later. Find out how they can make data analysis a lot easier!
with MyExcelOnlineData bars, color scales, and icon sets are new formatting features in MS Excel 2010 and later. Find out how they can make data analysis a lot easier!
-
7 minMicrosoft Office lesson 554 CQ
Learn how to use field-specific formatting to identify salespeople who will receive a bonus. Create tailor-made conditional formatting to suit your needs.
with MyExcelOnlineLearn how to use field-specific formatting to identify salespeople who will receive a bonus. Create tailor-made conditional formatting to suit your needs.
-
3 minMicrosoft Office lesson 562 CQ
In this lesson, MyExcelOnline demonstrates how to expand or reduce the range of a conditional formatting rule using the Excel pivot table field list menu.
with MyExcelOnlineIn this lesson, MyExcelOnline demonstrates how to expand or reduce the range of a conditional formatting rule using the Excel pivot table field list menu.
-
2 minMicrosoft Office lesson 572 CQ
In this lesson, MyExcelOnline demonstrates how to create a slicer to control how conditional formatting is applied to an MS Excel pivot table.
with MyExcelOnlineIn this lesson, MyExcelOnline demonstrates how to create a slicer to control how conditional formatting is applied to an MS Excel pivot table.
-
4 minMicrosoft Office lesson 583 CQ
Learn how to display text in pivot table values areas using conditional formatting. This handy MS Excel pivot table trick will help you synthesize data.
with MyExcelOnlineLearn how to display text in pivot table values areas using conditional formatting. This handy MS Excel pivot table trick will help you synthesize data.
-
6 minMicrosoft Office lesson 594 CQ
Learn how to create an accounts receivable aging report in MS Excel using pivot table conditional formatting. These reports are critical management tools!
with MyExcelOnlineLearn how to create an accounts receivable aging report in MS Excel using pivot table conditional formatting. These reports are critical management tools!
-
3 minMicrosoft Office lesson 602 CQ
Find out how to use conditional formatting and slicers to analyze sales results in Excel pivot tables, highlighting highest and lowest sales by year and region.
with MyExcelOnlineFind out how to use conditional formatting and slicers to analyze sales results in Excel pivot tables, highlighting highest and lowest sales by year and region.
-
4 minMicrosoft Office lesson 613 CQ
As MyExcelOnline explains in this lesson, the GetPivotData formula uses the pivot table to create customized reports that give the user more flexibility.
with MyExcelOnlineAs MyExcelOnline explains in this lesson, the GetPivotData formula uses the pivot table to create customized reports that give the user more flexibility.
-
5 minMicrosoft Office lesson 623 CQ
Now that you've learned about the benefits of working with GetPivotData formulas, begin creating your own custom reports in this MS Excel lesson!
with MyExcelOnlineNow that you've learned about the benefits of working with GetPivotData formulas, begin creating your own custom reports in this MS Excel lesson!
-
3 minMicrosoft Office lesson 632 CQ
Learn how to reference dates using GetPivotData formula, using pivot table data that includes order dates as row labels and sum of sales in the values area.
with MyExcelOnlineLearn how to reference dates using GetPivotData formula, using pivot table data that includes order dates as row labels and sum of sales in the values area.
-
4 minMicrosoft Office lesson 643 CQ
Find out how to use data validation to make an interactive GetPivotData formula! Create drop-down lists that update GetPivotData results based on the selection.
with MyExcelOnlineFind out how to use data validation to make an interactive GetPivotData formula! Create drop-down lists that update GetPivotData results based on the selection.
-
3 minMicrosoft Office lesson 652 CQ
The most important data is not always the most visible. Learn how to move grand total data to the left column using the GetPivotData formula to reference cells.
with MyExcelOnlineThe most important data is not always the most visible. Learn how to move grand total data to the left column using the GetPivotData formula to reference cells.
-
7 minMicrosoft Office lesson 664 CQ
MyExcelOnline demonstrates how to use the GetPivotData formula to improve the layout of a pivot table that displays actual vs. planned sales figures.
with MyExcelOnlineMyExcelOnline demonstrates how to use the GetPivotData formula to improve the layout of a pivot table that displays actual vs. planned sales figures.
-
5 minMicrosoft Office lesson 673 CQ
Channel analysis involves evaluating partners, often comparatively. Learn how to use GetPivotData formulas to create a channel partners analysis report.
with MyExcelOnlineChannel analysis involves evaluating partners, often comparatively. Learn how to use GetPivotData formulas to create a channel partners analysis report.
-
2 minMicrosoft Office lesson 682 CQ
In this lesson, MyExcelOnline explains the benefits of using macros, demonstrating different options for enabling macros or adjusting macro settings.
with MyExcelOnlineIn this lesson, MyExcelOnline explains the benefits of using macros, demonstrating different options for enabling macros or adjusting macro settings.
-
4 minMicrosoft Office lesson 693 CQ
In this lesson, MyExcelOnline demonstrates each step of recording a macro, explaining different options for storing and sharing, and creates a macro button.
with MyExcelOnlineIn this lesson, MyExcelOnline demonstrates each step of recording a macro, explaining different options for storing and sharing, and creates a macro button.
-
4 minMicrosoft Office lesson 703 CQ
Make it easy to filter data by month, quarter, and year-to-date values. In this lesson, MyExcelOnline records three different macros to apply date filters.
with MyExcelOnlineMake it easy to filter data by month, quarter, and year-to-date values. In this lesson, MyExcelOnline records three different macros to apply date filters.
-
4 minMicrosoft Office lesson 713 CQ
MyExcelOnline records macros to generate views for region by quarter, year-to-date sales by month, and top ten channels, creating buttons for each macro.
with MyExcelOnlineMyExcelOnline records macros to generate views for region by quarter, year-to-date sales by month, and top ten channels, creating buttons for each macro.
-
7 minMicrosoft Office lesson 724 CQ
Find out how to use Excel macros to easily identify your best customers! In this lesson, MyExcelOnline demonstrates how to create a macro for a top 10 filter.
with MyExcelOnlineFind out how to use Excel macros to easily identify your best customers! In this lesson, MyExcelOnline demonstrates how to create a macro for a top 10 filter.
-
10 minMicrosoft Office lesson 736 CQ
Get data management tips that will help you conserve memory when working with large MS Excel files. Find out about four ways to reduce Excel workbook file size.
with MyExcelOnlineGet data management tips that will help you conserve memory when working with large MS Excel files. Find out about four ways to reduce Excel workbook file size.
-
4 minMicrosoft Office lesson 743 CQ
You've learned how to create pivot tables the hard way, and skills are sharper for it! Now learn how to use the Excel Pivot Table Wizard to consolidate data.
with MyExcelOnlineYou've learned how to create pivot tables the hard way, and skills are sharper for it! Now learn how to use the Excel Pivot Table Wizard to consolidate data.
-
2 minMicrosoft Office lesson 752 CQ
Learn how to use pivot tables to create a frequency distribution, and insert a chart to visually display the frequency of sales according to sales person.
with MyExcelOnlineLearn how to use pivot tables to create a frequency distribution, and insert a chart to visually display the frequency of sales according to sales person.
-
3 minMicrosoft Office lesson 762 CQ
Learn how to use pivot tables and slicers to apply break-even analysis. MyExcelOnline demonstrates how to make a break-even model with a pivot table.
with MyExcelOnlineLearn how to use pivot tables and slicers to apply break-even analysis. MyExcelOnline demonstrates how to make a break-even model with a pivot table.
-
12 minMicrosoft Office lesson 777 CQ
Learn how to create an interactive balance sheet, featuring four pivot tables, two graphs, and slicers to control the display of metrics and graphs.
with MyExcelOnlineLearn how to create an interactive balance sheet, featuring four pivot tables, two graphs, and slicers to control the display of metrics and graphs.
-
6 minMicrosoft Office lesson 784 CQ
Get two more valuable data analysis tools—monthly sales manager performance reports and customer payment reports, which include interactive features.
with MyExcelOnlineGet two more valuable data analysis tools—monthly sales manager performance reports and customer payment reports, which include interactive features.
-
7 minMicrosoft Office lesson 794 CQ
Find out about a great MS Excel add-in that will save you a lot of time when you're working with pivot tables—PivotPower from Contextures.com.
with MyExcelOnlineFind out about a great MS Excel add-in that will save you a lot of time when you're working with pivot tables—PivotPower from Contextures.com.
-
1159 min11-part Microsoft Office course34 CQ
In this data processing course, learn the basics of using pivot tables in Excel, from how to create and format a pivot table to how to make a dashboard using slicers and pivot charts.
with MyExcelOnlineIn this data processing course, learn the basics of using pivot tables in Excel, from how to create and format a pivot table to how to make a dashboard using slicers and pivot charts.
-
79593 min79-part Microsoft Office course337 CQ
Pivot tables make data analysis and visualization fun! This extensive course explores how to apply the powerful Microsoft Excel pivot table feature to create reports that impress any audience.
with MyExcelOnlinePivot tables make data analysis and visualization fun! This extensive course explores how to apply the powerful Microsoft Excel pivot table feature to create reports that impress any audience.
-
889 min8-part Analytics course49 CQ
Want to improve your website’s SEO? In this course, Collin from White List Marketing Firm shares how to reach the top of Google search results using simple, proven white hat SEO strategy.
with Collin McAdamsWant to improve your website’s SEO? In this course, Collin from White List Marketing Firm shares how to reach the top of Google search results using simple, proven white hat SEO strategy.
-
16187 min16-part Analytics course100 CQ
Google Analytics is an essential tool for any online marketer. In this course for beginners, get a comprehensive overview of how to use it to track and report valuable data about your website.
with EduonixGoogle Analytics is an essential tool for any online marketer. In this course for beginners, get a comprehensive overview of how to use it to track and report valuable data about your website.
-
11122 min11-part Entrepreneurship course66 CQ
Growing a business is much easier with a solid brand in place. Digital marketing expert Dr. Gigi Johnson reveals how to analyze web data to design the launch—or re-launch—of your business.
with Dr. Gigi JohnsonGrowing a business is much easier with a solid brand in place. Digital marketing expert Dr. Gigi Johnson reveals how to analyze web data to design the launch—or re-launch—of your business.
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.