Microsoft Office
| Course Name: |
Microsoft Excel: Level Two |
| Credits: |
NASBA CPEs: 14|CEUs: 1.4
|
| Level: |
Intermediate |
Select a Date and Location
Who Should Attend
All students should take our Microsoft Excel: Level One class first, unless you have intermediate level Excel skills.
Note: We have Microsoft Excel 2010 and 2013 available in class for each student. You can work with either version (or both) and our instructor will demonstrate the minor differences.
What You Will Learn
- Produce and link multiple spreadsheets.
- Practice with drop down lists, formatting, conditional formatting, and embedding.
- Receive an introduction to data analysis with Pivot Tables.
- Learn to use Excel as a database.
- Create and use range names.
- Select nonadjacent cell ranges.
- Use the AutoCalculate feature.
- Display and print formulas in a worksheet.
- Identify and fix formula errors.
- Learn advanced functions for Graphs and Charts.
- Format a Data Series and Chart Axis.
- Add headers, footers, and page numbers to a worksheet.
- Reference external data sources.
- Protect and hide a worksheet.
- Save a “reader friendly” Custom View.
- Create and use templates.
- Add records to a list using a Data Form.
- Work with Lists.
- Work with AutoFormat, create a custom number format, find and replace formatting, and use conditional formatting.
- Work with and understand Absolute and Relative cell references.
- Preview and print worksheets and use advanced print options.
- Receive an introduction to Macros.
- Hands-on exercises with time set aside to practice what you have learned.
Why You Should Attend
Our training maximizes learning and allows for more “hands-on” practice. You also receive a copy of Microsoft Excel Visual: Quick Tips - a user-friendly, color manual.