Excel Weekly News from Contextures July 29, 2014

Set minimum row height + more Excel tips

During the summer, I am sending you the newsletter twice each month, instead of weekly. You will get the next newsletter on August 12th. In this week's Excel news, you'll see how to set a minimum row height in a table, and other tips. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.

 -  Debra -  ddalgleish@contextures.com

Excel Dashboard Course

What would you like to learn this summer, so you're ready to tackle exciting new projects this fall? If you'd like to improve your dashboard skills, Mynda Treacy from My Online training Hub is re-opening her popular Excel Dashboard Course, and registration closes on July 31st.

I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.

Bonus: If you sign up for Mynda's course through one of my links, type DebraD in the Referral code box, just below the Buy Now button. Then, let me know, and you can have a copy of one of my Contextures products, such as the PivotPower Premium add-in.

Set Minimum Row Height

A long table can be hard to read, if all the rows are tightly packed together. To add a little white space, you can use the REPT function, and set a minimum row height. I've also used this trick in a table with pictures, to make sure all the rows are the same height. That way, I can sort the table, without having all the pictures end up in a pile!

Click here to see the details, and watch the video: Set Minimum Row Height

Pivot Table Tips

I post tutorials on my Pivot Table blog every week, so you're familiar with those articles, if you've been reading this newsletter. There are lots of tutorials on my Contextures website too, and I've added a pivot table index so you can see what's available.

There is also a Frequently Asked Questions page that I'm updating, and a list of popular pivot table articles on my site -- you might learn some new tricks in those..

Click here to read the details: Pivot Table Tips

FastExcel to Speed Up Calculations

FastExcel is a product that can pinpoint calculation bottlenecks in your Excel files, and help you remove them, or speed them up. I'd seen other people use it, and finally got a copy to try on my own files. It's a complex and powerful tool, and a bit daunting at first! You can read my review, to see my first impressions of the tool. I made a short video to show the key features.

It's certainly not for everyone, but if you are working with big, slow Excel files, it's worth taking a look. The FastExcel bundle is 50% off for the next couple of days (until July 31st), if you use the code FXLV3Intro

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

Video: 3 Types of Drop Down Lists

You're probably familiar with making a drop down list in a cell, by using data validation. That has some limitations though, and this video shows a couple of other types of drop down lists that you can create, using combo boxes.

At the Dentist

I took my 7-year-old grandson to the dentist this month, for a checkup and teeth cleaning. When we got home, he drew this picture in his journal, to describe the visit. It looks a little scary to me, and that dentist certainly has long arms!

__________________________

Recommended Excel Tools

In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

__

 

Privacy Policy

 

Contextures Inc., Copyright 2017
All rights reserved.