Excel plays such a huge part in most people’s everyday work and yet most people only use a small fraction of its capabilities.  The trouble is, with Excel 365, they are adding new features and functions each month that is can be hard to keep up with what is new and whether those features could benefit us.

For those more advanced users we have just launched our Excel Advanced Statistical Analysis course.  This looks at some of the existing and newly added features to support in more advanced calculations.

What Do We Cover?

As mentioned above, there are a LOT of features available in Excel, some you may have heard of but don’t quite know what they do, and others are brand new additions.

In the Advanced Statistical Analysis course we look at some of the What If Analysis features that enable you to map scenarios and forecast data, including use of Goal Seek, Solver, Scenarios, Forecast Sheet and using Data Tables.

We also explore some of the inbuilt Financial functions that you can use. The Analysis Toolpak has so many options, we look at a few to generate statistical analysis and visualise your data.

We then start to explore Array Formulas and look at the Dynamic Arrays in Excel 365 and some of the new and extremely useful functions introduced by Microsoft.

And that’s just the tip of the iceberg. If there are specialist requirements you or your team need, please get in touch and let us know. We’re happy to help develop bespoke courses that cover your needs.

Read Next

  • woman using spreadsheet

What Are Macros and Why Should You Use Them?

What Is a macro? A macro is shorthand for a programming term: macroinstruction. In the most basic terms, a macro is a way to automate simple tasks. They can be used in a variety [...]

  • 'What's New?' on blue brick background

New Course Announcement

We are excited to announce the launch of a new course and to share some updates to our range of Excel programmes. With Excel being such a key skill in today's business world, Underscore [...]

back to all blogs