Advanced Excel

This course covers

• Utilising 365 Cloud Storage
• Version History
• Show Changes
• Adding Spreadsheets to Teams Channels
• Use of Sparklines
• Create a Sparkline
• Change the Style of, or Format Sparklines
• Timeline Slicer
• Create a Time Slicer
• Filter the Data
• Formulas / Functions
• XLOOKUP
• Logical Operators – IF, AND, OR and NOT
• PROPER, LOWER, UPPER
• TRIM
• CONCATENATE
• TEXT TO COLUMNS
• LEFT, RIGHT, MID
• IFERROR
• NESTED IF
• Data
• Data Validation with Formulas
• Variable Length Named Ranges
• What If – Scenario Manager, Goal Seek, Data Table
• Forecast Sheet
• Work Related Spreadsheets

There is also an opportunity during the last section of the workshop to work on Excel with specific work related issues.

N/A

N/A

N/A