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)
Soft copy course materials will be provided to all participants
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
Course fee payment to be done in advance to block the seat
Within 24 hours of realizing the payment seat blocking confirmation along with Online training link will be provided to all participants.
Course materials and Amazon ebook coupon will be provided on the first day of training.
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.
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)
Soft copy course materials will be provided to all participants
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
Course fee payment to be done in advance to block the seat
Within 24 hours of realizing the payment seat blocking confirmation along with Online training link will be provided to all participants.
Course materials and Amazon ebook coupon will be provided on the first day of training.
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.
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
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.
