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, yahoo-finance, works need excel, use case tutorial, tutorial use case, tutorial for data entry, number tutorial, new start auto finance, microsoft project import, microsoft excel help functions, microsoft excel help 2013, html 5 for dummies, how to use data entry in excel, how to do data entry in computer, how excel works, following up, excel tutorial 2010, excel essentials, excel 2007 functions in excel, data entry in excel 2007, data entry for dummies, microsoft excel price, len in excel, important steps

Tietoa työnantajasta:
( 0 arvostelua ) Jacksonville, United States

Projektin tunnus: #4273714

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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)

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

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

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)

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

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