If you are given files or receive attachments that were created in Office applications you do not have, you can still open many of them. Microsoft Office provides a range of free Viewer applications that you can download. These include Word Viewer, Excel Viewer, Visio Viewer, Access Viewer and PowerPoint Viewer. Simply download and install the appropriate viewer to open your file.
Archive for the ‘Business Software’ Category
Open important email attachments with Microsoft Viewers
Sunday, April 18th, 2010Systems Upgrade - Issue Tracking System
Sunday, January 10th, 2010As part of plans for the new year at Logicia we are looking to implement an issue tracking system to help more effectively and efficiently manage the development, maintenance and support requests received.
Analysis of the requirements provided a list of features to search for in suitable solutions that would help the team better deal with requests and ensure its integration with the existing suite of systems and tools used.
Early in our analysis we realised that bug tracking tools such as bugzilla, trac and mantis were not suited to our needs. Instead the two issue tracking systems short-listed to be evaluated are OTRS and Request Tracker (RT). These systems will be further investigated and trialed in the coming weeks and findings in our specific application will be reported here.
Microsoft Office - Unleash The Power of Macros
Friday, January 8th, 2010As part of our event management suite of web applications the site admin panel provides download-able lists of event delegates. This can then be used to export the data collected within the website to other systems in the office.
When we visited a client that was using the event management platform we found that although they were using the exported data, this had led to a very time-consuming, repetitive process to regularly copy updated delegate data into their office database system.
The client was copying the data into an Excel spreadsheet, and knowing about Office macros we knew it would be possible to create a macro within Excel to automate the work they were currently spending a lot of time doing manually.
By writing a Visual Basic for Applications (VBA) macro it was possible to not only save them a lot of time (and save someone in the office from a very tedious task!) but also it eliminated the possibility of human-error and any possible typos with it. As the macro runs within a matter of seconds the client can also take more regular exports from the website and synchronise office data more reguarly.
Microsoft Office macros are versatile enough to provide a solution to many of the repetitive and time-consuming tasks that arise when dealing with data in documents, spreadsheets and databases. If you have any processes within the office that are repeated and time-consuming contact Logicia and we can look at them and suggest a more efficient alternative.
List Invoices Report In QuickBooks
Tuesday, January 5th, 2010As many business owners in the UK must be at the moment, a client this week has been busy preparing their accounts in light of the upcoming self-assessment deadline.
Quickbooks offers a wide range of reports, but one that appeared to be missing was a list of all invoices, ordered by invoice number. After a little research we found a way to produce this report, although it isn’t very intuitive.
Generate a ‘Missing Cheques Report’ - Reports > Banking > Missing Cheques.
Now, select ‘Accounts Receivable’ as the account. This generates an ordered listing of invoices.
To make this report easily accessible in the future, we changed the title of the report to ‘Invoice Listing’ (by clicking on ‘Modify Report…’) and then saved the report using ‘Memorise…’
More ‘My Recent Documents’ In Windows XP
Saturday, January 2nd, 2010PLEASE NOTE: The following tip involves making changes to the computer’s registry. You should always make a backup of your registry before making any changes to it and should seek expert assistance if you are unsure of how to modify your registry.
Although the ‘My Recent Documents’ feature of the taskbar in Windows is really useful, when working with a lot of files, or if I want to open a file from a few days ago, the file can have disappeared from the list. After a little googling I found this handy tip that lets you increase the size of the recent documents list from the standard size of 15 items!
Simply visit this link - http://www.kellys-korner-xp.com/xp_tweaks.htm and look for ‘Change the Number of Recent Documents to 25′. The link provides the registry change required.