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
Keeping up to Date With Excel – Advanced Statistical Analysis
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 [...]
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 [...]
Using Advanced Formulas and Functions in Excel
With everyone using Excel more and more in business, the level of skill and knowledge required has increased hugely. Just being able to create a simple spreadsheet and input data is often no longer [...]
The Digital Skills Gap – Don’t Mind the Gap, Bridge It
We’re surrounded by technology; immersed in it so completely that most of us barely even realise it’s there (although we certainly notice when it’s not). Yet, it seems that despite our growing dependence on [...]
How to Make the Most of Your Digital Skills
It would be hard to think of a role that exists today that doesn’t require the use of technology in some form. The evolution of the digital realm has been so rapid that it [...]
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 [...]