Microsoft word 2013 tutorial for beginners in hindi free

Looking for:

Microsoft word 2013 tutorial for beginners in hindi free 

Click here to DOWNLOAD

   

 

Microsoft word 2013 tutorial for beginners in hindi free. MS Word tutorial notes PDF download in Hindi | Microsoft Office Course

  C Programming. Sign in. It is mainly used to design text for presentation.  

- Microsoft word 2013 tutorial for beginners in hindi free

  MS Word tutorial provides basic and advanced concepts of Word. Our Word tutorial is designed for beginners and professionals. Microsoft Word is a computer. This tutorial has been designed for computer users who are willing to learn Microsoft Word in simple steps and they do not have much knowledge about. What you'll learn. Course content. Reviews. Instructors. Best word processing and document creation. Find out how document collaboration and editing tools.    

 

Microsoft word 2013 tutorial for beginners in hindi free

   

Sastry - wow, thats a neat method there. Halfway around the globe in SE Asia Hey this was exactly what I've been looking for to track my portfolio. Thanks a bunch for sharing this. If you get around to London, here's a coupon for a meal at my place! This blog is really nice and informative. We are pleased to know this blog is really helping people. Its our pleasure to post informative content on this useful blog created by webmaster.

We have seen new highs of Nifty and Sensex in the past and now they are trading on lower sides which is hampering the confidence of traders and investors. One point to be noted and learned is that people are investing money by ignoring all fundamentals and technical aspects.

We request all of investors and traders that Invest money wisely its hard earned money do research work only then invest if you don't have time to do research work let professionals do it for you. Think twice thrice before investing blindly without backed by technical and fundamental research. Good Job. Its Fantastic and very very usefull. I was looking for some thing like this. I had one more query. Do we have some thing similar for Stock Market for Shares.

If you get enough time, share it with our other readers.. We appreciate your efforts This is not reflected in E column. Hece am not seeing this fund in the drop down list. Download it and try, you shouldnt see this problem. Let me know if this persists Thanks for visiting phd. Hi, an excellent tool for many investors Is there any way I can fetch data for a specific date This is a powerful tool using which you can create worksheets that can fetch data from web or network resources and display in your worksheet for you to process them.

You can findout more about these by learning to create a mutual fund portfolio tracker sheet. Dear Visitors, This blog is really nice and informative. There tips are really doing wonders in the world..

At this point of time they are the most trustworthy players Please tell my how to get historical NAV of more than 90 days from amfiindia. On their site they have data only for 90 days. We have to repeat the procedure for so many times.

Recent global melt over is causing problems worldwide. In just two days Nifty crashed like house of sand. There are rumors that Nifty will see lower circuit and all, still we strongly suggest all that don't follow rumors go as per technical analysis. Still buying at this stage should be avoided due to bad sentiments Nifty has taken a V turn and has entered into a bearish trend. Let once Nifty take U turn only then it will be right time to enter for Investors for value buying.

Traders never mind if market is bullish or bearish as they can mint money either way. Good article. The excel sheet seems good. Had a quesion on the vlookup, would the vlookup give u a perfect match? I am guessing the fund name in the first sheet should exactly match the fund name as per amfi records?

Is anyone here interested in creating a portal dedicated for Indian MF. You may have to visit individual fund sites to get historical NAVs. Agree, it is a limitation with AMFI.

Another approach could be to use a site like valueresearchonline. Regi: You are right. Vlookup needs exact spelling to fetch the correct fund name. I have a question though. Can it be modified to fetch my daily trade data from one of the online brokers. It is a https site with login and password. Please advise. I would like to "retain" your services if you can custom build one for me No offence meant. You can overcome this using VBA though. The problem post cell still seems to be there - i.

