top of page
EXCEL PROJECTS​

Data, Data Validity, Access and Reporting

Excel Support Specialist provides Data, Data Validity, Access and Reporting

  • Your Business relies on Data.

  • The Challenge comes in Data Validity, Data Access and Data Presentation.

  • We use advanced Excel tools and functionality to assist you such as

    • Dynamic Ranges (auto expand/contract)

    • Data Validation

    • Menu Driven Functions

    • Charts,

    • Pivot Tables

    • Reports

Spreadsheets

  • Simple Formula to very Complex formula

  • Single worksheets OR Linked worksheets​

  • Large Data Volumes

  • Latest Excel enhancements (UNIQUE, SSORT)

Data Validation

  • Drop Down lists

  • User Forms

  • Behind the scene validation

  • Dynamic Data Validation Expansion - Dynamic Range Names

Data Display/Reports

  • Menu Driven

  • Charts

  • Dashboards

  • Pivot Tables. Power Pivots

  • Grouped Data,

  • VBA Macro

INTERFACE TO:

​​​

Outlook, Word, Internet, PowerPoint, MYOB

Interface to Word, Outlook, Internet, Powerpoint etc

  • Retrieving Data and using your Data in the appropriate Tools may be important and can SAVE you time and errors
     

  • Interacting with other software tools can be Automated  through simple Menu Driven Systems

Retrieve Data From the Internet

  • Extract data from Internet directly into spreadsheet

Distribute Data

  • Outlook, PowerPoint, MYOB

  • Generate and send Emails directly from Excel -- with attachments or notifications

  • If required, Use Menu Driven solutions to validate email or control your selection before sending email(s)

  • Use Tab driven User Forms to simplify the use

  • Create Transactions to Update MYOB

Data Display/Reports

  • Menu Driven

  • Charts

  • Dashboards

  • Pivot Tables. Power Pivots

  • Grouped Data,

  • VBA Macro

EXCEL PROJECTS GALLERY

​

​​

Industries worked in, amongst others are:​

Building

Brewery

Curtains

Education

Financial institutions

Futures and Forex Trading

Local Government​

Local Clubs

Manufacturing

Mining (Coal, Oil)

Motor Vehicle

Restaurant

Rental

Racing (Horse, Greyhounds, Harness)

Travel

Minimise errors and key strokes

Minimise errors and key strokes

Use Drop Down lists and pre-filled in fields

Analyse data in Charts or Numbers

Analyse data in Charts or Numbers

Analyse data in Charts or Numbers

Analyse data in Charts or Numbers

Use Filters to only see data you require

Use Filters to only see data you require

Arrange Work Functions by Activity

Arrange Work Functions by Activity

Front End User Forms

Front End User Forms

No Need to work in a spread sheet – Easier to work in a User Friendly Form with prompts and error checking

Performance Reports

Performance Reports

Management Reports - Charts

Management Reports - Charts

Dashboards

Dashboards

Ron Schellings – Excel Support Specialist
Based in Sydney, Ron Schellings brings over 30 years of Excel/VBA experience helping businesses and individuals manage, analyse, and report on their data effectively.

From dynamic charts and insightful dashboards to streamlined data entry and complex reporting systems, Ron delivers tailored Excel solutions that meet a wide range of business and personal needs.

Stay Ahead with Excel Tips & Tricks
Join our mailing list to receive advanced Excel tips and techniques — shared periodically to help you get the most out of your spreadsheets.

 

© 2000 Ron Schellings. 
bottom of page