Placeholder image for Data Management and Analysis with Advance Excel

Data Management and Analysis with Advance Excel, Certificate

  • Anytime
    Application Deadline
  • 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.
Access all 180000+ programmes, for free with a Studyportals account.
account benefits visualised
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

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

    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.

Let us fund your studies abroad!

Apply to The Global Study Awards and get the chance to receive up to £10000 for your study abroad! This funding is powered by ISIC, British Council, IELTS and Studyportals.

Tell me more
Global Study Awards

Wishlist

You’ve wishlisted multiple studies. Did you know you can compare them side-by-side in our Compare-tool?