Home » Excel Essential Skills » Page 2

# Category: Excel Essential Skills

The Excel Essential Skills category groups together posts that cover the essential skills needed to confidently create Excel worksheets that are both professional in look and design.

# Understanding the Excel screen components

When you first start using Excel the screen can be a little overwhelming.

Once you have an understanding of each of the components you can quickly locate and use them with confidence.

# Selecting cells and moving around an Excel worksheet

If you are new to Excel, before you start entering data it’s a good idea to become familiar with how to select cells using the keyboard and the mouse. Read more

# How to calculate GST at 15% using Excel formulas

I have been asked twice in one week to please explain how to calculate GST at 15% using Excel formulas.

You can find information on how to calculate GST  (Goods and Services Tax) on the NZ Inland Revenue website. I’ve taken this a step further and put together a tutorial on how to put these calculations into Excel formulas.

# Excel – 5 Paste tips that will save you HEAPS of time

Ever wondered what the most used command is in Excel?

I have. In fact a few years back I searched for the answer on Google.  I had thought that the answer would surely be ‘Undo’, especially when I think about how often I use the fabulous Ctrl + Z key combination. Amazingly I found a page (which sadly I’m unable to find now) that claimed that Undo wasn’t the most used…it was Paste, Ctrl + V. Read more

# Excel – Why is my figure displayed as a date?

PROBLEM: when typing a figure into a cell in Excel the figure is displayed as a date?

SOLUTION: quickly change the format of the cell back to a format that displays numbers, not dates. Read more

# Excel – The relative to absolute shortcut key

PROBLEM: wasting time manually changing cell references in Excel from relative (e.g. A3) to absolute (e.g. \$A\$3).

SOLUTION: learn the relative to absolute shortcut key!

# Excel – Why does the 0 (zero) disappear?

PROBLEM: why does the 0 (zero) disappear in Excel? How do I stop the 0 from disappearing?

SOLUTION: learn how to format cells so that 0 (zeros) are displayed.

# Excel – Find the Average, Count and Sum of a range without having to write a formula

PROBLEM: wasting time writing formulas to find the Average, Count and Sum of a range.

SOLUTION: learn how in Excel you can quickly calculate the Average, Count and Sum of a range without having to write a formula.

# Excel – Control key shortcut tips to save you time

PROBLEM: Using the mouse to perform repetitive tasks can really slow you down.

SOLUTION: Learn this group of CTRL key combination shortcuts and start saving yourself a heap of time.