Category Archives: Microsoft Excel

Microsoft Excel – SMALL and LARGE functions

You may well know that the function MIN gives the smallest number in a range in Excel and that the function MAX gives the largest number in a range in Excel. But what if you want to return the Xth … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , , | Leave a comment

Excel 365 – new text function TEXTSPLIT

New text functions have recently been added to Excel 365. The TEXTSPLIT function works in very much the same way as Data – Text to Columns. The syntax is =TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode] [pad_with]) Only the first two bits … Continue reading

Posted in Excel 365, Microsoft Excel | Tagged , | Leave a comment

Microsoft Excel – dates in mix of format xx/xx/xxxx and xx.xx.xxxx

Where I was training last week, they sometimes received Excel worksheets where in a column of dates some were input in the format xx/xx/xxxx and some were input in the format xx.xx.xxxx. They needed consistency in formatting. Now there may … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – Start and end points in Sparklines

A sparkline is a miniature graph of a data range which can add a useful visual look to your data. To create a sparkline, click in the cell in which you want the sparkline to be displayed, then on the … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – using wildcards with numbers in Data Validation

I was at a client recently and they wanted to limit data input in an Excel column to have a number starting with 4 and then five numbers after it. I have worked out a way of doing this using … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Office 365 – Quick Access toolbar – command labels

In Office 365 and the latest version of Microsoft Project, you can choose to show the Quick Access Toolbar above or below the ribbon. To do so, click on the drop-down to the right of the Quick Access Toolbar. If … Continue reading

Posted in Excel 365, Microsoft Office 365, Office 365, Outlook 365 | Tagged | Leave a comment

Microsoft Excel – moving worksheets around in a workbook

I was quite surprised the other day to be asked by someone who was using VLOOKUPS and Pivot Tables as to whether they could alter the order of worksheets in a workbook. This is probably a case of someone who … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – dates formatted as text

If your dates are formatted as text in Excel – this sometimes happens if you have downloaded the data from elsewhere, then you will be unable to use them in formulas, timelines, etc. To convert Text fields to dates, select … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel 365 – Sheet View

If you go to the View tab in Excel 365 towards the left you will see a group called Sheet View. Mine seems to be greyed out a lot of the time, so it took me a while to work … Continue reading

Posted in Excel 365, Microsoft Excel, Uncategorized | Tagged , | Leave a comment

Excel 365 and Excel 2021 – the Filter function

The FILTER function is new in Excel 365. When we use the Filter dropdowns we see the results as part of the data set but the new FILTER function allows us to easily create a subset of that data somewhere … Continue reading

Posted in Excel 365, Microsoft Excel | Tagged | Leave a comment