|Author :||Jay R Carlson, MCSE, MCDBA, A+ Certified|
|CPE Credits :||2.0|
|IRS Credits :||0|
|Passing Score :||70%|
|Primary Subject-Field Of Study:||
Specialized Knowledge and Applications - Specialized Knowledge & Applications for Course Id 706
The following training introduces you to Microsoft Excel 2007 and 2010 Ribbon customizations. You will learn how to add customized tabs and groups to Excel 2007 and 2010. You will learn to edit XML while working with the Custom UI Editor. You will also learn how to create and insert a Visual Basic Application (VBA) command into the Ribbon using the Visual Basic Editor.
|Usage Rank :||0|
|Experience Level :||Overview|
|Additional Contents :||Complete, no additional material needed|
|Additional Links :|
|Advance Preparation :||None|
|Delivery Method :||Self-Study|
|Intended Participants :||Anyone needing Continuing Professional Education (CPE)|
|Revision Date :||21-Apr-2015|
|NASBA Course Declaration :||Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.|
|Approved Audience :||
NASBA QAS - NASBA Registry - 706
|Keywords :||Specialized Knowledge and Applications, Customizing, Ribbon, Microsoft, Office, 2007/2010, cpe, cpa, online course|
|Learning Objectives :||
Add a custom tab in Excel 2010.
Add and remove the default tabs in the Excel 2010 Ribbon.
Use custom UI parts to create custom tabs in Excel.
Hide the default tabs in Excel by using custom UI parts.
Decipher the XML code in a custom UI part.
Customize the File menu (Backstage) in Excel 2010.
|Course Contents :||
Chapter 1: Customizing the Ribbon in Microsoft Excel
The User Interface (UI): An Overview
Office 2007 and later
Customizing the Quick Access Toolbar
Custom Tabs in Excel 2010
How to Add a Custom Tab to the Excel 2010 Ribbon
Adjust Tab Location
Add a Group to the Tab
Adding and Removing the default Excel 2010 Tabs
Chapter 2: Customizing the Excel 2007/2010 Ribbon Using CUI Editor
Writing Code to Customize the Ribbon
What You Will Need
Create a workbook in Excel
Adding a Custom Tab in Excel 2007
Office Custom UI Editor
A Look at XML (Extensive Markup Language)
Adding Custom Functionality in Excel 2007/ 2010
Customizing Backstage in Excel 2010
Added Value: Another Ultimate (Really) Customization