Microsoft  Excel Advanced Excel Function Syntax (Required arguments shown in bold) What it does Logical … Read more »

Auditing Formulas In this unit, you will learn how to: Trace formula precedents, dependents and errors Correct errors in formulas Trace Form… Read more »

Use Text Functions When data is copied from another source such as a Website you may need to manipulate or transform it in some way. The text functions menti… Read more »

Time Calculations Time values can be entered into Excel worksheets by typing them in the format: hh:mm For example 12:00 would mean mid day. The time is… Read more »

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 »