Basic Excel

Outline

Getting started:

• Spreadsheet terminology
• The Excel environment
• Navigating a worksheet
• Using a template
• Entering and editing data
• Entering and editing text and values
• Entering and editing formulas
• Saving and updating workbooks

Modifying Worksheet & Functions:

• Moving and copying data
• Moving, copying, and viewing formulas
• Absolute and relative references
• Inserting & deleting ranges, rows, columns
• Entering functions
• Auto Sum
• Other common functions

Formatting:

• Text formatting
• Row and column formatting
• Number formatting
• Merge Cells
• Apply an Auto Format
• Apply Styles
• Entering Data
• Using Flash Fill
• Using Auto Fill
• Editing Data
• Adding Rows and Columns
• Checking Your Spelling

Managing workbooks and worksheets: 

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets
• Linking worksheets with 3-D formulas
• Usingmultiple workbooks
• Linking workbooks
• Usingspecial number formats
• Workingwith themes
• Otheradvanced formatting

Outlining and subtotals:

• Outlining and consolidating data
• Creating subtotals
• Cell and range names
• Creating and using names
• Managing names
• Data structure and tables
• Sorting and filtering data
• Working with tables

Building Formulas, Shortcuts.