# Excel Roundup 20160222

In this week's roundup, Slicer trick, pivot charts, slow workbooks, dashboards, and more.

#### 1. Split Date and Time

Instead of using a complicated date formula, here are a couple of quick ways to split a combined date and time into two separate columns. One method uses a simple formula, and the other method just needs a bit of typing.

#### 2. Excel Slicer Trick

On the Excel Campus blog, Jon Acampora shows a handy trick for creating a search box to use with a Slicer. This will make it much easier to find things, if the Slicer has a long list of items.

And remember, registration closes this Thursday (Feb 25th) for Jon's VBA Pro Course.

#### 3. Working With Charts

It reasonably easy to make a combination chart in Excel, to show some series in columns, and other series as lines. It's not as easy to make a Bar-Line combination chart though, so Jon Peltier guides you through the steps.

You won't be able to do that with a pivot chart though, because the "line" series is really a Scatter (X,Y) chart type, and those aren't allowed. Jon also wrote everything you ever wanted to know about pivot charts last week, and he mentioned Contextures, so it must be a good article! There are a few pivot chart articles on my Pivot Table blog too.

#### 4. Hero Weir-Ship

The always enthusiastic Jeff Weir is finally going to meet some of his Excel heroes – he's registered for the upcoming Excel Summit South. I agree, it should be a great event, and a bit too far away for me. What do you think, after reading Jeff's article – should those Microsoft guys be very afraid?

#### 5. Slow Workbook

Lots of things can slow down a workbook, and some of those problems are hard to track down. Colin Legg just discovered some rogue INDIRECT formulas in a workbook that were causing calculation to grind to a halt in some cases. Use those Volatile functions wisely! And if you're not sure which ones are volatile, Charles Williams has a list.

#### 6. Excel Dashboards

Excel Dashboard Course: Mynda Treacy recently opened registration for her acclaimed Excel Dashboard course, and the registration deadline is Thursday, Feb. 25th. The course is a great investment, and you can read my review for the highlights, and more information. Get my new dashboard tools as a bonus with purchase -enter coupon code DebraD

Free Dashboard Webinars: Mynda is also offering two free one-hour webinars -- 1) How to Build Excel Dashboards, and 2) Dashboards with Power Query and Power Pivot. Get the details, and sign up for a date and time that is convenient for you.

#### 7. Excel Humour

Finally, for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets. Here's one of my favourite tweets from this week's collection.

#### Get Weekly Excel News By Email

To get Excel news and tips by email, add your name for the Contextures Excel newsletter.

________________

### 3 comments to Excel Roundup 20160222

• I liked Jon's pivot chart post. As I mentioned there, it confirmed my recent impression that they've gotten better over the years since I've last used them. Coincidentally (or not?) my most recent post is about finding the pivot table that a pivot chart is based on: http://yoursumbuddy.com/finding-a-pivotcharts-pivot-table/.

I think they should add Jeff's presence to the Summit publicity - he is one exuberant and entertaining fellow.

• Thanks Doug, and nice job on your article. And you're right -- Jeff should be their poster boy!

• Jeff Weir

Yeah, I'd be a good poster boy. I'm really big down-under. ;-)