Excel tips and tutorials
If you’re trying to figure out when a project will be completed, you can use the WORKDAY.INTL function (Excel 2010 or later). It’s more flexible than the older WORKDAY function – it doesn’t assume that you work Monday to Friday any more!
Continue reading “Customize Weekends With Excel WORKDAY Function”
In this week’s roundup, KPI dashboards, pricing lookups, autofit for merged cell rows, and more.
Way back in June 2012, I posted some sample code for adjusting the row height in merged cells. It’s been 3-1/2 years, and people are still commenting on that article!
Apparently it is a common problem, and even though I don’t like merged cells, sometimes we just have to deal with them.
Continue reading “AutoFit Merged Cells Row Height Update 20151203”
In this week’s roundup, prevent errors, break links, register for an Excel summit, download an Advent calendar, and more.
In this week’s roundup, get file creation dates, plan for Thanksgiving, create icons with number formatting, and much more.
Also, I’m making a list of Black Friday (Nov 27th) and Cyber Monday (Nov 30th) sales for Excel related products. I’ll post it here on Thursday, November 26th, so we can be ready!
If you’re having a sale, and would like it included in the list, please send me the details — ddalgleish AT contextures.com
The Internet says that 15 years ago this month, I started my Contextures Excel Tips website. And since the Internet is never wrong, it must be true! The dates are a little hazy, because that was a loooong time ago, but it was definitely 2000 that I got the website up and running.
This week, I took a look back, and figured out how to get an Excel list that shows the original creation date of all my sample files. You can download a workbook with the sample code, below.
In this week’s roundup, create a rolling total, chart tricks, unmerge cells, clean data, and much more.
It’s easy to create a running total in Excel, and show the accumulated amount in each row. You can use the SUMIF function in a table, or show running totals in a pivot table.
But what if you want to show the total for a specific number of previous months – not all the previous months?
In this week’s roundup, find errors, lock slicers, plan for the holidays, use keyboard shortcuts, and much more.
My challenge this week was to show the running total in a list, but only for the current date and earlier. I wanted rows for future dates to appear empty, but have the formulas in them – ready to go. How would you solve that problem?
