Users who are experienced with Excel but want to take advantage of more in-depth functionality (e.g. complex functions, defined names and ranges, charts, data manipulation, advanced formatting) should enroll in the Excel 2013 Intermediate class. (One day, 3-hour class.)
Objectives
Students will gain experience with nested functions, boolean logic, data organization and manipulation. They will understand the difference between absolute and relative references, the dual worksheet layers (value and formula), and expanded charting operations. Students will also be able to implement object security (workbooks, worksheets, cells, etc.).
Prerequisites
Students should have taken Excel 2013 Basic or its equivalent. Must be able to create, open, save, format, and print worksheets. Should be able to use formulas and basic functions and have the ability to cut, copy, and paste values and formulas. Must be familiar with Windows and possess basic computer skills.
- One day, 3-hour class
$219$169 ($50 discount)
Topics
Working with Worksheets
- Viewing, Renaming, and Color-coding Worksheets
- Moving and Copying Worksheets
- Creating Linked Formulas
- Using 3-D References
- Hyperlinks
- Advanced Sorting
- ScreenTips
Formulas and Functions
- Absolute vs Relative Cell References
- Creating and Using Named Ranges
- Using Custom Zoom
- Entering Formulas and Functions
- The Functions Library
- Working with Insert Function
- Using Financial Functions
- Using Date Functions
- Nested Functions
- Auditing and Error Checking
Cell Formatting and Data Validation
- Merging Cells and Wrapping Text
- In-Cell Formatting
- Creating and Using Custom Formats
- Copy/Paste Formats
- Applying Conditional Formatting
- Using Data Validation
Working with Charts
- Creating Charts
- Changing the Chart Location and Size
- Changing the Chart Type
- Modifying Chart Elements
- Formatting Chart Elements
- Formatting a Data Series
- Adding and Removing Data Series
- Applying a Chart Filter
- Printing Charts
- Creating and Using a Chart Template
- Creating a Sparkline
Object Security
- Protecting Workbooks and Worksheets
- Locking Cells
- Allowing Users to Edit Ranges
- Creating the History Report
Views
- Row and Column Outlines
- Group and Ungroup
- Cell Comments
