Motion Training
Essential Skills for Microsoft Office Users

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 developing an exciting range of new tutorials that he believes will not only help people get started with the most popular business software, but turn them into confident users, opening doors to new opportunities in learning and at work.

Teacher Statistics
Lessons:
Total Views:
Enrolled Students:
Assignments:
55
240,189
29,023
2,649
2924
3903
Excel 2003 | The Essentials
FREE Preview
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.
Taught by Motion Training
11 lessons
110K
13K
1.4K
1.9K
20
SEE MORE
Excel 2010 | The Essentials
FREE Preview
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.
Taught by Motion Training
9 lessons
130K
17K
1.4K
1.8K
14
SEE MORE
COURSE: Microsoft PowerPoint 2010 | The Essentials

Show off your slideshow skills with this tutorial in the basics of PowerPoint! In this beginner lesson from Motion Training, learn to create professional and engaging slideshows. See how to: add slides; create bullet points; write and edit text make custom slide layouts; format your presentation with themes; add images, animate your presentation; and much more. Although this lesson is specific to PowerPoint 2010, the concepts presented here can be applied to any edition of PowerPoint.


Assignment:
17:30
2.7K
1.2K
80
123

You've learned the basics of navigating Microsoft Office, but how do you create really effective PowerPoint presentations? Motion Training continues his series on PowerPoint 2010 by offering advice on what to take into account when making a good slideshow. See PowerPoint presentation examples, and get a sense of how to tailor your project to your audience and objectives, making your content easy to digest and learning how best to deploy images and graphs.


Assignment:
11:37
298
96
3
13

Why just say something in a powerpoint presentation when you could say it in style? This lesson from Motion Training’s Microsoft Office PowerPoint series explains how to deal with text boxes and WordArt. Learn how to make use of PowerPoint templates, edit font size and type, create fancy text, add bullet points, and generally add a little pizzaz to the words in your slideshow. This lesson includes handy keyboard shortcuts and clear examples of making a PowerPoint presentation.


Assignment:
16:27
178
35
2
2

A picture’s worth a thousand words, so why not add some to your PowerPoint presentations? Motion Training continues its series on how to use Microsoft Office PowerPoint 2010 by introducing you to inserting photos and Clip Art. Learn how to import your own photo or find Microsoft Clip Art. See how to resize, move, and rotate images without distorting them. Make a picture into your slide’s background, or apply a photo effect such as changing the transparency of a picture in your slideshow.


Assignment:
13:39
173
50
3
6
Failed to load more lessons. Please try again.
COURSE: Microsoft Word 2010 | The Essentials

Become a word whiz with this introduction to Microsoft Word 2010 for beginners! This opening overview of a series of lessons on Microsoft Word from Motion Training takes you through the initial basics of navigating Microsoft Word. Learn about typing, correcting errors, using Word’s spell check and autocorrect features, and formatting your text. Find out how to save documents and use and keyword shortcuts, and then move beyond text by inserting tables and pictures into your document.


Assignment:
20:07
867
440
36
55

Patawaran tells us that “A blank page is no empty space. It is brimming with potential.” Learn how to harness all that potential with this second lesson from Motion Training’s series on Microsoft Word 2010 for beginners. Learn how to create a new document, use Microsoft Word keyboard shortcuts, modify spacing, and cut, copy, and paste text. Then preserve your work by saving and printing! The skills in this Microsoft Word tutorial also can be used for earlier or later versions of Word.


Assignment:
12:47
323
74
3
6

Learn to navigate Microsoft Word 2010 with grace and ease! In this third lesson from a series of Microsoft Word tutorials, Motion Training teaches you how to open existing documents and how to scroll through the document with a mouse or keyboard. Learn how use spell check to catch spelling and grammar errors, select and delete sections of text, use the undo and redo features, and search a Microsoft Word document for a specific word or phrase.


Assignment:
16:23
298
67
3
2
Failed to load more lessons. Please try again.
Other Lessons by Motion Training

