# Data Management and Analysis with Advance Excel, Certificate

• Anytime
• 1 day
Duration
Online
This Data Management and Analysis with Advance Excel course at Simpliv 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.
Continue with
or
By registering, you agree to our  Privacy Statement  and  Terms and Conditions.

## Overview

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 Data Management and Analysis with Advance Excel course at Simpliv 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

## Detailed Programme Facts

• Deadline and start date A student can apply at any time for this programme, there is no deadline.
• Programme intensity Part-time
• Average part-time duration 1 days
• Part-time variant
Flexible
• Languages
• English
• Delivery mode
Online

## Programme Structure

Courses include:

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

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

## English Language Requirements

This programme may require students to demonstrate proficiency in English.

## Tuition Fee

• ### International Applies to you

18 USD/full
Tuition Fee
Based on the original amount of 18 USD for the full programme and a duration of 1 days.
• ### National Applies to you

18 USD/full
Tuition Fee
Based on the original amount of 18 USD for the full programme and a duration of 1 days.
We've labeled the tuition fee that applies to you because we think you are from and prefer over other currencies.

## Funding

Studyportals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.