Find Jobs
Hire Freelancers

Excel Expert

$30-250 AUD

Closed
Posted over 5 years ago

$30-250 AUD

Paid on delivery
Activity 3: Workbooks and templates For this activity you will need to complete the following tasks (a) to (d). For the consistency of design and layout you must: • Ensure Columns are wide enough to display data properly and are evenly spaced. • Include a header containing the file name of the workbook. • Today’s date and a Branch name area must appear on the worksheet. (The branch name will be filled in when the template is used.) • Format the spreadsheet so it is clear and easy to read. Use Calibri font in keeping with the organisation’s house style. Format currency columns to two decimal places. • All headings are to be bold Task (a) Branch Template Based on the data above, you will need to create a template file to structure the style, format and in-built formulas needed for Breeze Appliances sales calculations. From this template, you will later be able to record and calculate the sales data for each branch, shown in the tables above. (The data for each branch must be recorded in a separate workbook as instructed in task b.) • Spend some time planning and designing your template and make notes about the style and planning of the template. • You will need to submit your notes as part of this activity to demonstrate how you: o evaluate the task, o determine methods to improve efficiency and o apply your knowledge of functions and features of the computer applications you are using To complete the task, you will need complete the following steps: • Import the text file called Commission [login to view URL] into a new workbook. Name the worksheet Commission Rates. • Create a named range for the commission rates data. The Commission Rates data is used to look up the % commission each sales person will receive. This percentage will then be used to calculate the commission for each month, based on monthly sales. • Insert a new sheet before the Commission Rates worksheet. Name the new sheet Sales. • On the Sales worksheet, calculate the commission each sales person will receive each month. • Each month if a sales person equals or exceeds a 12% commission target, they receive an additional bonus of $1,250. Insert a column for each month to determine if the sales person will receive the bonus. (This can be achieved by combining an IF and a VLOOKUP statement.) The commission target and the amount of bonus on offer will vary every quarter. Ensure that this is considered when designing the spreadsheet by positioning the bonus amount and the % commission target in separate cells at the top of the worksheet data. You will need to think of using absolute referencing in your formula as well. • Calculate the total sales for each month. • Save the workbook file as a template with an appropriate file name in the correct templates folder. Note that macros are required in the template. • A summary of the sales for each of the three months recorded must appear on the worksheet. This summary must include average, maximum and minimum calculations for each month. All figures must be rounded to the nearest $100. • Check all that formulae work correctly. • Ensure that the workbook template is set up to automate all calculations so the user only needs to enter the sales data for each month. • Ensure users cannot enter data in formula cells by protecting these cells. Please use ‘password’ for your password when protecting the sheet as the marker needs to be able to access the formulae. • Develop a macro that will sort all sales persons into alphabetical order. • Develop a macro that will print only the sales summary information. • Assign these two macros to buttons at the top of the worksheet.
Project ID: 17571891

About the project

