Excel tips and tutorials
On the weekend, I copied a list of blog names and URLs into Excel. On the website that I copied it from, the list was in 2 columns, but it pasted into a single column in Excel. Having everything mixed together in one column wasn’t going to be very helpful. Here’s what I did to change single column list to 2 column table.
Continue reading “Change Single Column List to 2 Column Table”
Last week, three Office apps were released for the iPad – Excel, Word and Powerpoint. Have you downloaded any of the apps, and tried using them?
If you’re not sure whether to download them, you can read Ed Bott’s review of the new apps – he’s quite impressed by them. Bill Jelen (Mr. Excel) also reviewed the Excel app, and you can see his report here. Bill lists what’s in the apps, and what’s missing.
In the video below, there is a short interview with Han-Yi Shaw, head of Microsoft’s Office Design Studio. For more details, click here to read the Mashable interview.
Here’s what I posted last week:
Here are a few of the Excel articles that I read last week, that you might find useful:
Here are some upcoming events, courses and new books, related to Excel.
If you read or wrote any other interesting Excel articles recently, that you’d like to share, please add a comment below, or send me an email.
Please include a brief description, and a link to the article.
__________________________________
Screenshot – Excel for iPad
I’ve seen some confusing Error messages while working in Excel, and some rather cryptic ones. But yesterday, I saw the least informative Excel message ever, while working with a pivot table in Excel 2013.
Continue reading “Least Informative Excel Message Ever”
I ran into an odd problem with images in Excel 2010 last week – after looking at the sheet in Preview, a small logo graphic grew big enough to cover the most of the data on the sheet! Have you run into the problem where Excel images change size after Preview?
You might have heard a thing or two about March Madness, even in you don’t live in the USA, and follow college basketball. David Ringstrom explains how to use Excel to manage March Madness.
Here’s what I posted last week:
Here are a few of the Excel articles that I read last week, that you might find useful:
Here are some upcoming events, courses and new books, related to Excel.
If you read or wrote any other interesting Excel articles recently, that you’d like to share, please add a comment below, or send me an email.
Please include a brief description, and a link to the article.
__________________________________
On most of the worksheets that I build, there is a mixture of labels, data entry cells, and cells with formulas. Here’s how to clear cells and leave formulas, if you want to start a new entry.
In Excel, you can give a name to a range of cells, then use that name in a formula, or to create a drop down list in a cell. Later, if you decide that the range should be bigger or smaller, you can change address of Excel named range.
Happy St. Patrick’s Day! Four years ago, we celebrated by creating Ireland’s flag in Excel.
The flag is a simple column chart, with the 3 columns coloured to match the flag’s design. It’s an easy project, so you’ll be done in time to go out to celebrate.
The blog post also has a video of some festive Canadian Irish music, featuring Great Big Sea, playing with The Chieftains.
I’ve linked to it again this year, at the end of this post. The music will get your toes tapping, while you work on Excel projects today.
Here’s what I posted last week:
Here are a few of the Excel articles that I read last week, that you might find useful:
Here are some upcoming events, courses and new books, related to Excel.
If you read (or wrote) any other interesting Excel articles recently, that you’d like to share, please add a comment below, or send me an email.
Please include a brief description, and a link to the article.
Here’s the video, to put you in the St. Patrick’s Day mood – Lukey, by Great Big Sea, with The Chieftains.
__________________________________
With dependent drop down lists, you can control what appears in a drop down, based on what was entered in the previous cell. In this example, you select a region, then a country in that region, then an area, and finally a city. See how to set up dependent drop down lists, with tables that make this easy to maintain.
If I apply an AutoFilter to see the Top 10 Sunday sales in a list, why does Excel just show me the Top 2? Here’s how the Top Ten values in filtered rows feature works.
Update 9/29/2025: In the new video below, I show how to use the AGGREGATE function, for a top ten filter with an already filtered list.
