Core User | Microsoft Excel Foundation
Sunday 01 JanuaryDescription
This course is designed as a one-day, hands-on workshop to teach user the foundational skills of working with Excel for Windows
Outcomes
The outcomes of this course for delegates include being able to create spreadsheets
- Using Simple Formulas and Functions
- Adding and Removing Columns, Rows and Cells
- Formatting the Sheet
- Creating Charts
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: 100. Delegates must come to the course with basic computer user skills
Roles Aimed at: All business roles
The course is designed for delegates who have basic computer skills and review Excel workbooks, but do not create them.
This course is not intended for:
- Advanced 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
Creating Spreadsheets Part 1
- Excel Basics including Navigating Excel & File Operations
- Managing the Worksheet
- Using AutoSum
- Copy Formulas
10:30 – 10:45
Break
10:45 – 12:30
Creating Spreadsheets Part 2
- The Structure of Formulas
- Formatting The Worksheet
- Using Tables
12:30 – 13:30
Lunch
13:30 – 14:45
Creating Spreadsheets Part 3
- Creating Charts
- Creating Pivot Charts
- Editing Charts
- Filtering Charts
14:45 – 15:00
Break
15:00 – 16:30
Creating Spreadsheets Part 4
- Working with Multiple Workbooks and Worksheets
- Printing
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 ...