Software lessons Show All Sort By students

Interested in learning how to use Microsoft Excel 2010? The first in a series, this Excel tutorial covers how to edit and format spreadsheets, enter data, and create basic charts. Motion Training will also teach you simple tips and tricks to help you get started with this powerful software. Although the lesson focuses on Microsoft Excel 2010, the concepts covered can be applied to earlier versions of Excel.

Assignment:
9:19
90K
19K
992
1.3K

New to Microsoft Excel 2003? Unfamiliar with the program and its basic functions and applications, or intimidated by this complex software? This tutorial demystifies the program and teaches you the basics of creating a spreadsheet and chart from a series of data, while demonstrating the advantages of using Microsoft Excel to manage information.

Assignment:
10:54
75K
13K
997
1.3K
2 of 12

Begin wrapping your head around Excel with this tutorial on basic workbook skills! Follow along with Motion Training as he demonstrates how to create a new spreadsheet, enter and edit data, format and resize your data cells, and how to save your changes - all the while cluing you in on handy keyboard shortcuts. Although this tutorial is specific to Excel 2010, most of the skills taught here can be applied to earlier versions of Microsoft Office.

Assignment:
10:13
14K
5.5K
162
247
3 of 12

In this lesson, Motion Training demonstrates how to do calculations in spreadsheets in Microsoft Excel 2010. From where important keys are located on the keyboard to the sequence in which formulas are written, Guy equips you to do basic calculations. By the end of the tutorial, you will understand the benefits of using cell references instead of numbers, and be able to apply formulas quickly to lists of calculations.

Assignment:
14:04
12K
4.8K
109
159
4 of 12

Improve your Microsoft Excel skills by learning how to use common functions. In this lesson, Motion Training will walk you through a sample workbook and commonly used Excel functions: sum (adding), average, maximum, minimum, and count. Learn how to set the range of a function manually, how to use the Excel AutoSum feature, and how to choose standard functions from the function wizard or the formula library.

Assignment:
18:46
8.6K
4.1K
122
126
5 of 12

Learn how to use the number formatting tools in Excel 2010 to apply Currency, Comma, Percentage and Fraction formatting. The lesson also introduces the Format Painter tool that can save you time in formatting your Excel spreadsheets. In addition, this comprehensive 17-minute lesson includes practice files so you can try out your new Excel skills. Motion Training makes formatting in Excel easy!

Assignment:
17:13
3.6K
2.8K
31
43
2 of 11

Whether you have a home business and need to keep track of inventory, or you have to organize data for a report, spreadsheets are a great organizational tool and can help you manage information efficiently. In this lesson, learn how to get started in Microsoft Excel 2003. Guy Badger shows you the basics of data entry and formatting, and teaches you about auto complete and general navigation in the spreadsheet.

Assignment:
8:23
11K
2.9K
199
237
9 of 12

Are you hungering for new Microsoft Excel skills? Learn how to make a pie chart! This lesson from Motion Training teaches you to make and modify a pie chart, which tracks the distribution or percentage of data across multiple categories. Learn how to select your numbers, create your chart, and format it by moving individual pie slices (for an 'exploded pie chart'). Give the chart a 3D effect, and see how to label your pie slices with numbers or percentage values and format your legend box.

Assignment:
11:01
2.5K
2.8K
16
32
6 of 12

Learn how to use the date and time formatting tools in Excel to apply a variety of date and time formats. This lesson shows how to create your own custom date and time formats in Excel spreadsheets, and introduces a few handy keyboard shortcuts to make date and time entry much faster. This comprehensive 18-minute lesson includes practice worksheets for you to download and try out your new Excel skills. Motion Training makes formatting in Excel easy!

Assignment:
18:25
3.5K
2.7K
25
29
10 of 12

Whether you need to track your company's progress over time or simply want to improve your Excel skills, this lesson from Motion Training walks you through the basics of creating line charts in Microsoft Excel. Learn to select your data, make your chart, and mark and label data points. Discover how you can alter your axis to exaggerate changes in the data, and learn how to make charts with multiple series of data. Line charts allow you to present your data in a clear and visually appealing way.

Assignment:
13:40
2.1K
2.6K
25
35
7 of 12

Learn how to use the numerous formatting options in Excel 2010 to add a professional look to your spreadsheets. The lesson will show you how to apply font formatting, align text and numbers, add color, and work with cell borders. This comprehensive 20-minute lesson includes practice worksheets for you to download and try out your new skills.

Assignment:
20:23
2.7K
2.6K
31
32
3 of 11

Take the confusion out of calculations with this Excel 2003 tutorial from Motion Training. In this third lesson in the training series for Excel users, learn how to create and format a table to compute equations using division, multiplication, addition, and subtraction. Become familiar with keyboard shortcuts, and learn what cell references are and how using them will make updating data much simpler. Finally, learn tips and tricks to make your calculations quicker and easier.

Assignment:
8:22
9K
2.4K
108
108

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
3.1K
1.5K
84
131

We use fonts every time we type, but do we really understand them? In this first in a series of typography lessons from Yes I'm a Designer, get an introduction to the wonderful world of fonts. You'll learn how to use InDesign to view the full range of glyphs in a font (beyond the characters you're used to seeing on your keyboard), discover how fonts are stored on your computer, and unravel the mystery of unicode.

Assignment:
5:15
798
1.4K
8
26

Want to wow the world with the quality HD video you could be shooting with that iPhone in your pocket? This lesson will teach you the basics of shooting video on your iPhone 4, 4s, or 5. Once you are familiar with the camera app, learn how to hold and focus the camera, and how to view an accurate display of your video. Ready to shoot? Finish this lesson by learning ways to stabilize your camera to make your online video or tutorial appear smooth and fluid.

Assignment:
10:16
1.1K
1.1K
101
133

You've created your Curious video lesson, sharing your knowledge with the camera. Now it's time to share your lesson with the world! Learn how to use the Curious LessonBuilder to: break your lesson up into easily digestible sections; name your lesson and sections; create exercises to quiz your students on key points; add attachments to provide helpful external materials for your students; preview your lesson; and publish it live on Curious.com!

Assignment:
8:57
1.3K
744
77
64

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
1.2K
698
42
61
4 of 11

Get more out of your data in Microsoft Excel 2003! Once you have a spreadsheet, use Excel functions like sum, average, max, min, and count to get a better understanding of your numbers. Whether you have never used Excel or your skills are lodged in the deep recesses of your memory, this tutorial by Motion Training makes using five of Excel’s basic functions easy. Work with your own file or follow along with an attached spreadsheet.

Assignment:
15:49
3.9K
937
35
58
1 of 4

Microsoft Excel is a great program for organizing and analyzing data. One of the most helpful tools within the program, though, is the ability to turn any range of data into a table (which allows you to sort and filter your data, as well as display it in an easy to read fashion) with the click of a mouse. So, get comfortable with Excel! This lesson from Subject Money will show you how to create a table, and acquaint you with the numerous styling and table options available.

Assignment:
9:49
4.1K
592
15
39