Services

MICROSOFT EXCEL

Development of customised spreadsheets, workbooks, templates and VBA macros.

Dynamic tables and arrays
Formulas and functions
Pivot tables, reports and charts
Data import, transformation, analysis and data models using Power Query
Conditional formatting and data validation
Content controls (i.e. drop down list, date picker, options buttons) for easy data entry and improved accuracy
VBA user forms and macros

microsoft word

Design, create or reformat customised user defined Word documents and templates for brand consistency, improve accuracy, increased efficiency, professional image and automation of repetitive tasks.

Insertion of headers, footers, styles, table of contents, hyperlink and bookmarks
Insert content controls (i.e. drop down list, date picker, options buttons) for easy selection and improved accuracy
Setup Mail merge documents and labels
Setup building blocks/quick parts for quick insertion of repetitive text
Electronic Word forms with tables and images which can be easily converted to PDF.
VBA user forms and macros to automate workflows

web and mobile forms

Go paperless with electronic forms to standardize processes, increase productivity and streamline workflows. Also great for legally binding contracts with signatures, inspection reports with ability to upload photos and obtain GPS location information, application forms, customer surveys, stored securely in the cloud. Submission can be emailed as PDF files and data collected will be stored securely in tables.

Collect responses using a mobile device or desktop computer
Responses are collected in real time and evaluated using built in analytics.
Forms can be completed by clicking on link, using a mobile app or scanning a QR code.

Data analysis

Import data from various sources, clean, transform and display as per business requirements using Microsoft Power Query in Excel, Power Pivot and Power BI tools. Data is analysed and presented in a user friendly way with graphs and charts.

VIRTUAL COLLABATION TOOLS

Explore the potential of Microsoft 365 virtual collaboration tools.

Microsoft Teams
Microsoft SharePoint
Microsoft Yammer
Microsoft OneDrive

VBA mACROS AND Office Scripts

Automate repetitive tasks to customise Microsoft applications to meet the specific needs of your business requirements. With a click of the button you can perform multiple actions such as insert header/footer details, find and replace specific text strings, save file with name to specified directory, export to PDF and send document as email attachement.

Develop user-defined functions
Automate computer processes
Enter data using VBA user forms
Message boxes
Incorporate combo boxes, list boxes, date pickers, option buttons, check boxes and command buttons in documents and spreadsheets.

contact me…