This is a basic/intermediate level workshop for those who are mainly self-taught users of Excel and would like to improve their skills and become more proficient users.
Focus is on features that can be applied immediately to your data – especially tables – and that make the biggest impact on your use of spreadsheets – whatever type of data you work with.
SKILLS INTRODUCED:
Worksheets:
- Keyboard shortcuts
- Navigating and selecting data
- Quick Access Toolbar
- Moving and copying worksheets
- Worksheet tabs
- Working with rows and columns
Excel Tables:
- Advantages
- Creating
- Sorting and filtering
- Adding data
- Forms to enter data
- Themes and styles
Introduction to making professional looking Charts:
- Choosing the correct chart type
- Creating and editing charts
Conditional Formatting:
- Allows cells to be automatically formatted (e.g. colour of text/cell etc.) if they meet certain criteria set by the user (e.g. over or under a set value, top 10 values etc.)
Formulas:
- Basic arithmetical functions and order of preference
- AutoSum
- Sum
- Counta
- Count
- Min
- Max
- Average