Microsoft Office Courses Warwickshire

How to Create a Table of Contents in Word

Hints and Tips

How to Create a Table of Contents in Word – how can I insert one […]

Read more

Using Copilot in Excel – a brief introduction to the AI package

Using Copilot in Excel – the Microsoft AI package that can be used along your […]

Read more

SUMIFS and COUNTIFS Functions in Excel – what do these do?

Excel Tips

SUMIFS and COUNTIFS Functions in Excel – how are these different to the SUMIF and […]

Read more

Inserting Hierarchy SmartArt Diagrams in PowerPoint – how do I insert them into my slides?

Hints and Tips

Inserting Hierarchy SmartArt Diagrams in PowerPoint – how do I insert this type of SmartArt […]

Read more

Inserting Process SmartArt Diagrams in PowerPoint – how do I insert them into my slides?

Hints and Tips

Inserting Process SmartArt Diagrams in PowerPoint – how do I insert this type of SmartArt […]

Read more

Excel Conditional Formatting with Dates – have you used this feature before in your spreadsheets?

Excel Conditional Formatting with Dates – taking conditional formatting a step further in your spreadsheets […]

Read more

New Excel Status Bar Feature Coming Soon! Copying from the status bar in to Excel

Excel Tips

New Excel Status Bar Feature Coming Soon – did you know you will be able […]

Read more

Advanced Filtering Methods – how do you use it?

Excel Tips

Advanced Filtering Methods – what are the ways in which you can use it? This […]

Read more

Data Subtotals with Visible Cells – have you used the visible cells only option before?

Excel Tips

Data Subtotals with visible cells – using the visible cells only option with the Data […]

Read more

FILTER vs VLOOKUP Function in Excel – which one should I use?

Excel Tips

FILTER vs VLOOKUP Function in Excel – have you used both? Which do you prefer? […]

Read more

Duplicate Values in Excel – how can I show them?

Excel Tips

Duplicate Values in Excel – how can I shows these highlighted in my spreadsheets? This […]

Read more

Excel Shortcuts Part 2 – F2, F4 and cut, copy and paste shortcut keys

Excel Tips

Excel Shortcuts Part 2 – the F2 and F4 function keys and cut, copy and […]

Read more