Excel Skills Test
May 22, 2018
NOTE: You'll get the next newsletter on June 5th -- we're on the summer schedule now.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site!
Some worksheets have blank cells, so it's easier to read headings in a column. I used to work with lots of data like that, which was imported from an accounting system.
It's fine for printing a report, but if you want to sort or filter that data, you'll need to fill in those blanks.
Here are the steps to fill the blank cells manually, and there's a video on my site that shows the steps:
If you get this news because you bought one of my Contextures products, be sure you're ALSO on the weekly news list, if want to keep getting it. Otherwise, I'll only send you occasional product update news.
To see your subscription info:
Here are a couple of Excel articles that you might find useful or interesting.
Slicers - In a short video, Bill Jelen shows how to get the selections from a Slicer, and list them in a cell, as a worksheet title. You'll need Office 365 for this technique, because it uses the new TEXTJOIN function (Level - Intermediate)
Excel Skills - If you want to test your Excel skills (or someone else's), Sumit Bansal posted a list of 100 Excel Interview questions. The topics range from formatting to macros. (Level - All)
We just celebrated the first long weekend of summer, here in Canada, and the weather wasn't very summery. At least it wasn't as cold as the year that we went camping in the Rockies at the end of May. There was still snow on the ground, and beautiful Lake Louise was frozen solid. On the bright side, the bears were still hibernating!
That's it for this week! If you have any comments or questions, send me an email.
NOTE: For the online version, paste this URL into your web browser: http://www.contextures.com/newsletter/excelnews2018/20180522ctx.html
I'll also post any article updates or corrections there.
dsdalg @ gmail.com
Last updated: June 1, 2018 2:20 PM