Tutorials, How-To Videos and Documents

We have looked at the basic terminology associated with spreadsheets and are now ready to look at more specific how-to’s. Below are links to step-by-step tutorials from the Microsoft Website that explain common spreadsheet tasks and provide instructions and tips for performing these functions in the most efficient manner. The links below will take you through the basics of creating a spreadsheet, working with the types of data that can be input and give you an introduction to formulas and functions. The tutorials are either text or video based and all demonstrate tasks in Microsoft Excel 2010 — our campus standard at Broome Community College.

Note: The tutorials and documents listed below are only a small percentage of the complete set of the complete series available on the Microsoft site. To access all available Microsoft Office training materials please visit Microsoft’s site at:

http://office.microsoft.com/en-us/support/training-FX101782702.aspx

Links to Microsoft Excel 2010 Tutorials and Documents

Get to know Excel 2010: Create your first spreadsheet

If you are new to Microsoft Excel and to the creating of spreadsheets, this is where you should begin! This tutorial will give you examples of the types of spreadsheets that can be created, an overview of the Excel environment, and the basics of creating a new spreadsheet. The tutorial then moves on to performing basic math calculations, navigating within Excel and printing. It concludes with a practice and self test.

Basic Tasks in Excel 2010

The above link to the document will walk you through some of the basic tasks you will need to know in Microsoft Excel. In addition to entering data, this document will show you the basic formatting option , and methods of sorting and filtering your data. In addition, this document will also provide you with links to more detailed information. When reading the documents below, be sure to also click on the links contained within them. There are some great videos and Quick Start Guides that will help in your journey of learning Excel.

Basic Tasks in Excel 2010

Entering Data in a Worksheet

Formatting Numbers and Available Number Formats

Formatting a Worksheet

Filtering Data

Sorting Data

Creating a Formula or Function

Creating a Chart

Printing a Worksheet

Excel 2010 Keyboard Shortcuts (CTRL Key Shortcuts)

Using the keyboard rather than menus or toolbars can be a real time-saver. This course will introduce you to the shortcut keyboard combinations (using the CTRL Key) that you can use to carry out commonly performed tasks.

Excel 2010 Keyboard Shortcuts (ALT Key Shortcuts)

Using the keyboard rather than menus or toolbars can be a real time-saver. This course will introduce you to the shortcut keyboard combinations (using the ALT Key) that you can use to carry out commonly performed tasks.

Additional Training Courses and information can also be found on the “Training courses for Excel 2010” page.