Mastering Excel 365 – Advanced

Mastering Excel 365 – Advanced

Part of our online library flat rate.

  • By
  • Triple Tech LLC dba Bigger Brains

Flatrate 12 month

19 USD per month

  • 12 Months
  • Single License
  • 19 USD 228 USD per year
  • 850+ eBooks and video tutorials
  • Tips and tricks from experts
  • Instant access
  • Renews automatically

Share this Product

Get Custom offer

  • 10+ Users
  • For departments or complete companies
  • Premium analytics

Language

English

Level

Beginner

Release

2022

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

Lesson:

  1. Introduction
  2. Creating Internal Links
  3. Creating External Links
  4. Using Paste Special
  5. Using Group Mode
  6. Using 3D References
  7. Consolidating Data
  8. Adding Comments
  9. Tracking Changes
  10. Co-Authoring, Part 1
  11. Co-Authoring, Part 2
  12. Using Sheet Views
  13. Using Compare and Merge
  14. Preparing to Share
  15. Adding Digital Signatures
  16. Protecting Worksheets
  17. Protecting Workbook Structure
  18. Protecting a Workbook File
  19. Applying Data Validation
  20. Adding a Dropdown List
  21. Customizing Data Validation
  22. Recording a Macro
  23. Running a Macro
  24. Editing a Macro
  25. Using VLOOKUP, Part 1
  26. Using VLOOKUP, Part 2
  27. Using XLOOKUP
  28. More Lookup Functions
  29. Using Array Formulas
  30. Tracing Formulas
  31. Addressing Formula Errors
  32. Watching and Evaluating Formulas
  33. Adding Error Handling
  34. Working with Information Functions
  35. Using Goal Seek
  36. Forecasting with Data Tables
  37. Using Solver
  38. Forecasting with Scenarios
  39. Forecasting Data Trends
  40. Inserting Symbols and Special Characters
  41. Creating Sparklines
  42. Creating a Map Chart
  43. Creating a 3D Map Tour
  44. Creating Custom Lists
  45. Importing and Exporting Data
  46. Creating a Web Query
  47. Using Data Types
  48. Working with Forms
  49. Using ActiveX Controls
  50. Ideas in Office 365