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
GETTING FAKE NAMES | CREATING YOUR FUN FAKE IDENTITY
Yes, I bet that got your attention. No, this is not a step by step guide for developing multiple identities or promoting any sort of fraud or even some ideas for a name if you ever went into the Witness Protection Programme (note to self - time to stop watching fewer...
DATA TABLE | QUICKLY CREATE A LARGE TABLE OF VALUES
In this blog posting, I'm going to show you how to use a feature in Excel to create a large table of values. The feature is called Data Tables and I'm going to use the PMT function with it to show you how to quickly create a large table of loan repayment values. Here...
EXCEL NAMED RANGE – HANDY TRICK TO VIEW RANGES
As part of the Excel Hero Academy that I' m now doing, one of the first things we did was learn more about named ranges. Daniel Ferry showed us a really useful trick that allows you to view your ranges (with their names on their sheet). The trick is to reduced the...
FIND DUPLICATES IN EXCEL | PART TWO
In Part One of this blog posting, we've already looked at using Conditional Formatting to identify duplicates (and unique values). In the second scenario, I'm going to look at where we have a list of rooms/dates/times and we want to see if there are any clashes - so...
FIND DUPLICATES IN EXCEL | PART ONE
In this post, I'm going to show you how to locate duplicates in Excel. I'm going to look at two scenarios. In the first scenario - we just have to identify duplicate/unique values in a list. For this I'm going to use Conditional Formatting . I also show you how 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.