Data Management and Analysis with Advance Excel

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 or Counta or Countif or Countifs
• Sum or sumif or 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

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

Course Completion Certificate

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

Curriculum:

• Introduction
• Data Tools
• Subtotalling Data
• Summarizing Data through Pivot Tables
• Special Functions
• Macros and Mail Merge

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.