Fishel Shelley. Excel 2016 Advanced

Bookboon, 2016. — 184 p. — ISBN: 978-87-403-1199-0.This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.You will learn how toUse Conditional Logic in a formula – IF statements
Use the SumIF and CountIF functions
Produce a chart
Sort and filter
Apply subtotals
Introduction to Pivot Tables
Introduction to MacrosApply Conditional Logic in formula
Create and apply Range Names
Charts
Apply and manipulate illustrations
SmartArt
Shapes
Screenshots
Manage comments
Sorting data
Filtering data
Format as table
Filter a table
Grouping and outlining
Subtotals
Apply conditional formatting
Sparkline charts
Text functions
Quick analysis
Macros.