The Excel Expert Blog
Tracking Training Records in Excel
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Path – Step by Step
EXCEL COUNT FUNCTION – COUNTING THE NUMBER OF NUMBERS IN A LIST
Excel count function This post will show you how to use the Count function. The count function counts the number of items in a list. Unlike the Sum function (which adds up the numbers), the count function tells you HOW MANY NUMBERS in a list. If you want to count the...
AVERAGE FUNCTION IN EXCEL
Average function in Excel (2007/2010) In this post we are going to look at calculating the average in Excel (using the excel average function) [flowplayer src='https://s3-eu-west-1.amazonaws.com/the-excel-expert/02_average_demo.m4v'] As always you...
08 – USING MAX FUNCTION – FIND THE HIGHEST VALUE IN A LIST OF NUMBERS
Using Max function - (Excel 2007/2010) The max function (Excel) allows you to find the highest value in a list. View the video to see how to do it in Excel 2007/2010 [flowplayer src='https://s3-eu-west-1.amazonaws.com/the-excel-expert/04_max_demo.m4v']...
USING SUM FUNCTION IN EXCEL (AUTOSUM) | ADDING LOADS OF NUMBERS UP REALLY FAST
How to add in Excel 2010 (and 2007) [flowplayer src='https://s3-eu-west-1.amazonaws.com/the-excel-expert/01autosumdemo.m4v'] This post will show you how to sum in Excel (2007/2010). We will be using the Excel sum formula called...
Case Studies – How To
Aging debtors analysis | Using Today() and vlookups or how to know who you need to send to the Sopranos
I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...
Pivot Tables | Using an Excel pivot table to analyse tender applications
Recently I was asked to help a manager score a series of tenders. The scenario was as follows: He had 10 questions for each tender application. Some questions were deemed essential. Others less so. He had 15 applications He needed to find some way to be able to...
Using Vlookup for populating a scientific taxonomy list or channelling my inner Attenborough
I recently got asked to help with setting up a formula that would autofill standard entries for particular species. The idea would be that the user would enter a species name and then the other details would fill in as normal. While the example I've given here is for...
Using Excel to track property rent and expenses | 02 of 02 – Getting the overview with a pivot table
In the first of these blog posts I showed you how to set up your data entry sheet to make it pivot table friendly. Now in this blog post we are going to use pivot tables to show the following... Analysis of each property's performance (using total income) for a year...
Using Excel to track property rent and expenses | 01 of 02 – Getting data set up
Recently I got asked for help by a colleague. She had helped a friend set up a spreadsheet to track his income and expenditure on his properties. Of course he had started off with one and that was easy to track but he had been very successful and was now up to...
Excel – General
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Random
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Personal
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.