Use Landscape to see Search/Filter
Item Types:
Field of Study:
CPE Hours:
Course Details

Customizing the Ribbon in Microsoft Office 2007/2010 (Course Id 706)

QAS / Registry
Author : Jay R Carlson, MCSE, MCDBA, A+ Certified
Status : Production
CPE Credits : 2.0
IRS Credits : 0
Price : $17.95
Passing Score : 70%
Course Type: NASBA QAS - Text - Technical - NASBA Registry
Primary Subject-Field Of Study:

Specialized Knowledge - Specialized Knowledge for Course Id 706

Description :

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.

Note: The Office Custom UI Editor program is a third party program and needs to be downloaded from the Internet. You can find this program at:


This program is required for Module 3.

Usage Rank : 0
Release : 2014
Version : 1.0
Prerequisites : None
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 - Text - Technical - NASBA Registry - 706

Keywords : Specialized Knowledge and Applications, Customizing, Ribbon, Microsoft, Office, 2007/2010, cpe, cpa, online course
Learning Objectives :

Chapter 1
Customizing the Ribbon in Microsoft Excel

In this section, we’ll learn how to:
    • Customize the Quick Access Toolbar in the Ribbon.
    • Add a custom tab in Excel 2010.
    • Add and remove the default tabs in the Excel 2010 Ribbon.

Module 2
Customizing the Excel 2007/2010 Ribbon Using CUI Editor

In this section, we’ll learn how to:
    • Use the Office Custom UI Editor to modify the Excel toolbar.
    • 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

Learning Objectives


The User Interface (UI): An Overview

Office 2003

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

Review Questions


Chapter 2: Customizing the Excel 2007/2010 Ribbon Using CUI Editor

Learning Objectives

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

Review Questions

Specialized Knowledge and Applications Course 706 Home: https://www.cpethink.com/cpe-for-cpas
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
Exam completed on .

Do you want to add the course again?