Forgot password >
How it works
Free Trial or Buy
How to Videos
An easy way to make fully dynamic related drop-down boxes
An easy way to make dynamic linked drop-down boxes from a dynamic data set without using named ranges and the indirect function
How to produce a list of weekdays in Excel
How to display only weekdays in excel - three simple methods.
How to make a dynamic drop-down box
How to make dynamic drop down boxes in excel using Data Validation and tables.
How to make many levels of dependent drop-down boxes
How to make many related drop-down boxes that are dependent on each other. This uses the table method to provide dynamic lists
Excel – how to make a drop-down dependent on another drop-down
Excel: how to make the choices in one drop-down box dependent on the choice in another without using VBA. Uses named ranges and Data Validation.
Automatically pulling data from other sheets into a dashboard
how to automatically pull data from many sheets into a single sheet. Useful when combining many sheets into one to make a dashboard. Uses the INDIRECT formula to make this simple and quick.
Personalised Week Ahead report from MS Project in Excel
How to produce a personalised "weekly look ahead" report for each resource on your project. Initially produced in MS Project but then customised in Excel. Including a macro to automate the excel element.
Calculating Cell colour and changing Tints and Shades in Excel using VBA
Working with cell colours in Excel - how to get the RGB value of a cell and how to change this shade by a percentage to either make it lighter (change the tint) or darker (change the shade).
Adding colours to the Dot Chart
How to add colour to the Horizontal Dot chart to show the status of the different data points.
Avoiding massive nested IF statements in Excel
How to avoid complex nested IF statements with the modern IFS statement and how to avoid errors
Enhancements to a dot chart - labels on dots
How to label the dots on a horizontal dot chart to improve readability
Enhancements to a Dot Chart - lines to the axis labels
In this blog we explore another enhancement to the horizontal dot chart
Full set ASSCII Code set
The original and extended ASCII code set - especially useful when using the CHAR() function in Excel.
Joining text together in Excel (CONCATENATE)
Excel provides a number of ways to join the contents of cells together in text strings
Replace chart markers with clip art or pictures
How to replace the standard Markers in a chart with the picture or clip art of your choice.
Adding pictures to axis
How to add images (in this case flags) to the axis of a chart
Plotting categories on XY Scatter or Bubble chart
Using this method, it is possible to chart categories against each other or a numerical variable using either a bubble or XY Scatter chart
Displaying the latest value on a chart
How to display data point(s) on a chart showing the latest information without needing to edit the chart every-time.
VLOOKUP and HLOOKUP
Vlookup and Hlookup are very useful when working with sets of data. Simple when understood and very powerful and useful.
Advanced VLOOKUP: Nested lookups
An interesting way to make VLOOKUP (and HLOOKUP) more powerful is to nest them, allowing the result of the first lookup to be used as the reference in the second lookup.
Control the choices allowed in one drop down / cell based on the contents of another cell
How to control the allowed entries in one cell based on the contents of another cell - linked drop down boxes
Use conditional formatting to highlight cells containing a formula
How to highlight cells that contain (or don't contain) a formula. This is very useful when you have a table which is generally calculated but has some cells which are manually entered.
Find the Nth instance of text in a cell
Finding the 2nd, 3rd, nth instance of a character in another cell is very useful and not possible with the standard FIND. This blog entry shows a simple way to do this.
Horizontal Dot Chart
How to create a chart that Excel seems to make impossible - a series of dots with categories on the Y axis against values on the X axis.
Conditional formatting to show if a cell contains a formula
A way to show which cells in a sheet contain formulae - very useful if you have a column of calculations with isolated items manually entered.
Items 1 to 25 of 27