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

About Pivot Table. How to Activate the Auto Refresh Option of Pivot Table?

First of all I would like to wish you all a Happy and Prosperous New Year, 2014. I got a bit late in wishing this as I was occupied in the joining and training formalities in my new organization, Capgemini.

Let's again proceed to know more on MS Excel. I would like to share some information on Pivot table today. Pivot table is an interactive table that automatically extracts, organizes, and summarizes your data. We can use this to analyze the data, make comparisons, detect patterns and relationships, and discover trends.

You might have observed that every time you have to refresh your Pivot table post updating your master data from where you have created a Pivot table. To avoid this repetation, MS Excel has an option which helps the user to Refresh the data every time you open the file.This forces the Pivot table to refresh it automatically while opening.

To perform this, select the pivot table and click right. Click "PivotTable Options" and visit the "Data" tab as shown below. There you will find the check box option of "Refresh data when opening file".

Check the box and save. For more information on how to do this, please get in touch with me at 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 TricksHow to avoid #DIV/0! and #Value! Error?
How to create One Variable Data Table using What-if-Analysis?

Desde el analisis de blogspot, yo encontre que aqui son mas nacionales de espanol visita en mi Excel in MS Excel blog. so soy escribo el blogs en espanol tambien desde proximo blog en adelante. Espero el nacionales de espanol visitarnos en mi blog le gustara este in espanol.
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

What is Flash Fills in Excel 2013? How to turn it on?

Sometime we have to fill lot of repetitive data in excel and that becomes very cumbersome. During such cases Flash Fills newly included in MS Excel 2013 helps and saves a lot of time and effort. There are two different options available to reduce time and effort by avoiding repetitive tasks. 1) Auto Fill and 2) Flash Fill.

Auto Fill: Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells.

Flash Fill: Use Flash Fill, new in Excel 2013, to fill out data based on an example. Flash Fill typically starts working when it recognizes a pattern in your data, and works best when your data has some consistency.

How to turn on Flash Fills?

Flash Fill is On by default. However if it is not working then visit File => Option and then click Advanced. You will get the option of Flash Fill as shown below.

Check the box and save. For more information on how to do this, please get in touch with me at 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. And finally Merry Christmas to All.




Visit Other MS Excel Tips and Tricks
How to avoid #DIV/0! and #Value! Error?
How to create One Variable Data Table using What-if-Analysis?

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