Hints and Tips

Excel Missing Numbers in a Sequence – how can I do this in my spreadsheets?

Excel Tips

Excel Missing Numbers in a Sequence – can I use functions to find out what […]

Read more

Inserting Charts in PowerPoint – how do I insert them into my slides?

Hints and Tips

Inserting Charts in PowerPoint – how do I insert a chart into a slide in […]

Read more

Inserting Tables in PowerPoint – how do I insert them into my slides?

Hints and Tips

Inserting Tables in PowerPoint – how do I insert a table into a slide in […]

Read more

Inserting Shapes in PowerPoint – how do I insert them into my slides?

Inserting Shapes in PowerPoint – how do I insert a shape into a slide in […]

Read more

Nested VLOOKUPs in Excel: Mastering Them to Unleash Their Power Further!

Nested VLOOKUPs in Excel – using a step-by-step guide to learn and perfect the skill […]

Read more

VLOOKUPs in Excel: Mastering Them Through a Step-by-Step Guide

VLOOKUPs in Excel – using a step-by-step guide to learn and perfect the skill of […]

Read more

Date Reformatting in Excel – how to correct incorrect date formats to use in formulas

Date Reformatting in Excel – a solution to help fix incorrect date formats in Excel […]

Read more

Copy Paste Macro in Excel – how to use macros to copy and paste data through a button

Copy Paste Macro in Excel – using a macro in Excel to copy and paste […]

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

TEXTJOIN Function in Excel – have you tried this function out before in your spreadsheets?

TEXTJOIN Function in Excel – a function you can use to ‘extend’ the VLOOKUP function […]

Read more

Word Shortcuts Part 6 – Shift+F3, Ctrl+F6 and Ctrl+Alt+S, Ctrl+Enter Key and Ctrl+Shift+Enter shortcut keys

Hints and Tips

Word Shortcuts Part 6 – the Shift+F3 and Ctrl+F6 function keys and the Ctrl+Alt+S, Ctrl+Enter […]

Read more

Word Shortcuts Part 5 – F6, F8 and Ctrl+M, Ctrl+Shift+M shortcut keys

Hints and Tips

Word Shortcuts Part 5 – the F6 and F8 function keys and the Ctrl+M and […]

Read more