Feel like you’re the only person who doesn’t know Excel and worried about getting up to speed? You’re not alone, and we can help! Our Excel Introduction class leads you, step-by-step, through the basics of this popular spreadsheet program. There’s plenty of time for practice and hands-on exercises to cement your new knowledge.
As we go through the training, you’ll recognize — and finally understand — the very same features you’ve seen in Excel spreadsheets at work. By the end of this class you’ll be making those kinds of spreadsheets yourself, documents such as:
- Lists. These could be lists of employees, products, customers, or anything else… Lists take advantage of Excel’s formatting in rows and columns. You’ll learn how to format and freeze table headers; change fonts, sizes and colors; and set printing specs.
- Tabulations. Excel is great at number-crunching and offers a slew of arithmetic functions you can apply to your data, like averages, sums, and counts.
- Computations. Typically financials, these could be budgets, income statements, invoices, tax computations or similar. These spreadsheets contain values that are tied together by formulas so that changing one instantly changes the others: for example, the same way changing revenue immediately flows through to a change in profits. The key to creating these tied-together spreadsheets is learning how to correctly reference the spots where data is kept (“cells”) using formulas in other cells.
Module 1 - Getting Started with Excel: Essentials, Formulas & Functions
- 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 - Designing & Sharing Spreadsheets: Formatting, Layout & Printing
- 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
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”
