Monday, 21 April 2014

What’s new in April 2014 update of Excel Online


Some of the new features added to Excel Online in the April 2014 update, now available in both OneDrive (previously SkyDrive) and Office 365, are as follows:

Office.com is the place to get going with Excel Online

Now, it’s much easier—just go to http://office.com and click the type of document you want to create.
Authoring (inserting, editing, and deleting) comments

Users of Excel Online have been able to see comments on cells for a while, but until now there has been no way to add new comments to a cell. With this release, the ability to insert new comments as well as edit (and even delete) existing comments is added to Excel Online. Long-time Excel users may notice that the experience has been modernized—the text of a comment now shows in a task pane that contains all of the comments for the active sheet (making it easy to jump between cells with comments by simply clicking the comment in the task pane). 
Working with comments in Excel Online is now easier than ever, and is consistent with Word and PowerPoint Online.

Editing files with VBA

The capability of editing files that contain VBA without removing (or corrupting) the VBA contained in the file is now added to Excel Online. That means that if you have a file that you use in Excel Online sometimes and in desktop Excel other times, you can do that, taking advantage of the VBA in the desktop, and keeping it intact when you’re using it in a web browser.
XLSM files (with Macros) can now be edited in Excel Online, without removing the VBA.
Hiding and unhiding rows and columns

Previous releases of Excel Online have correctly displayed—by not displaying—hidden rows and columns, and there have been some “hacks” to hide and unhide those cells. With this release, Microsoft has added support for the most common way that users hide and unhide rows and columns, using a context menu that appears when you right-click a row or column header—just like in desktop Excel.

With this release of Excel Online, you can hide and unhide rows and columns just as you do in desktop Excel.
In-app feature search: Tell me what you want to do

We’ve all had that moment when we know what we want to do, but don’t quite remember how to do it, wondering, ”How do I change the font?” or “How do I find the median of a set of numbers?” Now, when you type a few characters in Tell Me, Excel Online will tell you exactly how to do what you want to do.

Tell me can quickly find any Excel command for you.
Customizable Status Bar Aggregates

Microsoft released an update in November that brought Status Bar Aggregates to Excel Online. With this update, several more aggregates where added , Min, Max, and Numerical Count; and by making the set of aggregates visible in the status bar configurable—just like in desktop Excel.
You can show the aggregates that are the most useful to you in the status bar.
You can show the aggregates that are the most useful to you in the status bar.
Get anywhere in your spreadsheet fast with GoTo

As Excel Online becomes more and more feature-rich, the spreadsheets being created are more and more similar to spreadsheets created with desktop Excel. That means larger, more complex spreadsheets and a greater need to quickly navigate around your masterpiece. Enter GoTo (Ctrl+G), a “pro” feature that allows you to quickly type in a reference and jump to that location in the spreadsheet.

You can jump to a place in your spreadsheet fast by typing a reference in GoTo.

31 comments:

  1. I have read your blog. It is really helpful to work with excel. Continue shares more about excel.
    Regards,
    Excel Advanced Training | MS excel Training in Chennai | Excel Macro Training in chennai

    ReplyDelete
    Replies
    1. I am technology Enthusiast. Your blog is really awesome, attractive and impressive. I like the way you think. it is very useful for Java SE & Java EE Learners. Your article adds best knowledge to our Java Online Training India. or learn thru Java Online Training India Students. or learn thru JavaScript Online Training India. Appreciating the persistence you put into your blog and detailed information you provide. Kindly keep blogging.

      Delete
  2. Advertising through email is another common form of online advertising. However, what distinguishes it from spam is when it takes the shape of legitimate opt in emailing. Online Advertising

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. we have almost all country students as our subscribers for online course.We have 10+ years of experience we can serve various ascent people. oracle fusion Cloud HCM online training at erptree.com is worlds best online training center. we have excelent knowledge sharing Platform we have user friendly website where you
    will be provided with all the required details and Self-paced DEMO videos. we have our branches in pune, gurgaon, noida, india, usa, uk, uae, oracle fusion hcm training, fusion Procurement training, fusion hcm, scm training.


    Oracle Fusion HCM Training

    ReplyDelete
  5. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete
  6. If you need to take in the genuine aptitude of blog composing, give this blog a read.
    www.bokepsemi69.com/

    ReplyDelete
  7. For some individuals, formal training finished the day they dropped out or moved on from High School https://okdissertations.com/writing-services/dissertation-methodology College or University, despite the fact that,

    ReplyDelete
  8. This formatting can include changing the appearance by adding banding to either columns or rows, changing the colour scheme from one of the options in the gallery and including a Totals row. More on this later...
    excel dashboard software

    ReplyDelete
  9. Informative article... Very helpful to me... Thanks for sharing..,....
    advanced excel training

    ReplyDelete
  10. These are some great tools that i definitely use for SEO work. This is a great list to use in the future.. Microsoft Excel Training Courses Malaysia

    ReplyDelete
  11. Being objective situated will likewise enable you to adapt in school since you will experience a progression http://whatbookshouldireadtoday.com/ of school works and examinations which would all incur significant damage on you.

    ReplyDelete
  12. Hi! Thanks for the great information you have provided! You have touched on crucial points! Send Gift To Pakistan
    Send Valentine Day Gift to Pakistan

    ReplyDelete
  13. Hey! Thanks for sharing information with us, it's very important. I have learned a lot from theese article. I also want to share the following information. It was some day, when I could not open .csv file https://wikiext.com/csv, before I found this website. Here is teurned out that, it is so easy to do that. So, I wanted to share it with you, in case if you will search such information.

    ReplyDelete
  14. Shrewdly worked by the creator and Stunningly delightful usage of words.
    internet money

    ReplyDelete
  15. Hey Really Thanks for sharing the best information regarding Excel Online,hope you will write more great blogs.

    Oracle Fusion Financials Online Training

    ReplyDelete
  16. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    oracle fusion financials training in hyderabad

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. Amazing write up. Great info regarding Excel. I am a regular follower of your blog. Keep updating and thanks for sharing.
    Final Year Project Center in Chennai | IEEE Project Center in Chennai | Diploma Project Center in Chennai

    ReplyDelete
  19. Thanks for Sharing this article and keep updating us regularly with a new set of articles. This article is more information.
    No.1 VLSI Project Center in Chennai | No.1 VLSI Project Center in Velachery

    ReplyDelete
  20. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.

    php training in bangalore

    ReplyDelete
  21. Hi, am a big follower of your blog. I am really happy to found such a helpful and fascinating post that is written in well manner. Thanks for sharing such an informative post. keep update your blog.
    BE/B.Tech Project Center in Chennai | BE/B.Tech Project Center in Velachery

    ReplyDelete
  22. Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.

    oracle training in bangalore

    ReplyDelete
  23. Thanks for posting useful information. Thank you very much for this one. And I hope this will be useful for many people .. and I am waiting for your next post...
    Good Technical Boot Camp in Chennai | Best Summer Course in Porur

    ReplyDelete
  24. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.
    Java Training Institute Bangalore

    ReplyDelete