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
NAME A RANGE IN EXCEL
So first of all what does this mean and why would you bother? Let me give you two examples =sum(a1:a10) or =sum(salaries) Which do you think looks easier to read and understand? Yes, the second one. So a very useful way to help document and clarify your spreadsheet is...
CREATE A DROPDOWN LIST IN EXCEL
A useful skill to have - particularly if you need to do analysis on a list (in pivot tables etc) as you want to ensure that your data entry is kept consistent. It's also a real time saver it you need someone else to input data for you and you want to restrict data...
CONDITIONAL FORMATTING BY ROW
In this video, I am going to show you how to use conditional formatting to highlight an entire row based on a single criteria (rather than just highlighting the single cell). In another post, I am going to show you how to use the And function with conditional...
IF STATEMENTS IN EXCEL
One of the most powerful tools in Excel is the if statement. An if statement has the following structure: test a question, if the answer is "Yes", do one thing. If it's "No", do something else. For example, a use of it would be in exam results - have you scored over...
HOW TO SET AND CLEAR PRINT AREA IN EXCEL 2007/2010
As a link to my other tutorial on printing , I am going to show you how to do the following in this tutorial: Set a print area Clear a print area Hide columns/rows if you only want to print specific parts of the spreadsheet, that may not be side by side... As always...
Case Studies – How To
Using Forms to capture data for analysis – Part Three – Meet Power Automate
When I had finished helping the user get set up with her data set - which is now working away merrily and taking her minutes instead of hours, I found myself wondering was there a way to automate it even further. When I asked in my network, the most common response...
Using Forms to capture data for analysis – Part Two
Last week I showed you how to set up a Form in MS Forms. I hope you have come down from the excitement of all that (!) and are now ready for Phase Two.. A - Getting your data into Excel and cleaning it upB - Constructing a pivot table to summarize the dataC - Updating...
Using Forms to capture data for analysis – Part One
I recently had a scenario where I had a customer who needed to capture timesheet data from her employees. She had been doing it manually up until then, chasing people for hours in the last minutes before doing a pay run. She decided to use Microsoft Forms to capture...
Deferred Income – When you haven’t quite got the money in the bank – Part Two
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam - and the techniques I learned there made me realise I could have done this more effectively.. You can view Part one here (Steps one to three) Just a reminder about what deferred income is......
Deferred Income – when you haven’t quite got the money in the bank…Part One
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam - and the techniques I learned there made me realise I could have done this more effectively, but that will be for another post...:-) There are seven steps in this so I have published the first...
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.