Introduction
- Introduction
Getting Started
- Three Primary Functions of Excel
- Spreadsheet Terminology
- Overview of the Excel Screen
- Navigating a Worksheet
- Using Zoom
Basic Worksheet Skills
- Creating a New Workbook
- Entering Data
- Selecting a Range
- Selecting Columns, Rows and Non-contiguous Cells
- Using Worksheets
- Using AutoFill
- Deleting a Worksheet
- Saving a Workbook
Creating Formulas
- Entering a Simple Formula
- Using Cell Addresses in a Formula
- Using Simple Functions: SUM
- Using Autofill with Formulas
- Using AutoSum
- Inserting Functions: AVERAGE, MAX, MIN, COUNT
- Working with Date Arithmetic
- Date and Currency Formatting
- Using Clear All
- Relative v. Absolute Cell Addressing
- AutoCalculate
Editing a Workbook
- Deleting a Range
- Using Undo and Redo
- Using Cut, Copy and Paste
- Using Paste Options
- Using the Clipboard Task Pane
- Using Find and Replace
Formatting the Worksheet
- Inserting and Deleting Columns and Rows
- Adjusting Column Widths and Row Heights
- Hiding Rows and Columns
- Changing Numeric Formats
- Using the Format Cells Dialog Box
- Changing Text Formats
- Aligning Data
- Using Borders and Shading
- Using the Format Painter
- Using Cell Styles
- Creating New Cell Styles
- Modifying Cell Styles
- Using Themes
Working with Large Worksheets or Multiple Workbooks
- Using the Zoom Feature
- Splitting the Window
- Freeze and Unfreeze Panes
- Tiling Multiple Workbooks
- Synchronous Scrolling
- Hiding, Maximizing, and Closing Windows
Using Protection and Comment Boxes
- Adding, Hiding, and Deleting Comments
- Locking and Unlocking Cell Ranges
Printing and Page Setup
- Using Page Break Preview
- Using Print Preview
- Changing the Orientation
- Changing the Margins
- Adding Headers and Footers
- Setting Sheet Options
- Setting Print Titles
- Working with Print Areas
- Using the Page Layout Tab
Conclusion
- Conclusion
Excel 2010 Introduction Assessment
- Assessment Test
