Home | About Us | Student Login | Admin Login | Employment

Schedule 1 | Schedule 2 | Corporate Training | GSA Training
Student Financing | Testing | Request Info | Contact ACE

Microsoft Excel Expert Training Course - (MS Excel Expert)

The Microsof Officet Excel Expert program is designed to prepare the student for the Microsoft Office Specialist Expert (MOS Expert) exam for Excel. The student will learn advanced techniques for Microsoft Office Excel.

After completing the program, students will understand and be able to implement the following skills:

Importing and Exporting Data
Import data from text files (insert, drag-and-drop) operations, Import from other applications, Import a table from an HTML file (insert and drag and drop operations, including HTML round tripping), Export to other applications

Using Templates
Apply templates, Edit templates, Create templates

Using Multiple Workbooks
Use a workspace, Link workbooks

Formatting Numbers
Apply number formats (accounting, currency, and number), Create custom number formats, Use conditional formatting

Printing Workbooks
Print and preview multiple worksheets, Use the Report Manager

Working with Named Ranges
Add and delete a named range, Use a named range in a formula, Use Lookup Functions (Hlookup or Vlookup)

Working with Toolbars
Hide and display toolbars, Customize a toolbar, Assign a macro to a command button

Using Macros
Record macros, Run macros, Edit macros

Auditing a Worksheet
Work with the Auditing Toolbar, Trace errors (find and fix errors), Trace precedents (find cells referred to in a specific formula)

Displaying and Formatting Data
Apply conditional formats, Perform single and multilevel sorts, Use grouping and outlines, Use subtotaling, Extract data Query databases

Using Analysis Tools
Use the Microsoft PivotTable® autoformat, Use Goal Seek, Create Microsoft PivotChart® reports, Work with Scenarios, Use Solver, Use data analysis and PivotTable, Create interactive tables for the Web with PivotTable, Add fields to a table using the Web browser

Collaborating with Workgroups
Create, edit, and remove a comment, Apply and remove worksheet and workbook protection, Change workbook properties, Apply and remove file passwords, Track changes (highlight, accept, and reject), Create a shared workbook, Merge workbooks

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.

>> Request More Information About ACE's MS Excel Expert Training Courses

>> Excel Beginner Training Class

>> Student Loans and Payment Plans