View Cart

             Course   Search

Login

Email Address

Password

Forgot Password? Click Here
 
Courses by Number of Hours   
Courses by Field of Study
Courses by Authors
QAS Courses - Only
EA Courses - Only
RTRP Courses - Only
Pilot Courses - FREE
FREE CPE Courses
Webinars
Subscriptions
Course and Site Instruction
 
 
 
Authors
Business Services
Boards and Associations
Not For Profit Organizations
 
 
  Home > Course Details
 

Course Details - Go to Course Contents
   New ! ! !   Registry
    
Title :

Customizing the Ribbon in Microsoft Excel 2007/10
Author :

Jay R Carlson, MCSE, MCDBA, A+ Certified
Status :

Production
CPE Credits :

3.0
IRS Credits :

0
Price :

$29.95
Passing Score :

70%
Primary Subject-Field Of Study :

Specialized Knowledge and Applications - Specialized Knowledge & Applications
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:

http://openxmldeveloper.org

This program is required for Module 3.

Usage Rank :

0
Release :

2011
Version :

1.0
Prerequisites :

None
Experience Level :

Overview
Additional Contents :

Complete, no additional material needed
Advance Preparation :

None
Delivery Method :

Self-Study
Intended Participants :

Anyone needing Continuing Professional Education (CPE)
Approved Audience :

 - NASBA Registry -  - 
Revision Date :

09/06/2011
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.
Comments :

CPE, online, self-study, self study, CPA, CPAs, continuing professional education, continuing education, accounting, accountants, business, commerce, microsoft, excel, ribbon
Learning Objectives :

Module 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/2010Ribbon 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 - Go to Details

Module 1: Customizing the Ribbon in Microsoft Excel

Introduction

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

 

Module 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
 

Back To Top

Cart is empty
Subtotal: $0.00

Cpethink.com will donate 1% of ALL purchases. See our donations.

Open Live Chat
Coupons and Specials

Payments secure through

Merchant Services by
iTransact Merchant Services


Save 10-25% or more on fees

Or we will assure you that you already have an exceptional rate

 

Showcase Courses
1040 Tax Workshop - 2012
IFRS in the U.S.A.: An Implementation Guide
California’s Regulatory Review for CPAs
Payment Processing Considerations to Comply with IRS and PCI-DSS Regulations & Policies (Video)
Texas Ethics: An Overview for Texas CPAs
Healthcare Reform: Pre-Existing Conditions, Benefit Limits, Rescission & Patient Protection Rules
Spreadsheet Controls Under Sarbanes-Oxley Section 404
Fraud Audit Techniques Using Excel
The Ultimate Guide to Retirement Planning from a Tax Perspective
WordPress 101 - Install, Setup, Use It Today! (Video)
All Courses

 

 
 

Click to verify BBB accreditation and to see a BBB report. Trusted Commerce

CPE for Wednesday, May 22nd, 2013
Copyright© 2002-2013 Cpethink.com
Home | Privacy | Refunds | Login | System Requirements | FAQs | Contact Us | Facebook

McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams

 
  Continuing Education Cpa - Continuing Professional Education - CPA Continuing Education - CPE for CPAs - CPA CPE - CPE CPA - CPE Courses -  CPE Credits -  CPE Hours -  Ethics Continuing Education -  Ethics CPE -  CPE Ethics -  CPE On Line -  Online CPE -  CPE Online -  CPE Requirement -  CPE Requirements -  CPA CPE Requirement -  CPE Tax -  Tax CPE -  Tax Continuing Education -  Accountant CPE -  Accounting CPE -  CPE Accounting