SKU: ME-EXL365Pt3 Category:

Microsoft Excel Course Part 3

Microsoft Excel 365 Part 3 is about working smarter at scale. You’ll manage multiple workbooks, automate repetitive tasks, use lookups, forecast outcomes and keep data clean and reliable. Ideal for teams and professionals who rely on Excel daily and want it to do more of the work.

ZK2,230.00 Excl. VAT

Product Details

Excel Training – Working at Scale in Excel

This Microsoft Excel course is delivered using the desktop version of Microsoft Excel, not the browser-based online version. If you’re here, you already use Excel – a lot. You know your way around functions, formulas and data analysis tools. You analyse data, build reports, collaborate with others and maintain workbooks for just about everything and at this level, you’ve probably hit your fair share of frustrations too.

You’re busy. You don’t have time to hunt through spreadsheets, fixing issues or repeating the same manual tasks over and over. You need Excel to work harder so you don’t have to and that’s exactly what this course is designed for.

This course builds on the skills covered in Microsoft Excel for Office 365 Part 1 and Part 2. Our Microsoft Excel course part 3 will enable you to work with multiple worksheets and workbooks automate workbook functionality, use lookup functions and formula auditing as well as forecast data, create sparklines and map data.

The goal is simple: let Excel do the heavy lifting while you focus on the key takeaways.

A quick note: Most Microsoft 365 users do their day-to-day work in the desktop version of Excel, so that’s our main focus. That said, the course also touches on key web-based tools included in your Microsoft 365 subscription, including Excel for the Web and OneDrive. Where the online version behaves differently, we’ll flag it clearly so there are no surprises.

Excel does the work. You get the answers.

 

Discover more

Download Outline ➤ ME-EXL365Pt2 – Microsoft Excel 365 Part 3

Watch an informative video ➤  Microsoft Copilot in Excel

Associated Certification & Exam

On successful completion of this outlook training course, participants will receive an attendance certificate from Training4Every1 powered by Eduqe.


COURSE CONTENT

Microsoft Excel Course Module One

Working with Multiple Worksheets and Workbooks
  • Use links and external references
  • Use 3-D references
  • Consolidate data

Microsoft Excel Course Module Two

Sharing and Protecting Workbooks
  • Collaborate on a workbook
  • Protect worksheets and workbooks

Microsoft Excel Course Module Three

Automating Workbook Functionality
  • Apply data validation
  • Search for invalid data and formulas with errors
  • Work with macros

Microsoft Excel Course Module Four

Using Lookup Functions and Formula Auditing
  • Use lookup functions
  • Trace cells
  • Watch and evaluate formulas

Microsoft Excel Course Module Five

Forecasting Data
  • Determine potential outcomes using data tables
  • Determine potential outcomes using scenarios
  • Use the Goal Seek feature
  • Forecast data trends

Microsoft Excel Course Module Six

Creating Sparklines and Mapping Data
  • Create sparklines
  • Map data

 


Disclaimer

Training4Every1 Course details and content may change without notice to stay aligned with current software updates and best practices.

By booking this training, you agree to our Training Terms and Conditions.

Click here to view Training T & C’s.

Got questions or feeling a bit lost in Excel, Word or Teams?

Don’t worry – we’ve got you! Reach out and we’ll help you find the perfect Microsoft training for you and your team.

Follow us and stay up to date with the latest training journeys, business solutions and powerful automation tools.

Microsoft Outlook Training    Microsoft Outlook Training

Data4Every1