We use cookies to give you the best experience on our website. If you continue without changing your settings, we’ll assume that you are happy to receive all cookies on this website. However, you can change your cookie setting at any time. x
Home > Blog
Sum VLOOKUP across a whole table - a fast way to do many Vlookup calculations
09.03.2022Sum VLOOKUP across a whole table - a fast way to do many Vlookup calculationsHow to apply VLOOKUP to many cells in a table at once. How to split text cells into columns to allow this to be useful.
the 56 standard colours in Excel - ColorIndex values or pallet
18.02.2022the 56 standard colours in Excel - ColorIndex values or palletDefinition of the 56 standard colours in Excel. Very useful in formatting.
Use Excel custom formats to show emoji and text
18.02.2022Use Excel custom formats to show emoji and texthow to use the Excel Custom formatting to change colour, add emojis and change numbers to text.
How to display a cell's colour in Excel
06.12.2021How to display a cell's colour in ExcelHow to display the RGB colour code for a cell in Excel
An easy way to make fully dynamic related drop-down boxes
05.12.2021An easy way to make fully dynamic related drop-down boxesAn 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
16.11.2021How to produce a list of weekdays in ExcelHow to display only weekdays in excel - three simple methods.
How to make a dynamic drop-down box
15.11.2021How 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
15.11.2021How to make many levels of dependent drop-down boxesHow 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
09.11.2021Excel – how to make a drop-down dependent on another drop-downExcel: 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
08.11.2021Automatically pulling data from other sheets into a dashboardhow 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.
How to convert an Excel Gantt chart into a MS Project plan
12.10.2021How to convert an Excel Gantt chart into a MS Project planHow to convert a Gantt in Excel into a Project Plan in MS Project. Simple step by step instructions to automate the process and avoid errors.
Personalised Week Ahead report from MS Project in Excel
13.06.2021Personalised Week Ahead report from MS Project in ExcelHow 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
08.06.2021Calculating Cell colour and changing Tints and Shades in Excel using VBAWorking 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
02.06.2021Adding colours to the Dot ChartHow to add colour to the Horizontal Dot chart to show the status of the different data points.
Avoiding massive nested IF statements in Excel
02.06.2021Avoiding massive nested IF statements in ExcelHow to avoid complex nested IF statements with the modern IFS statement and how to avoid errors
Enhancements to a dot chart - labels on dots
02.06.2021Enhancements to a dot chart - labels on dotsHow to label the dots on a horizontal dot chart to improve readability
Enhancements to a Dot Chart - lines to the axis labels
02.06.2021Enhancements to a Dot Chart - lines to the axis labelsIn this blog we explore another enhancement to the horizontal dot chart
Full set Ascii (ASSCII) Code set
16.06.2019Full set Ascii (ASSCII) Code setThe original and extended Ascii (sometimes misspelt as ASCII) code set - especially useful when using the CHAR() function in Excel.
Joining text together in Excel (CONCATENATE)
16.06.2019Joining 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
12.05.2019Replace chart markers with clip art or picturesHow to replace the standard Markers in a chart with the picture or clip art of your choice.
Adding pictures to axis
12.05.2019Adding pictures to axisHow to add images (in this case flags) to the axis of a chart
Plotting categories on XY Scatter or Bubble chart
25.09.2018Plotting categories on XY Scatter or Bubble chartUsing 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
23.09.2018Displaying the latest value on a chartHow to display data point(s) on a chart showing the latest information without needing to edit the chart every-time.
VLOOKUP and HLOOKUP
06.09.2018VLOOKUP and HLOOKUPVlookup and Hlookup are very useful when working with sets of data. Simple when understood and very powerful and useful.
Advanced VLOOKUP: Nested lookups
06.09.2018Advanced VLOOKUP: Nested lookupsAn 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.
Items 1 to 25 of 32
Page  1 2