Use this Exercise Fitness Tracker BMI Calculator Excel Templates to keep track of your client’s fitness goals.   Download Template

Split First & Last name The following formula is useful when you have one cell containing text which needs to be split up. One of the most common examples of this is when a person’s Forename and Surname are entered in full into a cell. The formula uses various text …

Rounding numbers in excel in critical in order to make spreadsheets look professional. I use the following trick on a weekly basis to round to the nearest thousand.

The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two

The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.  The format of the function is: =DAVERAGE(range, field, criteria) The range is the group of cells which you want to analyze and apply your criteria against. The field is the column …