Microsoft Office Excel
Getting Started
- Spreadsheets
- Microsoft Office Button
- Ribbon
- Quick Access Toolbar
- Mini Toolbar
Customize Excel
- Popular
- Formulas
- Proofing
- Save
- Advanced
- Customize
Working with a Workbook
- Create a Workbook
- Save a Workbook
- Open a Workbook
- Entering Data
Manipulating Data
- Select Data
- Copy and Paste
- Cut and Paste
- Undo and Redo
- Auto Fill
Modifying a Worksheet
- Insert Cells, Rows and Columns
- Delete Cells, Rows and Columns
- Find and Replace
- Go To Command
- Spell Check
Performing Calculations
- Excel Formulas
- Calculate with Functions
- Function Library
- Relative, Absolute, & Mixed Functions
- Linking Worksheets
Macros
- Recording a Marco
- Running a Macro
Sort and Filter
- Basic Sorts
- Custom Sorts
- Filter
Graphics
- Adding a Picture
- Adding Clip Art
- Editing Pictures and Clip Art
- Adding Shapes
- Adding SmartArt
Charts
- Create a Chart
- Modify a Chart
- Chart Tools
- Copy a Chart to Word
Formatting a Worksheet
- Convert Text to Columns
- Modify Fonts
- Format Cells Dialog Box
- Add Borders and Colors to Cells
- Change Column Width and Row Height
- Hide or Unhide Rows and Columns
- Merge Cells
- Align Cell Contents
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
Page Properties and Printing
- Set Print Titles
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Customize the Layout
- Split a Worksheet
- Freeze and Unfreeze Rows & Columns
Hide and Unhide Worksheets
