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
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
Word Shortcuts Part 5 – the F6 and F8 function keys and the Ctrl+M and […]
Read more
Excel Shortcuts Part 5 – F9, Ctrl+F9 and some other useful shortcuts
Excel Shortcuts Part 5 – the F9 and Ctrl+F9 function keys and some other useful […]
Read more
Word Navigation Shortcuts Part 3 – Shift+Left, Right, Up or Down keys, and the Ctrl+End and Ctrl+Home key shortcut keys
Word Navigation Shortcuts Part 3 – the Shift+Left arrow, Shift+Right arrow, Shift+Up arrow, Shift+Down arrow, […]
Read more
Word Navigation Shortcuts Part 4 – Ctrl+Shift+Left, Right, Up or Down keys, and the Ctrl+Shift+End and Ctrl+Shift+Home key shortcut keys
Word Navigation Shortcuts Part 4 – the Ctrl+Shift+Left arrow, Ctrl+Shift+Right arrow, Ctrl+Shift+Up arrow, Ctrl+Shift+Down arrow, […]
Read more
Word Shortcuts Part 4 – F2, F11, F10 and Ctrl+L, Ctrl+E, Ctrl+R, Ctrl+J shortcut keys
Word Shortcuts Part 4 – the F2, F11 and F10 function keys and the Ctrl+L, […]
Read more
Excel Shortcuts Part 4 – F7, F8 and some other useful shortcuts
Excel Shortcuts Part 4 – the F7 and F8 function keys and some other useful […]
Read more