Preface 2nd Edition

The Kindle edition of this book was liked by many individuals. There are multiple different messages and post on Facebook or in Excel in MS Excel blog for another edition of this book with more focus on additional formulas and functions.

Microsoft Excel has more than 300+ formulas included in the 2016 version. However, a few handfuls of them are extremely useful for the readers of this book. I focused only on those formulas which are of frequent use in any form of work.

Hope you all will like reading the new revised edition with more formulas and updated snapshots.

Happy Reading!!

Excel in MS Excel - For Freshers and Professional By Samrat Biswas

This book is aimed for professionals working in any domain where knowledge of MS Excel is of utmost importance. Be it a fresher with MBA and 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, Sparklines, Trace Precedents, Trace Antecedents, Slicers and Timelines are covered in this book.

This is not a typical text book for training MS Excel. This book is written keeping different scenarios in mind of the user. Some key questions which a novice or sometime an experienced person also get in his mind such as-

What Excel feature are to be used in a given situation? How to achieve a certain outcome based on your data availability? How to get your data entered by people so that it can be later easy to analyse the data are addressed with detail explanation.

Practice exercises are also given at the end of all chapters. This book is available in both printed form and Kindle edition. Kindle edition is very handy if one has Kindle monthly subscription.

Advance MS Excel 2013 Course Content

Day 1 (Saturday - 4 Hours)

Protecting and Sharing

• Sharing a file
• Tracking changes
• Accepting or rejecting changes
• Applying Data validation rules
• Inserting comments
• Protecting cells, sheets, files
• Password protecting a file
• Password protecting a cell range

Conditional Formatting/Data Validation

• Update Workbook Properties
• Apply Conditional Formatting
• Add Data Validation Criteria

Functions

• If Statements
• Nested If
• And
• Or
• Not
• Combining If, And, Or, Not
• Sumif
• Countif
• Horizontal Lookup (Hlookup)
• Vertical Lookup (Vlookup)

Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Lookup and Information Functions

• Match function
• Index Function
• IFERROR
• Vlookup, Hlookup
• Database Functions: Dsum, Dmin, Dmax, Daverage, Dcount

Day 2 (Sunday - 4 Hours)

Summarizing Data with Pivot Tables

• Inserting calculated fields
• Manipulating Fields
• Changing Value Field Settings
• Using Report Filter
• Grouping Data containing Dates and Numbers
• Formatting Pivot Table
• Showing and Hiding the Grand Totals
• Refreshing Data In Pivot Table
• Changing The Scope Of The Data source
• Summarizing Values by Sum, Count, Average, Max, and Product
• Show Values As % of Grand Total, % of Column Total, % of Row Total
• Pivot Table Options
• Using Slicers for Effective Filtering
• Pivot Chart

General Analysis Tools

• Scenarios
• Custom Views

Introduction to Macros

• Displaying the Developer Tab
• Review And Purpose Of Macros
• Where To Save Macros
• Absolute and relative record
• Running macros: Assigning to Quick Access Toolbar, 
• shapes, Pictures and keyboard shortcuts

Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform a What-if Analysis
• Perform a Statistical Analysis with the Analysis ToolPak 

Importing and Exporting Data

• Export Excel Data
• Import a Delimited Text File

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