Logo
Helpful Resources
  • Close

Request a Consultation

Supercharge Your Superannuation & Maximise Your Retirement Savings

Welcome back everyone. In the sixth and final part of my blog series, I want to discuss something that affects all of our financial journeys: Superannuation. Perhaps you’re concerned about your retirement savings? Or maybe uncertain about how to make the most .....

Business - 5 min read

Super Short - Super Fast - Super Effective 

1) CTRL+A                                                                

One click and it will highlight the whole table/info on the page (very handy)

2) CTRL+F                                                              

To search

3) SUMIF                                                                 

Very handy when you need a summary by categories/names

4) TRIM                                                                    

to remove any extra spaces within the name for example

5) Text to Columns function                            

in case when you need to separate the text to separate columns

6) Home>Paste>Transpose                             

This function will transpose your data to get a better display

7) & Function                                                          

Combine several columns to one

8) VLOOKUP and HLOOKUP functions!

Using VLOOKUP is similar to looking up a person's name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.

9) Conditional Formatting

(CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100.

10) Insert a Table                                                    

On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data. On the Insert tab, in the Tables group, click Table.  If the selected range contains data that you want to display as table headers, select the My table has headers check box.

New Call-to-action

Could Your Business Benefit from an Outsourced CFO?

Set your business on the right path with this simple guide.

Could Your Business Benefit From an Outsources CFO_Resources

Prospective Business Owner - Succession Checklist

Make sure you’re on the right track with this online checklist.

Business Owner - Succession Checklist_Resources
Have a question for Altus Team?

Connect with the author of this post and they'll get back to you.

close (1)