Microsoft Excel
We provide three 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.
Bespoke Courses
We can design a course around your needs. Download our Master List of Objectives and tell us what you would like the course to focus on.
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.
Excel Intermediate
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 Advanced
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. Due to the varying needs of Advanced users, we also provide a list of optional topics.