Who is it for?
This course is suitable for people who have some experience using Excel or attended the Excel Introduction course and would like to learn about additional features and produce spreadsheets more efficiently.
Description
Building on your existing knowledge of Excel this course includes tools for handling large spreadsheets and managing lists of data. You will also understand how to control worksheets that are being edited by several people.
This course will enable you to create, build and customise graphs including plotting trend lines and summarise a large worksheet using the outlining tools. You will also learn about making decisions using conditional statements and formatting.
Please note: this course outline is a guide only. Topics covered on the day depend on the number of delegates in the training session, their pace and interests.
Course content
-
Split screen and freeze panes
-
Custom views
-
Conditional statements
-
Conditional formatting
-
Creating and editing charts
-
Sorting a list
-
Auto filter and advanced filtering
-
Automatic subtotalling
-
Creating a pivot
Course duration
1 day, normally between 9:30 and 4:30
“
“Very informative and Sarah is a very good trainer. I feel the course has helped a lot in my duties at work."
SB, Capespan Ltd
“
"Great, just the right mix of tips and tricks as well as full discussion of main points. It has given me more tools to effectively handle information management in my job.”
AY, Business Link Kent