AUTOHIDE AND AUTOVIEW
Many files consist of numerous different sheets. Using some simple lines of code, we can keep our files nice and tidy, whilst retaining the ability to drill down into the data if we want more details.
​
As with lots of coding, the video shows processes that can easily be done manually. However, automation speeds them up no end, leaving you free to get on with what you really want to do.
VISUALISE YOUR PROJECT
VISUALISE YOUR PROJECT
Excel can be used to create visual summaries of the different elements of a piece of work or tasks that depend on each other.
​
Gantt charts like this are used by Microsoft in their Project and Visio products. However, with a bit of know-how, we can use Excel to generate models that are just as effective. We can be as versatile as our imaginations allow us...
​
Have a look at the video: it's a bite-sized look at different options that are available that I can help you with.
MAKE YOUR OWN SLICERS
The video shows a snapshot of a project done for the company The Art Of Work. With a standard layout across the different sheets, buttons that slice up the data can be created without needing the intricacies of formal pivot tables.
PIVOT YOUR DATA
You can turn bland data into a tool of powerful analysis by using Excel's Pivot Table and Pivot Chart features.
A simple list of data is turned into a rich visual summary. Understand patterns and trends and identify areas of strength and weakness quickly and easily with the tools I can help you utilise.
Click the button to download and check out this workbook for yourself.
​
You can use the slicers (the coloured boxes) to look at different sections of the dataset.
You can also have a look at pivot charts and slicers in action with the video. It's using data from Bedford Parkrun to analyse on age categories, first timers, club runners, gender splits and many more different stats.
TRACK YOUR DATA
You can use Excel to specify what you want to see in your spreadsheet, and draw attention to the most important details.
​
The video introduces you to just a few of the options available to build in to systems of logging, tracking and interrogating your data.
SAMPLE YOUR DATA
Ever wanted to highlight a sample of your data? This video shows how to combine functions and conditional formatting to pick out one in every ten records for each different person named in a list of entries.
​
No VBA required, but the COUNTIF, RIGHT, LEN, MOD and OR functions all make an appearance. So do mixed reference ranges, so eyes down and give it a go!