Studyportals placeholder

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.

About

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.

The Global Study Awards: get funded with up to £10,000 to study abroad

Together with the ISIC Association and British Council IELTS, Studyportals offers you the chance to receive up to £10000 to expand your horizon and study abroad. We want to ultimately encourage you to study abroad in order to experience and explore new countries, cultures and languages.

Wishlist

Did you know you can compare your wishlisted programmes with our new Comparison tool?