Data Management and Analysis with Advance Excel

(Instant booking on GulfTalent)
Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Course Fee
$15

Course 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 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 should take this course

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

Accreditation

Course Completion Certificate

Course content

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

About Course Provider

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.

How to enroll?

You can book the course instantly by paying on GulfTalent.

(Instant booking on GulfTalent)

Frequently asked questions

{{ item.question }}