I have setup numerous Word systems for clients including: Full automatic implementation of house style guide Multiple Word Templates Full Word Menu Customisation VBA / Macro driven routines and menus Forms to collect and automatically populate Word templates Automation of bookmarks, signatories and attachments VBA Macro driven printing routines Customised Ribbons Implemented Shortcut keys Attached …
Category Archive: Microsoft
Excel File and Data Processing
I develop routines for organisations that can quickly process your data and files. The raw data can come from: Excel SAP Oracle Other Database Systems The data is then processed to produce the relevant data for your needs. This data can then be used in: Master Excel file Multiple Excel files Exported out to PDF, …
Excel Dashboards
Excel Dashboards Training Excel Dashboards are reports that allow senior management or directors to get high-level overview of the business or organisation. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. You will learn how to explore and analyse your data by creating an …
Excel – Moving to Excel 2013 / Excel 2016
Moving from Excel 2003 to Excel 2016 (or ( Excel 2007, Excel 2010 or Excel 2013 ) can be fraught with difficulty if not done correctly. Where to find menu-to-ribbon reference guides, training, and other useful resources for Excel 2013 / Excel 2016 ? Where to find things you might be looking for, such as …
Database Training – Microsoft Access 2010, 2013 and 2016
Among the topics that I cover in my Microsoft Access 2010 / Access 2013 / Access 2016 training are the following: Relational Databases Normalised Tables Tables Queries Forms and sub forms Reports and sub reports Macros VBA Programming for Access Security Networking Front End and Back End Data Recover Data from corrupt Access Databases JAWS compatible databases for …