by John Legge | Jun 23, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Leicestershire
SUMIF and COUNTIF Functions in Excel – how can I use these functions in my worksheets? This week’s hint and tip is about the SUMIF and COUNTIF functions in Excel and how you can use them in your worksheets. These are covered on our intermediate Excel...
by John Legge | Jun 9, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Herefordshire
NETWORKDAYS.Intl Function in Excel – how can I use this function in my worksheets? This week’s hint and tip is about the NETWORKDAYS.Intl function in Excel and how you can use it in your worksheets. This isn’t covered on any of our courses so we...
by John Legge | Apr 14, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Staffordshire
Formula Conditional Formatting in Excel – how can I use formulas to apply conditional formatting in my worksheets? This week’s hint and tip is about formula conditional formatting in Excel and how you can use it in your worksheets. This is covered in our...
by John Legge | Mar 31, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Gloucestershire
Excel green triangle errors – have you ever come across these errors/notifications before? Watch the video to learn more This week’s hint and tip is on Excel green triangle errors. This blog is to help you understand a little more about the little green...
by John Legge | Mar 17, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Herefordshire
RANK and XLOOKUP – how can I use both of these my worksheets? This week’s hint and tip is about the functions RANK and XLOOKUP in Excel and how you can use them in your worksheets. In this hint and tip we are showing you how you can use Excel for sporting...
by John Legge | Feb 17, 2021 | Excel Tips, Hints and Tips, Microsoft Office Courses Warwickshire
Excel Shortcuts Part 2 – the F2 and F4 function keys and cut, copy and paste shortcut keys, have you used them? Watch the video to learn more This week’s hint and tip is on Excel shortcuts part 2. Part 2 of these shortcuts covers the function buttons F2...
