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 will show you what to do and then you will be given examples to try it out for 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, when and how to use them. You will be able to use Pivot Tables and charts and analyse raw data and provide meaningful information. You will be able to use a wider range of formulas and functions to get the answers you need 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 who 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 completed during the workshop.
Days & times
Saturday 10:00 - 15:00