Microsoft Excel training
If you're one of those people who knows - just knows - that Excel hates you, and yet you need to know more about it, then don't worry - we'll make your training actually enjoyable as well as informative.
And if you already love Excel, and want to take things to the next level, we've got you covered too...
Just mix and match from the topics below to create your perfect course.
Microsoft Excel - Introductory topics
We completely understand that for many people, Excel can be a source of frustration and even dread. But we guarantee that a day with us will not only be useful and informative but actually really enjoyable too (and if you don't believe us, check out some of the testimonials at the foot of this page).
We'll show you what you really need to know, give you some really useful shortcuts and demystify some of Excel's fantastic features.
Key skills learned:
- The basics - getting started, navigating around and finding your data
- The ten most useful Excel shortcuts
- Creating a spreadsheet from scratch
- Entering data and understanding (and fixing) common problems in working with spreadsheets
- The basics of entering formulas - two rules you should always follow
- Getting Excel to do it for you - shortcuts for entering and copying data and calculations
- Functions: What are they? Which ones do you need? How do they work?
- Sorting your data: How to do it - and the common mistakes to avoid
- Filtering your data - the best ways to find your data in Excel
- Creating charts - pie charts, column charts and more
- Printing data - how to get what you want first time, every time
- A sneak peek at some of Excel's best advanced features, and why they're really not advanced at all...
Unlike most training companies, we don't operate to fixed schedules.
We always run our courses in our clients' offices, so your staff will not have to travel or stay away from home.
We run courses on demand, tailoring each course to the needs of the client. So, for example, if you want a quick recap on the basics to fill in any gaps, but then want to move on to specific functions like VLOOKUPs or Pivot Tables, that's fine. Whatever works for you is fine by us.
As to when - whenever you need it. Because the course is just for you, we'll work with you to find a date to suit you.
Costs vary, but typically start at £750 + VAT per day. Remember, this is the total cost - not the cost per person.
Want something more advanced?
For those who are happy with the basics, we offer a range of more advanced topics, covering such areas as data management functions and analysis tools.
Take a look at the topics below, and as always, if what you want isn't listed, just ask.
Key areas covered:
- Building on the basic functions - IF, nested IF, COUNTIF and SUMIF
- Using named ranges in your formulas
- Keeping running totals with SUMIF and COUNTIF together with absolute references
- Data management functions - VLOOKUP, INDEX and MATCH
- Handling errors - ISERROR, ISNA and IFERROR
- Functions to check your data ISTEXT, ISNUMBER, LEFT, RIGHT and MID
- Working with dates in Excel - DATE, EDATE, NETWORKDAYS and WORKDAY
- Using data validation tools
- Advanced use of data management tools such as Text to Columns and Remove duplicates (both through the interactive tool and with Functions),
- Advanced use of conditional formatting, to highlight entire rows and to build dynamic forms
- Options for protecting your files at various levels
- Pivot Tables and Pivot Charts
- Building interactive dashboards
- Verifying that your Excel spreadsheets are accessible
Working with VBA - creating macros in Excel
If you're already comfortable with Excel's many features, but want to take your knowledge to the next level, then you'll be wanting to look at creating macros in Excel.
We'll start with recording a macro - that's where most people begin. But quickly we'll get our sleeves rolled up and start writing code from scratch.
Key areas covered:
- Getting started - recording a macro
- The benefits of writing your own code over recording macros
- Where Excel keeps its code - understanding standard and class modules
- Creating a procedure from scratch
- Responding to user interaction - event procedures
- Creating and using variables
- Working with what you've already got - objects, properties and methods
- Making your code more powerful - looping constructions
- Making your code more flexible - branching constructions
- Interacting with other applications - automating Word and Outlook from within Excel
- When it all goes wrong - using error handling techniques
- Why did it do that? Debugging your code
We'd love to work with you if we can!
Let us know how we can help - whether it's giving you a general understanding of Excel or fixing issue with spreadsheets you've already got - just get fill in the form below and we'll get right back to you.