Excel Roundup 20141215

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

Thank you for reading my Excel Roundup every Monday, and after this week, I will be taking a couple of weeks off, to enjoy the holidays. There will be a blog post here this Thursday, and the next roundup will be posted on January 5th.

To help you celebrate, here is a no-macro animated Christmas tree, created in Excel, of course. Just move the scroll bar, to add lights, tinsel, a star, and presents, to the tree. You could use this technique for less festive projects too, like a business dashboard. Read the details on my Contextures website.

 

(adsbygoogle

Continue reading Excel Roundup 20141215

Excel Roundup 20141208

Christmas is only 2-1/2 weeks away, so it's time to start planning! Of course you'll want to organize everything in a spreadsheet, so you can download the free Excel Holiday Planner, from my Contextures website.

It has shopping lists, budget sheets, task lists, and even a dinner planner, so get your copy, and get the holidays under control.

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

Continue reading Excel Roundup 20141208

Contextures Cyber Monday Sale 2014

Happy Cyber Monday! I hope you didn't spend all you money at the Black Friday sales, and have a little left over for today's shopping spree.

To celebrate Cyber Monday, the busiest online shopping day of the year in the USA, you can buy a couple of my Excel products, at 50% off today only. The details, and links to the product pages, are below.

NOTE: Unfortunately, the shopping cart will only discount one item per order -- if you want both items, please order them separately.

Continue reading Contextures Cyber Monday Sale 2014

Excel Roundup 20141201

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

Wow! It's December already – how did that happen? It's Cyber Monday too – a big online shopping day. Did you find any Excel bargains?

To start the countdown to Christmas, Mynda Treacy created an Advent Calendar in Excel. You can download the file, if you'd like a bit of fun while you count the days until Christmas

You'll have to answer a quiz each day, to open the calendar doors. To get a head start, you can start thinking about the answer to the December 5th question, shown in the screen shot below.

Continue reading Excel Roundup 20141201

Contextures Black Friday Sale 2014

Happy Black Friday! If you celebrated Thanksgiving yesterday, I hope you enjoyed time with your friends and family, and are ready to do some shopping today.

To celebrate Black Friday, the busiest shopping day of the year in the USA, you can buy my popular ebook kit – Excel UserForms for Data Entry – at 50% off today. So, instead of the regular price of $30 US, you can get the kit for only $15 US. The price will be reduced automatically – you don't need to enter a coupon code.

The special price ends tonight (Nov. 28, 2014) at

Continue reading Contextures Black Friday Sale 2014

Convert Currency With Different Separators

change currency separators http://www.contextures.com/xlDataEntry03.html#diffsep

Happy Thanksgiving, if you're celebrating today. Tomorrow is Black Friday – the biggest shopping day of the year, in the USA. Up here in Canada, we celebrate the day too, so I'll put one of my Excel products on sale for the day. Remember to check this blog tomorrow, to get the coupon code.

If you're doing your shopping around the world, you might end up with a worksheet filled with amounts in a different currency. For example,

In the USA, a comma is the Thousands separator, and a period is the Decimal separator -- 987,654.32 In Germany, a period

Continue reading Convert Currency With Different Separators

Excel Roundup 20141124

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

In a short video, Sara Silverstein shows 6 keyboard shortcuts for formatting numbers in Excel. Do you use any of these?

You can see the shortcuts in the video below, or on the Business Inside website.

Continue reading Excel Roundup 20141124

Ignore Blank Cells When Pasting

Ignore blank cells when pasting http://blog.contextures.com/

Last week, I was working on a client's file, and we wanted to get any new information from an update file, and paste it into the current record.

Both files were set up with the same columns, but the update file only had a few of the fields filled in. We could have used a macro to loop through the fields, grab any new information, and paste it to the current record. However, that would be a slow way to update the records, especially in a large file.

Fortunately, there is a built-in feature in Excel, that will copy a

Continue reading Ignore Blank Cells When Pasting

Excel Roundup 20141117

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

In this Garage Series episode, Power BI and Excel go to Spain, to expose data patterns in past matches between Real Madrid and FC Barcelona.

"By combining historical El Clásico and player data, outside forces like temperature, humidity and moon phases, Jeremy tries to predict the outcomes and puts these predictions to the test among fans in Barcelona."

They didn't use "good hair" as one of the factors, but they predict 2-1 for Madrid, in the Oct. 25th match. (The final score was 3-1 for Madrid.)

You can watch the video below, or on YouTube: Power BI takes on El

Continue reading Excel Roundup 20141117

Excel Roundup 20141110

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

One Excel annoyance is that after you select a group of cells, you can't unselect one of them. For example, you might want to format specific cells, or create a named range, and you accidentally include a cell that shouldn't be in the group. You can't click on that cell to unselect it – you have to start over, and select more carefully the next time.

To solve that problem, Doug Glancy has created a free tool that you can download -- SelecTracker.

Next, we need a version that lets you unselect one cell within an large area. For example,

Continue reading Excel Roundup 20141110