Our Excel 2013 Essentials training is a modified class that covers important core Excel functionalities, including: Workbooks and worksheets, formulas and functions, formatting, printing, and charting. Students will understand how to build formulas (with and without functions) as well as essential printing and formatting techniques. The class also includes a brief review of the Excel application. (One day, 3-hour class.)
This class packs a lot of information into a three-hour block, and if you want to get a solid foundation in short period of time this is the class for you!
Objectives
Students will be able to use many of the core functionalities within Microsoft Excel, and understand how to navigate, calculate, format, and print worksheets.
Prerequisites
Basic familiarity with Microsoft Excel, and have some experience with workbooks, worksheets, and general spreadsheet usage.
- One day, 3-hour class
$199$149 ($50 discount)
Topics
Application Overview
- Backstage (Files, Options, and Settings)
- Working with the Ribbon
- Windows, Panes, and Zooming
- Cells, Columns, and Rows
- Keyboard Shortcuts
Formulas and Functions
- Order of Operations
- The Functions Library
- Cell References (A1 vs R1C1; Absolute vs Relative)
- Creating and Using Named Ranges
- Essential Functions (Sum, Date, Financial, etc.)
- Nested Functions
- Moving and Copying Formulas
- Using the Fill Handle
- Sorting Columns and Rows
Working with Worksheets
- Moving, Copying, and Inserting Worksheets
- Working with Tabs
Formatting and Printing
- Cell Width and Alignment
- Formatting Numbers, Dates, and Times
- Using Page Break Preview
- Merging Cells and Wrapping Text
- Applying Conditional Formatting
- Printing a Worksheet
Working with Charts
- Creating Charts
- Changing the Chart Type
- Modifying Chart Elements
- Applying a Chart Filter
- Printing Charts
- Creating and Using a Chart Template
