Excel Level 2 Ninjas

Save on all online bookings (Enter Promo Code: WINTER25 at checkout). To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula

Description

Using multiple worksheets and workbooks

 

Advanced formatting 

 

Outlining and subtotals

 

Cell and range names

 

Tables

 

Advanced charting

 

Documenting and auditing

 

Templates and settings

 

PivotTables and PivotCharts

 

Prerequisites

Delegates should have completed Excel Secrets Level 1 course or have equivalent experience. If you are not sure what level knowledge/experience you have please contact us to complete a free Training Needs Analysis. 

Similar courses

Save on all online bookings (Enter Promo Code: WINTER25 at checkout). On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Learn the new XLOOKUP function.

More Information

Save on all online bookings (Enter Promo Code: WINTER25 at checkout). Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one. Let's make one for your business too.

More Information

Save on all online bookings (Enter Promo Code: WINTER25 at checkout). This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools.

More Information

Save on all online bookings (Enter Promo Code: WINTER25 at checkout). A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

More Information

Save on all online bookings (Enter Promo Code: WINTER25 at checkout). Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

More Information