• Post category:StudyBullet-16
  • Reading time:5 mins read


Essential Excel for Data Analysis: Cleaning, Manipulating & Visualizing Data

What you will learn

Introduction to Microsoft Excel

How to use the workspace of MS Excel

Using Basic Formulas and Functions

Data Entry and Formatting

Cell Referencing

Data Management

Chart & Graphs

Data Validation

Description

Hello everyone, welcome to our class of Excel Essential to learn the essentials of the usage of Excel so if you are planning to learn about excel from the beginning than you are in right place because we will cover in this class from the basic to advanced. This is a beginner level class so if you have no previous experience then you can join in this class.

Let’s take a look what you will learn from this class:

1. Introduction to Microsoft Excel

2. How to use the workspace of MS Excel

3. Using Basic Formulas and Functions

4. Data Entry and Formatting

5. Cell Referencing


Get Instant Notification of New Courses on our Telegram channel.


6. Data Management

7. Chart & Graphs

8. Data Validation

After complete this class you will be able to do:

  • You will be able to express your ideas freely
  • You will have the confidence and skills to efficiently use Excel for various tasks
  • You can use basic formulas and functions
  • You will be able to create a strong foundation for more advanced functionalities
  • You will be able to save and share data

This is a project-based class so during learning you will have class project so what you learned you will be able to participate in class project so you can do practice while you are learning. You will have supporting resource in this class so it will be easier for you to learn.

During learning if you face any issue or if you have any question than feel free to ask me, I am always there for you to help you. So let’s start learning Excel Essential together.

English
language

Content

Introduction

Introduction
Introduction to Excel and its interface
Saving data
Errors
Relative Absolute Cell Reference
Switch Cell Row
Logical Functions
IF IFS
Nested IF
Filter Function
Date Function
Time Function
Numbers to Words
Pag Settings Print Settings
Protecting Sharing
Shortcut Keys
Basic Accounting Functions
Sort, Filter and Chart
Vlookup Hlookup
Sum Count Functions
Count IF
Min, max, small large function
Median Mode
Using if with basic functions
Making a Marksheet
Left, Right, MID, Rept LEN
Round function
Match
Index TRIM
Index Match Function
Class Project 1
Class Project 2