Excel Express – UK

---

Learning Objectives

• Determine how to increase the speed with which you work in Excel through shortcuts and productivity tips.
• Apply the most useful and relevant Excel functions to your spreadsheets to support your work.
• Use pivot tables to quickly summarize data in a meaningful way.
• Identify how to format your work to look professional and presentable.
• Identify how to approach Excel with a step-change in confidence.

---

Major Topics

Practical Exercises
• Learning is put into practice as you progress through the below topics with tasks based around a fictional cinema company.

Productivity & Tips
• Quick Wins – 10 quick-fire tips to save time and boost your productivity.
• Navigational Shortcuts – top keyboard shortcuts that will get you around your spreadsheet rapidly.
• Action Shortcuts – vital keyboard shortcuts to perform your most repetitive actions at speed.

Essential Functions
• SUM – one of Excel’s simplest functions but with still much to learn. Master the basic functionality, add multiple worksheets with a 3-D Sum, or cumulatively sum a range of cells.
• VLOOKUP – the most widely used lookup function that enables the user to lookup a value in a table and return an associated result. This function is prevalent in worksheets and so is vital to know.
• XLOOKUP – the Swiss Army Knife of lookup functions – there’s a lot you can do with it! A hybrid of VLOOKUP and a more advanced lookup approach INDEX & MATCH, this function is vital to have in your pocket.
• IF – used to introduce logic into your work. For instance, if Condition A is true then return Result B, otherwise return Result C. It has a range of applications and will bring great functionality to your spreadsheets.
• SUMIFS – an extremely useful function that sums all the values in a range that satisfy one or more criteria. For instance, the quantities sold by product, or showing monthly profits by year.

Pivot Tables & Formatting
• Pivot Tables – slice, dice and dissect large amounts of data…superfast! Learn to organise and summarise large amounts of bland data into something simpler, more meaningful and engaging, in literally seconds.
• Formatting – give outputs a more professional look, increase engagement, and ensure they’re interpretable by your audience.

---

Who Should Attend

This course has been designed for any businessperson searching for a fun, engaging, content-packed course that will deliver the maximum return on their limited time. This is particularly suited to those with a free afternoon who are looking for a quick step change in their Excel abilities and who are unwilling to commit the time to a long course.

---

Fields of Study

Computer Software & Applications

---

Prerequisites

Beginner or Intermediate Excel skills

---

Provider

Business Learning Institute

---

CPE Credits

1.5

---

Level

Intermediate