Disclosure: when you buy through links on our site, we may earn an affiliate commission.

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
4.5
4.5/5
(71 reviews)
251 students
Created by

9.6

CourseMarks Score®

9.4

Freshness

9.7

Feedback

9.1

Content

Platform: Udemy
Video: 6h 57m
Language: English
Next start: On Demand

Table of contents

Description

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

You will learn

✓ After taking the course the students would be able to do Autofill, Data Validation
✓ Analytical Functions like – Goal Seek, Scenario Manager and Data table
✓ Functions like PMT, Vlookup, Hlookup, Multiple vlookup, Identifying and deleting duplicates
✓ Importing and exporting data, creating subtotal based reports
✓ Pivot tables, Pivot Charts
✓ Functions like count, countif, countifs, sum, sumif,sumifs,
✓ Introduction to basic Macros and Mail Merge
✓ Fun, interactive, and highly effective lessons from a best-selling Excel instructor.
✓ Unique tips, tools and case studies that you won’t find in ANY other course.
✓ Lifetime access to reference materials and practice files

Requirements

• 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 for

• 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
• Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

How much does the Data Management and Analysis with Advance Excel course cost? Is it worth it?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $19.99. So you save $5 if you enroll the course now.
The average price is $17.3 of 923 Excel courses. So this course is 13% cheaper than the average Excel course on Udemy.

Does the Data Management and Analysis with Advance Excel course have a money back guarantee or refund policy?

YES, Data Management and Analysis with Advance Excel has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Data Management and Analysis with Advance Excel course, but there is a $5 discount from the original price ($19.99). So the current price is just $14.99.

Who is the instructor? Is Sam Parulekar a SCAM or a TRUSTED instructor?

Sam Parulekar has created 23 courses that got 242 reviews which are generally positive. Sam Parulekar has taught 799 students and received a 4.2 average review out of 242 reviews. Depending on the information available, Sam Parulekar is a TRUSTED instructor.
Trainer
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.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 6h 57m
Language: English
Next start: On Demand

Students are also interested in