Hi - the following video highlights the power of flexible charts in Microsoft Excel.
Hi - a very useful data tidying option available in Microsoft Excel is the 'Remove Duplicates' function.
What is conditional formatting in Excel? …and why should I use it?
Hi – today I would like to detail how you can use the ‘TEXT’ function within a ‘SUMIFS’ function.
Hi – many businesses regularly receive external customer or supplier data and have the dilemma of how to utilise different data formats in their own reports.
Hi – one of the most commonly used Microsoft Excel functions is the ‘IF’ function.
A useful date function for reports showing more than one month is the EOMONTH function.
Hi – during a training session earlier this week the group conversation turned to #N/A results in VLOOKUPS.
Most regular users of Microsoft Excel are familiar with the SUMIF worksheet formula but it's surprising how many people are unaware of the SUMIFS formula.
Most businesses generate periodic ‘league table’ reports ie reports that rank products, salesman etc in order of performance.
Have you ever tried using the ‘MATCH’ formula with a ‘VLOOKUP’?