Excel Tips

Excel Shortcuts Part 3 – F3, F5 and some other useful but lesser known shortcut keys

Rachel Excel Tips

Excel Shortcuts Part 3 – the F3 and F5 function keys and some other useful […]

Read more

Charts from Data with Error Messages – how to to create a chart from data that has error messages in it

Rachel Excel Tips

Charts from Data with Error Messages – do you know how to create a chart […]

Read more

Creating a Chart From Hidden Rows in Excel – how to easily remove unwanted rows with empty cells

Rachel Excel Tips

Creating a Chart From Hidden Rows in Excel – have you used this option before […]

Read more

New Excel Status Bar Feature Coming Soon! Copying from the status bar in to Excel

JPL Excel Tips

New Excel Status Bar Feature Coming Soon – did you know you will be able […]

Read more

UNIQUE Function in Excel – another way of filtering out data in your spreadsheets

JPL Excel Tips

UNIQUE Function in Excel – have you used this function before to filter out data […]

Read more

Excel Currency Data Types – a way of adding extra information to your data

JPL Excel Tips

Excel Currency Data Types – have you used this feature on the Data Tab to […]

Read more

Excel Table Based Formulas – another way of creating a formula in Excel

JPL Excel Tips

Excel Table Based Formulas – have you ever created a formula through an Excel table […]

Read more

Advanced Filtering Methods – how do you use it?

JPL Excel Tips

Advanced Filtering Methods – what are the ways in which you can use it? This […]

Read more

Nested XLOOKUP with MIN Function – have you used these functions nested together before?

JPL Excel Tips

Nested XLOOKUP with MIN Function – nesting together the XLOOKUP and MIN functions to further […]

Read more

Data Subtotals with Visible Cells – have you used the visible cells only option before?

JPL Excel Tips

Data Subtotals with visible cells – using the visible cells only option with the Data […]

Read more

Array Spill in Excel – have you tried using this before?

JPL Excel Tips

Array Spill in Excel – another way to do formulas and calculations in Excel that […]

Read more

FILTER vs VLOOKUP Function in Excel – which one should I use?

JPL Excel Tips

FILTER vs VLOOKUP Function in Excel – have you used both? Which do you prefer? […]

Read more