exceltoxl.com

Hi there,

  Share on Facebook

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

Excel Master School - 2014

Formulas Tutorial

List FileNames in a Folder

Tampering our own Excel Workbook

Thanks,