TOIT Training

Mastering Excel 365 – Intermediate (2022)

Mastering Excel 365 – Intermediate (2022)
  • Overview
  • Curriculum
  • Reviews

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn great tools to modify your data and refine your workbook.  Excel expert Kathy Jones will also show you how to nest functions and modify and format charts. You’ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you’ll learn some of the tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options. 

And if you need to know more about forecasting, you’ll learn how to conduct What-If analysis using Excel’s special features. 

  • 37 Sections
  • 3h 33m Duration
Expand All

Introduction

Flash Fill

Text to Columns

Find and Replace

Sort and Filter

Proofing and Researching Tools

Group Mode

Workbook Properties

Freeze and Split Windows

Workbook Views

Custom Views

Custom Number Formats

Conditional Formatting for Text and Dates

Comparative Analysis with Conditional Formatting

Customizing Conditional Formatting

Functions in Conditional Formatting

Nested Functions

Logical Functions

Statistical Functions

Chart Elements

Chart Formats

Sparklines

Graphics

SmartArt

Creating Tables

Table Styles

Summarizing Data in Tables

Managing PivotTables

Web Queries

Hyperlinks

Compare and Merge

Track Changes

Share a Workbook

Comments

Goal Seek

Forecasting with Data Tables

Analyze Data Tool

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Using Flash Fill, Text to Columns, and Group Mode to work with your data 
  • Using editing features such as Find and Replace, proofing options, and research tools to refine your workbook 
  • Modifying workbook views 
  • Applying conditional formatting to text, numbers, and dates 
  • Applying custom number formatting 
  • Using nested, logical, and statistical functions 
  • Modifying and formatting charts 
  • Adding sparklines, pictures, and SmartArt 
  • Modifying Tables, PivotTables, and web queries 
  • Sharing workbooks 
  • Using tools to enhance sharing such as hyperlinks, track changes, and comments 
  • Analyzing data with Goal Seek and Data Tables 

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Mastering Excel 365 – Intermediate (2022)
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)