Introduction

Customizing the Ribbon

Customizing the Quick Access Tool Bar

Customizing the General and Formula Options

Customzing the Auto Correct Options

Customizing the Save Default

Customizing Advanced Excel Options

Linking Workbooks and Worksheets

Linking Worksheets with 3D References

Understanding the Consolidate Feature

What are Range Names

Creating Range Names Using the Name Box and Define Name

Creating Range Names Using Create from Selection

Working with the Most Common Logical Functions

Evaluate Data with the AND Function

Evaluate Data with the OR Function

Understanding IF Functions

Nesting AND and OR Inside and IF Function

What are Lookup Functions

Using VLookup

Using HLookup

Differences Between Sorting & Filtering

Sorting Lists

Filtering Lists

Creation and Benefits of a Table

Elements of a Table

Formatting a Table

Sorting Tables

Filtering Tables

Filtering with Slicers

Calculating with Tables

Removing Erroneous Table Data

Exporting, Refreshing, Converting Tables

What is Conditional Formatting

Conditional Formatting and Highlight Cells and Top Bottom Rules

Conditional Formatting Data Bars, Icon Sets, and Color Scales

Using Custom Fonts and Colors

Using Custom Conditional Formatting

Modify or Remove Conditional Formatting

What are Subtotals and Grouping

Creating Subtotals

Grouping and Ungrouping Data

What are Charts

Creating Charts

Understanding Chart Elements

Modifying Chart Elements

Changing and Moving Charts

Filtering a Chart

Formatting Charts

Adjusting Numbering

Creating Dual Axis Charts

Forecasting with Trendlines

Creating a Chart Template

Displaying Trends with Sparklines

What is a Pivot Table

Creating a Pivot Table

Working with the Pivot Table Fields Pane

Basic Data Organization and Analysis with Pivot Table

Formatting Pivot Tables

Creating a Pivot Chart

Modifying and Formatting a Pivot Chart

Adding Slicers and Timeline Slicers

Formatting Slicers

What is Flash Fill

Using Flash Fill and Autofill

Filling Various Series

What are Date and Time Functions-

Using TODAY, NOW, and DAY Functions

Using NETWORKDAYS and YEARFRAC Functions

What are Text Functions

Using CONCATENATE

Using Text to Columns

Using LEFT, RIGHT, & MID Functions

Using UPPER, LOWER, & PROPER Functions

Course Recap