Moving nimbly around the spreadsheet with lots of navigation shortcuts thrown in!
Entering and editing data
How to enter text, numbers, formula and pictures and how to work with them.
Modifying a worksheet
As your spreadsheet develops, you need to make changes and if you don’t know these few simple steps it can all go horribly wrong! We cover the basics of how to insert or delete rows and columns and copy formula without getting a nasty error message.
Learn the simple ways to create formulas and the 5 basic formulas everyone should know!
Getting to grips with that tricky formatting of text and numbers so your spreadsheets are easy to read and look amazing in just seconds.
Don’t get tied up in knots with printing – a few simple rules will help you print your spreadsheet right first time.
Starting with chart basics we’ll take you through how to format your charts so they are stunning representations of your figures.
Managing large workbooks
Working with large or multiple worksheets? You need to know how to traverse them in seconds and how to move and copy data within them.
Graphics and screenshots
Work with the beautiful new graphics features and see how you can simply take a screenshot.
One Day Classroom based course - can be one of our public courses or on your own business premises for groups.
Attendees should be familiar with using keyboard and mouse and have some experience of using Excel. Even experienced users will find this course useful for keyboard shortcuts and navigation keys which will save (on average) up to 30 minutes a day doing routine spreadsheet work. This is a solid foundation for anyone who needs to use Excel.
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;More Information
This course is specifically designed for office staff/managers with some previous knowledge of Excel, and is designed to take you to the next level. Mistakes can be reduced if you use the tools that come with Excel and check your work. This course will cover essential time-saving features and will look in detail at:More Information
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 first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use the tools – Get & Transform, Power Pivot, Power Maps and Desktop BI Visualisations.More Information
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