EasyPC Training

Xero Product Release Updates Feb 2020

Xero Global Release Update: February 2020 | Xero Blog It's that time of the month again – check out the latest updates for small businesses and partners in this month's product release.

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

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.

Friday Funny...

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.

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.

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.

Friday Funny...

Have a great weekend folks!

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.