MOS: Excel 2010 Level 3 for Windows

Description

This Excel 2010 Level 3 course builds on the skills and concepts taught in Excel 2010 Level 1 and 2. Students will learn how to record, edit and use Macros. You will also learn how to create forms and incorporate your Macros on the forms. Other valuable features taught in this level of Excel are the Auditing Tools; using Excel in conjunction with the Internet; creating custom styles and advanced formatting; and sharing, linking and consolidating workbooks. The Appendix has valuable information on setting up your ‘default’ workbook which utilizes Styles and other Excel features learned in other levels of Excel. This course is for someone that wants to know the full power of Excel. This course can be taken either before or after Excel Database Features, Excel Formulas, Excel Dashboards or Excel Pivot Tables. If you are real familiar with Excel, it can be taken before the
Intermediate Level course.

We recommend all 9 courses for the person that wants to be an Expert in Excel.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Module 1: Macros and VBA Programming

What is a Macro?
Developer Ribbon 2007
Developer Ribbon 2010
Macro Naming
Macro Naming Rules
Auto-Run Macros
Macro Referencing
Understanding Macro Referencing
To Use Relative Referencing During Macro Recording
Recording a Macro
Creating a Macro Using the View Tab
Creating a Macro Using the Developer Tab
Running a Macro
Run a Macro Using the Macro Dialog Box
Editing a Macro
Visual Basic for Applications
VBA Modules
Visual Basic Editor
Opening the Editor from Within Excel
Macro Security
Macro Security
Setting the Macro Security Level
Adding a Macro Button to the QAT
To Change the Appearance of the Button

Module 2: Form Controls

Form Controls
What is a Form Control?
Adding Form Controls
Adding a Control to a Worksheet
Assigning a Macro to a Control
Changing the name of the button
Assigning or Recording a Macro
Assigning a Macro to a Form Control
Adding More Form Controls
The List Box Control
The Button Form Control
The Check Box Control
Customizing the Checkbox Control
The If Then Decision Structure
Using Other Form Controls
The Combo Box Control
The Group Box Control

Module 3: Formula Auditing

Formula Auditing
The Formula Auditing Group
Tracing Precedents and Dependents
Correcting Errors
Correcting Errors with the Error Checking Tool
Using the Trace Error Tool
The Circular Reference Tool
Using the Evaluate Formula Tool
Common Errors
Common Errors in Excel
The Watch Window
Using the Watch Window
To Add a Cell to the Watch Window
To Delete a Cell from the Watch Window

Module 4: Excel and the Internet

What is a Hyperlink?
Inserting Hyperlinks
Creating a Hyperlink
Link to Existing File or Web Page
Link to Place in this Document
Link to Create New Document
Full Path
Modifying Hyperlinks.
Changing the Attributes of the Selected Hyperlink
Changing the Attributes of All Hyperlinks
Saving Workbooks as Web Pages
Should you save your workbook as a Single File Web Page or Web Page?
Save As Web Page HTM and HTML Files
Save As Single File Web Page MHT and MHTML Files
Saving an Entire Workbook as a Web Page
Publishing a Workbook
Saving Worksheets as Web Pages
Saving a Chart as a Web Page
Saving a Range as a Web Page
Save as Web Page Limitations
Getting Data from the Internet
Importing from an External Data Source
Creating a Web Query
Saving a Web Query
Refreshing a Web Query
External Data Range Properties

Module 5: Sharing and Linking

Workbooks
Creating and Using Shared Workbooks
Sharing a Workbook
Sharing Limitations
How to Share a Workbook
Tracking Changes
Opening and Editing a Shared Workbook
Tracking Changes
Establishing Your User Credentials for
Tracking Changes
Highlighting Changes
Protecting a Shared Workbook
Resolving Conflicts in a Shared Workbook
Accepting and Rejecting Changes
Resolving Conflicts When Saving a Shared Workbook
Consolidating Workbooks
To Consolidate Workbooks
Combining Worksheets
Using Paste Link
Consolidating Worksheets

Appendix A: The Default

Workbook
The Default Workbook
Settings that you can save in a workbook or worksheet template
Saving Cell Styles to the Default Workbook

Enrolled