Our Excel 2013 Basic training covers fundamental concepts in learning how to use Microsoft Excel. Students will become familiar with the application interface, understand how to build basic formulas (with and without functions), and gain other essential skills. The class also covers data entry, navigation, formatting, and printing. (One day, 3-hour class.)
If you are entering (or re-entering) the professional workforce, new to spreadsheet applications, concerned about falling behind, or just anxious to learn more, this is the class for you!
Objectives
Students will exit the class with a basic knowledge of Microsoft Excel, and gain the ability to create and use simple worksheets using core Excel functionalities.
Prerequisites
Be familiar with the Windows operating system and comfortable using a mouse and keyboard.
- One day, 3-hour class
$199$149 ($50 discount)
Topics
Getting Started / General Navigation
- Starting Excel
- Understanding the Interface
- Backstage (Files, Options, and Settings)
- Working with the Ribbon
- Working with the Quick Access Toolbar
- Opening a Workbook
- Windows, Panes, and Zooming
- Cells, Columns, and Rows
- Sizing Columns and Rows
- Intro to Keyboard Shortcuts
- Using Excel Help
Data Entry
- The Active Cell
- Selecting a Range of Cells
- Creating a New Workbook
- Entering Constant Values
- Editing Cell Contents
- Clearing Cell Contents
- Working with Undo and Redo
- Spell Checking
- Saving a Workbook
- Closing a Workbook
- Exiting Excel
Formulas and Functions
- Entering Formulas
- Addition, Subtraction, Division, Multiplication
- Entering Functions
- Using the SUM Function
- Using Statistical and Financial Functions
- Working with the Range Finder
- Understanding Formula Error Checking
- Cell References (A1 vs R1C1; Absolute vs Relative)
Moving and Copying Data
- Cut, Copy, and Paste
- Copying or Moving Values and Formulas
- Using the Fill Handle
- Sorting Columns and Rows
Working with Worksheets
- Moving, Copying, and Inserting Worksheets
- Formatting Numbers
- Changing the Font Format
- Aligning Cell Contents
- Merging Cells
- Adding Borders
- Working with Tabs
Formatting and Printing
- Cell Width and Alignment
- Formatting within Cells
- Formatting Numbers, Dates, and Times
- Using Print Preview
- Using Page Setup Tools
- Working in Page Layout View
- Creating a Header and Footer
- Using Page Break Preview
- Printing a Worksheet
