AusManagement Logo
Skip Navigation Links
About UsExpand About Us
MYOB trainingExpand MYOB training
Reckon trainingExpand Reckon training
Xero trainingExpand Xero training
QuickBooks Online Expand QuickBooks Online
Bookkeeping Expand Bookkeeping
Cashflow & BudgetsExpand Cashflow & Budgets
Online LearningExpand Online Learning
Microsoft trainingExpand Microsoft training
ConnectionsExpand Connections
Choosing a ProductExpand Choosing a Product
News and BlogExpand News and Blog
HelpdeskExpand Helpdesk

courses Skip Navigation Links

webinars Skip Navigation Links
Office WebinarsExpand Office Webinars
Reckon WebinarsExpand Reckon Webinars
Calxa WebinarsExpand Calxa Webinars
MYOB WebinarsExpand MYOB Webinars
QBO WebinarsExpand QBO Webinars

products Skip Navigation Links
MYOB ProductsExpand MYOB Products
ManualsExpand Manuals

Excel tips to make you look good!
Try one of these three handy Excel features:
1. Paste Special with Formulas
Let's say you have a large amount of numbers in decimal format that you want to show as percentages.
The problem is that number 1 should not be 100%, however that is what Excel gives to you if you click on the % Style button.
You want that 1 to be 1%, so you have to divide it by 100... this is where Paste Special is handy!
Type 100 in a cell and copy it, then select all the numbers you want to reformat.
Then select Paste Special and click the 'Divide' button and hooray, you have numbers converted to percentages!

Paste Special with Formulas

2. Hide a whole sheet
Often when working in Excel, you can get loaded with lots of worksheets. Hide a sheet can be useful rather than deleting it, especially when using the data contained on that sheet. Simply right click on the bottom sheet tab and select Hide.
When you need to find it again, go back to the View Tab at the top and select Unhide, selecting the sheet name from the list appearing.

Hide A Whole Sheet

3. Conditional formatting
When working with lots of data and wondering where the key areas are eg ratings, lowest/highest etc, Conditional formatting can do a range of options including colour coding a table, to putting a border around, or build a graph to give better visuals!

Conditionally Format

Learn more handy tips on our Excel courses - save time when you know how to make better use of software!

2019 Australian Management Control ABN: 65 066 670 353