Core User | Microsoft Excel Intermediate

Sunday 01 January

Core User | Microsoft Excel Intermediate

Sunday 01 January

Description
This course is designed as a one-day, hands-on workshop to teach user intermediate skills of working with Excel for Windows. It can be taken as a follow on from our Excel Foundation course or taken in its own right

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

  • Using Formulas and Functions
  • Working With Multiple Sheets and Files
  • Formatting Excel Spreadsheets
  • 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-200. Delegates must come to the course with basic computer user skills and with some basic experience of Excel or to have taken our Core User | Microsoft Excel Foundation course

Roles Aimed at: All business roles

The course is designed for delegates who have basic computer skills and work with Excel workbooks and wish to extend their skills creating spreadsheets

This course is not intended for:

  • Advanced 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 – 10:30
Introductions and Protocols

09:30 – 10:30
Advanced Functions Part 1

  • Using Built-in Functions
  • Using Dates in Calculations

10:30 – 10:45
Break

10:45 – 12:30
Advanced Functions Part 2

  • Nesting Formulas and Functions
  • Tracing and Correcting Errors
  • Named Ranges

12:30 – 13:30
Lunch

13:30 – 14:45
Managing Spreadsheets

  • Working With Multiple Worksheets and Workbooks
  • Worksheet Views
  • Freeze Panes
  • Creating Formulas across Worksheets and Workbooks
  • Printing Workbooks

14:45 – 15:00
Break

15:00 – 16:30
Advanced Charting

  • Trendlines
  • Dual Axis Charts
  • Creating Template Charts

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 ...