Excel tips and tutorials
In this week’s roundup, let me know if you like the version of Excel that you’re using at work, get productivity tips, add a sneaky filter to a pivot table, and more.
We’re on our summer schedule now, so the next roundup will be published on Monday, August 3rd.
Someone emailed me recently, asking how to copy just the numbers, from a column that also contained some blank cells. The goal was to paste those numbers in another location, in a solid block, without all the blanks.
In this week’s roundup, create bullet charts, export dashboards, use the Rank feature in pivot tables, and many other Excel tips
We’re on our summer schedule now, so the next roundup will be published on Monday, July 20th.
In this week’s roundup, plan your meals, fix dates, multiply cells, refer to tables, and many more Excel tips.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
In this week’s roundup, add custom chart labels, get started with VBA, compare worksheets, get info from hyperlinks, and many more Excel tips.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
In this week’s roundup, build a nested IF formula, improve your dashboards, work with dates, and change a pivot table layout.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
In this week’s roundup, fix drop down lists that allow invalid entries, create an interactive chart, get a free Excel book on Kindle, and much more.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
In this week’s roundup, see how to reverse last and first names, pin a shape to a chart point, learn some Solver history, and more.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
In this week’s roundup, see how to choose a chart type, check formula speed, work with pivot table source data, and many more tips.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
In this week’s roundup, choose a file format, get an Excel book sampler, fix dates, and build an add-in.
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!