This Excel training is for intermediate users who know their way around a spreadsheet and want to take their skills to the next level.
What you will learn:
- Using colour scales to highlight variances in values
- Display icons (such as arrows or traffic lights) based on cell values
- Highlight highest or lowest values in a range
- Create custom rules so that data is treated consistently
- Arranging and sorting large amounts of data
- Tools to support consistent information being recorded
- Turn numbers into charts / graphs to easily and clearly communicate what the data is telling you
This workshop includes:
- Linking cells and conditional formatting - a powerful feature in Excel that lets you change the appearance of cells based on certain criteria.
- Logical & IF's Functions - Perform tasks without a calculator or extra work
- Advanced Filtering - finding specific information easily
- Formatting as a Table - assists to more easily sort and organise data
- Removing duplicates and data validation - helps to reduce errors and invalid data being added
- Macros - recording of mouse clicks and keystrokes that can be played back to automate work
- Charts - graphs to visually convey information
Please bring your laptop for a hands-on workshop facilitated by the very experienced Cathi Barker from Software Solutions.
Cathi is a great facilitator, we had wonderful feedback from the last workshop she delivered for SociaLink. less