# 10 Excel Paste Special Tricks to Make you a Pro

To be an Excel pro you must be a master of Paste Special.

Copy and paste is one of the most common tasks a computer user performs daily. Paste Special in Excel allows you to specify what elements of the copied item get pasted. It also allows you to perform operations on values and other cool stuff.

This blog post explores 10 Excel Paste Special tricks that an Excel pro needs to know. Continue reading

# 5 Reasons Why your Excel Formula is Not Calculating

When your Excel formulas are not calculating, or not updating, it can be very frustrating. Your formulas are the driving force for your spreadsheet.

There are 5 reasons for your Excel formula not calculating are many. In this tutorial we explain these scenarios.

# 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 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.

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.