Tips and Tricks

In older versions of Excel, if you wanted to extract data from cells or combine data from cells you had to use formulas. Now you can use a really handy technique called ‘Flash Fill’ without the use of formulas…

More Tips and Tricks

How to Create a Drop-Down List in Excel

The drop-down list is the most popular data validation tool in Microsoft Excel. This creates a drop-down list in cell(s) and ensures data entry is consistent, restricted to entries that are approved a...

Read more
Need Training Advice?

Speak to one of our expert team 0333 344 6630

Get in Touch

Courses

We offer a range of training courses from Microsoft apps such as Teams, OneDrive and Excel to Management and Leadership, Customer Service, Personal Impact and Effectiveness and Project Management.

Learn more

Popular Training Courses

Microsoft Excel
Microsoft Teams
Microsoft Power BI