Overview of course
This is a 1 day workshop for those 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 to save time and work more effectively.
The format will be 'teach and try' where we show you what to do then you will be given files 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 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 quickly.
What will I learn?
- Selecting cells quickly and effectively.
- Working with multiple worksheet and workbook windows
- Creating charts.
- Creating pivot tables.
- More advanced formulas and functions, e.g. SUMIF, IF
- Conditional formatting
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 you can take home the example files and work completed in the course.
The memory needed will be less than 1 Gigabyte so any old memory stick you have lying around with a little bit of space on it would be OK.
Am I ready to start?
If you are ready to learn more about how to use Microsoft excel and become more confident using some more complex elements of it, then yes.
I'm interested. What should I do now?
To enrol and pay for this course you must visit www.wsc.ac.uk and apply for course code 19LP2184CHB by clicking the Enrol Online button.
Days & times
Saturday 10:00 - 14:00