Category Archives: Excel

Excel: Using the MAX() and MIN() Functions

Want to find the highest or lowest values in the a range in Excel? Then there are two functions that are easy to use to do that. They are MAX(), for finding the highest, or maximum value, and you guessed … Continue reading

Posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office | Tagged , , , , , , , , , | Leave a comment

Excel: Using the LARGE() and SMALL() Functions

If you have been using Excel you have probably come across the MAX and MIN functions for finding the highest or lowest values in a range. But what if you want to find the second largest or third and so … Continue reading

Posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office | Tagged , , , , , , , | Leave a comment

How to Use Consolidate Data in Microsoft Excel

If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , | Leave a comment

How to Use Excel Flash-fill

Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it. If you have a list of data and need to say … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , , , , | Leave a comment

How to Remove Duplicates in an Excel List

If you have created lists in Excel you might have thought to check if it has any duplicates. It could be data you’ve imported or data that has been entered. Perhaps you have shared the spreadsheet and you want to … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , , | Leave a comment

Excel’s Newest Function XLOOKUP

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features … Continue reading

Posted in Excel, excel function, Microsoft Office | Tagged , , , , , , | Leave a comment

Creating a Chart in Excel When Data is Not Next to Each Other

Excel has some great features for creating charts, I remember when I first started using it and saw how easy it was to create one. You would not believe what I had to do to create a chart before then … Continue reading

Posted in Excel, Microsoft Office | Leave a comment

How to Enter a Series of Dates in Excel That Are Only Weekdays

Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays.  All … Continue reading

Posted in Excel, Microsoft Office | Tagged , , , , , | 1 Comment

Excel: How to Enter the Same Day but Different Month and Year

We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on … Continue reading

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

How to Select Visible Cells in Excel

If you have every copied cells in a range that has some hidden rows our columns you soon discover that the hidden data gets copied too. Same applies to other features including subtotals. What would help is a command or … Continue reading

Posted in Excel, Office 2010 | Tagged , , , | Leave a comment