Time to sort out your knowledge of Microsoft Excel! In this lesson, Motion Training teaches you how to sort your Excel tables by categories other than cell content, particularly color. Find out how to add icons to your cells, then sort by those icons using Conditional Formatting. See how to sort spreadsheets by 'Likes': fill color, font color, or icon color. This lesson is also a great review in using Excel's data sorting functions, including how to add multiple levels at which data is sorted.


Assignment:
7:55
448
172
1
4

Tired of calculating things by hand? This lesson for all versions of Microsoft Excel will show you how to use built in functions to calculate AVERAGE (MEAN), MEDIAN and MODE. In addition you will see how to use a combination of functions to calculate the range from a list of numbers. The worksheet featured in the lesson can be downloaded - just click the paperclip icon at the top right of the lesson player


Assignment:
4:09
183
69
1
2

The IF Function is one of Microsoft Excel's most powerful features. In this lesson from Excel master Guy Badger with Motion Training, you will learn how to create IF functions in Excel 2010 to add a degree of automation to your spreadsheets—saving you time and giving your work a more professional look.


Assignment:
11:55
11
8
0
0

Displaying data using effective data visualization tools is essential when working in Microsoft Excel 2010! In this lesson, learn how to use the most basic data display tool: the column chart. Start by learning how to select data to create a chart, selecting the chart type, and applying formatting to add a professional finish to the charts you create!


Assignment:
13:34
0
0
0
0

In this lesson, Guy Badger with Motion Training teaches you how to calculate percentage values and incorporate percentages into simple and complex formulas in Microsoft Excel 2010. It also covers the importance of using absolute cell references—you’ll wonder how you managed your spreadsheet data without them!


Assignment:
15:15
9
10
0
0

The VLOOKUP function in Microsoft Excel 2010 is a great way to automate data entry in spreadsheets, to save you time, and to avoid data errors within those spreadsheets. This lesson from Guy Badger with Motion Training teaches you how to use and get the best use out of the VLOOKUP function in Excel.


Assignment:
17:26
11
7
0
1

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 demonstrates how to use several shortcuts along with a multitude of automated features that’ll help you add data to your tables quickly and easily, and will save you headaches!


Assignment:
22:01
1
2
1
0

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! Guy Badger with Motion Training gives real-life examples of how to sort and filter data in Excel spreadsheets. You’ll first learn about basic sorting, then learn how to apply advanced sorting options using a variety of data filtering tools that’ll help you quickly find essential information within your data tables.


Assignment:
19:38
8
11
0
0

This Microsoft Excel 2010 lesson will help you to understand and apply Nested IF Functions to a spreadsheet, which create more options for automation. You’ll learn how to expand the basic IF Function capability for better, detailed spreadsheet data organization, and you’ll even learn how to troubleshoot when the functions are written incorrectly.


Assignment:
11:31
3
2
0
0

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 and important keyboard shortcuts in this lesson from Motion Training! COUNTIF and SUMIF are some of Excel 2010’s most useful functions for analyzing numeric data. This lesson will help you save time and headaches when sorting through your spreadsheets.


Assignment:
8:10
4
3
1
0

Get ready to expand your fluency in Microsoft Excel 2010 by learning about the Subtotal command! Before jumping into this function itself, discover the basics of formatting and manipulating tables. Then learn how to apply the Subtotal command to one column, and then learn how to work with several columns in a range. Finally, learn how to print a table so you can share your work with others!


Assignment:
18:17
4
1
0
0

Using Microsoft Excel to organize and analyze data with a series of functions is effective, but what if the process could be simplified? In this Microsoft Excel 2010 lesson, learn one of the most powerful tools in Excel: Pivot Tables! Discover how to use this feature with existing data, and see how Pivot Tables provide amazing flexibility in how data is displayed. The best part is that it's really easy to use once you get the hang of it!


Assignment:
11:30
1
3
0
0
Failed to load more lessons. Please try again.