Microsoft Excel: Functions and Analysis Tools

categories: Technology, Science & Productivity

Data

Software

MS Excel

SDG 8: Decent Work and Economic Growth

By the end of this course, you will be able to

How to use Microsoft Excel to perform various practical mathematical equations and extract results from the reports by understanding how to use the Excel tools.
How to use pivot tables, analyze data in the table, and analyze these tables to forecast a future analysis using analysis tools to help in the decision-making process.
How to make a set of equations to help you to accomplish the work in efficiently, such as sum, the sum in the case of a condition and advanced formulas.

Course details

1 h 1 m/18 lessons
Last updated: 28/10/2020
7 Quiz
Course completion certificate

Course Content

Free lessons

Building Advanced Excel Equations and Formula Part 1

6 Minutes

Quizzes

Building Advanced Formula and Equations Part 2 (Count - Count if - Count ifs )

3 Minutes

Quizzes

1. Microsoft Excel: Functions and analysis tools

Building Advanced Excel Equations and Formula Part 1

6 Minutes

Quizzes

Building Advanced Formula and Equations Part 2 (Count - Count if - Count ifs )

3 Minutes

Quizzes

Building Advanced Formula and Equations Part 3 (Max - Min - Small - Large )

3 Minutes

Quizzes

Building Advanced Formula and Equations Part 4 (Vlookup)

3 Minutes

Building Advanced Formula and Equations Part 5 (Vlookup)

2 Minutes

Quizzes

Building Advanced Formula and equations Part 6 ( Match - Index )

3 Minutes

Quizzes

Advanced Excel Tools : Tables

Table Styles and Formats

3 Minutes

Table Dynamic Range

3 Minutes

10.

Table Formulas Building

5 Minutes

11.

Table Filters Options

4 Minutes

Quizzes

12.

Pivot Table Tools

3 Minutes

13.

Pivot Table Calculated Fields

2 Minutes

14.

Pivot Table : Show Value As Tool

2 Minutes

15.

Pivot Table Filter Options

2 Minutes

16.

Pivot Charts

4 Minutes

Quizzes

17.

What If Analysis : Goal Seek Tool

2 Minutes

18.

What if Analysis : Data Table Tool

4 Minutes

About this course

Excel is a key for the success of a business, the amount of data stored and functions that can be done through excel is endless. This course is designed to provide you with an understanding of how to use the different functions and when, according to your needs. Using the Microsoft Excel program in making different equations and analysis is necessary for your job or business nowadays, especially for decision making. You will learn to practice Excel in a simple, straightforward way.