Course description
This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.
Upcoming start dates
Choose between 6 start dates
Suitability - Who should attend?
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
Training Course Content
Working with Functions and Complex Calculations
- Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.)
- Work with Logical Functions
- Work with Lookup Functions
- Work with Date and Time Functions
- Work with Text Functions
Working with Lists and Tables
- Sort and Filter Data
- Remove Duplicate Values
- Group and Outline Data
- Subtotal Data
Visualizing Data with Charts
- Create and Modify Charts
- Use Advanced Chart Features
- Save a Custom Chart Template
Using Tables, Pivot Table Reports and Pivot Charts
- Create and Modify Tables
- Use Functions to Calculate in Tables
- Create a Pivot Table Report
- Manipulate Pivot Tables
- Present Data with Pivot Charts
- Filter Data by Using Slicers and Timelines
Request info
Nexus Human
Level 30, Leadenhall Building, 122 Leadenhall Street
EC3V 4AB London
Nexus Human
For over 20 years Nexus Human has specialised in IT and Business Skills Training and Certification in the UK and Ireland. What makes Nexus Human different is putting people at the core of what we do. We deliver both private...
Ads