Microsoft Office Courses
Course Name:
Microsoft Excel: Level Three
| Date/Time | Location | Price | |
July 20, 2012
9am-4pm
|
HRI
Oxon Hill, MD
| $395.00 |
Register
|
August 17, 2012
9am-4pm
|
HRI
Washington, DC
| $395.00 |
Register
|
August 31, 2012
9am-4pm
|
Greenbelt Marriott
Greenbelt, MD
| $395.00 |
Register
|
September 28, 2012
9am-4pm
|
HRI
Oxon Hill, MD
| $395.00 |
Register
|
All students who took our Microsoft Excel: Level Two course OR advanced users with outstanding Excel skills
.
Note: Since they are very similar, we have the
Microsoft Excel 2007 and 2010 versions available in class for each student. You can work with either version (or both) and our instructors will demonstrate the minor differences.
Level: Advanced
- Summarize and analyze large amounts of data in a logical, organized manner.
- Create interactive pivot tables and pivot charts to perform real time data analysis, including specifying the data analyzed, changing a calculation, selecting what appears, and formatting and charting a pivot table.
- Learn advanced formulas and functions.
- Fix formula errors.
- Perform data imports and exports.
- Review advanced filtering techniques with flat databases.
- Create and sort a list, filter a list with AutoFilter, create a custom AutoFilter, filter a list with Advanced Filter, and copy filtered records.
- Use data validation and drop down lists.
- Use the lookup, VLookup, and logic functions.
- Automate repetitive tasks using Macros.
- Record a Macro, play a Macro, and assign a Macro a shortcut.
- Perform “What if” analysis.
- Create forms with command buttons.
- Use the PMT function, mathematical functions, date and time functions, and database functions.
- Protect a worksheet.
- Add a print title and gridlines.
- Add and work with hyperlinks.
- Save a workbook as a non-interactive web page.
- Import an external data source, including CSV files.
Our team of instructors have developed a course to cater to our students who have wanted to learn Excel’s most advanced features and functions! This class covers those advanced features with an emphasis on Excel’s data analysis capabilities. You also receive a copy of Microsoft Office Excel Step by Step, which includes a Microsoft Office System Reference Pack on CD-ROM.
Course includes lunch, continental breakfast, certificate, and all course materials.