Power User | Microsoft Excel

Sunday 01 January

Power User | Microsoft Excel

Sunday 01 January

Description
This course is designed as a one-day, hands-on workshop to teach user advanced skills of working with Excel for Windows

Outcomes
The outcomes of this course for delegates include being able to create spreadsheets

  • Using Advanced Formulas and Functions
  • Working with Lists and Analysis Tools
  • Ready for Distribution
  • Utilising Automation

Cost
Special discounted pricing for Vuzion Partners can be found on the price guide within the Vuzion Partner portal here or quoted by your BDM. You can also reach out to us at partners@vuzion.cloud

Duration
1 day
 
Course Format
This course is delivered virtually

Course Constitution 
This course is constituted as follows:

  • Theoretical: 15%
  • Practical - Demo: 45%
  • Practical - Tasks, Activities or Labs: 40%

Percentages are approximate. Whilst we endeavor to include a blend of theory, demo and activities in all of our courses we recognise that some delegates prefer a particular style of course (I.e. wholly or predominantly lab based workshops or immersion experiences) and would ask them to consider their preferred learning style before registration. We would also ask delegates to check the site regularly for new courses as we expand to offer different blends of theory/practice

Who should attend?
Course Level: 200-300. Delegates must come to the course with existing Excel knowledge equivalent to the Core User | Microsoft Excel Foundation course. It is also recommended to have taken the Intermediate course

Roles Aimed at: All business roles

The course is designed for delegates who have basic Excel skills and need to create workbooks for data analysis or for use by others..

This course is not intended for:

  • New users of Excel
Course Capacity
The course capacity is currently 14 seats with a minimum of 10. Should this exceed the maximum number then the course will need to be separated into two deliveries

Certifications & Competencies

This course is not linked to a Microsoft Exam but would input into MO-200 Microsoft Excel (Excel and Excel 2019). This course is not linked to any Microsoft Competencies

Prerequisites
This course has the following prerequisites

  • Microsoft Teams desktop app installed to join the course
  • Microsoft Excel for Windows installed
  • Two Screens are highly recommended - One for the meeting and one for Excel
Upon submission, we will reach out and work with you to find the next available dates to fit yours and your customers schedule. Should you have any questions on this course please reach out to us at partners@vuzion.cloud

Register today!

Limited spaces available

Agenda

09:00-09:30
Introductions and Protocols

09:30 – 10:30
Advanced Functions

  • Dynamic Array Functions
  • Calculating With Text
  • Calculation in Pivot Tables

10:30 – 10:45
Break

10:45 – 12:30
Analysis Tools

  • Scenarios and Goal Seek
  • Get and Transform

12:30 – 13:30
Lunch

13:30 – 14:45
Creating and Distribution Workbooks

  • Preparing Workbooks for Distribution
  • Data Validation
  • Protecting Data
  • Form Controls
  • Managing Comments and Reviewing Worksheets

14:45 – 15:00
Break

15:00 – 16:30
An Introduction to Automation

  • Macros
  • Office Scripts

Spotlight Events

Azure Data Fundamentals

Virtual Training | 1 Day | This course is designed for those who desire to learn the fundamentals of data platform concepts in a clo...

Power Platform Fundamentals

Virtual Training | 2 Days | This course enables candidates to gain a fundamental understanding of Power Platform for achieving effic...

Microsoft 365 Security Essentials | Identity & Access

Virtual Training | 1 Day | This course is designed as a one-day, hands-on workshop to teach administrators of Microsoft 365 tenants ...

Microsoft 365 Security Essentials | Threat Protection

Virtual Training | 1 Day | This course is designed as a one-day, hands-on workshop to teach administrators of Microsoft 365 tenants ...