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.
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.
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.
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.
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.
Let Microsoft Excel 2003 recognize your data! When you have a spreadsheet of costs and/or percentages, you don’t have to manually edit each cell to denote units. Using the format toolbar and the format painter, as demonstrated in this tutorial by Motion Training, it is easy to apply currency, comma, and percentage formatting to raw numbers. Work with your own file or follow along with an attached spreadsheet.
There are dozens of ways to input date and time in Microsoft Excel 2003. You may input recognizable information into a cell and allow Excel to automatically format it, or you may work with custom arrangements. This lesson by Motion Training demonstrates several date and time formats through both keyboard input and the format cells dialog box. Work with your own file or follow along with an attached spreadsheet.
Before you go any further, review spreadsheet formatting in Microsoft Excel 2003. Using formulas and calculations with data is only the first step to making a presentable Excel file. In this tutorial by Motion Training, learn how to change cell alignment, colors, and borders. You will also learn how to customize toolbars to your liking. Work with your own file or follow along with an attached spreadsheet.
Want Microsoft Excel 2003 to format your data with more flexibility? The conditional formatting feature changes the appearance of cells (text and/or background) when they satisfy a predetermined condition. Learn how to use conditional formatting with simple and function-based conditions in this tutorial by Motion Training. Work with your own file or follow along with an attached spreadsheet.
Want to visualize your data in Microsoft Excel 2003? With several types to choose from, charts in Excel work for just about any data set. In this lesson, Motion Training demonstrates how to insert a column chart and format it for improved aesthetics and readability. Work with your own file or follow along with an attached spreadsheet.
Another way to visualize your data in Microsoft Excel 2003 is with a pie chart. Great for comparing the parts against the whole, pie charts are also highly customizable in Excel. In this lesson by Motion Training, learn how to insert and format a pie chart to your liking. As a bonus, you will learn how to move objects to separate spreadsheets. Work with your own file or follow along with an attached spreadsheet.
If your spreadsheet is all ready to go, it is time to print it! Depending on the project, you might want to make some changes to your file’s appearance with the Page Setup dialog box. This tutorial by Motion Training shows you the gamut of print options in Excel, from orientation and scaling to margins, headers, and footers. You will also learn how to print selections of files. Work with your own file or follow along with an attached spreadsheet.
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.
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.
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.
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.
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!
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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