Have you avoided using Excel because you think it is too complicated? Are you frustrated by spreadsheets and to want to be more effective and efficient in Excel? Demystify spreadsheets with this hands-on workshop and learn how to develop and modify a useable worksheet. You will learn how to save time by using quick functions such as Autofill, AutoCalculate, AutoComplete and AutoSum. You will also get a glimpse of a few of the most popular functions and how they can make your spreadsheets efficient. Ideal for those who are new Excel or would like to brush up on their skills prior to participating in for further Excel training.
The following topics will be covered:
- working with worksheets
- basic formulas and functions
- charting techniques
- sorting and filtering
- effective formatting
- printing workbooks
- handy tips, tricks and shortcuts in Excel
On completing this course you will be able to:
- navigate, create and modify workbooks
- use autofill to copy a range of data
- create simple formulas and using functions
- sort and filter data according to criteria
- represent data graphically using a chart
- print a workbook
- use tips and tricks to shortcut processes
Do this course as part of the Better Excel Series and save!
|We will provide you with:
||Course Notes, a Certificate of Completion and refreshments during the day, including a light lunch on full day courses.|
|You are encouraged to bring:
||Current workplace examples related to this topic for use in course exercises.|
|You might also be interested in:
||Get Organised Using Technology
|Need customised training for your organisation?
||Contact Jo Carrick to discuss tailoring this course to meet your needs or find out more about our tailored training services.|
|Are you enrolling on behalf of others?
||Enrol others now.|
|Are you University of Adelaide Staff?
||Enrol using a University of Adelaide account code now. |