Overview

Introduction

The Customizing Excel module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Customize Workbook Options and Views
  • Enhance Worksheets with Themes
  • Customizing Excel Quick Access Toolbar
  • Understand Excel Application Options

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Customize Workbook Options and Views

After you start working with Excel, you'll probably want to change some things about how it works to suit your own work style and needs. You can customize both the Quick Access toolbar and the ribbon.

When working with worksheets you can modify the properties setup like margins, header/footer, sheets and pages.

By default, Excel has general application settings that control how the program work like re-computing values when a formula is changed or where workbook file is saved and other important application features.

Exercise 2 - Enhance Worksheets with Themes

Themes define a set of colors, fonts, and effects that go together to make your workbooks look good. You can choose existing themes or customize them.

In this exercise, you will learn about themes and how to change and customize them.

Exercise 3 - Customizing Excel Quick Access Toolbar

After you start working with Excel, you'll probably want to change some things about how it works to suit your own work style and needs. You can customize both the Quick Access toolbar and the ribbon.

Exercise 4 - Understand Excel Application Options

Excel provides many workbook and worksheet options that control how you interact with Excel, what things look like, and how Excel actually works. You can control an enormous number of these options. Workbooks also have properties that you can change, and these travel with the workbook file, which can be useful when people want to know who created a workbook or what the creator's intent was.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.