When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
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
This Course Includes
udemy
3.2 (103 reviews )
6h 57m 
english
Online - Self Paced
professional certificate
Udemy
About Data Management and Analysis with Advance Excel
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_
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
What 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.