Group Worksheets in Excel – Time Saving Excel Tip

This blog post looks at grouping the sheets of a workbook, and a couple of reasons why you would want to do that. This awesome little technique can save tons of time and seriously improve your productivity.

Why would you want to group worksheets?

By grouping worksheets you can make the same change to multiple worksheets at the same time. This can be a formatting change, a structural change such as inserting a row, or even a formula. Continue reading

Basic Excel – 7 Buttons You Must Add to your Quick Access Toolbar

In the latest version of Excel it has become your responsibility (if you choose to) to create your own toolbar, and in our basic Excel series we show you how.

The Quick Access Toolbar at the top of your screen begins with just the Save, Undo and Redo buttons. If you require fast access to any other Excel commands you are able to add them yourself. You can add almost any functionality to the toolbar including those not found on the Ribbon.

As part of our basic Excel series, this post explores 7 incredible additions to the toolbar that are sure to improve the way you work.

Continue reading

Basic Excel Skills – Insert a Happy Face using the IF Function

I was asked today if it was possible to write an IF function that could insert a happy face if certain criteria was met. This would be used to show good performance. An unhappy face would be inserted for poor performance.

To insert a happy face in Excel we need to enter a capital J and format the cell in a Wingdings font. For an unhappy face, it’s a capital L formatted in the Wingdings font. Continue reading

Learn Excel Basics – New Baby Checklist Spreadsheet

My wife and I are expecting our first child in just 5 days now. It’s a very exciting time in our household and it has taken a few months to get everything ready for the newborn.

To ensure I have everything I need, I made a checklist (in Excel of course) and worked my way through it.

If you want to learn Excel basics, this spreadsheet features a few fantastic tools that I thought you may be interested in seeing.

Download the new baby checklist.

  1. Check boxes to make it easy for the user to mark of items as they go
  2. Conditional Formatting to cross out the items with a strikethrough when it is checked
  3. A Thermometer Chart to show progress through the list and how close it is to completion (See how to create a thermometer chart in Excel).
  4. The COUNTIF function to count the items as they are checked off

The items in the checklist have come courtesy of www.newparent.com.

Excel Tips 2010 – Where is the Excel 2010 Data Entry Form?

The popular data entry form from Excel 2003 was removed from the Ribbon in Excel 2010. I am often asked where this feature went. So what is this feature and where can it be found? Find out in this Excel tips 2010 guide.

What is the Data Entry Form?

The Excel 2010 data entry form makes it easy to;

  • Add new records to a table
  • Edit and delete records from a table
  • Search for records in the table

The data entry form is very user friendly and is a must for anyone who performs alot of data entry, especially in a large table.

Continue reading