Excel Introduction - Full Day

Course Outline

Module 1: Excel Essentials & Formulas and Functions

Topics:

• Introduction to the Excel Interface
• Search & Help
• Smart Lookup
• Zooming
• Navigating and Selecting Cells
• Keyboard Shortcuts
• Deleting/Replacing Cell Data
• Performing Simple Calculations
• Saving the Workbook File
• Overview of The Formulas Ribbon
• Building Basic Formulas
• Using Simple Functions
• Formulas/Functions with the Autofill Command
• Relative and Absolute Cell References

Module 2: Formatting, Spreadsheet Design, Page Setup & Printing

Topics:

• Inserting Rows & Columns
• Moving, Copying and Pasting Data
• Using Autofill to Complete A Series of Values
• Formatting Worksheet Data/Using Cell Styles
• Introduction to Worksheet Themes
• Creating Custom Templates
• Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy
• Grouping Worksheets
• Freezing or Splitting Panes
• Grouping and Hiding Rows/Columns
• Creating Custom Views
• Spell Checking Your Worksheets
• Setting Print Options
• Using the Page Layout View
• Printing Your Worksheet

What We'll Explore:

• Be able to Navigate Excel and create spreadsheets
• Be able to use excel's basic functions (sum, max, min, avg)
• Select cells and sheets using keyboard shortcuts
• Be able to edit a spreadsheet by adding columns and rows
• Creating reusable fonts, and formats in workbooks by saving them as templates
• Adjust settings for workbook so its suitable for printing? using print options in Excel