When you've got a worksheet full of functions and formulas (or a combination of them), it sometimes gets hard to figure out what cells you'd need to pay attention to. This could be especially true if you're working with people that need to help fill in values or need to know where the formula are so they don't mistakenly update them. You can highlight cells that have formula in a couple easy steps
Monday, March 28, 2022
Monday, March 21, 2022
Quickly Remove Blank Rows
When you get a table of data sometimes it's got some blanks cells. For those records in the row where there's any cell that is blank, you may not need that record...so you want to get rid of them. To delete some record rows manually is not hard if you have just a few rows, but if you've got a lot, there's any easier and faster way to do this.
Monday, March 14, 2022
Clear All Formatting - Excel
Sometime you get all sorts of formatting on your spreadsheet like bold, underline, some funky magenta cell fill and just need to start over. You don't want to go into each cell and find and "find" the multiple types of formatting that might be there. Let's just do it one and done.
Monday, March 7, 2022
Separate / Extract Data Flash Fill
Flash Fill was introduced in Excel 2016 and give you an easy way to split or extract text or values from one column cell to another. A common use is to split out a column with full name (i.e. first name last name like John Smith) to separate first and last name columns. Before you might have used LEFT, MID or RIGHT functions, but now with Flash Fill, there's no need to use those functions.
Monday, February 28, 2022
Millionaire Calculator NPER- Excel
f you're got a mutual fund or some kind of investment vehicle that lets you put in an initial investment and give you the chance to put in additional investments, how long will it take to get to a million bucks? Use the NPER function to find out.
Monday, February 21, 2022
Sort Column by Cell Color
Sorting columns are a common occurrence and usually done via ascending or descending based on A to Z or Z to A with text or number values. But did you know you can sort by color? The use case maybe that you've done some conditional formatting for the cell color and you want to sort on blue, yellow and green in that order. It can be done with the custom sort feature.
Monday, February 14, 2022
Calculate Cumulative Principal & Interest
When you've got a loan or mortgage and you're the analytical type, maybe you'd want to know how much you're paying in principal and interest for a giving time period. For example for the first year, how much is that payment for the principal (hint: it's not much) and how much of the payment is interest going to the bank (it might surprise you). You can figure this out with Excel.
Subscribe to:
Posts (Atom)