Academy of Computer Education
7833 Walker Drive, Suite 520C
Greenbelt, Maryland 20770
Phone: (301) 220-2802
Toll-Free: (877) 564-TRAIN
Fax: (301) 220-3814
Email: click here
Get Directions
Category: Desktop Applications | Vendor: Microsoft Corporation
Excel Daytime
Date: 12/03/08 - 12/04/08
Days: Weds|Thurs
Time: 8:30am - 5:00pm
The Microsoft Office Excel Hands-On learning program is designed to prepare the student for the Microsoft Certified Application Specialist (MCAS) exam for Excel. This program replaces what used to be called the Microsoft Office Specialist (MOS). In fact, the MCAS Excel encompasses all levels of usability. Microsoft previously had three levels of Excel training, now there is only one level and one test. You also have the option of taking just the one day, Excel Basic User Class. The full two day program, however, offers a deep perspective of MS Excel and demonstrates the tricks, shortcuts and time saving tools of the program. The full two day class prepares you for certifcation and makes you the "go-to" person in your office for MS Excel.
Topics and Course Content
Among many topics, you will learn how to work with worksheets, workbooks and cell data; format, manipulate, and print worksheets; create formulas, use functions, insert graphics, and share worksheets with workgroups and over the Web.
After completing the program, students will understand and be able to implement the following skills:
Working with Cells
Use Undo and Redo, Clear cell content, Enter text, dates, and numbers, Edit cell content, Go to a specific cell, Insert and delete selected cells, Cut, copy, paste, paste special, and move selected cells, Use the Office Clipboard, Use Find and Replace, Clear cell formats, Create hyperlinks,
Working with Files
Use Save, Use Save As (different name, location, and format), Locate and open an existing workbook, Create a folder, Use templates to create a new workbook, Save a worksheet/workbook as a Web Page, Send a workbook via e-mail
Formatting Worksheets
Apply font styles (typeface, size, color, and styles), Apply number formats (currency, percent, dates, and commas), Modify row and column size, Modify alignment of cell content, Adjust decimal places, Use the Format Painter, Apply autoformat, Apply cell borders and shading, Merge cells, Rotate text and change indents, Define, apply, and remove a style,
Page Setup and Printing
Preview and print worksheets and workbooks, Use Web Page Preview, Print a selection, Change page orientation and scaling, Set page margins and centering, Insert and remove a page break, Set print, and clear a print area, Set up headers and footers, Set print titles and options (gridlines, print quality, and headings for rows and columns),
Working with Worksheets and Workbooks
Insert and delete rows and columns, Hide and unhide rows and columns, Freeze and unfreeze rows and columns, Change the zoom setting, Move between worksheets in a workbook, Check spelling, Rename a worksheet, Insert and delete worksheets, Move and copy worksheets, Link worksheets and consolidate data using 3-D references
Working with Formulas and Functions
Enter a range within a formula in a drag-and-drop operation, Enter formulas in a cell and use the formula bar, Revise formulas, Use references (absolute and relative), Use AutoSum, Use the Paste Function to insert a function, Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX), Enter functions using the Formula Palette, Use date functions (NOW and DATE), Use financial functions (FV and PMT), Use logical functions (IF)
Using Charts and Objects
Preview and print charts, Use the Chart Wizard to create a chart, Modify charts, Insert, move, and delete an object (graphic), Create and modify lines and objects
Layout and Pricing
1 Day Basic User Class (8 hours) - $350
2 Day Full Excel Usability Certification Class (16 hours) - $525
1 Certification Exam (Optional) - $100
The Academy of Computer Education has the distinction of being recognized as an official Microsoft IT Academy. The Microsoft IT Academy program is a global IT learning solution that connects educators, students, and communities. Learn more about the features and benefits of the Microsoft IT Academy program.
**Federal, State, Local and Government Employees can have your organization purchase this class with our GSA Contract #GS-35F-0431S.
***Please note that Microsoft is replacing the former Microsoft Office Specialist (MOS) with the MCAS
There are no current articles related to this course. Please check back soon!