28 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

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
28 freelancers are bidding on average $138 AUD for this job
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 385 + projects with 100% client satisfaction. I have more than 5 years of the experience in Excel Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. Thanks.
$250 AUD in 4 days
4.9 (341 reviews)
8.0
8.0
User Avatar
Hi Can you share your workbook please? I am WordPress expert, ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always deliver work on time. My motive is to make my employer happy with quality of service. best regards
$84 AUD in 1 day
4.9 (287 reviews)
7.5
7.5
User Avatar
Dear Client, I have vast experience in excel and I assure I can finish the job for you with the utmost precision. Kindly contact me. Roy
$150 AUD in 1 day
4.9 (417 reviews)
7.1
7.1
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i cna make macro like your spesification on the project description Sir please chat me for discuss detail of your project and im able to start working today Thank You Sincerely Galih AP
$150 AUD in 3 days
4.9 (378 reviews)
7.3
7.3
User Avatar
Hi, I am an Excel expert. I can complete the task as per your description with great care and perfection. Regards Soni
$100 AUD in 2 days
5.0 (145 reviews)
6.4
6.4
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Good to do. Willing to take up your project. Thank you, Regards.
$200 AUD in 3 days
5.0 (125 reviews)
6.5
6.5
User Avatar
1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 AUD in 5 days
4.8 (69 reviews)
5.8
5.8
User Avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable
$250 AUD in 3 days
4.9 (56 reviews)
5.7
5.7
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$250 AUD in 3 days
4.8 (67 reviews)
5.5
5.5
User Avatar
Hello, Thank you for the detailed instruction set. It would be a pleasure to work on this project for you. I have string attention to details and I'm focused on quality. No payment is required before you can test the template and you are totally happy with the result. I provide 1 year free support (includes all bug fixes and small improvements) Please open a chat with me so we could discuss more details. Kind regards, Sorin
$150 AUD in 3 days
5.0 (57 reviews)
5.3
5.3
User Avatar
hi! let me help you with your project. Just award the project to me and I will do the rest as per your requirement. thanks
$185 AUD in 5 days
4.9 (30 reviews)
4.7
4.7
User Avatar
Hi, I have over 5 years of experience in MS Excel, macros, and VBA programming. Would love to discuss further details and start working on the project right away.
$100 AUD in 2 days
5.0 (9 reviews)
3.8
3.8
User Avatar
I have been programming in Excel VBA for more than 20 years. We can adjust the budget, break it down in milestones and give you a better deadline. I offer - Quality. Everything organized, excellent grammar, proper indentation comments on the code. - Availability to work full time on this project, to meet the deadline. - Satisfaction guaranteed. - I will start working on this project right away.
$133 AUD in 2 days
4.9 (8 reviews)
3.1
3.1
User Avatar
Hi I have over 15 years experience in excel. I can do this for you no problem and get it back to you within a day Jess
$200 AUD in 1 day
5.0 (1 review)
2.5
2.5
User Avatar
Hello, I am a professional Excel and Excel VBA user with 3+ years of experience. I had done many projects like this both at my work place and in Freelancer. Furthermore, I am enthusiastic and hard-working. I am willing to do this project at low rate. Please pm me for further discussion. Thank you!
$35 AUD in 3 days
5.0 (8 reviews)
2.6
2.6
User Avatar
Hello, I am a MIcrosoft certified trainer and I have been teaching and offering consultancy services on Excel and Excel automation for over 13 years. I am very good with Excel and VBA. I can also create an addin based solution (one that can embed as a part of Excel on your ribbon) as opposed to using traditional VBA. I use vb.net to create such com addins. I have read your requirement and I would be happy to take this up. I can either do this using VBA and standard Excel functions or if you so prefer, I can deploy a com addin based solution using VB.net. The later one will give you a more polished finished results and be a part of your Excel environment functioning just the same way a normal VBA program would, though if you prefer to use classic VBA, I am fine with that too. I also do Dashboard designing and have created plenty of Dashboards for corporate firms. I pay close attention to detail and can have the template created to your precise expectations. I would be happy to answer any questions you might have as well as appreciate the opportunity to discuss this further with you. I look forward to hearing from you. Thank you
$250 AUD in 3 days
5.0 (7 reviews)
2.6
2.6
User Avatar
greetings,,your project caught my attention we can cooperate together i know EXCEL from A to Z ALSO have very good experience as a data entry i will provide you with accurate work within short duration u can trust me and will be satisfied...............regards
$88 AUD in 3 days
5.0 (1 review)
0.8
0.8
User Avatar
Expert in excel and other Microsoft office
$30 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a highly professional who has rich experience and expert level skills on Excel/spreadsheet. I can deliver the quality you are expecting. regards, Rana
$75 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in Microsoft Excel Spreadsheet formulas and Visual Basic (VBA) programming for Excel files. I am willing to do the first project at low cost in order to demonstrate skills, earn good feedback and recommendations for future work. Samples of my work in Excel and Excel VBA can be viewed on my portfolio.
$35 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Qld, Australia
5.0
1
Payment method verified
Member since Aug 14, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.