Hi - the following video highlights the power of flexible charts in Microsoft Excel.
Hi - the video below explains how you can create your own customised date formats in Microsoft Excel.
Hi - please find below a short video that explains how you can create an automated league table in Microsoft Excel.
Hi - do you need to improve the way your weekly, monthly or annual sales are reported?
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.
Hello - whilst Excel has many preloaded cell formats more often than not there is a requirement to create your own.
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’?