MS Excel 2010 Intro / Intermediate

Exploring Microsoft Excel
Working with Excel, Start Excel, Use the Interface, Use the File Tab, Explore Excel Options, Work with Worksheets, Use the Ribbon, Hide the Ribbon, Customize Quick Access Toolbar, Mini Toolbar, Customize Status Bar, Exit Excel

Using Basic Workbook Skills
Select a Cell using the Keyboard and mouse, Use Key Tips, Scroll Bar Shortcut Menu, Go To Dialog Box, Enter Text & Numbers into Cells, Save, Close & Open Workbook, Create a New Workbook, Use a Template, Data Entry Shortcuts, Edit Cell Entries, Check Spelling, Create New Folder, Rename a Workbook

Working with Ranges
Use Ranges, Select Ranges with Mouse & Keyboard, Select Non-adjacent Ranges, Enter Values into a Range, Use Auto Fill

Creating Simple Formulas
Use Formulas, Use Functions, AutoSum Button & AutoSum List, Formula AutoComplete, Insert & Edit Functions in Formulas, Auto Calculate Feature, Range Borders to Modify Formulas, Check Formula Errors

Copying & Moving Data
Copy/Cut & Past Data, Copy & Paste Formulas, Paste Options Button, Paste List, Clipboard Task Pane, Create Absolute Reference, Fill Cells, Drag-&-Drop Editing, Undo & Redo

Formatting Numbers & Text
Use Currency, Percent & Comma Style, Change Decimal Places, Change Text Appearance, Rotate, Wrap & Shrink Text in a Cell, Change Cell Alignment, Change Text Indentation

Formatting Cells
Use Merge & Centre Button, Change Vertical Alignment, Split Cells, Use Borders Button, Use Fill Color Button, Paste Formats, Use Format Painter Button, Copy Formats to Non-Adjacent Cells, Clear Formats, Insert Selected, Cut or Copied Cells, Delete Selected Cells

Working with Columns & Rows
Select Columns & Rows, Use Narrow Column Tooltips, Change Column Width & Row Height, Adjust Columns Automatically, Hide & Unhide Columns & Rows, Insert Columns & Rows, Delete Columns & Rows

Using Page Setup
Set Margin & Centre Options, Change Page Orientation, Change Page Setup Options, Headers & Footers

Printing
Preview a Worksheet, Print Current Worksheet, Print a Selected Range, Print a Page Range, Print Multiple Copies