Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Intellezy Excel 365 Intermediate

Video Introducing this tutorial


Introduction :
Introduction

Linking Workbooks and Worksheets :
Linking Workbooks and Worksheets
Linking Workbooks with 3D References
Understanding the Consolidate Feature

Working with Range Names :
What are Range Names?
Using the Name Box and Define Name
Using Create from Selection

Sorting, Filtering, and Subtotaling :
Differences Between Sorting and Filtering
Sorting Lists
Filtering Lists
Creating Subtotals

Analyzing and Organizing with Tables :
Creating Tables and Understanding the Benefits
Understanding the Elements of a Table
Formatting a Table
Sorting and Filtering Tables
Filtering with Slicers
Calculating with Tables
Removing Erroneous Table Data
Exporting, Refreshing, and Converting Tables

Using Conditional Formatting :
What is Conditional Formatting?
Highlight Cells and Top Bottom Rules
Data Bars, Icon Sets, and Color Scales
Using Custom Fonts and Colors
Using Custom Conditional Formatting
Modifying or Removing Conditional Formatting

Displaying Data Graphically :
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

Understanding PivotTables, PivotCharts, and Slicers :
What is a PivotTable?
Creating a PivotTable
Working with the PivotTable Fields Pane
Data Organization and Analysis with PivotTables
Formatting PivotTables
Creating a PivotChart
Modifying and Formatting a PivotChart
Adding Slicers and Timeline Slicers
Formatting Slicers
Using the Ideas Feature

Working with Advanced PivotTables and PowerPivot Features :
Using the PivotTable and PivotChart Wizard
Adding a Calculated Field
Adding a Calculated Item
Applying Conditional Formatting to a PivotTable
Creating Filter Pages for a PivotTable
Enabling the PowerPivot Add-In

Conclusion :
Course Recap
Final Assessment Quiz - Excel 365 Intermediate
Final Assessment Quiz - Excel 365 Intermediate