by dataSights | Sep 29, 2023 | Excel
In this tutorial, we’ll walk you through the process of connecting Microsoft Excel to your Microsoft Azure Cloud Database, a vital step in streamlining your data management tasks. Whether you’re using Windows or Mac, we’ve got you covered. ...
by dataSights | Sep 21, 2023 | Excel
Are you tired of your Excel spreadsheets slowing down over time, especially when dealing with linked workbooks, multiple sheets, and complex calculations? In this video, Kev from dataSights shares a clever Excel trick to enhance your spreadsheet performance and make...
by dataSights | Sep 21, 2023 | Excel, Xero
Are you tired of spending countless hours manually entering data into your Xero accounting software? Do you wish there was an easier way to consolidate your financial information? Well, you’re in luck! In this comprehensive guide, Kev from DataSights...
by dataSights | Oct 27, 2021 | DEAR Inventory, Dear Process Automation, Excel, Excel Add Inc, Process Automation
Purchase Order creation is without a doubt a fundamental part of any inventory based business. Without raw materials to manufacture and/or without goods to sell, well, what are we doing here exactly? So now that we have relatively easily established PO’s are an...
by dataSights | Feb 18, 2020 | Excel, PowerBI, Xero
When it comes to effective #Xero consolidation that an SME will actually use, there are four rules; don’t force a particular tool on the SME’s various functions, let them use what they want automate the data into all the SME’s reporting tools via a single...