Excel: tricks and tips for productivity

About this course

The course explores ways to organise, amend and present spreadsheet data more efficiently. Topics include formatting, subtotals, conditional formatting, basic formulas, sorting, filling and changing data views, spreadsheet protection, pivot tables and charts. Teaching combines tutor demonstrations with practical tasks, allowing participants to work through the features being introduced and consider which Excel tools are appropriate for different purposes.

What you'll learn

• Apply basic formatting, subtotals and conditional formatting to spreadsheet data
• Use basic Excel formulas more efficiently
• Sort, fill and view data using appropriate spreadsheet features
• Protect Excel spreadsheets
• Create pivot tables and charts

Is this course right for you?

This course is intended for improvers who have some familiarity with Excel, including learners who may not use it regularly. Participants should be comfortable with basic spreadsheet tasks such as entering data. Learning combines demonstrations with practical exercises.

• Some familiarity with Excel or basic spreadsheet software is expected
• The course is designed for learners developing beyond fundamental spreadsheet techniques

Before you go

• Learners may bring their own laptop if preferred.
• The course may require use of a personal account or creation of an account for the course.
• No work outside the class is specified.