Suljettu

Excel (simple following steps)

The following files are attached. (IMPORTANT INSTRUCTIONS BELOW - PLEASE READ)

1. The case file

2. Start sheet for excel

3. A short video showing you how to set up your sheet correctly. - Although the Yahoo finance page has changed, the essentials remain the same. Please note one critical point though - Instead of last trade - use the 'price' field.

4. The formula to convert Capitalization into number figure - =LEFT(E2,LEN(E2)-1)*(IF(RIGHT(E2,1)="B",1000000000,1000000))

5. I left out the formula for calculating commission on purpose. You should be able to figure that out.

6. There are a couple of ticker symbol that don't exist any more. Please ignore them. However, you will need to make a note of them in your writeup.

7. Piviot table tutorial (right click - open in new window)

[url removed, login to view] (Copy paste in a new window please)

8. Database functions in Excel 2010

[url removed, login to view]

(Right click, open in new window)

9. Once you import the data, remove the auto refresh as well. It works only when you do the project on one computer in one seating, otherwise it will mess up your sheets.

10. There is a question regarding which fields to select from yahoo - below is the screenshot (not, that the order of fields depends on how you want to get your data across and you need to change it to your liking)

Taidot: tiedonsyöttö, Excel, Word

Näytä lisää: excel simple steps, yahoo finance overview, works need excel, use case tutorial, tutorial use case, tutorial data entry, number tutorial, new start auto finance, microsoft project import, microsoft excel help functions, microsoft excel help 2013, html dummies, use data entry excel, following up, excel tutorial 2010, excel essentials, data entry excel 2007, data entry dummies, microsoft excel price, len excel, important steps, excel sheet formula, excel help formula, window price, need excel help

About the Employer:
( 0 reviews ) Jacksonville, United States

Projektin tunnus: #4273714

4 freelanceria on tarjonnut keskimäärin 73 $ tähän työhön

cowboy14

Read and understood about the project requirements. Please check your pm for more details about my bid.

30 $ USD 2 päivässä
(23 arvostelua)
4.7
farr4u

Hi, Excel and VBA expert here, ready to start, plz chk pm for DEMO.

65 $ USD 2 päivässä
(7 arvostelua)
3.0
sharly001

Ready to initiate the project straight away. I'll deliver your requirement with perfection and within time limit.

120 $ USD 7 päivässä
(2 arvostelua)
2.2
DoGau247

Hello Sir, I can do this project with accuracy & in good time.

77 $ USD 5 päivässä
(0 arvostelua)
0.0