Happy New Year 2019

Wish all my blog readers a 

Very Happy and Prosperous 

New Year 

2019.

Advance MS Excel 2 Days course

Booking Open for Batch 4 - 3rd and 4th November 2018

There are only 25 seats available per batch...

Thanks for showing all your interest in the Excel in MS Excel Blog. Although I was out from blogging for few months but now I am back with Online MS Excel 2013 training. Join the best online training to learn MS Excel Nuances...

MS Excel Course Fee

Advance MS Excel 2013 

Duration: 14 hours (2 days)

Training Mode: Online

Fees: INR 1999/- and USD 69 

Course Contents (Click the link below for details)

Advance MS Excel 2013

Course Materials

1. Soft copy course materials will be provided to all participants
2. Excel in MS Excel E Book Amazon coupons will be provided to all participants. 

Excel in MS Excel - Visit Amazon for more details

Training Dates

Weekends (Saturday and Sunday)

Booking Open for Batch 4 - 3rd and 4th November 2018 - Hurry Block Your Seat!!!

Course Enrollment

For course enrollment please send the following information in the given email ID.

samrat.biswaas@gmail.com along with the payment confirmation/reference number and amount paid.

Subject: Advance MS Excel 2013| Training Date

Name:

Email ID:

Phone No:

Organization:

Experience in Excel: Foundation/Intermediate?
Preferred Date of Training: (Any weekends)

Any specific features in Excel you are interested in:
Amount Paid:
Payment confirmation Reference Number:

System Requirement

Laptop/Desktop

MS Excel 2013 

Broadband Connection for good internet speed

Payment Mode (NEFT/IMPS)

Samrat Biswas/Excel in MS Excel
Bank: Yes Bank Ltd
Bank Address: 26th Main Road, 9th Block, Bangalore 560011
Account Number: 065390100000612
IFSC Code: YESB0000653

Contact Details

Mobile: +91 8095039316

Email: samrat.biswaas@gmail.com 

Terms and Conditions

1. Training will be provided Online. 
2. Course fee payment to be done in advance to block the seat
3. Within 24 hours of realizing the payment seat blocking confirmation along with Online training link will be provided to all participants.
4. Course materials and Amazon ebook coupon will be provided on the first day of training.
5. In case the trainer is not able to impart the training on the scheduled days for any technical reason and if candidate do not want to participate in the next available dates then the course fees will be refunded with necessary deduction of the ebook and course material cost.

Advance MS Excel Online Training Course

Booking Open for Batch 3 - 29th and 30th December 2017 

Hurry Block Your Seat!!! Offering Rs. 1000/- Year-end discount.

There are only 25 seats available per batch...

Thanks for showing all your interest in the Excel in MS Excel Blog. Although I was out from blogging for few months but now I am back with Online MS Excel 2013 training. Join the best online training to learn MS Excel Nuances...

MS Excel Course Fee

Advance MS Excel 2013 

Duration: 14 hours (2 days)

Training Mode: Online

Fees: INR 1999/- and USD 69 

Course Contents (Click the link below for details)

Advance MS Excel 2013

Course Materials

1. Soft copy course materials will be provided to all participants
2. Excel in MS Excel E Book Amazon coupons will be provided to all participants. 

Excel in MS Excel - Visit Amazon for more details

Training Dates

Weekends (Saturday and Sunday)

Booking Open for Batch 3 - 29th and 30th December 2017 - Hurry Block Your Seat!!!

Course Enrollment

For course enrollment please send the following information in the given email ID.

samrat.biswaas@gmail.com along with the payment confirmation/reference number and amount paid.

Subject: Advance MS Excel 2013| Training Date

Name:

Email ID:

Phone No:

Organization:

Experience in Excel: Foundation/Intermediate?
Preferred Date of Training: (Any weekends)

Any specific features in Excel you are interested in:
Amount Paid:
Payment confirmation Reference Number:

System Requirement

Laptop/Desktop

MS Excel 2013 

Broadband Connection for good internet speed

Payment Mode (NEFT/IMPS)

Samrat Biswas/Excel in MS Excel
Bank: Yes Bank Ltd
Bank Address: 26th Main Road, 9th Block, Bangalore 560011
Account Number: 065390100000612
IFSC Code: YESB0000653

Contact Details

Mobile: +91 8095039316

Email: samrat.biswaas@gmail.com 

Terms and Conditions

1. Training will be provided Online. 
2. Course fee payment to be done in advance to block the seat
3. Within 24 hours of realizing the payment seat blocking confirmation along with Online training link will be provided to all participants.
4. Course materials and Amazon ebook coupon will be provided on the first day of training.
5. In case the trainer is not able to impart the training on the scheduled days for any technical reason and if candidate do not want to participate in the next available dates then the course fees will be refunded with necessary deduction of the ebook and course material cost.

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