February 14, 2018
Today's tip is from Excel project manager Ash Sharma. I asked Ash for his favorite Excel tips and will feature them for the next seven Wednesdays. His first tip involves a really simple way to calculate a distinct count in an Excel pivot table. It all comes down to one simple check box.
February 13, 2018
You've likely seen the viral YouTube video of Hunter Hobbs pressing the Down arrow key in Excel for 9 hours to get to row 1048576. I saw that video and shook my head. Why would he waste nine hours when Ctrl + Down Arrow would get you there in an instant? I considered the guy hopeless.
February 9, 2018
Ron wants to do a bunch of VLOOKUPs and sum the results. There is a single-formula solution to this problem.
February 5, 2018
Create calendar in Excel with one formula by using array-entered formula.
January 29, 2018
Say that you want to be able to count unique items from a list, but with a twist. Read this guest article from Bob Umlas to learn using variable ranges for unique counts.
January 24, 2018
It can happen: the long-running Excel file that has all of your information suddenly won't save or won't open. Excel tells you that they are going to attempt a repair, but that repair either does not work or it removes all of your macros. What do you do?
January 22, 2018
Sometimes Excel simply gives a message along the lines of - "Excel has stopped working. We are sorry for any inconvenience". When you get such a message, you might press Ctrl + Alt + Delete and open the workbook again (hopefully having saved whatever work you had done!), wanting to step through the code to find the offending statement. When you single-step through the code, all may work fine, but when you run it at full speed, once again it may crash. How can you find the offending statement?
January 19, 2018
Can a hyperlink in Word open a specific Excel file, jump to a sheet and jump to a cell? The syntax is fairly tricky, but it seems to work.
January 15, 2018
Suppose you want to produce a report from a set of data as if you filtered on a column. But what if you wanted a formula-based version of the same thing?
January 5, 2018
Need to get a list of all of the tax invoice PDF files from a folder in to an Excel spreadsheet. This is easy to do if you are using Excel 2016 on a Windows PC using the new Get & Transform Data tools.
November 21, 2017
If you always want Excel to default to a particular folder when you do File, Open... this article is for you.
November 21, 2017
Lev is commissioner of a competitive swim league. He writes: "I am the commissioner of a swim league. There are eight teams this year. Each team hosts one meet and is the home team. A meet will have 4 or 5 teams. How to arrange the schedule so every team swims against every other team twice? In the past, when we had 5, 6, or 7 teams, I could solve it by pressing F9 until close. But this year, with 8 teams, it is not coming out."