Category Archive: Microsoft

Word – Templates, Styles and VBA Macros

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 …

Continue reading »

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, …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

Database Training – Microsoft Access 2010, 2013 and 2016

Among the top­ics that I cover in my Microsoft Access 2010 / Access 2013 / Access 2016 training are the following: Rela­tional Databases Nor­m­al­ised Tables Tables Quer­ies Forms and sub forms Reports and sub reports Mac­ros VBA Pro­gram­ming for Access Secur­ity Net­work­ing Front End and Back End Data Recover Data from cor­rupt Access Databases JAWS com­pat­ible data­bases for …

Continue reading »

Page 1 of 212