Microsoft Office Courses
Course Name:
Microsoft Excel : Level One
| Date/Time | Location | Price | |
May 29 - 30, 2012 9am-4pm
|
HRI Oxon Hill, MD
| $775.00 |
Register
|
June 11 - 12, 2012 9am-4pm
|
HRI Washington, DC
| $775.00 |
Register
|
July 16 - 17, 2012 9am-4pm
|
HRI Oxon Hill, MD
| $775.00 |
Register
|
August 13 - 14, 2012 9am-4pm
|
HRI Washington, DC
| $775.00 |
Register
|
August 27 - 28, 2012 9am-4pm
|
Greenbelt Marriott Greenbelt, MD
| $775.00 |
Register
|
September 4 - 5, 2012 9am-4pm
|
Crystal City Marriott Arlington, VA
| $775.00 |
Register
|
September 24 - 25, 2012 9am-4pm
|
HRI Oxon Hill, MD
| $775.00 |
Register
|
October 9 - 10, 2012 9am-4pm
|
HRI Washington, DC
| $775.00 |
Register
|
Federal employees, contractors, self taught individuals, and anyone else who wants to learn Microsoft Excel fundamentals - and beyond.
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: Introductory
- Master the Excel interface and fundamentals, such as mouse controls, keyboard shortcuts, and dialog boxes.
- Select, retrieve, view, and chart data.
- Discover how to use Excel as a database and understand how and why we use spreadsheets.
- Review sorting & filtering, formulas, functions, charts, and graphs.
- Enter labels and values into a workbook.
- Navigate, name, and save a workbook.
- Enter and work with date values and AutoComplete.
- Edit, clear, replace cell contents, and use the Clipboard.
- Cut, Copy, Paste, Paste Special, and move cells.
- Insert and delete cells, rows, and columns, and adjust row height and column width.
- Use Undo, Redo, and Repeat.
- Find and replace information.
- Understand and effectively incorporate Smart Tags.
- Use the Format Painter to copy formatting.
- Work with AutoFormat, create a customer number format, find and replace formatting, and use conditional formatting.
- Create, apply, and modify a Style.
- Merge cells, align a cell's contents, add borders and colors, and rotate text.
- Preview and print worksheets and use advanced print options.
- Create charts, format objects in charts, change a chart’s source data and chart type, and work with a 3-D chart and custom charts.
- Work with and understand Absolute and Relative cell references.
- Hands-on exercises with time set aside to practice what you have learned.
Our training features a two-instructor approach to maximize learning and allow for more “hands-on” practice. You also receive a copy of Microsoft Office Excel QuickSteps – a full-color, user-friendly manual.
Course includes lunch, continental breakfast, certificate, and all course materials.