Booking options
Price on Enquiry
Price on Enquiry
Delivered Online
4 days
All levels
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.
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....