Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today's blog will show you all you need to know about how to use Absolute (and Relative) references when you are using an Excel table and structured references. Absolute Cell References. I think one of the most useful and first thing we learn when using Excel is the value of using the $ symbol. (Or the F4) key. This allows you to freeze a column or row, so when dragging a formula down a … [Read more...]
Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity
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...]
Proper Excel Formula
Hi Excellers and welcome to another #Excel #FormulaFriday blog post in my 2020 series. Today let's look at how useful the PROPER Excel function. This little formula does what it says. It converts your text to it's 'proper' case. Essentially it will turn the first letter of each string to uppercase and following letters to lowercase. PROPER Function Syntax. =Proper(cell reference) OR =Proper("your text") Let's work through an example. See my sample data in the screen-shot below, "sales … [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
- …
- 82
- Next Page »
Recommended Excel Resources
