The Ultimate Microsoft Excel: Essential Comprehensive Guide

Language: English
Created by: Sayman Creative Institute
Rate: 4.2 / 16 ratings
Enroll: 4,035 students

What you’ll learn

Introduction to MS Excel
Understanding the Alignment Box
Doing Calculations in Excel
Project on Making a result sheet
Using the IF function
Number formatting in Excel
Making Tables in Excel
Inserting Images in Excel
Project on how to do Data Entry at Ease
Using the SUMIF function
Highlighting the Text Cells
Using the IF function with AND and OR
Essential 10 functions for work in Excel

Requirements

Basic Computer Skill

Description

Hello everyone welcome to our class of MS Excel for learning Data Management so if you are planning to learn MS 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.

Lets take a look what you will learn from this class:

1. Introduction to MS Excel

2. Understanding the Alignment Box

3. Doing Calculations in Excel

4. Project on Making a result sheet

5. Using the IF function

6. Number formatting in Excel

7. Making Tables in Excel

8. Inserting Images in Excel

9. Project on how to do Data Entry at Ease

10. Using the SUMIF function

11. Highlighting the Text Cells

12. Using the IF function with AND and OR

13. Essential 10 functions for work in Excel

After complete this class you will be able to

– Understand the Interface

– Data Entry

– Basic formulas and functions

– Formatting and Styling

– Sorting and Filtering Data

– Basic Data Analysis

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 lets start learning MS Excel for Data Management together.