Microsoft Excel Intermediate

Is this course for you?

Does any of this sound familiar?

You may be comfortable entering data and creating basic formulas, yet find that larger spreadsheets, inconsistent data, repeated calculations and reporting tasks take too long or are difficult to manage. Do you...

• ✓Use Excel regularly but feel there are gaps in your knowledge?
• ✓Rely on manual formatting, copying and pasting to organise information?
• ✓Find it difficult to keep formulas correct when copying them?
• ✓Want to understand when to use relative, absolute and mixed cell references?
• ✓Work with lists that need to be sorted, filtered or checked for duplicates?
• ✓Want to create drop-down lists and control what users can enter?
• ✓Need to highlight deadlines, exceptions, trends or duplicate values?
• ✓Spend time preparing worksheets and reports for other people?
• ✓Want to create clearer charts and summaries from your data?
• ✓Know there must be a quicker way to complete common Excel tasks?
• ✓Want a stronger foundation before progressing to advanced Excel or Power Query?

If any of the above resonates, this course is for you.

What you’ll be able to do

• ✓Use Excel Tables to organise, filter and calculate data.
• ✓Create formulas using relative and absolute references.
• ✓Apply common statistical, logical, date and text functions.
• ✓Control data entry with validation and highlight information with conditional formatting.
• ✓Sort, filter, present and print larger worksheets effectively.
• ✓Create and format charts and protect important worksheet content.