Additional Intermediate / Advanced Excel Topics

Customise our standard Excel courses by adding in or swapping out topics you don't need with those you do


The standard 1-day intermediate Excel course and 1-day advanced Excel course contain the most popular, most useful and most commonly requested topics.

Below you will find a selection of additional topics.

You are welcome to select any combination of topics from those below or from any of our courses to create your own custom course.

We can accommodate all requests. Customisation is 100% free. 

Let us deliver a powerful course with useful content that you or your staff will actually use. Tailor the training around your own needs and requirements.

Contact us right now and tell us what you need.


These addition topics are designed to be mixed with the intermediate and advanced Excel courses. They are not intended for people just starting out.

Versions Taught

Our computers are always installed with Excel 365 (desktop) - we always use the current version.

If you have an earlier or Excel such as Excel 2016 or Excel 2013 we will explain any key differences during the training.

Still using Excel 2010 or earlier? It's time to say goodbye to an old friend and upgrade! Microsoft don't support this version any more.

Related Courses

what you get

Here's what you'll learn in this course

Paste Special

  • Understanding the different layers of formatting
  • Pasting contents without formatting
  • Using Paste Special to consolidate data
  • Transposing data
  • Creating a dynamic link to the source data
  • Creating automatic subtotals

Protecting cells, worksheets and workbooks

  • Protecting a cell or cell range
  • Protecting and un-protecting a worksheet
  • What can you protect against?
  • Setting and un-setting a password
  • Workgroup protection
  • Protecting a workbook
  • Encryption
  • Locking down a final version of a spreadsheet


  • Workbook and worksheet templates
  • Saving, modifying and deleting a template
  • Creating a new workbook based on a template

Formulas that link to other cells, worksheets & workbooks

  • Creating formulas that reference cells within other worksheets and other workbooks
  • Viewing and updating links manually Updating links automatically

Advanced Find & Replace Techniques

  • Overview of Find & Replace
  • Specifying where to search
  • Case-sensitive searches
  • Searching for and replacing a format, rather than text
  • Using AutoCorrect
  • Using the Go-To-Special feature

Links (formerly called Hyperlinks)

  • Creating, editing and removing hyperlinks
  • Linking to another file
  • Linking to another place in the same workbook
  • Linking to a web page
  • Linking to a new e-mail message
  • Activating the hyperlink from a graphic


  • Creating, editing and deleting comments
  • Reviewing and navigating through comments
  • Moving and resizing comments
  • Changing the default user name

Customising the Quick Access Toolbar (QAT)

  • What is the Quick Access Toolbar?
  • What can be added to the QAT?
  • How to add elements to or remove elements from the QAT
  • Adding a custom iconRunning a macro from the QAT

Using the Microsoft Graphic Tools

  • Using the graphics ribbons
  • Working with the 157 drawing shapes in the shapes gallery
  • Adding and editing your own pictures
  • Aligning graphics for a professional finish
  • Adding glow, reflection, shadow, soft edges, 3D, and bevel effects
  • Using the new and improved WordArt
  • Creating a multitude of different business diagrams using Smart Art

More What If? Analysis Tools

  • Data Variable tables

Advanced Date & Time Functions

  • Doing clever things with advanced date and time function combos including TODAY, NOW, DAY, MONTH, YEAR, DATE, 
  • Custom date & time formats
  • Incrementing a date by a day / month / year
  • Calculating the difference between two dates
  • Calculating the last day of the month
  • Determining if the current year is a leap year
  • Determining if this month is somebody's birthday, renewal date etc. 
  • Time as a duration (e.g. 48 hours) vs time as a time
  • Calculating a duration when start and end times span midnight
  • Calculating / converting duration as a decimal (e.g. 3.5 hours) vs duration as hours, minutes and seconds (e.g. 3:30)Second

Additional Database Functions


Importing External Data into Excel

  • Importing a CSV file
  • Importing an entire or filtered Access database table

Custom Views

  • What can be stored in a view?
  • Creating, editing, displaying and deleting a view

Sharing Workbooks

  • Advantages and disadvantages of sharing a workbook
  • Allowing a workbook to be shared
  • Protecting worksheets and workbooks
  • Handling conflicts
  • Implications of sharing a workbook

Online Forms

  • Exploring the Form tools
  • Adding labels
  • Adding a drop-down list or list box
  • Adding a spinner control
  • Adding tick boxes or option buttons
  • Grouping option buttons together
  • Adding a scrollbar
  • Showing or hiding the gridlines
  • Selecting and moving controls
  • Save the form so it can be used

Array Formulas

  • Creating an array formula
  • Understanding array rules and characteristics
  • Locating and editing an array formula
  • Using logic functions with arrays
  • Creating a Frequency Distribution
  • Creating a Histogram