Study Learn Grow
Data Management and Analysis with Advance Excel

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.

Overview

About this Course
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

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

Course Information

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

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

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

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs