Excel TutorialExcel VBA TutorialTutorial

Automatically Refresh a PivotTable When its Data Source is Updated

PivotTables require a refresh if the underlying data is changed or added to.  This tutorial will explain how to automatically refresh your PivotTable using a few lines of VBA code. The solution will work when you change existing data or add new data.  Follow the tutorial and/or watch the video below.

For…

Read More
Excel TutorialTutorial

Combine Values & Delimiters Using Excel’s TEXTJOIN Function

How to Use Excel's TEXTJOIN Function =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Excel’s TEXTJOIN function provides a quick way of combining values in different cells, like for example first, middle and surnames as shown below.  This has always been possible in Excel but TEXTJOIN provides a better solution if you need to include…

Read More
Excel TutorialTutorial

Using Excel’s SWITCH Function including SWITCH with VLOOKUP.

SWITCH Function =SWITCH(expression,value1,result1,default)

Simple Example To help explain how SWITCH works, here is a simple example. We need the SWITCH function to return the correct discount percentage for each item of fruit in the list D2:G9.  The discounts are listed in the first table A2:B6. The fruit value in column D is…

Read More