The Basics
- Creating a New Workbook
- Navigating in Excel
- Moving the Cell Pointer
- Using Excel Menus
- Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
- Entering Values in a Worksheet and Selecting a Cell Range
- Previewing and Printing a Worksheet
- Getting Help from the Office Assistant
- Saving a Workbook & Re-opening a saved workbook
Formatting a Worksheet
- Creating Headers, Footers, and Page Numbers
- Adjusting Page Margins and Orientation
- Adding Print Titles and Grid lines, rows to repeat at top of each page
- Formatting Fonts & Values
- Adjusting Row Height and Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and Patterns
- Using the Format Painter
- Using Auto Format
- Merging Cells, Rotating Text, and using Auto Fit
- Using Auto Fill
Managing your workbooks
Editing a Workbook
- Entering Date Values and using Auto Complete
- Editing, Clearing, and Replacing Cell Contents
- Cutting, Copying, and Pasting Cells
- Moving and Copying Cells with Drag and Drop
- Collecting and Pasting Multiple Items
- Using the Paste Special Command
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
- Checking Your Spelling
- Finding and Replacing Information
- Inserting Cell Comments
Formulas
Creating & Working with Charts
USING RANGES
COPYING & PASTING FORMULAS
COLUMNS & ROWS
Talk with a Consultant
Hi! Click one of our member below to chat on WhatsApp
