Microsoft Excel - Intermediate

Dec 12, 2017 09:00am -
Dec 12, 2017 04:30pm
(GMT-6)
St. Louis

 

Event Description

This ILT Series course will teach students how to work with large worksheets in Microsoft Excel, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel (exam 77-421). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Excel.

Course Outline

Unit 1: Managing workbooks and worksheets
Topic A: Viewing large worksheets
Topic B: Printing large worksheets
Topic C: Working with multiple worksheets
Topic D: Linking worksheets with 3-D formulas
Topic E: Using multiple workbooks
Topic F: Linking workbooks

Unit 2: Advanced formatting
Topic A: Using special number formats
Topic B: Working with themes
Topic C: Other advanced formatting

Unit 3: Outlining and subtotals
Topic A: Outlining and consolidating data
Topic B: Creating subtotals

Unit 4: Cell and range names
Topic A: Creating and using names
Topic B: Managing names

Unit 5: Data structure and tables
Topic A: Sorting and filtering data
Topic B: Working with tables

Unit 6: Web and sharing features
Topic A: Saving workbooks as Web pages
Topic B: Using hyperlinks

Unit 7: Documenting and auditing
Topic A: Auditing features
Topic B: Comments in cells and workbooks
Topic C: Protection
Topic D: Workgroup collaboration

Unit 8: Application settings and templates
Topic A: Application settings
Topic B: Working with templates

Prerequisites: There are no prerequisites for this course.

Advanced Preparation: There is no advanced preparation for this course.

Competencies: Computer Science

Delivery Method: Group-Live

Program Level: Intermediate

Recommend CPE Credits: 7

Fields of Study: Computer Science

Duration: Full-day – 9:00 am - 4:30 pm

Member Cost:  $175; NonMember Cost: $189

Computer Training Cancellation/Reschedule Policy: If cancellation/reschedule is received 15 or more business days prior to the start of the class, there will be no penalty. If cancellation/reschedule is received 10-14 business days prior to the start of the class, there will be 50% penalty billed. Anything less than 10 business days the full fee for the class will be billed.

For more information regarding refund, complaint and/or program cancelation policies, please contact AAIM’s Research and Solutions Team at 314-968-3600.​


Event Type:Computer Training
Category:Computer Training
Early registration ends on Oct 08, 2017.
Regular registration starts on Oct 09, 2017 and ends on Dec 04, 2017.
Late registration starts on Dec 05, 2017.
(GMT-06:00) Central Time (US & Canada)

Register for this event  

Registration Fees
Fee TypeEarlyRegularLate
 Computer Training
Member Fee: $175.00$175.00$225.00
Non-Member Fee: $189.00$189.00$239.00