EasyPC Training

18/03/2020

Learn how to apply and modify styles to quickly and easily format your document.

17/03/2020

Xero Product Release Updates Feb 2020

It's that time of the month again – check out the latest updates for small businesses and partners in this month's product release.

16/03/2020

Using Sparklines in Microsoft Excel...

Sparklines are used to show trends in data, like a mini chart, either as a line, column or win/loss.

1. Select your data
2. Go to Insert tab
3. Select Line, Column or Win/Loss from the Sparklines group
4. Select which cell(s) you want to display the sparkline

15/03/2020

Shortcut of the Week...

Microsoft Windows

Windows key + Left arrow or right arrow key.

Snaps a Window to the Left or Right half of the screen.

12/03/2020

Friday Funny...

11/03/2020

Learn how to apply condtional formatting to highlight specific data on your worksheet, based on logical rules.

10/03/2020

Uploading and Attaching Files in Xero

Did you know that you have a dedicated email address in your Xero software to upload files to?

1. Click on your Company name (top left corner)
2. Select 'Files'
You will see the email address in the top right corner. Save that as a contact in your Outlook / phone contacts or photocopier machine and quickly send files to Xero.

You can also take pictures on your phone and share to Xero Files if you install the Xero Accounting app on your phone first. Easy!

Once you have uploaded the files, you can save them into custom folders or attach them to your transactions including: spend money, receive money, invoices and bills.

09/03/2020

Have you see the new 3D-Models in Microsoft Office?
(Excel, Word, PowerPoint and Outlook)

Very cool 3D models, allowing you to see objects from all angles! Found on the Insert tab on the ribbon.

08/03/2020

Shortcut of the week...

Microsoft Excel

Alt + ;

Selects only the cells that are currently visible.

If you have hidden rows or columns, applied filters/subtotals etc, this shortcut will only select what you see.
1. Select the cells / worksheet that you want to copy
2. Use Alt + ; then copy the data
3. Paste the data in another cell/worksheet
It will NOT paste the hidden data.

05/03/2020

Friday Funny...

Have a great weekend folks!

04/03/2020

Learn how to sort your data alphabetically and by cell colour

03/03/2020

Automated Invoice Reminders in Xero

Set automated invoice reminders to get that cash in quicker...

Organisation Settings > Invoice Settings > Invoice Reminders

You can set a number of reminders to go out a specified number of days before or after an invoice due date.