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 is an Excel support specialist with over 30 years experience helping businesses with their data management and reporting needs. Creating charts, reports, dashboards, data entry, data management and numerous solutions to support business and personal requirements.

Join our mailing list and receive advanced excel tips and tricks that are published from time to time.

© 2025 Ron Schellings. 
bottom of page