Learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting and navigating super-fast and how to create charts which are a stunning representation of your figures. You will create a chart with one click and learn how to manage large workbooks. A day crammed with delightful shortcuts and quicker ways to work!
Our Excel Secrets 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 and how to format your charts so they are a stunning representation of your figures. You’ll create a chart with one click and learn how to manage large workbooks.
You’ll introduce coloured icons into your spreadsheets with Conditional Formatting so you can see at once your important data. At the end of this training course you’ll feel like an Excel Wizard!
Who is it for?
This One Day course is specifically designed for office staff/managers with little or no previous knowledge of Excel, or no prior formal training. You should be able to use a keyboard and mouse and know how to save documents. This course will cover the basics of using Spreadsheets and will look in detail at:
Entering and editing data
Modifying a worksheet
Managing large workbooks
Graphics and screenshots
You’ll cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links; special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Make 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; using the auditing features to check your work and protect your spreadsheet. We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts.
To help you become an Excel Ninja on this course we cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links.
We also look at 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 the secret built in formula!
You’ll learn how to speed up navigation around your spreadsheet and use range names in formula; using the auditing features will allow you to check your work and protect your spreadsheet.
We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts.
Using multiple worksheets and workbooks
Outlining and subtotals
Cell and range names
Documenting and auditing
Templates and settings
PivotTables and PivotCharts
You will learn how to become an Excel Guru using Logical functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions for geeks but in a way that makes it easy to understand and conquer! Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; Cover importing and exporting data into Excel, how to use built-in Analytical tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own macros.
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 it easy to understand and conquer! Financial, Date and Time Functions and Array Formulae, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; cover Importing and Exporting Data into Excel, how to use built in Analytical Tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own Macros. The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively.
Excel is one of the world’s most popular software programmes used by millions of people – but many are untrained and only use up to 10% of it’s features. The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively.
What You Will Learn
This course is specifically designed for office workers, managers, accountants and data analysts. Delegates on this course should have existing Intermediate knowledge of Excel, and we will turn you into Excel Guru’s. We will cover some of Excel’s best kept secrets and will look in detail at:
Logical and statistical functions
Financial and date functions
Lookups and data tables
Advanced data management
Exporting and importing
Macros and custom functions
When you need to see all your key business data and be able to visualise what this data means…Learn how to shape and show your data faster using Get & Transform, Power Pivot, Power Maps and a first look at Excel Desktop Power BI Visualisations.
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 Business Intelligence course has been developed to fill the gap with this innovative new collection of add-on features in Microsoft Excel 2013. This course runs through getting the BI modules installed, then how to use the 4 new tools – Power Query, Power Pivot, Power Maps and a first look at Excel Desktop Power BI Visualisations.
Get & Transform
Get & Transform allows data crunchers to get hold of public and internal data from many sources and combine them to share them with others.
Pivot Tables are a terrific tool in Excel allowing large amounts of information to be compressed and filtered, even shown using a PivotChart. The latest tool is PowerPivot, which allows the joining of data from several tables and on our course delegates will learn in a workshop session how to create and edit relationships between files and tables within Excel.
Power BI Desktop
Power BI Desktop gives Excel users the ability to create dashboards to view many types of Charts and Tables and change them using simple controls. The data analyst would create the Visualisations for management to see and manipulate their data in a very interactive way.
PowerMaps are the awesome new way of combining ‘geo-spacial data’ with map data and overlaying bar charts or heat maps onto Bing Maps and creating a ‘video’ with scenes and even music, panning in and out from space to a specific location where you want to display that data.
This course is for regular Excel users who have completed our Excel Secrets Level 1 – Excel Ninjas Level 2 – Excel Gurus Level 3 courses or can show they have this level of skill. We take regular Excel users to another level where they can produce a Dashboard on a single sheet which a user can manipulate to show the top level figures or charts they need.
If the numbers you need to track are spread out across different systems, learn how to have everything on one screen so all you need to do is 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 us help you make one for your business too.
The differences – Dashboards & Reports
• Issues with file size
• Pivot Table reports
• Interactivity with slicers
• Dynamically rearranging pivot table data
Grouping & bucketing data
Showing performance against target
• Useful macros for dashboards
• Navigation buttons
• Form Controls
Protecting your dashboards
10 Questions before distributing your dashboard
This training course is a practical guide to using the Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.
Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.
Please note there are pre-requisite courses/knowledge that you will need to have to take this course. Please ask us for details.