Most businesses these days use Microsoft Excel Spreadsheets in one fashion or another. Given there are a variety of uses for spreadsheets to read, review and manipulate your data, it is hard to see how using this tool could limit your business.
Read More >
Sometimes one doesn't have to exit an Excel spreadsheet to get the necessary data. All Sage 300 (formerly Accpac) tables can be accessed and analysed directly from within Excel. Yes, yes - Excel! I'm talking here about MS Query that can be called upon from the Data menu of Excel. Provided you know the ODBC connections to your company's data and credentials to access it you're good to go and query the data you need, all fields of any table, with the availability of selections and filters. Of course knowing SQL language can be handy and can save hours of work, as in the below example.
Read More >