Great news for Xero users who bank with ANZ Royal - now you can extract transaction lists, and more, directly from the bank within Xero. No more manual data entry or importing Excel workbooks!
Check out Xero today or ask Joe from Xlconsulting to explain why you should use Xero for your accounting needs.

Team work is an important part of any organisation. 2017 was a big year for technology tools which improve collaborative team work. Industry players like Slack, HipChat, Facebook Workplace and Microsoft Teams have continued to improve their offerings and get more companies on board; to see the added value these types of chat tools can provide small and large teams.
​Your organisation can try out these tools, often for free. Office 365 subscribers already have Microsoft Teams included in their subscription, making it the obvious choice for them. Slack, HipChat and Facebook all have free offerings with some limitations and you can sign up and get chatting today for free.
​You can try a demo of Microsoft Teams by click this link, or ask Xlconsulting for a free demonstration today.

Here is a wonderful summary of all the changes to Office 365 during 2017, and some predictions for 2018. Enjoy!
​"Office 365 Year in Review 2017"

Xlconsulting is now an official Google G Suite Partner. We can offer you setup and migration to the subscription version of Gmail. Please contact Craig for further information!

Microsoft offer a series of supervised exams to test the knowledge of users of the Microsoft Office suite. Craig & Joe put their knowledge to the test this week and convincingly passed the Outlook 2016 and Excel 2016 exams respectively!
​Congratulations Craig & Joe!

I recently came across this signature generator web site. You can make professional and good looking signatures for Outlook, Exchange, Office 365, Gmail and more - all for free. You can thank me later!

Free Email Signature Generator
​ ​

You should see David's Outlook calendar. Never a blank space! And here is some of what he has been doing in recent months.

• June – PowerBI consulting: the “marketing for good causes” firm needed to analyse data, so they sent me the documents (multiple excel files with 300,000-600,000 rows of data) and I used PowerBI to link sheets & produce stunning interactive data visualisation reports & glean insights.
• June – Training: a 5 week training program where many participants have transformed the way they do email, note taking, to do lists & other speed up tricks.
• May – I have taught Excel & Word to RUPP students in the “Master of Science in Biodiversity Conservation”
• February – Training presentation skills with PowerPoint where participants learn the secrets that make their presentations into the 5% of presentations that are good.
• creating an interactive dashboard for Impact hub’s annual questionnaire, only because the PowerBI dashboard is interactive can we see that respondents who made 10+ new connections through the Hub are the ones who feel inspired & developed.
• Compliance PowerBI dashboard: this business used to manually create lists (such as which suppliers have an audit soon, or which are top or high priority for each country. PowerBI now does that all for them.
• Teaching: Taught a course on NUM’s international business program
• A well-known UK mid-tier accounting firm worked with David to implement PowerBI for analytics
• Excel and Office Suite training for many students and organisations
• A training course on PowerPoint using the Office 365 exclusive features that have transformed the way modern presentations look (e.g. 3D graphics, movie like transition effects, 1 click for redesign ideas)

​Time to take a break David!

Joe has been slaving over a hot Mac (booting to Windows 10!) developing up some interesting solutions for a number of different clients. This is on top of his QuickBooks work for clients. Some examples are:

• an online solution for student tracking in a ‘technical and vocational education and training’ programme.  We created an online database tracking students/trainers & enterprises from pre-sign up through to post training support.
  
• Building web data collection forms using Office 365 Power Apps to keep track of all open interventions & target tracking within a program project
  
• helping with Xero sales tax and depreciation set up & reconciliations
  
• Creating VBA code to convert data into correct format with data validation to help reduce time and errors when uploading the data into an accounting system
  
• Creating a logistics template spreadsheet with advanced formulas/tables/lists/validation and a more visual output to help reduce time and errors when creating a quote.
  
• re-working a “Supply chain” spreadsheet to better keep track of what stage the order is at whilst reducing the human error involved with data input and reducing input time.

Please contact Joe today and ask him if he can assist you with your data management needs.