Course 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 59 min
- Lessons 11
- Attachments 12
- Exercises 35
-
34 CQ
11 Lessons in This Course
-
6 minFREEMicrosoft Office lesson 1Free4 CQ
Ready to do more with MS Excel? Gain an overview of what will be included in this Microsoft Excel course on the basics of pivot tables.
with MyExcelOnlineReady to do more with MS Excel? Gain an overview of what will be included in this Microsoft Excel course on the basics of pivot tables.
-
5 minMicrosoft Office lesson 23 CQ
Learn to organize and format data to create an Excel table with an easy-to-read design, complete with useful header and total rows; next step, pivot tables!
with MyExcelOnlineLearn to organize and format data to create an Excel table with an easy-to-read design, complete with useful header and total rows; next step, pivot tables!
-
5 minMicrosoft Office lesson 33 CQ
In this data processing lesson, learn how to create a pivot table in Excel, including organizing the fields to summarize, analyze, and report key information.
with MyExcelOnlineIn this data processing lesson, learn how to create a pivot table in Excel, including organizing the fields to summarize, analyze, and report key information.
-
3 minMicrosoft Office lesson 42 CQ
In this lesson, learn how to format a pivot table in Excel, including how to refresh data, and format the values, style, and layout of the pivot table.
with MyExcelOnlineIn this lesson, learn how to format a pivot table in Excel, including how to refresh data, and format the values, style, and layout of the pivot table.
-
2 minMicrosoft Office lesson 52 CQ
In this Excel lesson, learn to display various values based on a field, how to hide grand totals, and tips for customizing the pivot table labels.
with MyExcelOnlineIn this Excel lesson, learn to display various values based on a field, how to hide grand totals, and tips for customizing the pivot table labels.
-
7 minMicrosoft Office lesson 64 CQ
In this lesson, learn how to use the Show Values as options under the Value Field Settings to run a variety of calculations in an Excel pivot table.
with MyExcelOnlineIn this lesson, learn how to use the Show Values as options under the Value Field Settings to run a variety of calculations in an Excel pivot table.
-
6 minMicrosoft Office lesson 74 CQ
In this data processing lesson, you'll learn how to use values, dates, and locations to group data in pivot tables together for dynamic, useful reports.
with MyExcelOnlineIn this data processing lesson, you'll learn how to use values, dates, and locations to group data in pivot tables together for dynamic, useful reports.
-
3 minMicrosoft Office lesson 82 CQ
In this data processing lesson, learn how to use slicers in Excel pivot tables to sort associated data into informative, at-a-glance reports.
with MyExcelOnlineIn this data processing lesson, learn how to use slicers in Excel pivot tables to sort associated data into informative, at-a-glance reports.
-
2 minMicrosoft Office lesson 92 CQ
Follow along with this Excel lesson to learn how to insert pivot charts that link not only to a pivot table but also to associated slicers.
with MyExcelOnlineFollow along with this Excel lesson to learn how to insert pivot charts that link not only to a pivot table but also to associated slicers.
-
4 minMicrosoft Office lesson 103 CQ
Follow along with this pivot table lesson to learn how to link sliders and pivot charts together to create an adjustable, dynamic dashboard in MS Excel.
with MyExcelOnlineFollow along with this pivot table lesson to learn how to link sliders and pivot charts together to create an adjustable, dynamic dashboard in MS Excel.
-
9 minMicrosoft Office lesson 115 CQ
Now that you know your way around an Excel pivot table, follow along to gain tips to navigate, customize, and personalize the features of this useful tool.
with MyExcelOnlineNow that you know your way around an Excel pivot table, follow along to gain tips to navigate, customize, and personalize the features of this useful tool.
-
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.
-
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.