Microsoft Excel - Up to Speed

About Microsoft Excel - Up to Speed

Introduction

Before You Begin

Creating an Excel Workbook

Examining the Excel Environment

Opening an Existing Workbook

Navigating a Worksheet

Create and Save a New Workbook

Changing the Save Format

Moving Between Workbooks

Setting Excel Options

Switching beween Views

Using Tell Me to Obtain Help

Closing a Workbook and Exiting Excel

Entering Text and Numbers

Entering Simple Formulas

Using AutoSum

Changing and Deleting Data

Using Undo and Redo

Using Find and Replace

Using the Go To Command

Inserting Symbols

Spell Checking Your Worksheet

Using Smart Lookup

Working with Ranges

Copying and Pasting Data

Using the Office Clipboard

Cutting and Pasting Data

Copying and Moving Cells using Drag and Drop

Changing Column Width

Changing Row Height

Inserting and Removing Rows and Columns

Copying Data and Formulas with Autofill

Filling in Cells using Flash Fill

Formatting Text

Using the Format Cells Dialog

Formatting Values

Using the Format Painter Button

Alignment and Text Wrapping

Merging Cells and Centering Text

Adding Cell Borders

Applying Colors and Shading to Cells

Applying Cell Styles

Hiding and Unhiding Rows and Columns

Freezing and Unfreezing Rows and Columns

Inserting and Removing Page Breaks

Adjusting Margins

Setting Page Orientation

Setting Paper Size

Defining a Print Area

Printing Worksheet Titles

Forcing a Worksheet to Fit

Inserting Headers and Footers

Printing a Worksheet

Relative References

Absolute References

Mixed References

Copying Formulas

Additional Aggregrate Functions

The Insert Function Button

Adding and Deleting Worksheets

Copying Worksheets

Renaming Worksheets

Repositioning Worksheets

Grouping Worksheets

Changing Worksheet Tab Colors

Using 3 D Formulas and References

Working with Tables

Entering Data into a Table

Deleting Rows and Columns

Formatting a Table

Totaling Data in a Table

Sorting Data in a Table

Filtering Data using AutoFilter

Creating Custom Filters

Converting a Table to a Range

Creating a Chart

Changing the Layout and Style

0905 Labeling Chart Elements

Formatting Chart Text

0907 Formatting Chart Elements

Changing Chart Type

Showing or Hiding Gridlines

Customizing Axes

Creating a Pie Chart

Creating a Map Chart

Creating a Funnel Chart

Changing a Charts Source Data

Moving a Chart to a Different Worksheet

Saving a Chart Template

Filtering Chart Data

Using Sparklines

Adding Pictures

Inserting Online Images

Adding Shapes

Adding Icons

Adding 3D Models

Formatting Drawing Objects

Inserting WordArt

Inserting SmartArt

Inserting an Organization Chart

Modifying an Organization Chart

Taking a Screenshot

Using Drawing Tools

Drawing Simple Math Equations

Generating Complex Equations

Emailing a Workbook

Web Page Preview

Converting Worksheets into Web Pages

Inserting Hyperlinks

Viewing and Editing Comments and Notes

Using the IF Function

Using Nested Functions

Using the IFS Function

Using the PMT Function

Using the FV Function

Using AutoCalculate

Understanding Date and Time Functions

Adding a Date and a Date Interval

Subtracting Dates

Calcuating Time Intervals

Creating a Workbook Using a Template

Creating a New Template

Editing a Template

Showing or Hiding Workbook Elements

Creating a Workspace

Comparing Two Workbooks Side By Side

Saving a Workbook in a Different File Format

Using Data Consolidation

Importing and Exporting Data

Importing Text Data into Excel

Converting Text to Columns

Removing Duplicate Rows of Data

Importing Data from a Database

Linking to another File

Linking and Embedding Objects

Exporting Data from Excel

Publishing Worksheets and Workbooks to the Web

Creating Custom Number Formats

Using Conditional Formatting

Applying Conditional Formatting Based on Top and Bottom Riules

Applying Specialized Conditional Formatting

Creating Your Own Formatting Rules

Managing Conditional Formatting

Clearing Conditional Formatting

Working with Ranges

Using a Named Range

Managing Range Names

Using the VLOOKUP Function

Creating a Macro

Running a Macro

Editing a Macro

Saving a Workbook with Macros

Adding a Macro to the Quick Access Toolbar

Tracing Formula Precedents

Tracing Cell Dependents

Tracing and Fixing Errors

Error Checking a Worksheet

Creating a PivotTable

Setting PivotTable Options

Formatting a PivotTable

Filtering PivotTable Data with Slicers

Filtering PivotTable Data Inline

Creating Custom Filters

Filtering PivotTable Data Using Timeline

Creating a PivotChart

Adding Subtotals to a List

Nesting Subtotals

Applying Advanced Filters

Adding Group and Outline Criteria to Ranges

Using Data Validation

Previewing Data using Quick Analysis

Using Goal Seek

Using Solver

Creating and Displaying Scenarios

Using Data Tables

Forecasting Future Values

Locking and Unlocking Cells in a Worksheet

Protecting a Worksheet

Showing or Hiding Formulas

Protecting a Workbook

Encrypting a Workbook

2206 Marking a Workbook as Final

Inspecting Workbooks

Checking Document Accessibility

Sharing & Co Authoring an Excel Workbook

Conclusion and Thank You!