Data Management and Analysis with Advance Excel

[LeeAndro]

Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | SRT | Size: 1.13 GB | Duration: 2h 10m

Fun, interactive, and highly effective lessons from a best-selling Excel instructor.

What you'll 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

Unique tips, tools and case studies that you won't find in ANY other course.

Life 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.

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



DOWNLOAD
uploadgig

https://uploadgig.com/file/download/C9eF4Dd264161Fcd/R9FLlxhR__Data_Manag.part1.rar
https://uploadgig.com/file/download/1ac09f46bFaAbefc/R9FLlxhR__Data_Manag.part2.rar

rapidgator

https://rapidgator.net/file/a5023cb46dbb18c376e837c3b529b75c/R9FLlxhR__Data_Manag.part1.rar.html
https://rapidgator.net/file/255b062fc2e9f9d4bccf5d9bc06173a4/R9FLlxhR__Data_Manag.part2.rar.html

nitroflare

http://nitroflare.com/view/181C6E6C87D3F86/R9FLlxhR__Data_Manag.part1.rar
http://nitroflare.com/view/C0583FEEC89C5E3/R9FLlxhR__Data_Manag.part2.rar