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
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Case Studies – How To
Formula showing formula not result | How to solve
I recently came across an interesting problem. A student in one of my classes asked me to help her set up some If functions which I did and which worked fine. It was a function to say that if a cell was blank, then the answer was to show today minus the days in F2,...
Tables and Structural References or how to do a lot less highlighting when creating formulas
One of the issues I come across frequently in class are people who have to work with large amounts of data. That often means a Lot of scrolling and selecting of lists of data and I have often wondered how I could make this easier for people. I have found an answer...
Combining data from multiple Excel files
In many cases we need to combine information from multiple sources together. Using the Vlookup function is one way to do this (if we just want to pull in matching information) but sometimes we actually need to add information together e.g. from branches of the same...
Creating an Excel hyperlink | Or how to create a table of contents for Excel sheet
In this tutorial I plan to show you how to create a cover page/table of contents for your Excel sheets. i.e. how to create hyperlinks to jump to another worksheet in your workbook. I'm going to look at two options. In the first one - we are just going to use text and...
Excel remove duplicates | How to summarise list from two sources
I was recently doing some training and one of the issues that came up was that the user had the following problem: Two stock lists (identical items), two physical locations and he needed to get a summary that showed the total number of items. I first thought about...
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.