Power User | Microsoft Excel
Sunday 01 JanuaryDescription
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
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
Register today!
Limited spaces availableAgenda
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 ...