CPD 9 hours On Demand Course Online

Excel tips and tricks for business series

Master the essentials of using Excel in business. This series teaches you the core functions and features in Excel that help you create and solve spreadsheets effectively. 

$654.54

non-member : $785.45

Description

This series covers the essentials of using Excel in a business context. We look at the core functions and features in Excel that help people build up spreadsheets and solve problems in a manner that is consistent; robust; flexible and transparent.

We start off with functions and basic features in the grid, along with keyboard shortcuts to improve speed and accuracy. Then, we move on to the data analysis and reporting tools, also known as Power Pivot and Power Query, to show how you can easily convert and transform mountains of data into insights and analysis in the space of minutes. Finally, we wrap up by taking a whirlwind tour of the big changes that have taken place in Excel over the last 10 years. For more detailed information, click on the 'Agenda' tab.

Learning outcomes

  • Learn keyboard shortcuts to improve your speed and accuracy
  • Pick up better ways to use formulae to solve common business problems
  • Use Power Pivot to perform analysis over multiple linked datasets
  • Use Power Query to transform your data and reduce your manual workload each month
  • Get an overview of what has arrived into Excel in the last 10 years

Benefits
Attendees will learn how to save time by applying Excel formulae and features more effectively.

Agenda

Presenter