Overview of course
This is a 1 day workshop designed for those who already know how to use the basics of Excel but want to enhance their knowledge by learning how to use more of its functionality to help them work more effectively and save time.
The format will be 'teach and try' where we show you what to do then you will be given examples to try it out yourself.
At the end of the course you will have a much better understanding of Excel, and its various features, including the benefits of each feature and when and how to use them. You will be able to use Pivot Tables and charts to analyse raw data and provide meaningful information. You will also be able to use a wider range of formulas and functions to get the answers you need more quickly.
What will I learn?
- Review of the basics
- Selecting cells quickly and effectively
- Working with multiple worksheet and workbook windows
- Pivot tables - what they are and when to use them
- More advanced formulas and functions e.g. SUMIF, IF
- Conditional formatting
- Creating charts
Who is the course for?
Those with a good understanding of the Excel basics e.g. those have attended the Excel for beginners course, but who want to learn more Excel.
Will I have to provide anything?
Computers and handouts will be provided; however, if you have one, you can bring in a USB (memory) stick so that you can take home the example files and work.
Days & times
Saturday 10:00 - 15:00