Quick Recap of Excel in MS Excel 2013 Tips

What is Data Validation?

What is Signature Line?

How to load Add-In Tools?

Use of Advance Filters

Usage of Inspect Document

Remove Duplicate Content thru Conditional Formatting

You Know MS Excel 2013 Recommends Charts as per your Data

Buy Now

Know Data Validation in MS Excel

Conversation between Manager and Executive

Executive: Team members are filling data in irregular formatting

Manager: So you must have tough time create the report

Executive: Yes L

Manager: So why don’t you use Data Validation to restrict your user for filling irregular data. Read the section below to know more on this…

Data validation in Excel helps you to restrict others to enter the value in the way you want them to enter. For example, you want that the user should only fill value from 1 to 100. If the user fills a value more than 100 then Data validation will restrict the user to fill the same. Simultaneously you can restrict user to update date as per the format you have decided. You can even allow “custom” in the data validation option by including some kind of formulas in it.

Youtube Video Teaching - Data Validation List

For more details you can buy my ebook available in Amazon

BUY NOW

Only @ Rs.139/-

Visit Other MS Excel Tips and Tricks

How to load Add-Ins Tool in Excel 2013?

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation

Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio

-----------------------------------------------------------

Be a part of regular Weekend Knowledge Sharing Sessions

Reach me @ +91 8095039316

https://www.facebook.com/Samrat.Biswas

Excel in MS Excel - For Freshers and Experienced Professionals| eBook is now available for SALE in Amazon

Buy Now 

This book is aimed for professionals working in any domain where knowledge of MS Excel is of utmost importance. Be it a fresher  or a full time professionals working in any roles; this book will help them understand the different MS Excel features required in day to day operations. This book will deal on the basic concepts of MS Excel which an individual need to know before implementing them in their official activities. I have written this book not as a traditional text book where you only see the explanation of the individual topics. But tried to bring different scenarios we face in our daily office work to correlate the office requirement and MS Excel knowledge. You can find many unique topics such as Trendline, Spaklines, Trace Precedents, Trace Antecedents, Slicers Timelines and many more are covered in this book. I have included practice exercises at the end of each topics. This will help readers to judge their gathered knowledge. I will also be sharing Practice Sheet along with the book. Where you will see all live examples and re-use them in your office work.

I hope that this eBook will definitely help you improve your performance in MS Excel usage. 

India| http://www.amazon.in/gp/product/B016YYJS9E?*Version*=1&*entries*=0
USA| http://www.amazon.com/gp/product/B016YYJS9E?*Version*=1&*entries*=0

UK| http://www.amazon.co.uk/gp/product/B016YYJS9E?*Version*=1&*entries*=0

What is Signature Line in MS Excel?

A signature line is similar to any signature placeholder we see in a printed document. This options helps the user to put a place holder for a signature, suggested signer, his title and email address. The idea to use this is for considering the document as 'reviewed' and 'approved'. Once the signature is done the document turns into a non editable document.

How to add a Signature Line in MS Excel?

For this, user has to go to the Insert ribbon of MS Excel. There you find a tool called 'Text'. This has an option called 'Add a Signature Line'. Upon clicking this option, a 'Signature Setup' dialog box pops out. In this user has to enter suggested signer, his title and email address. You can also enter a comments for the proposed signer as shown below.

After completing the entries when you click ok you will find a signature line embedded in your Excel spreadsheet. You can move, cut and paste it anywhere in your document as per your need.


If you double click the signature line you will be prompted with a dialog box of 'Sign'. There you will have an option of selecting the signature image which will get embedded in your document. This will also show the signing date and other details of the signing authority. Once done your document is signed and become non editable for others unless anyone forcefully removes the signature and does some changes. Make sure you review the document before signing it...otherwise the onus of any mistake in the document content will be on you :-)

For more details you can reach me...

Visit Other MS Excel Tips and Tricks

How to load Add In Tools?

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
-----------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +49 15211442120
https://www.facebook.com/Samrat.Biswas

How to load Add-Ins Tool in Excel 2013?

How to load Add-Ins Tool in Excel 2013?

Add-Ins tool comprises four different tool packs. For example:

1. Analysis ToolPak - Provides data analysis tools for statistical and engineering analysis
2. Analysis ToolPak - VBA - VBA functions for Analysis ToolPak
3. Euro Currency Tools - Conversion and formatting of Euro currency
4. Solver Add-in - Tools for optimizing and equation solving

But before we go and load the above tools you first need to have the "Developers" ribbon in place. If you do not know how to get the "Developers" ribbon then please follow the below blog.

How to load Developer's Ribbon?

Once the Developer ribbon is loaded click the Add-ins option available under tool Add-ins. This will provide you a pop up tool kit having list of all the above four tools. To load any of them you have to click the check box and hit ok. And there you go...

Users having interest in statistical tools and its usage can try and use the Analysis ToolPak option. This is really a wonderful tool. It provides you enormous amount of calculations in seconds; provided you have to give the right inputs.

For more details you can reach me...

Visit Other MS Excel Tips and Tricks
Use of Advance Filter in MS Excel

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
https://www.facebook.com/Samrat.Biswas

Use of Advance Filter in MS Excel

Advance filter available in "Data" ribbon is used to filter your data with some complex criteria. To use advance filter option you have to create a criteria for your filter. The criteria table should have the same set of headings with respect to your data list. Scenario - We would like to filter Quarter 1 sales from state Karnataka in the below given data set.

Step 1: Have your data set ready

Step 2: Create your criteria

Step 3: Go to "Data" Ribbon and click "Advance Filter" option. This will pop out the following dialog box. You will get an option called Action. Select "Copy to another location" radio button then select the data set range from which you want to filter your criteria and then select the criteria which you would like to filter. Once this is done locate the place in the same sheet or any other sheet where you want to have the output. Hit OK and there you go you will get the desired result.

For more information on how to do this, please get in touch with me at Samrat.Biswas@ hotmail.com or Samrat.biswaas@gmail.com

Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.

Visit Other MS Excel Tips and Tricks
Usage of Document Inspector

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316
https://www.facebook.com/Samrat.Biswas

Usage of Inspect Document

Hello Friends, After almost 2 months I have got time from my normal bid management work to share something new on Excel with you. But before that I would like to say thanks to all my blog reader for visiting my posts regularly. I would also like to thank to all the viewers in my Facebook page.

Let's come back to the point- Many a times it might have happened to all that after sending report to your manager it bounces back - saying this has been copied from some old customer reports. Isn't it? Because we tend to work on an existing file always. We tweak them and make them as per the current requirements but forget to change/update the file properties.

In MS Excel, we have an option called "Inspect Document". This helps user to check the workbook for hidden properties and personal information.

For this you have to go to the FILE Ribbon and click "Check for Issues". This will have the option "Inspect Document". Upon clicking this you will get "Document Inspector" dialog box. Here you have to continue by clicking the "Inspect" button. Thereby you will see all the hidden properties. You may like retain them or Excel will provide an option of Removing them all.

Hope this helps.

For more information on how to do this, please get in touch with me at Samrat.Biswas@ hotmail.com or Samrat.biswaas@gmail.com

Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.

Visit Other MS Excel Tips and Tricks
How to create drop down menu in MS Excel?

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas