Create Excel Dashboard

$10-30 AUD

In Progress

Posted

about 8 years ago

$10-30 AUD

Paid on delivery

Need to code up a dashboard spreadsheet mainly layout work to help show hide sections of a spreadsheet from a dynamic data source of names / teams / region (names and teams change so this will need to adjust to any monthly changes). use a button to expand a section to break down to individual level from team level then be able to minimize back to region level. no data importation required i'll be adding this later on. Need to keep the 'PEX source' sheet as it is, I will be using this sheet to upload from another source file for team name / structure changes. Also if most of the referencing can be done and labelled on a REFDATA sheet to make future changes. This needs to also work with the check boxes that display certain categories based on the check box selected.

Data Processing

Excel

Visual Basic

Project ID: 9452514

About the project

5 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

5 freelancers are bidding on average $38 AUD for this job

@jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay

$50 AUD in 2 days

5.0

(271 reviews)

7.3

@kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

$34 AUD in 1 day