Mastering Excel 365 – Advanced

By the end of this course, you will be able to use the advanced features of Excel 365 to Collaborate on, analyze, and or

There are two kinds of people: Those who are masters at Excel 365, and those who wish they were

What you’ll learn

  • Collaborate with others using Track, Comment, Chat, and Share..
  • Consolidate and copy data across worksheets and copy through linking and grouping..
  • Automate functions to save time and effort..
  • Protect a file and workbook..
  • Find and track errors..
  • Create Forecasting models and manipulate variables, find trends.
  • Create 3d Maps, Custom Lists, Queries, and Form.

Course Content

  • Linking and Consolidating –> 7 lectures • 34min.
  • Sharing and Protecting –> 11 lectures • 1hr 4min.
  • Automating –> 6 lectures • 40min.
  • Using Lookup Functions –> 5 lectures • 38min.
  • Auditing Formulas –> 5 lectures • 28min.
  • Forecasting Data –> 16 lectures • 1hr 16min.

Mastering Excel 365 - Advanced

Requirements

  • People who have taken the Basic and Intermediate Mastering Excel Courses..

There are two kinds of people: Those who are masters at Excel 365, and those who wish they were

 

When you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. Once you have completed this course, there are few things you won’t be able to do with Excel!

 

Topics covered include:

· Collaborating and Sharing

· Efficiency functions

· Auditing Functions

· Forecasting data and trends

 

Over 5 hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

 

Objectives. You will be able to:

· Collaborate with others using Track, Comment, Chat, and Share.

· Consolidate and copy data across worksheets and copy through linking and grouping.

· Automate functions to save time and effort.

· Protect a file and workbook.

· Find and track errors.

· Create Forecasting models and manipulate variables, find trends.

· Create 3d Maps, Custom Lists, Queries, and Forms

 

Mastering Excel is essential to growing in your position!

By the end of this course, you will be able to use the advanced features of Excel 365 to Collaborate on, analyze, and organize your data.

Get Tutorial