Studyportals
Certificate Online

Data Management and Analysis with Advance Excel

Simpliv

Unknown
Duration
Unknown
Tuition fee
Unknown
Unknown
Apply date
Unknown
Unknown
Start date

About

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. 

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 from Simpliv you'll be writing robust, elegant formulas and functions which would help you to analyze data.

What will you 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

Programme Structure

Courses include:

  • 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

Key information

Start dates & application deadlines

You can apply for and start this programme anytime.

Language

English

Delivered

Online

Academic requirements

We are not aware of any academic requirements for this programme.

English requirements

We are not aware of any English requirements for this programme.

Other requirements

General requirements

  • 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

Tuition Fee

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.

Fresh content

Updated in the last 6 months

Check the official programme website for potential updates.

Our partners

Data Management and Analysis with Advance Excel
-
Simpliv

Wishlist

Go to your profile page to get personalised recommendations!