New Learning | Premium Moodle Theme

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.

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

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

Training Formats

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

By far the most competitve price we found, which included exam vouchers, hands on labs, practice test and a true Master of Cyber Security concepts as our Instructor. Franklin Mesa was the best trainer I have ever had and i walked out certified on the last day of my CompTIA Security+ certification bootcamp. 

Marc Alfonso - CompTIA Security + Student

 

The Academy is one of the best educational values for today's job market.  I studied hard and got certified (A+ and N+).  Even though I had no prior IT experience, I now have a good job replacing obsolete computers in hospitals throughout the country.  At my job interview, I just slid my test scores and certification across the table to the interviewer, who is now my boss.  I was hired the next day.  

Not bad for a 65 year old.

John Arnett- Student 

"I congratulate The Academy for a great facility and good lab computers. The Academy is great and I will definitely be taking more courses and utilizing the services available. Omer Palo is an excellent instructor that truly knows his material. I never felt bored in his class which is a first for me. Thank You."

IT Director, Burger King Corporation

"The instructor Frank Martinez is excellent – he covered so much material in 2 weeks that was unbelievable! He definitely knows what he does and it shows in the way that he conducts each lecture. He is the greatest!"
"Thanks Academy for allowing me to experience the MCSA / MCSE + Security Boot camp."

IT Professional, Florida International University

 

Schedules

Contct Us


THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Students - Orbund Log-In