Data Management and Analysis with Advance Excel

Learn and Master Excel functions and tools for data analytics. Course compatible with Excel 2007, 2010, 2013 & 2016

Instructed by Sam Parulekar

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I would teach you on how to apply the formula and understand its business and analytical application as well. By the end of the course you'll be writing robust, elegant formulas and functions which would help you to analyze data by allowing you to: Understanding basics: AutoFill a Series Creating a Custom List Data Tools Data Validation Drop-Down Lists Text to Columns pmt Goal Seek Scenario Manager Data Table Vlookup hlookup Importing and Exporting Data Identifying and deleting duplicates Outline, Sort, Filter and Subtotal Introduction Group and Ungroup and subtotals Subtotals Consolidate Pivot Tables Introduction Creating Pivot Tables Choosing Fields Pivot Table Layout Filtering Pivot Tables Modifying Pivot Tables Data Pivot Charts Special Functions Count / Counta / Countif / Countifs Sum /sumif / sumifs Macros Mail merge

This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I would teach you on how to apply the formula and understand its business and analytical application as well.

By the end of the course you'll be writing robust, elegant formulas and functions which would help you to analyze data by allowing you to:

Understanding basics:

  • AutoFill a Series

  • Creating a Custom List

Data Tools

  • Data Validation

  • Drop-Down Lists

  • Text to Columns

  • pmt

  • Goal Seek

  • Scenario Manager

  • Data Table

  • Vlookup

  • hlookup

  • Importing and Exporting Data

  • Identifying and deleting duplicates

 Outline, Sort, Filter and Subtotal

  • Introduction

  • Group and Ungroup and subtotals

  • Subtotals

  • Consolidate

 Pivot Tables

  • Introduction

  • Creating Pivot Tables

  • Choosing Fields

  • Pivot Table Layout

  • Filtering Pivot Tables

  • Modifying Pivot Tables Data

  • Pivot Charts

Special Functions

  • Count / Counta / Countif / Countifs

  • Sum /sumif / sumifs

 Macros

 Mail merge

  • Microsoft Excel should be installed on your system,
  • This course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016
  • Some experience with basic formulas is recommended, but not required.
  • This course is suitable for any individual who wants to go beyond the basics of Excel and learn to master excel.
  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
View More...

Section 1 : Introduction

  • Lecture 1 :
  • Lecture 2 :
  • Autofill Data and Creating Custom Lists

Section 2 : Data Tools

  • Lecture 1 :
  • Data Validation
  • Lecture 2 :
  • PMT function
  • Lecture 3 :
  • Data Table
  • Lecture 4 :
  • Scenario Manager
  • Lecture 5 :
  • Goal Seek
  • Lecture 6 :
  • Vlookup, Hlookup
  • Lecture 7 :
  • Approximate Vlookup
  • Lecture 8 :
  • Multiple Vlookup
  • Lecture 9 :
  • Identifying and Deleting Duplicates

Section 3 : Subtotaling Data

  • Lecture 1 :
  • Data Subtotal
  • Lecture 2 :
  • Data Consolidate

Section 4 : Summarizing Data through Pivot Tables

  • Lecture 1 :
  • Branchwise Pivot
  • Lecture 2 :
  • Datewise Pivot
  • Lecture 3 :
  • Count of Account Types Pivot
  • Lecture 4 :
  • Bucketwise Pivot
  • Lecture 5 :
  • Pivot with Conditional Formatting
  • Lecture 6 :
  • Pivot Graphs

Section 5 : Special Functions

  • Lecture 1 :
  • Count, Countif and Countifs
  • Lecture 2 :
  • Sum, Sumif and Sumifs

Section 6 : Macros and Mail Merge

  • Lecture 1 :
  • Creating and Editing a Simple Data Entry Macro
  • Lecture 2 :
  • How to Mail Merge using Word and Excel
  • Lecture 3 :
  • How to Mail Merge to Email

Sam Parulekar,

Sam Parulekar is the founder and CEO of I-MIND Training Solutions and Consultancy. He is a graduate from Mumbai University. After gaining sufficient applauds on the training front, he identified that he is destined for training and there was no looking back from that point on wards. In 1992, he started his own training institute which ran successfully for 13 years, making its mark as pioneers in Computer Training. Later he took a brief sabbatical and worked as a Training Manager in Wipro. He resigned in 2012 when he decided that it is better to build his own dream. He strongly believes in the maxim that “If you are not busy building your own dream, you would be busy building others dream”. During his two decades of experience he has trained many corporate and individuals in Computer and Behavioral programs. He has also helped many small scale companies set up and establish their brands. He feels that it is time to redeem and wants to share his experience and help others build their dreams. He is also a certified Yoga Teacher and strives to implement yoga principles in his training programs so that the participants become more receptive and better healthy individuals. He has written more than 20 books on management and behavioral topics which are available on internet sites. He is an ardent lover of music and reads voraciously. In his spare time he is either writing books or composing music on his piano, guitar and flute. He lives in Mumbai with his wife Harshada and his mother.
View More...
vba-web-connect-ms-office-to-the-web

VBA WEB - Connect MS Office to the ...

By : Daniele Protti

Lecture 223

excel-vba-from-beginner-to-expert

Excel VBA from Beginner to Expert

By : Daniele Protti

Lecture 66

excel-tips-and-tricks

Excel tips and Tricks

By : Muhammad Ali Yasin

Lecture 16

microsoft-powerpoint-2016-self-publishing-ebook-book-covers

Microsoft PowerPoint 2016 Self-publ...

By : Brian Jackson

Lecture 34

powerpoint-2013-2016-beginner-to-advanced-with-animation

PowerPoint 2013/2016 Beginner to Ad...

By : Brian Jackson

Lecture 114

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password