Could you advise what we should do to fix this? Debra from Contextures Blog shows how [ Hey chandu, this is really fundoo This can be done using another sheet maybe where SIP can be tracked seperately and then linked to the main sheet Advise use next tool- Excel file error: data may have been lost ,which is free as how as i remember,program save important information,such as graphics,statistic and mathematics,program will help you to recover valuable information and avoid its losses,tool scans your broken worksheet,then gets the data from this document,will help you to repair damaged files in Microsoft Excel sheet recognizable format,repair file Excel this file is not in a recognizable format, Excel showing this file does not in a recognizable format, or Microsoft Excel worksheet this file is not in a recognizeable format, it is an Excel file error: data may have been lost: Microsoft Excel impossible read file,tool performs a scan of your corrupt excel files not recognizable format and attempts to recover all available data.

This is very nice. Be aware though that for return calculations to be accurate you must account for income distributions dividends and interest. This sheet only tracks change in NAV which is only part of the return calculation. For example a bond fund may show no change in NAV over the measured time-frame, but have a positive return due to the monthly interest distributions.

This spreadsheet ignores those distributions. Return calculations for MFs is a complicated task. I have provided a basic framework for gathering MF data and measuring the performance. Once you have the data any set of performance metrics can be derived. Btw, are you aware of any good formulas to take care of dividends etc? Thank you. I will be sending a separate e-mail to you about my consulting service details.

The NAV tracker for Mutual fund is very good. If there is anything similar for shares of Indian Market please send the link. It will be helpful.

The sheet you have created is very helpful. Thanks for that. Any idea? Any other alternative? Never mind. It has a new URL now. NY Guy: yes, they have recently revamped the site and changed lot of urls. I will correct the portfolio tracker and post it once again. Raman, go to the sheet where downloaded NAVs are pasted and change the web reference from there. It is a simple step. I will upload another version of this excel when I get some time to edit it.

I have downloaded Portfolio Tracker on MF. You can find out how to do this from:. The Problem is :. The sheet assumes there are no more than funds. That is why it is failing. It was created more than an year ago and in the last 16 months there are few hundred new funds. You can just change the formula references in the main sheet to include a larger range.. Let me know if you are not able to do it. This disturbs the Comparison. Can any one help me to uderstand what is the formule or method for preparing list of Fund Name referring to other sheet.

I am preparing spreadsheet based on this excell for tracking My Stocks. A while back we have posted a file on tracking mutual funds using excel. Today we are going to release an upgrade for that [ Thanks a lot for your effort to make our life easier. Can you tell me whether this will show the exact value of the fund with market? Even if i type the Mutual Fund name then values are not calculated. Can you please help me in using this tracker.

I can help you about that. Hi, Thanks a million for the MF tracker. I have just started using and am finding it really exciting. What about a similar tracker for equity? Hi Avinash, Thank you for your reply, I got this file from below link.

I noticed this link from Download option in Chandoo Blog only. Thank you for sharing. I am trying to make my own sheet, and I am having problem getting my current value. Hey wl u plz help me, how i get freshly NAV in my excel sheet through newly updated format by Valueresearch???????????? AMF web site has changed the format of the NAVs text file with new character inserted ;-;-; hence the format is not working properly.

Hi Chandroo, I am also facing the same issue as reported by Mr Subash. Can you forward the details for correcting the Excel sheet. Hi, I had found a short cut method to enable NAV auto update. Noticed NAV is getting autoupdated. Hi All, I had made changes as instructed by Y, It is working fine now. Thank you for providing the solution. But the details is not getting transferred Need help in solving this issue.

Y's suggestions lacks ISN Copy paste the formula till the end of the column. Press F9 and done. You are all set Any issues let me know. Also check if your formulas are consistent from the top cell to the lat one. Hi Mr Y, Thank you for sharing the details, I tried copy the formula and pasted it in E10, After validating the formula getting error message as. AMFI has made some changes in their file 'nav. So the excel file is not giving the correct NAV in the appropriate column.

Can you please upload the modified excel file. I am very beginner in excel. Sorry for asking this. Get Indian stock market tips covering cash tips, future tips, nifty trading idea, commodity and option trading tips.

First of all, Let us applaud Chandoo for such a beautiful and helpful site. Since the Nav. Any way Chandoo will get it done, but till then following are the steps which can help. Replace ;-;-; with ; 3. Replace ;-; with ; 4. Dilip it is working, i have tested and posted. Looks like you have not replaced with blank, may be with word blank you may have replaced. I can modify instead as shown below 1. Hi, I had made changes as instructed by Mr.

We have to do lot of manual intervention for seeing the correct portfolio details. What to do we are not so professional in Excel as Mr Chandroo. Let us see whether we will be getting new template. No need to replace values. The Nav values are available under Sales Price column.

Just refer to the sales Price column L in you calculations. As pointed out earlier in the post the format of the NAV data has changed. You may try doing the following to correct the sheet. Click on cell D12 3. In the formula bar paste the below formula. Once you complete the step 3, copy cell D12 5. Select column D12, all rows will get selected 6. Do paste special and select formulas.

Ensure that you save the sheet after you are done with the changes so next time when you open, it will work correctly. Thanks Chandoo for this amazing excel based portfolio. From past few days, I am not able to refresh new data to my portfolio.

As we are facing problems of format of the NAV data has changed in amfi. Also tried to do the suggestion given by Abhijit and earlier members but not worked. So please update the version as it would be useful to everyone. HI chandoo, the tracker is not working since we entered I will be posting an updated version of this file tomorrow. Thanks for your patience.

Hi Chandoo, It has been so many days waiting for new version still there is no update about the file. Use Moneycontrol. We are waiting for new version of Mutual fund portfolio tracker in excel as the current version is not giving proper data. Hope it will be beneficial for all the users. Thanks for this wonderful tracker once again. The change i suggested works for me.

Not sure why it wouldn't work for you. The post does not allow me to attach a file, else i can attach it. I too am using this excell sheet since long, please let me know from where to download the latest fixed version. Hi All, I am using this Mutual Fund excel sheet for the past two years. I need help and suggestion on two thoughts 1 I want to know how can i calculate difference of NAV amount of any mutual fund between yesterday and today's NAV.

Your Portfolio Tracker is just awesome. There are close to 18, US mutual funds, I can see the fund perfomances and everything on morningstar. IS there an easy way to select the fund rather than scrolling down? It is a large list!!

In NavPivot sheet teh latest value is not updating. Thanks a lot for uploading "MF Portfolio Tracker". Similar way I was trying to create "Equities Portfolio Tracker", but I am unable to find any source data in Tabular format for importing through "Excel web quarry".

Have you created anything for Indian Equity market? Thank you for sharing this file. Pardon if this has been answered already but would appreciate a simple instruction on how to do it.

Need your help on this.. Nice breakdown on how to create an excel sheet. I'll definitely be using this as my basis the next time I create an excel sheet.

I am using Mutual fund tracker for quite long time but yesterday while refreshing the data on sheet, the Raw data on Latest NAV sheet gets deleted. I have also been using the Excel portfolio tracker for quite some time now. I thought that I could edit the web query but could find a way to locate and edit the web query.

Kindly have a look. Derar Sir, I am a user of this tracker that you created. It was working excellent. Whenever I open it, a pop-up box appears, telling that 'Reference is not valid'. The 'Latest NAV sheet' is getting the updated data. I tried many options. Still no clue. Could u please advise. Yours faithfully, Shafi. Hi, have updated the MF tracker. Wanted to share with all.

Please follow the link below. I don't understand why you put the Avg unit value, What is the significance in different type of funds, kindly explain. The result of the comparison i need is 1. Per Day movement 2. Yearly Return. Hello friends firstly thanks for every one for this community and share best experience and knowledge of stock market. Stocks are appearing by companies in order to raise capitals and are bought by investors in order to acquire a portion of the company.

With the help of Stock Tips service Provider India you will determine about stock is profitable for you. Please help. Thank you very much for providing the Mutual Fund tracking Excel sheet. It has been very useful to track most of the mutual Funds. I am facing a small problem in terms of a particular mutual fund which is getting displayed as part of your pop up menu and also not available in the web query file.

Could you please find out and let me know the solution for this. Further to my earlier request, the statement should read as It is NOT getting displayed as part of the pop up menu. To get best bullion tips to the best advisory. Hi Chandoo, I haven't seen any recent comments from you on this blog even though there are lot of questions unanswered in this post. Let me know if you are still maintaining this site. I would like to seek your help on MF tracker. I have developed v3. I will update this post with new instructions and workbook soon.

Could you please check and update the excel. This link can be accessed separately in browser however this not working in excel query. Need your help in resolving this issue. Where as in NAV Pivot excel sheet if we select "Sales Price" then excel sheet is not working once the "Sales price" is unchecked then mutual fund tracker is working. Is there a way to pull the market indicies for the various MF benchmarks. I am finding that Moneycontrol does not have all of them.

What I do for the ones I have for my SIPs if list of the SIPs dates and amounts, use the index values for those same dates to calculate and compare bench mark returns.

From where should I begin first? Thank you in advance. I downloaded spread sheet for MF Tracking. The problem faced by is that I am working on Excel which does not have a power query addin. Please guide how to install power query add in for MS Excel and source for that. I am a beginner. And wanted to learn whatever i could about the funds. I have a got some essential information by this posts thank for it Keep updating us The Csv. Document paramter 'Columns' is invalid. Let me know if there is a known workaround.

Thanks for putting this sheet in the public domain, really useful for tracking. I have read your blog its very attractive and impressive.

I like it your blog. Power BI training in marathahalli bangalore. Dear I got this error Expression. Error: The Csv. Document parameter 'Columns' is invalid. It was working in my excel after adding power query, now i change the excel to now this error is coming How to fix this. Is there a way to pull the market indicies for the various. Your blog is too good, you have written a wonderful article..

Motivational stories in hindi for success. Hello brother , the problem is. I have downloaded the sheet and when i go for the refresh and it says the below error initialization of data source failed. What to do.

Hi all, have created a Google Sheet version of this with some modifications. Please feel free to copy the sheet and use as you see best. Thanks to Chandoo once again for setting this up. Note that the Google Sheets version does work a bit slower than excel.

I'll post a link to the Excel version too a bit later. Hey Raj, updating the values on google sheets takes minutes. Its a bit slower than using excel. I just opened my sheet now and got updated with the NAVs for the 2nd of April. Share your email and I'll send you the xlsx version. Hi Chandoo, I have just downloaded the xls file for mutual fund return from your website.

Error] The Csv. Thanks for the excel sheet of mutual funds, but i would like to tell you that there are new funds in India which are not in your list like , IDFC MfF's , axis focused 25 equity fund etc.

Here is a link to an working excel version of the google sheet I had shared earlier. If you make any great enhancements to the sheet, do share back with me so I can incorporate them into the same. I was trying to make my own sheet with the help of your sheet , after importing data, how to arrange the sheet, there are a lot of unnecessary rows. Thanks for the wonderful excel tracker have been using it for some years. Unfortunately in the older version the pivot table gets corrupted.

I keep a copy of the original file and reenter all the data again and it works till the next time it crashes. I downloaded your version but its giving some csv error. Can you or anyone else help me in fixing this problem.

As you would have understood by now I am just a user with not much knowledge of excel- so please explain in layman's terms. Try this Hi Varun.. AMFI the source system for this data has changed their website structure. I will update the post to share a new template soon. It is giving following error message. I really appreciate your hard work. Thanks for sharing with us. Thanks a lot. Unable to refresh the data; it says credentials are required to connect to the web source.

Using Office I have been looking for something like this but can't download it due to restrictions in my office. I have one query though. My understanding is that this basically fetches the NAV values from the AMFI website for the funds I have invested in and neatly presents the values based on my portfolio. Question: Is it possible to have this ready right after pm when the market closes and calculate the NAV ourselves?

For example, if I have invested in Axis Bluechip, I know the names of all the companies in the portfolio and their closing stock prices at pm, plus the expense ratios and all other technical information of the fund, so is there a way to fetch them live, calculate the NAV ourselves and get my portfolio values right after pm? Hey Uday, What do you hope to gain by getting your portfolio value at pm vs say pm?

You can't trade in MFs after pm anyway. MFs are not for day traders, unless you are trading very large volumes in liquid schemes. Thanks for the superb excel file. However, I am facing some problem in the file.

Actually the refresh worked for few months but now it is not working. In other words, 'refresh' is disabled whenever I open the file. Further, can you suggest me something so that on particular day the purchase section is updated automatically based on sip date. The final format in your sheet and data from AMFI are quite different. Pls help. I have been trying for a long time to create a graph of my UK mutual funds in excel , but have always failed.

I have no trouble with shares but codes for mutual funds baffle me. I would be eternally grateful if you could help me. Error]2arguments were passed to a function which expects 1 [Expression. Hi Chandoo Being a senior citizen my investments are in FD and it becomes difficult to track which one is maturing and which one has already matured.

Do you have any excel tracker? Hi Chandoo, I am still looking for a Indian stocks portfolio tracker in excel similar to your excellent MF portfolio tracker. Help please? Hello Guys, i downloaded Mutual fund Excel file and trying to refresh all, but its not allow me to do that. Thank you sir, you have given very good information, and would personally recommend it to my friends.

I am sure you will post similar thanks. Hi, while calculating the return there is some high mismatch in the mutual fund returns shown in my statement and in the your excel I am having some problem in building the VBA to store previous data for my funds. Can you please give me the code to do this?

Hi, i have downloaded MF tracker, but how to enter the data for the part sale of the units Due to that the Tracker is not updating the NAV. Can you please help? I created the cascade list as per the above instructions. However, in case of wrong combination of fund house and fund name it is not showing any color Indication alert.

Pls help me out if i missed anything here. I have been using the excel MF tracker from 3 years, today when i opened my file, it crashed. It is lot of work to enter the data again on new downloaded from your website file. Hi, Well using this from last few months now, loving the overall feel.

Slight issue with the NAV updating to the current price I have the power query installed and also done with updating it. Is there any other updated file? Hi, I am using this. So this fund is not updating. Request you to look into this Thanks. If this can be done, please let please let me know the procedure. It would be nice if it was possible to track MFs based on a transaction statement. So every time I do a transaction, bur or sell, the MF tracker should update the correct no.

Hello, Really nice work with the mutual fund tracker. Could you please tell me how to pull only mutual funds form the source instead of updating the whole list which seems inefficient or is it? My idea is to get only those funds which i am interested and keep a history of NAV changes. In the Fund House, the name does not appear. In the drop down. What should I do. I have enabled as you have suggested but I am getting the following error.

I have Windows 10 and Office Firstly, thank you for the Mutual fund Tracker. I downloaded it to my system and entered my mutual funds data.

But i found that it works only for lumpsum investments and not for SIPs as it requires me to insert all my SIP investments data month-wise. I need to insert total 20 months data to get exact current value. Kindly look into this. Thanks for your valuable information, this even works after few years which means - you have done a fantastic work. I am planning to track my MF investment using your tracker..

But i need more technical latest information like exit load, expense ratio, rating - how is it possible in same tracker?? Looks for my posts above. Thanks for the wonderful sheet, i was using it for last 2 years. Please look into it. Last one week the 'Fund Name' is causing a data validation error. Is there an update which will solve it? Name required. Mail will not be published required. Notify me of when new comments are posted via e-mail.

One email per week with Excel and Power BI goodness. Login to online classes. Learn Excel , personal finance , Power Query , technology. Last updated on July 6, Share on facebook Facebook. Share on twitter Twitter. Share on linkedin LinkedIn. How to use this mutual fund tracker Excel workbook? When you finish creating the table, it would look something like this: Next we will use Power Query to automatically fetch the funds and latest fund value from AMFI website.

The result looks like this in Power Query editor. That way, our drop down will be small and easy to use. Please read cascading drop downs page for details on how to do this.

The rest is easy to calculate. Now as you input fund names and refresh data, your portfolio gets updated. I cannot refresh data: You need internet connection. If you have an older version of Excel, download Power Query add-in for free. It could be a weekly issue ie every Friday they might be publishing some extra data.

Try again in a day or two. If the problem persists, post a comment so I can suggest a work around. Some other problem: Please post a comment so I can look in to this for you.

Tagged under downloads , free , how to , investing , Learn Excel , MS , mutualfunds , personal finance , portfolio tracker , power query , spreadsheet , stock , technology , vlookup , web queries Category: Learn Excel , personal finance , Power Query , technology.

Welcome to Chandoo. She also created video training CDs and online training classes for Microsoft Outlook. This applies only to Office and older. The click to run versions do not support selective installations in the consumer versions.

Businesses can use ODT to control what gets installed. I have a malware infestation in my outlook Kaspersky's technicians have worked on it for over a fortnight and can't resolve the issue.

If I uninstall and reinstall MS Office my understanding is that I will lose all the updates that have occurred since it was first activated. I just reinstalled Office and Outlook won't open; everything else works fine. Should I uninstall Outlook? I haven't done it because I'm afraid I'll lose Word, Excel, etc. And if I uninstall Outlook, can I download a free copy online? Thank you. You can't uninstall outlook only - it will uninstall all office apps but your data won't be touched.

Outlook is acting up: I cannot add my account back. Now I can't create a new account. It complains about encryption. Then, when I go back to look at the settings, the server settings somehow changed from AOL to to imap. So I tried to delete the app.

It is part of a download version of Microsoft Office that I purchased. I still have access to the download but I don't see any way to delete Outlook. Yahoo requires an app password to add the account to Outlook, even if you don't have their extra security features enabled.

Select your app from the list and click Generate. Choosing the app is to make it easier to delete revoke a specific password if you need to later. You can use the app password in any application. How do I completely remove Outlook When I uninstall, remove all. I want to completely uninstall. There must be setting that exist in the registry. How do I remove all registry entries? I have an odd one here! Perhaps you can help.

I am in support at a managed services company and we have a client witt the follwoing Outlook issue:. Outlook Business Premium - Two profiles, one work account and one outlook. If I remove it and add it back it works for a few days and does it all over again. They are two different accounts with their own emails. Outlook is renaming the account itself! As you can imagine then, the problem is trying to differentiate between them in the contacts or calendars sections of outlook and even the email mailboxes.

When i right-click on a file to send it through windows mail which is my Default program, the file goes attached to Outlook Compose by clicking "Send to Mail recipient"!!! I am using Windows 10 pro and Office I also have an outloook email account registered in my laptop. I have uninstalled outlook but after opening the system, the system tries to launch it.

Please help how to remove it. What version of Office do you have installed? You cannot uninstall just outlook when you use Office and click to run installs, which pretty much everyone is using. Schedule Management. Calendar Printing Tools. Calendar Reminder Tools. Time and Billing Tools. Meeting Productivity Tools. Duplicate Remover Tools.

Sending and Retrieval Tools. Mass Mail Tools. Compose Tools. Mail Tools for Outlook. Online Services.