| Create simple spreadsheets, then format numbers and text, rows and columns. Utilize borders and shading, fonts and alignment for greater impact and clarity. Learn how to copy, move, insert, and delete data. Insert functions and use basic formulas. Create simple charts! 6 hours |
Getting Started
- Understanding pointer shapes
- Undo and Redo
- Excel's menus and toolbars
- Activating another cell
- Making selections within a worksheet
- Using navigation keys
- Working with sheet tabs
Creating a New Workbook
- Entering data
- Working with comments
Entering Formulas and Functions
- Calculation operators in formulas
- Order of operation precedence
- Using the AutoSum function
- Copying data within a row or column
- Using AutoCalculate
Formatting a Worksheet
- Formatting toolbar
- Format Cells command
Editing Worksheets
- Moving and copying cells
- Moving, copying and exporting sheets
- Selecting multiple sheets
- Moving or copying within the current workbook
- Moving or copying to another workbook
- Emailing an Excel worksheet or Workbook
|
AutoFilling a Series
- Creating a custom lists series
Relative vs. Absolute references
- Relative references
- Absolute and Mixed references
- Switching between Absolute, Relative, and Mixed references
Preparing to Print
- Formatting the sheet onscreen
- Changing your margins
- Adding headers and footers
- Repeating titles on every page
- Print Preview options
- Checking page breaks
Charting Basics
- Anatomy of a chart
- Choosing the best chart type
- Selecting data
- Creating an embedded vs. a separate chart
|