• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Instructor Rental for Virtual Private Group

Instructor Rental for Virtual Private Group

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online

  • 4 days

  • All levels

Description

Duration

3.5 Days

21 CPD hours

This course is intended for

Intermediate Users of Office 365 and Excel

Overview

Creating Advanced Formulas
Analyzing Data with Logical and Lookup Functions
Organizing Worksheet Data with Tables
Visualizing Data with Charts
Analyzing Data with PivotTables, Slicers, and PivotCharts
Inserting Graphics
Enhancing Workbooks

This course builds upon the foundational Microsoft Office Excel 2016, you create advanced workbooks and worksheets using advanced formulas and organizing your data into tables.

Excel Intermediate

  • Learn how to navigate Pivot Tables, (for example, Create a Pivot Table/ add data/ Add calculations); Formulas, Data organization (for example, multiple worksheets)

Excel Advanced

  • Data Analysis (for example, sparklines) , Macros (making changes to macros) and Building A Fast Dashboard (PivotCharts, slicers, etc.)

Office 365 Training

  • Getting More with OneDrive

Office 365 Training

  • When is a Team a Team? Includes Using Video with Audio, Exploring Teams/Navigating among Teams etc.

About The Provider

Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK....

Read more about Nexus Human

Tags

Reviews