« What is Touch/Mouse Mode in Excel 2013? | How to Get Decimals using RANDBETWEEN » |
Hi there,
Today is the most memorable day for me. The reason is, I have successfully installed Excel 2013 in my windows 7 operating system.
Quite some time, I was planning to install office 2013 in my pc but it really happened today. So, I thought why can't I share my experience here. The first feelings will never come back again, right? So, before the cup of tea get's cold I will get into the subject.
You, being a trusted visitor of our blog "exceltoxl", have a GIFT PACK in the end of this post. Grab It, Use It, Enjoy It and That's It!!!
Let's start for now:
WHAT'S NEW IN EXCEL-2013?
...
Out of many new features that are available in Excel 2013, the most amazing features I felt to share with you are:
1. Flash Fill
2. Quick Analysis Button
3. Recommended Charts
Now, we will see one by one how each feature helps us to save ample of time.
1. Flash Fill
What is Flash Fill?
Flash Fill is a feature which helps user to fill the entire column with the help of data inputted in first cell.
When to use this feature?
When we require a unique output for the rest of the cells in a column we can utilize this feature.
How to use this feature?
To use this feature, just type the first cell (FIRST NAME) here and goto second cell and type the first letter. That's it the Excel will automatically takes the AUTO FILL feature to help you fill the rest of the cells.
NOTE:
1. AUTO FILL works only for column wise data.
2. To disable AutoFill option, Goto FILE --> OPTIONS --> ADVANCED --> Enable AutoComplete for cell values --> disable Automatically Flash Fill.
2. Quick Analysis Button
What is this, Quick Analysis Button, all about?
This is a bundle of few features which are placed in a group to use as shortcut. And, this group is named as "Quick Analysis Button".
Why the hell I should use this option?
When the user selects the data, this option gets shown up in the bottom right corner of the selection which helps user to 1. Formatting 2. Charts 3. Totals 4. Tables 5. Sparkline's.
Now, tell me is it a hell or a heaven. ;)
How to make use of this feature?
Very simple! Just click on the suitable icon and see how the selection of data works.
BullShit, what a wonderful feature it is!
I don't know how wonderful the bullshit is? :) But this feature is really wonderful and really time saving.
3. Recommended Charts
What is this Recommended Charts?
Recommended Charts are the new feature added here in 2013 version, which helps the lazy user to make select the chart with less number of options, this will help a lazy user to become a bit more lazy. :)
Where is this option available?
This option is available in CHARTS group in INSERT TAB.
How to make use of this facility?
To make use of this facility, just need to select the best fit chart by moving your cursor towards the chart to match the best fit for your data.
This option actually minimizes the chart selection for your data.
Non-Sense, I know which one to use?
Its, great if you know which chart to be used for your data. However, this feature is more comfortable for lazy users (like me) and new users (like you).
On this special day, my gift for you all. Just Grab It, Unpack It & That's it. :)
If you don't want to unpack your gift click here or here.
Want to buy office 2013 click here . Check here, If you want to buy a book on Office 2013
That's it from my end for now.
DID YOU LIKE THIS?
Are you using Excel 2013 version @ your work or @ your home pc, did you have anything to share with me. You can always use our below comments section to share with me or with our visitors. To share it with me through an email, you can use nourgent@yahoo.com
If you like this post, share it on your social networking sites by clicking on the icons placed around the blog.
If you want to support me for maintaining this blog and to receive monthly NEWSLETTERS, REGISTER here for free. Your email ID will be safe with us and will not be published in a public posts without your permission.
SOME IMPORTANT LINKS
Tampering our own Excel Workbook
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments