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
INTRODUCTION TO PIVOT TABLES | 08 – USING THE SLICER (EXCEL 2010 ONLY)
So this is the final installment in the series of pivot tables. You can check out parts one, two, three, four, five ,six and seven here. A new feature of Excel 2010 is the Slicer - which looks rather like a grater but which allows you to easily "slice and dice" your...
24 – INTRODUCTION TO PIVOT TABLES | CREATE PIVOT CHARTS
So we are now up to seven of the eight part series I am doing on pivot tables. You can check out parts one, two, three, four, five and six here. In Excel 2007 (and later editions) the charting facility with your pivot charts gives you a huge amount of flexibility....
INTRODUCTION TO PIVOT TABLES | 23 – CREATE MULTIPLE PIVOT TABLES IN SECONDS
This is number 6 in an 8 part series of blog postings on pivot tables. You can read one, two, three, four and five and number seven and eight are on the way next week. I came across this rather delightful little trick on www.datapigtechnologies.com . Essentially it...
22 – INTRODUCTION TO PIVOT TABLES| GROUPING BY DATES AND NUMBERS
In part one of this series, I looked at list preparation and in part two, I suggested that you convert your list to a table to make it much easier to manage adding in new data. In part 3, we looked at how to construct your first pivot table. In part four I showed you...
PIVOT TABLES INTRODUCTION 04 | CONVERTING OUR NUMBERS TO PERCENTAGES
In part one of this series, I looked at list preparation and in part two, I suggested that you convert your list to a table. In Part 3, we looked at the nuts and bolts of creating your first pivot table. In this post I am going to look at how you quickly convert your...
Case Studies – How To
Identify non-attendance from a list of Zoom emails
Recently in a class I had someone who had to track attendance over a number of days training via a bunch of Zoom Emails. This link shows you how you would extract a list of attendee email addresses from your Zoom list. The key is really to get your data in good shape....
Simple Vaccination timetable
This video show you how to create a very simple timetable for vaccinations with names and a dropdown list for timeslots (which can be updated). You can download the completed version here. You can view the video on how I did it here https://youtu.be/FZ4DOwDY5co
Cleaning up an accounts file with Power Query
One of the most common tasks faced by accountants and office workers is that of data cleansing i.e. removing the extra blank columns , sub totals, blank rows so beloved of accounts packages but which all need to be removed before any sort of Excel analysis can be done...
Another way to “pivot” or “unpivot” – Excel style
This year has been the year of the pivot - so many people have had to pivot in their lives, both personal and professional. Pivot is defined as the action of turning around a point but of course in Excel it invariably means pivot table - which is basically a way to...
How to quickly get your PDF data into Excel
A question that comes up from time to time is how to get your PDF data into Excel. There are of course many online options to do so - just do a quick Google for "convert PDF to Excel" . However in this tutorial and video I want to show you how you could use the...
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.