- 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.
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:
Seeking to migrate from their unsupported version of Microsoft Exchange 2007, Dynamic Pharma contracted Xlconsulting to move their 170+ users from their on-premises email server to Microsoft Exchange Online. This was successfully achieved over two weekends (one weekend per company) with zero data loss and minimal impact on the general staff. Xlconsulting assisted the Dynamic Pharma IT staff during and after the migration to ensure a smooth on boarding process with minimal inconvenience. The two companies also purchased licenced copies of Office 365 Business for the staff, the always up-to-date feature enhanced version of Office 2016.
Xlconsulting welcomes Dynamic Pharma, and sister organisation Agrotech Vita, to Office 365 and all its benefits!
In late 2015 — to much fanfare — Microsoft released the latest version of their productivity suite: Office 2016. Most of us were not compelled to rush into a relationship with this new platform; we were content and comfortable with our current setup, and didn’t feel the need to shake things up. You know, the old “if it ain’t broke, don’t fix it” approach. And now, one and a half years later? Is it finally time for all of us to suck it up and make the switch?
Reason #1 — It’s the new standard
Reason #2 — Older versions won’t last much longer
Reason #3 — Our businesses need to gravitate toward collaboration
Read the full article here.
Microsoft recently conducted a productivity survey and the results are interesting and informative. And(!) they created a really impressive interactive results survey using their own PowerBI tool. Read the article and the click on the PowerBI chart on the Microsoft web site today!
10 Things You Never Knew About Copy & Paste. That's the title of David's new blog post on the Think Productive web site - the people behind the Productivity Ninja books.
Tip 1: The Format Painter isn’t just for text
MS Office’s “Format Painter” is essentially copying & pasting formats only. It is handy not only with text, but also if you want to replicate the formats numbers, shapes & pictures.
You can read the other 9 tips on the Think Productive web site today.
Microsoft launched Office 365 in Cambodia today! From their blog announcement:
"Today, we are announcing the availability of Office 365 in 10 new markets: Bhutan, Cambodia, Greenland, Guadeloupe, Laos, Maldives, Martinique, Mozambique, Myanmar and Vatican City. With this launch, Office 365 is now available in 150 markets and 44 languages.
More than 1.2 billion people around the world use Office—at school, at work and in their personal lives. As our service expands, we are mindful of the incredible and increasing diversity of Office users. This latest market expansion required innovative engineering work to create new languages, cultures and currencies.
Our team works tirelessly to meet the highest levels of security, compliance and feature parity so that we can deliver the same first-class experience in Office 365 to every market where it’s offered. We plan to launch a further 97 markets over the next year. Stay tuned for more updates.
—Tom Batcheler, @TomBatcheler, senior product marketing manager for the Office 365 team"
Contact Xlconsulting for all your Office 365 needs!
David Benaim, Xlconsultings founder, was recently interviewed by B2B Cambodia about boosting efficiency in the workplace.
Here is question 1:
B2B: What are some of the very practical and simple ways in which your everyday office worker can boost his/ her productivity with Microsoft Office?
Benaim: In general, we should try to think of ways to Do Once, Reuse Often (DORO). This is the basis of copy & paste, a tool which we all love to use, there are, however, several tools just as useful as copy & paste which go unused. Here are some examples across MS Office:
Read the remainder of the interview here.
We have a new staff member! Please say hello to Joe the next time you see him! He will be helping us implement solutions around accounting, stock management, POS, Excel, Access and anything else we find for him to learn or do!
Car 4 You and their sister company Danfil Carz recently migrated from their IMAP based email system to Office 365. Kjeld Olsen, business owner, is a committed Apple Mac user. He was able to easily download and install the latest Office 2016 on his MacBook Pro and connect to Microsoft Exchange Online servers without any technical knowledge beyond his email address and password. Xlconsulting handled the initial setup of migrating the various inboxes to Office 365 and Kjeld did the rest; a testament to the new Office 365 Administrators console and its ease of use. The other company staff use Microsoft Windows and the computers existing Office 2013 installations connected with Office 365 without difficulty. Kjeld and his staff are now enjoying reliable and malware free email along with shared calendars and shared file storage. Xlconsulting recorded videos to help staff learn different aspects of the Office 365 product. Thanks to Car 4 You for joining the Office 365 racing team!