Excel Roundup 20150302

Weekly Excel Roundup http://blog.contextures.com/

Spreadsheets are already fun, but Tableau wants to make them even more exciting, with its newest smartphone app, Elastic. In this video, Tableau's VP of Mobile & Strategic Growth, Dave Story, opens a spreadsheet file (csv format) from his inbox, and shows how Elastic works.

I don't see any information about the expected release date or pricing.

(adsbygoogle = window.adsbygoogle || []).push({});

Continue reading Excel Roundup 20150302

Excel Roundup 20150223

Weekly Excel Roundup http://blog.contextures.com/

The cover slide in this presentation, with its 3-D column and pie charts, led me to believe that the content wouldn't be too useful. However, a different person must have prepared the remaining slides, because they have some useful tips.

The last slide shows that the content is from Mike Alexander's book, Excel Dashboards & Reports for Dummies, which was published last year.

(adsbygoogle = window.adsbygoogle || []).push({});

Continue reading Excel Roundup 20150223

Excel Roundup 20150216

Weekly Excel Roundup http://blog.contextures.com/

In this video, Bill Jelen (Mr. Excel) and Mike Girvin (ExcelIsFun) show two different ways to insert an apostrophe at the start of a long column of numbers.

There is an interesting bit of history, starting at the 1:00 mark – Bill shows how that apostrophe, and other characters, affected cell entries in old versions of Lotus 1-2-3.

Continue reading Excel Roundup 20150216

Excel Roundup 20150209

Weekly Excel Roundup http://blog.contextures.com/

Microsoft announced that Office for Windows 10 Preview is now available for download, and they're working on Office 2016

You see the preview in this video, and the Excel demo starts around the 1:00 mark.

Continue reading Excel Roundup 20150209

Save Space With Compact Worksheet Buttons

Last week, AlexJ sent me a tip for making better worksheet buttons, and I'll be using it from now on, instead of my old method. I'll show you both button types, and maybe you'll switch too.

Big Bold Buttons

If I'm making a workbook with several sheets, I usually add a menu sheet at the front, with buttons that link to the other sheets. In the screen shot below, you can see a typical menu, with buttons for two of the worksheets. Each button has a hyperlink to cell A1 on the named sheet.

The buttons are wide enough to

Continue reading Save Space With Compact Worksheet Buttons

Excel Roundup 20150202

Weekly Excel Roundup http://blog.contextures.com/

Happy Groundhog Day! Please feel free to read this roundup over and over again.

Poynter posted a couple of videos from the early days of Lotus 1-2-3, which was released 32 years ago, on Jan. 26, 1983. In this video, you can see how exciting a workday becomes, when new spreadsheet software is installed. Does Excel ever make you feel like dancing?

Continue reading Excel Roundup 20150202

Excel Roundup 20150126

Weekly Excel Roundup http://blog.contextures.com/

Here is a short video, by Dennis Taylor from Lynda.com, that shows some keyboard shortcuts for formatting on a worksheet. For example:

Ctrl + Shift + - (hyphen) to remove borders in selected cells Ctrl +5 to change text to Strikethrough

He also shows how to use the ISFORMULA function, new in Excel 2013, with conditional formatting, to dynamically highlight cells that contain formulas. You can get written instructions for that technique on my website.

Continue reading Excel Roundup 20150126

Excel Roundup 20150119

Weekly Excel Roundup http://blog.contextures.com/

In this tutorial, from the Lynda.com website, you can learn 5 helpful Excel keyboard shortcuts, for tasks such as toggling the Ribbon on and off, and showing a print preview.

I use the mouse, and buttons on the QAT, for most of these commands, but if you're a keyboard person, you might like a couple of these shortcuts. Or did you know all of them already?

Contextures Posts

Here’s what I posted recently:

You can delete worksheet rows based on a specific Conditional Formatting color Give your Excel Pivot Table a makeover so the data is easier to read

Continue reading Excel Roundup 20150119

Delete Rows With Conditional Formatting Color

Delete rows based on Conditional Formatting color http://blog.contextures.com/

If you've highlighted cells with conditional formatting, what's a quick way to delete the rows those cells are in?

Someone asked that question on one of my old blog posts last week. That article showed how to use the Find command, to get a list of cells that contain a specific word. Then, delete the rows for those cells.

It's a handy trick, but won't work to select cells that are colored with conditional formatting.

Continue reading Delete Rows With Conditional Formatting Color

Excel Roundup 20150112

Weekly Excel Roundup http://blog.contextures.com/

Doug Glancy used Excel's camera tool, and some VBA, to create a mesmerizing "selfie" of a range which has conditional formatting applied. Doug describes the results:

Kind of like when you’re in a dressing room with the mirrors front and back and you get a reflection of a reflection of a reflection … Unless you’re like me and you just keep buying the same pants online.

I downloaded the sample file, and changed the colours, to match my Contextures logo. I'm not sure if this has too many practical applications, but perhaps you can use it to hypnotize your boss,

Continue reading Excel Roundup 20150112