Date & Text Functions In this unit you will learn how to: Find smarter ways to calculate dates and times using TODAY, NETWORKDAYS, WORKDAY and D… Read more »

Use COUNTIFS and SUMIFS Excel has the useful functions COUNTIF and SUMIF which are able to count the number of records or sum values of a field based on a cr… Read more »

Microsoft Excel 2021 has a new look, it’s cleaner and primed for use on tablets and phones. You can swipe and tap your way through worksheets. You can analys… Read more »

T he Goal Seek  Tool   The Goal Seek  tool can be very useful in a forecasting situation. Your forecast predicts that you in December will reach sales of £ 9,… Read more »

Quick reference: Excel shortcuts CTRL combination shortcut keys Key Description CTRL+SHIFT+( Unhides any hidden ro… Read more »

Using Logical Functions Excel’s logical functions are: ✅ AND  ✅ OR  ✅ IF  ✅ NOT  ✅ FALSE  ✅ TRUE  ✅ IFERROR These logical functions are important when doing a… Read more »