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
LINK WORKSHEETS IN EXCEL
In this tutorial, we are going to look at how to link Excel workbooks. For example if you are tracking the same information from three shops - you will probably keep the information on each shop on a separate worksheet but then want to add up the information from the...
PRINTING IN EXCEL | INTRODUCTION
In this tutorial we are going to look at the basics of how to print in Excel. [flowplayer src='https://s3-eu-west-1.amazonaws.com/the-excel-expert/print_introduction.m4v'] As always here is the file for you to download and practise with. I hope you are now...
FORMAT PAINTER – EXCEL (OR HOW TO QUICKLY COPY FORMATTING FROM ONE CELL TO ANOTHER))
If you need to quickly copy formatting from one cell to another, the Format Painter tool in Excel is a gift. You can use it to copy formatting once or multiple times. This video shows you how. For example, if you have formatted a spreadsheet on Monday but can't...
HOW TO HIDE ROWS (AND COLUMNS) IN EXCEL
In this tutorial we are going to look at how to hide rows and columns in Excel. This technique is very useful if you only want to look at part of your list or if you only want to print some of your spreadsheet ( you can hide the rows or columns you want to omit) You...
VLOOKUP IN EXCEL
In this Vlookup tutorial we are going to look at how to use the Vlookup function. Essentially what this does is allow you to match up information from two lists and pull in matching information. An example would be if we have a list of part numbers and we want to pull...
Case Studies – How To
How to compare two lists in Excel
Recently I got asked by a colleague to help her identify compare two lists of providers in Excel. In one list there was a list of providers available in May. In the other she had a list of providers available in January. She wanted to identify what providers were in...
Calculating age in Excel or “You are HOW OLD!”
In a class recently the subject of age calculation came up, which reminds me of when my son was young and would ask me how old I was. "19", I would say succinctly. He was at the age when he was learning basic maths. "So what would make you 12 when you had me.." "Yes,...
Solving Solver – when you need to see what numbers add up to a specific figure
Well, had a bit of a weird experience. I had written a full blog post on how to use Solver to identify what numbers make up a specific number. Let me give you a specific example. Many years ago - when I was working in an office - I'd have a difference in my bank...
Do you need to know how to analyse your Facebook data |Here’s how, using Power Query and Pivot Tables
In this blog post I'm going to show you how to use one of the new add-ins from Excel (Power Query) to quickly pull in your data from Facebook and then summarize it. Note that if you have found this useful that I cover both pivot tables and Power Query in my book Your...
Getting marginalized | What price do I need to sell at to make a profit?
A common question in a business is what price do I need to sell something at in order to make a certain margin or if I can only sell something at a certain price - what does my cost price have to be to make a certain margin. As always if you have specific questions or...
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.