Mastering Excel 365 - Advanced (2023)

Objectives. You will be able to:

• Create, save, and use a custom worksheet template
• Explore dynamic array functions
• Use the LOOKUP, text, date, and database functions
• Use advanced filtering and sorting techniques
• Apply and modify data validation for numbers, text, and date cells
• Use Subtotal functions and the Subtotals feature
• Use Data Consolidation to summarize data from multiple ranges
• Create, modify, and filter a PivotTable
• Create macros and add form controls
• Create custom charts and chart templates
• Insert, format, and modify graphics, screenshots, symbols, and 3D models
• Run the Accessibility Checker and address needed changes
• Protect sheets, workbooks, and ranges

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Editing 19:07

  • 1: Introduction Preview 02:12
  • 2: File Types 06:49
  • 3: Templates  03:45
  • 4: Customizing the QAT 04:21
  • 5: Knowledge Check 02:00

• Functions 1:19:23

  • 6: Dynamic Arrays 08:17
  • 7: VLOOKUP  09:16
  • 8: XLOOKUP, Part 1 06:32
  • 9: XLOOKUP, Part 2 05:27
  • 10: MATCH, INDEX 07:55
  • 11: Multiple Criteria Functions 06:16
  • 12: Text Functions 08:41
  • 13: Date Functions 06:02
  • 14: Time Formulas 05:22
  • 15: Math Functions 07:50
  • 16: Database Functions 05:45
  • 17: Knowledge Check 02:00

• Data Manipulation 39:33

  • 18: Advanced Filtering 07:03
  • 19: Advanced Sorting 04:59
  • 20: Data Validation 06:00
  • 21: Data Validation Lists 08:52
  • 22: Data Validation Messages and Invalid Data 05:54
  • 23: Form Controls 05:45
  • 24: Knowledge Check 01:00

• Data Consolidation and Subtotals 18:07

  • 25: Subtotal Function 04:55
  • 26: Subtotal Feature  06:17
  • 27: Data Consolidation 05:55
  • 28: Knowledge Check 01:00

• PivotTables and Macros 24:13

  • 29: Manage PivotTables 07:30
  • 30: Report Filter, Slicers, and Timelines 08:59
  • 31: Run a Macro 06:44
  • 32: Knowledge Check 01:00

• Charts 22:29

  • 33: Customize Charts 09:40
  • 34: Combo Charts 05:01
  • 35: Trendlines  03:22
  • 36: Chart Templates  03:26
  • 37: Knowledge Check 01:00

• Graphics 26:30

  • 38: Screenshots, Symbols, 3D Models 06:07
  • 39: Format Graphics, Part 1 05:49
  • 40: Format Graphics, Part 2 07:56
  • 41: Manipulate Graphic Objects 05:38
  • 42: Knowledge Check 01:00

• Sharing 41:27

  • 43: Accessibility Checker 06:07
  • 44: Modifying Hyperlinks 06:01
  • 45: Protecting Sheets and Workbooks 08:01
  • 46: Protecting Ranges 04:35
  • 47: Protecting a Workbook File 08:23
  • 48: Digital Signatures 03:55
  • 49: Sheet Views 03:25
  • 50: Knowledge Check 01:00

Learn many of Excel’s advanced tools for analyzing and reporting on your data

Being able to use Microsoft Excel skillfully is crucial for all business professionals who use, analyze, and apply data. Excel is the most popular data analysis tool in the workplace, so increasing your understanding of its advanced features is both necessary and smart.

Excel expert Kathy Jones will show you how to make use of advanced features to summarize information, identify errors, apply conditional formatting, and find and assess information. She will also demonstrate how to best utilize available filtering and sorting techniques, including the new dynamic array functions. Learning to use these techniques will enable you to find information you need when analyzing either large or small data sets.

Since graphs greatly enhance your reports, you’ll learn how to add trendlines to charts to add a visual element to your forecasting and how to save time by creating custom templates that can be used repeatedly. You’ll also be able to create and modify important objects such as PivotTables, macros, and graphics.

Finally, if you’re looking to easily identify rankings or need to generate random numbers for inspections, this course will teach you how to use Excel to help you do it!

This course is intended for users who are comfortable using basic and intermediate features in Excel 365 and want to learn additional features.

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