EXCEL PROJECTS
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

-
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 strokesUse Drop Down lists and pre-filled in fields | ![]() Analyse data in Charts or Numbers | ![]() Analyse data in Charts or Numbers | ![]() Use Filters to only see data you require |
---|---|---|---|
![]() Arrange Work Functions by Activity | ![]() Front End User FormsNo Need to work in a spread sheet – Easier to work in a User Friendly Form with prompts and error checking | ![]() Performance Reports | ![]() Management Reports - Charts |
![]() Dashboards |