Microsoft Office Courses Warwickshire

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

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

Word and PDF’s – a warning about protection settings in Word

Hints and Tips

Word and PDF – how does the new feature of PDF to Word cause issues […]

Read more

Time Calculations in Excel – using cell formatting to allow use of these in spreadsheets

Excel Tips

Time Calculations in Excel – how can I use cell formatting to allow use of […]

Read more

Text Wrapping in Word – how to use it plus some extra features

Hints and Tips

Text wrapping in Word – how do I use this? Watch the video to learn […]

Read more