Mastering Excel 365 - Intermediate (2022)

Are you looking for an Excel course that will push the knowledge you already have in Excel? This course will prepare you to take on Advanced Excel features and tools! This course will prepare you to...

• Create and use named ranges
• Insert functions into spreadsheets including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
• Sort and filter column data
• Create and modify tables, and apply advanced Conditional Formatting
• Create and modify charts and graphics
• Apply advanced charting tools
• Create a Pivot Table to group and summarize data
• Apply advanced Pivot Table features, create a Pivot Chart, and filter data using Slicers and Timelines

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Editing 49:18

  • 1: Introduction Preview 02:14
  • 2: Flash Fill 08:23
  • 3: Text to Columns 05:32
  • 4: Find and Replace 09:08
  • 5: Sort and Filter 06:09
  • 6: Proofing and Researching Tools 07:22
  • 7: Group Mode 04:08
  • 8: Workbook Properties 04:22
  • 9: Knowledge Check 02:00

• Workbook Views 18:10

  • 10: Freeze and Split Windows 06:47
  • 11: Workbook Views 05:36
  • 12: Custom Views 04:47
  • 13: Knowledge Check 01:00

• Formatting 34:08

  • 14: Custom Number Formats 09:32
  • 15: Conditional Formatting for Text and Dates 04:40
  • 16: Comparative Analysis with Conditional Formatting 05:02
  • 17: Customizing Conditional Formatting 07:55
  • 18: Functions in Conditional Formatting 04:59
  • 19: Knowledge Check 02:00

• Functions 24:41

  • 20: Nested Functions 09:37
  • 21: Logical Functions 05:28
  • 22: Statistical Functions 07:36
  • 23: Knowledge Check 02:00

• Charts and Graphics 28:17

  • 24: Chart Elements 09:16
  • 25: Chart Formats 07:36
  • 26: Sparklines 02:15
  • 27: Graphics 03:10
  • 28: SmartArt 04:00
  • 29: Knowledge Check 02:00

• Tables and PivotTables 26:24

  • 30: Creating Tables 04:25
  • 31: Table Styles 04:22
  • 32: Summarizing Data in Tables 04:36
  • 33: Managing PivotTables 08:43
  • 34: Web Queries 03:18
  • 35: Knowledge Check 01:00

• Sharing 30:08

  • 36: Hyperlinks 05:09
  • 37: Compare and Merge 04:01
  • 38: Track Changes 05:53
  • 39: Share a Workbook 04:21
  • 40: Comments 08:44
  • 41: Knowledge Check 02:00

• Data Analysis 15:41

  • 42: Goal Seek 05:30
  • 43: Forecasting with Data Tables 05:44
  • 44: Analyze Data Tool 02:27
  • 45: Knowledge Check 02:00

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. This course builds on your existing Excel knowledge and teaches you how to manage data, charts, and tables, and how to use powerful tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.

This is our most requested training course!

If you learn to use Excel 365, you will start to see how useful it is in your life—from formatting your grocery list to calculating complex ROI values. If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer, Kathy Jones, walk you through more advanced topics that will take your spreadsheets to the next level and help you to be more efficient in analyzing your data.

Topics covered include:

• Working with named ranges
• Inserting functions
• Using advanced sorting and filtering techniques
• Inserting Tables
• Applying advanced Conditional Formatting
• Inserting charts and graphics
• Applying advanced charting tools
• Working with Pivot Tables, Pivot Charts, Slicers, and Timelines

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

People who have a working knowledge of Excel 365, but want to use more complex functions and features to analyze data.

Currently there are no Q&As for this course. Be the first to ask a question.