Course Overview
Teacher
Guy Badger (founder of Motion Training) has always been an enthusiastic supporter of self-paced, interactive learning and has designed and written numerous training programs on the use of Microsoft Office. He is currently working full time on... View ProfileDetails
- Total Time 5 hr, 53 min
- Lessons 27
- Attachments 46
- Exercises 105
-
187 CQ
27 Lessons in This Course
-
15 minFREEMath lesson 1Free8 CQ
In this lesson, Guy Badger with Motion Training teaches you how to calculate percentage values and use absolute cell references in your Excel formulas.
with Motion TrainingIn this lesson, Guy Badger with Motion Training teaches you how to calculate percentage values and use absolute cell references in your Excel formulas.
-
4 minFREEMicrosoft Office lesson 2Free3 CQ
This lesson for all versions of Microsoft Excel will show you how to use built in functions to calculate AVERAGE (MEAN), MEDIAN and MODE.
with Motion TrainingThis lesson for all versions of Microsoft Excel will show you how to use built in functions to calculate AVERAGE (MEAN), MEDIAN and MODE.
-
11 minMicrosoft Office lesson 36 CQ
In this lesson perfect for Microsoft Excel enthusiasts, learn different ways to work with text entries! Discover how to join text using specific functions.
with Motion TrainingIn this lesson perfect for Microsoft Excel enthusiasts, learn different ways to work with text entries! Discover how to join text using specific functions.
-
13 minMicrosoft Office lesson 47 CQ
Microsoft Excel 2010 is packed with powerful financial functions! In this lesson, learn to work with the Future Value, Present Value, and PMT functions.
with Motion TrainingMicrosoft Excel 2010 is packed with powerful financial functions! In this lesson, learn to work with the Future Value, Present Value, and PMT functions.
-
11 minMicrosoft Office lesson 56 CQ
The IF Function in Microsoft Excel 2010 is an important and versatile tool. Save time and give your work a more professional look by learning how to use it!
with Motion TrainingThe IF Function in Microsoft Excel 2010 is an important and versatile tool. Save time and give your work a more professional look by learning how to use it!
-
11 minMicrosoft Office lesson 66 CQ
This Microsoft Excel 2010 lesson will help you to understand and apply Nested IF Functions to a spreadsheet, which create more options for automation.
with Motion TrainingThis Microsoft Excel 2010 lesson will help you to understand and apply Nested IF Functions to a spreadsheet, which create more options for automation.
-
8 minMicrosoft Office lesson 75 CQ
Sorting through lists and creating formulas in Excel 2010 is more efficient when you use functions like COUNTIF and SUMIF. Learn about these Excel functions!
with Motion TrainingSorting through lists and creating formulas in Excel 2010 is more efficient when you use functions like COUNTIF and SUMIF. Learn about these Excel functions!
-
17 minMicrosoft Office lesson 89 CQ
Learn how to use the VLOOKUP function in Microsoft Excel 210—a great way to automate data entry in spreadsheets, save time, and avoid errors.
with Motion TrainingLearn how to use the VLOOKUP function in Microsoft Excel 210—a great way to automate data entry in spreadsheets, save time, and avoid errors.
-
13 minMicrosoft Office lesson 97 CQ
In this Microsoft Excel lesson learn how to set up a multiple worksheet workbook, add worksheets, and create calculations that take values from other sheets.
with Motion TrainingIn this Microsoft Excel lesson learn how to set up a multiple worksheet workbook, add worksheets, and create calculations that take values from other sheets.
-
7 minMicrosoft Office lesson 104 CQ
Now that you are familiar with working in multiple Microsoft Excel worksheets, learn how to calculate using values from other worksheets in this lesson!
with Motion TrainingNow that you are familiar with working in multiple Microsoft Excel worksheets, learn how to calculate using values from other worksheets in this lesson!
-
14 minMicrosoft Office lesson 118 CQ
Get ready to become a Microsoft Excel power user! In this Excel lesson, learn how to create calculations and formulas that take values from multiple workbooks.
with Motion TrainingGet ready to become a Microsoft Excel power user! In this Excel lesson, learn how to create calculations and formulas that take values from multiple workbooks.
-
22 minMicrosoft Office lesson 1212 CQ
In this Microsoft Excel 2010 lesson, you’ll learn how to create, navigate, and format a table or list of data. Guy Badger with Motion Training shows you how.
with Motion TrainingIn this Microsoft Excel 2010 lesson, you’ll learn how to create, navigate, and format a table or list of data. Guy Badger with Motion Training shows you how.
-
19 minMicrosoft Office lesson 1310 CQ
Now that you know how to create and format tables and lists in Microsoft Excel 2010, it’s time to learn how to sort and filter the data in them as well!
with Motion TrainingNow that you know how to create and format tables and lists in Microsoft Excel 2010, it’s time to learn how to sort and filter the data in them as well!
-
7 minMicrosoft Office lesson 144 CQ
Time to sort out your knowledge of Microsoft Excel! Learn how to sort your tables by criteria other than data value, such as by color or icon In Excel 2010.
with Motion TrainingTime to sort out your knowledge of Microsoft Excel! Learn how to sort your tables by criteria other than data value, such as by color or icon In Excel 2010.
-
18 minMicrosoft Office lesson 1510 CQ
Get ready to expand your fluency in Microsoft Excel 2010 with the Subtotal command! Learn how to apply the Subtotal command to several columns in a range.
with Motion TrainingGet ready to expand your fluency in Microsoft Excel 2010 with the Subtotal command! Learn how to apply the Subtotal command to several columns in a range.
-
11 minMicrosoft Office lesson 166 CQ
Using Microsoft Excel to organize and analyze data with a series of functions is effective, but with Pivot Tables the process can be streamlined!
with Motion TrainingUsing Microsoft Excel to organize and analyze data with a series of functions is effective, but with Pivot Tables the process can be streamlined!
-
15 minMicrosoft Office lesson 178 CQ
Are you ready to unleash the power of Microsoft Excel 2010? In this Excel lesson, learn how to create and work with Pivot Tables and Pivot Table Charts.
with Motion TrainingAre you ready to unleash the power of Microsoft Excel 2010? In this Excel lesson, learn how to create and work with Pivot Tables and Pivot Table Charts.
-
14 minMicrosoft Office lesson 188 CQ
Data in Microsoft Excel is useful for more than just analysis! In this lesson, learn how to make data easier to analyze using three different chart types.
with Motion TrainingData in Microsoft Excel is useful for more than just analysis! In this lesson, learn how to make data easier to analyze using three different chart types.
-
11 minMicrosoft Office lesson 196 CQ
In this Microsoft Excel lesson, learn how to apply Styles and Themes to spreadsheets, and modify existing styles to create custom themes.
with Motion TrainingIn this Microsoft Excel lesson, learn how to apply Styles and Themes to spreadsheets, and modify existing styles to create custom themes.
-
16 minMicrosoft Office lesson 209 CQ
Did you know that you can use Microsoft Excel 2010 to create organizational charts? In this Excel lesson, learn how to add, modify, and format SmartArt!
with Motion TrainingDid you know that you can use Microsoft Excel 2010 to create organizational charts? In this Excel lesson, learn how to add, modify, and format SmartArt!
-
11 minMicrosoft Office lesson 216 CQ
Learn how to customize Excel to suit the way you work! In this Excel 2010 lesson, learn how to customize the Quick Access Toolbar and Ribbon toolbars.
with Motion TrainingLearn how to customize Excel to suit the way you work! In this Excel 2010 lesson, learn how to customize the Quick Access Toolbar and Ribbon toolbars.
-
15 minMicrosoft Office lesson 228 CQ
What is a macro in Excel 2010? This exciting tool records actions in Excel while you are using the mouse or keyboard, helping you to automate your work!
with Motion TrainingWhat is a macro in Excel 2010? This exciting tool records actions in Excel while you are using the mouse or keyboard, helping you to automate your work!
-
15 minMicrosoft Office lesson 238 CQ
What happens if you create an Excel workbook and later a colleague erases the data? In this lesson, prevent this trouble by learning how to protect workbooks!
with Motion TrainingWhat happens if you create an Excel workbook and later a colleague erases the data? In this lesson, prevent this trouble by learning how to protect workbooks!
-
8 minlesson 245 CQ
In this lesson for intermediate Microsoft Excel 2010 users, learn all about hiding content and workbook structure to help with privacy and security.
with Motion TrainingIn this lesson for intermediate Microsoft Excel 2010 users, learn all about hiding content and workbook structure to help with privacy and security.
-
8 minMicrosoft Office lesson 255 CQ
Formating Excel workbooks manually can be time-consuming, especially if you work with lots of data. In this lesson, learn how to save time by using templates!
with Motion TrainingFormating Excel workbooks manually can be time-consuming, especially if you work with lots of data. In this lesson, learn how to save time by using templates!
-
11 minlesson 266 CQ
In this lesson learn how to set up and distribute a Google Form, then see how to get the resulting data into Excel using the external data import features.
with Motion TrainingIn this lesson learn how to set up and distribute a Google Form, then see how to get the resulting data into Excel using the external data import features.
-
12 minMicrosoft Office lesson 277 CQ
In this lesson discover how to successfully make Excel 2010 workbooks available to users of earlier versions of Excel, as well as users of other spreadsheets.
with Motion TrainingIn this lesson discover how to successfully make Excel 2010 workbooks available to users of earlier versions of Excel, as well as users of other spreadsheets.
-
11122 min11-part Microsoft Office course68 CQ
If your work calls for Microsoft Excel expertise or if you’re simply interested in learning one of the most powerful Microsoft Office programs - let Motion Training be your guide. Over the course of 11 lessons, you’ll learn: proper use of Excel workbooks, formulas, functions (including AutoFill, AutoSum, and more), cell formatting, chart setup, and printing tips. Each lesson consists of step-by-step instructions and practice .xls spreadsheets.
with Motion TrainingIf your work calls for Microsoft Excel expertise or if you’re simply interested in learning one of the most powerful Microsoft Office programs - let Motion Training be your guide. Over the course of 11 lessons, you’ll learn: proper use of Excel workbooks, formulas, functions (including AutoFill, AutoSum, and more), cell formatting, chart setup, and printing tips. Each lesson consists of step-by-step instructions and practice .xls spreadsheets.
-
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.
-
349 min3-part Microsoft Office course27 CQ
Need to get up and running fast on Microsoft Word 2010? Dive into this short-but-comprehensive course for beginners, and be ready to work on your document in less than an hour!
with Motion TrainingNeed to get up and running fast on Microsoft Word 2010? Dive into this short-but-comprehensive course for beginners, and be ready to work on your document in less than an hour!
-
459 min4-part Microsoft Office course31 CQ
Looking for a fast way to produce a professional-looking presentation in PowerPoint 2010? Master these techniques in just a couple of hours, and learn digital slideshow skills to dazzle your audience!
with Motion TrainingLooking for a fast way to produce a professional-looking presentation in PowerPoint 2010? Master these techniques in just a couple of hours, and learn digital slideshow skills to dazzle your 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.
-
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.