Learn and Master Excel functions and tools for data analytics. Course compatible with Excel 2007, 2010, 2013 & 2016, Created by Sam Parulekar
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
Who is the target audience?
- 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
Preview This Course - GET COUPON CODE
0 Response to "Data Management and Analysis with Advance Excel"
Post a Comment