Course ID: EXEX

Excel Express – UK

About & Customize

Popular Options

  • In-Person
  • Live Webcast

• 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.

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.

Designed For

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.

Field of Study
Computer Software & Applications
Prerequisites

Beginner or Intermediate Excel skills

Course Producer
Business Learning Institute
CPE Credits
1.5
Level
Intermediate
Available Formats
In-Person, Live Webcast
Types
Seminars

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org