The course covers some of the advanced features which Excel has available to its users.
The last section of the workshops gives you the opportunity to work on Excel in relation to your specific work related requirements. You may have a spreadsheet which is not fit for purpose, or is too complicated to understand. You may have ‘inherited’ a spreadsheet from a colleague who is no longer with your company, or you may be using a process which is pen/paper/calculator based and could be converted into Excel.
Please bring along your ‘troublesome’ spreadsheets to the workshop on a USB drive, removing any confidential information beforehand, and be prepared to outline your requirement to the other delegates on the course and to devise a solution for each scenario.
1 day, 9.00 am - 4.00 pm
The course covers –
Conditional Formatting Using Formulas
Format Using a Formula – Check One Column
Format Using a Formula – Check the Whole Column
Apply to Whole Row
Apply Across Columns
Sorting Coloured Cells to the Top
Conditional Formatting to Text
Use of Sparklines
Create a Sparkline
Change the Style of, or Format Sparklines
Create a Time Slicer
Filter the Data
Formulas / Functions INDEX/MATCH
Logical Operators – IF, AND, OR and NOT
PROPER, LOWER, UPPER TRIM
TEXT TO COLUMNS
LEFT, RIGHT, MID
NESTED IF Data
Data Validation with Formulas
Variable Length Named Ranges
What If – Scenario Manager, Goal Seek, Data Table
Depending on your situation, you may be able to access a range of financial support available.