Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Wil will compare TEXTJOIN and CONCATENATE. If you have Excel 2016 then you may be already aware of some of the new functions that are available. One of those functions is TEXTJOIN, and also CONCAT which was introduced in February 2016. I have been using TEXTJOIN recently to replace the CONCATENATE function I used on a regular basis. I get the same results, without the hassle the … [Read more...]
Formula Friday – Fast Formula Fill Using An Excel Table
Hello and welcome back Excellers. Today I want to show you how to achieve a fast formula fill by turning your data into an Excel table. If you want to make managing your data really easy, then I would recommend turning your range of cells on your Excel workbook to an Excel Table. Why Excel Data Tables? Excel Tables really help you filter, sort, organise and make your data easier to view. They also have an ideal structure for the source data of an Excel Pivot Table. If … [Read more...]
A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday
Welcome Excellers to another #FormulaFriday blog post in my 2020 Excel series. Today I am going to show you some Excel formulas. These are a great way to check if you have extra spaces in your Excel data that you need to clean up. Sometimes the data in cells looks identical like my barcodes in my sales extract. But, when you try to analyse the data you do not get the expected results. I will show you an example. I have a set of data below that I want to use in a VLOOKUP … [Read more...]
Excel Tip. Copy A Worksheet And Create A New Excel Workbook.
Hello, Excellers. Time for another Excel tip. I want to share with you a question from a subscriber. How to copy a worksheet It is going back to basics. They needed to take one worksheet from a sales workbook and create another workbook with just that one worksheet. They previously had been making a copy of the workbook and then deleting the extra unnecessary worksheets they did not need. Copy Your Excel Worksheet. There is a quick and easy way to do … [Read more...]
Excel Tip. Highest And Lowest Selling Price of Product Using MINIFs and MAXIFS.
Today's Excel tip is a question I was asked recently by a subscriber. It was to achieve an easy way to find the lowest and highest selling prices for a range of products. So, Welcome back to another blog post in my Excel tips #FormulaFriday 2019 series. The data set contained sales records for Sales People along with selling prices of goods. The minimum and the maximum price that the Salesperson agreed with the customer per product was needed. This is an easy job for the MINIF and the MAXIF … [Read more...]
- 1
- 2
- 3
- …
- 38
- Next Page »
Recommended Excel Resources
