[20251129-20251130] SkillsFuture: Data Analytics with Excel (Intermediate): Turning Numbers into Insights

Some very useful functions/ features learnt: 

(1) Remove Duplicates (under Data) & Highlight Duplicates using conditional formatting

(2) Conditional Formatting: Various features, which can be customised further

(3) Absolute value is not new to me, what I want to illustrate here is the use of 

= Formulatext(cell address) to display the formula we used for calculation.

(4) Defining Range Names makes the spreadsheet more elegant. 

By Defining a range, the formula no longer requires us to select the cells, but directly use the name(s) assigned (see the formulae on the right)

(5) Slicers - a very powerful filter

(6) VLookUp/ HLookUp/ Lookup - a search and match tool, which I think I'm now more confident to use 

The biggest advantage of XLOOKUP is the table of items does not need to be organised in alphabetical order.

(7) Formatting Features that are useful:

(8) Logic Functions - IF, IF(AND), IF(OR), nested IF

In some instances, I attempted to show there are more than 1 way to do the same task (multiple solutions)

(9) Something useful when trying to check the relationship between the cells:

(10) Mathematical Functions (including "Database" approach) are very useful

Where possible, alternative methods are shown