We provide four standard courses in Microsoft Excel. However, we can also deliver more topics than are included in our standard courses, so contact us if a topic you need isn't listed. All of our standard Excel courses last one day (6 hours plus lunchtime) but we are happy to provide shorter or longer courses according to your needs.
You can click on the buttons below to obtain our detailed lists of objectives for each course. Although the Objectives files may refer to Excel 365, we can deliver courses for you on any Windows based version of Excel.
We can design a course around your needs. Tell us what you would like the course to focus on and we will build a bespoke course for you.
Our Standard Excel Courses
Excel for Beginners
Starting the delegates at the very beginning, we introduce them to the Excel Interface and to general Excel concepts. A sound foundation in writing simple formulas and functions will be provided with exercises for the delegates to work through. They will also be taught some tricks for accurate and efficient data entry, how to set up and manage worksheets and worksheet content, basic formatting techniques and how to sort and filter a spreadsheet. An introduction to charts is also included.
Our main Excel Intermediate course is for delegates who already know their way around a spreadsheet. We begin with a review of the basics of writing formulas and introduce the IF function which is one of the most useful functions in Excel. Many essential tools are covered in the course, including Paste Special, Comments, Charts, Sparklines, Data Validation, Conditional Formatting and ways to protect your data from unauthorised access or modification.
Excel Intermediate Formula Workout
This is a course where we mainly concentrate on formulas and functions for Intermediate level delegates. The day begins with a review of the fundamentals of formula and function writing. We then proceed through a range of functions including the IF function, functions for using with dates, times and text, subtotals, and those which perform a calculation on certain cells as specified by criteria (SUMIF, etc.). We also cover naming cells and ranges, building formulas which reference cells in other worksheets, and formula auditing tools.
To get the most out of this course, delegates should already be familiar with the IF function since we start the day with how to "nest" this function with others in the same formula. Other functions are also covered, such as lookup (including XLOOKUP and/or VLOOKUP) and information functions. In addition, the course provides introductions to PivotTables and PivotCharts, and to recording basic Macros. We also include Advanced Conditional Formatting (in particular, using formulas) and Advanced Chart features such as secondary axes and trendlines. If you are working with Excel 365, you also have the opportunity to learn about Dynamic Arrays and such functions as UNIQUE, SORT and FILTER.