Microsoft Excel Foundation 2016

Module 1 - Getting Started

Lesson 1.1 - About Workbooks

·          Creating a New Workbook

·          Opening a Workbook

·          Saving a Workbook

·          About Excel File Types

·          Closing a Workbook

Lesson 1.2 - Exploring your Workbook

·          Using Worksheets

·          The Active Cell

·          Selecting Cells

·          Exploring a Worksheet

·          Using Zoom

Module 2 - The Excel Interface

Lesson 2.1 - The Quick Access Toolbar and File
                     Menu

·          The Default QAT Commands

·          Adding Commands

·          Removing Commands

·          Customizing the Toolbar

·          Using the File (Backstage) Menu

Module 3 - Excel Basics

Lesson 3.1 - Working with Excel

·          Columns, Rows, Cells, and Ranges

·          Creating Worksheet Labels

·          Entering and Deleting Data

Lesson 3.2 - Basic Excel Features

·          AutoFill

·          AutoSum

·          AutoComplete

·          Working with Basic Formulae

Lesson 3.3 - Moving your Data

·          Dragging and Dropping Cells

·          How to Cut, Copy, and Paste Cells

·          How to Cut, Copy, and Paste Multiple Cells

·          Using Paste Special

·          Inserting and Deleting Cells, Rows, and Columns

·          Using Undo, Redo, and Repeat

Module 4 - Editing your Workbook

Lesson 4.1 - Modifying Cells and Data

·          Changing the Size of Rows or Columns

·          Adjusting Cell Alignment

·          Rotating Text

·          Creating Custom Number and Date Formats

Lesson 4.2 - Cell Formatting

·          The Format Painter

·          Cell Merging and AutoFit

Lesson 4.3 - Enhancing a Worksheet’s
                     Appearance

·          Adding Patterns and Colors

·          Adding Borders

·          Working with Styles

·          Working with Themes

Lesson 4.4 - Working with Charts, Part 1

·          Creating a Chart

·          Styling Charts with the Design Tab

·          Modifying Charts with the Layout Tab

·          Manipulating a Chart

Module 5 - Printing and Viewing your
                   Workbook

Lesson 5.1 - Using the View Tab

·          Using Normal View

·          Using Full Screen View

·          Using Page Layout View

·          Page Break Preview

Lesson 5.2 - Printing your Workbook

·          Print Commands

·          Print Preview

·          Using Basic Print Options

·          Other Print Options