Learn Excel from beginner to advance with Example

Name: Learn Excel from beginner to advance with Example
Rating: 4.2 (1931 reviews)

For every beginner

(1,931 ratings)

105,386 students

Created by Meet Doshi

Last updated 6/2022

English

English [Auto]

What you'll learn

Basic excel equations widely used in
Email shooting by using VBA Directly from excel to specific users
Hands on experience to the excel with understanding of shortcuts
Analytical dashboard creation
Data filtration, Border, Sr No., Format Painter
Codes used in VBA
Function today() and Equation additing
Command Dollar {$} understanding
Data Validation - Drop Down List creation
IF, Nested if, if(And) command
Use of Conditional Formatting with Example
Remove Duplicates value in Excel
Automate Boarder - Where data available
Understanding of VLOOKUP
Index - Match equation
Data Filter - Analyse data
Bar Chart, Pie Chart Creation - Dashboard
VBA Form Creation
Password Protected Mail shooting directly from excel

Requirements

No prior knowledge is required
Any Fresher to the Excel

Description

In this course you are going to learn, daily excel equations which are widely used in daily life with short cut. No prior knowledge is required. We have taken example to teach easily so one can learn from basic with example.

You are going to learn : -

1. Basic excel equations widely used in

2. Hands on experience to the excel with understanding of shortcuts

3. Analytical dashboard creation

4. Data filtration, Border, Sr No., Format Painter

5. Email shooting by using VBA from excel to specific users

6. Codes used in VBA

7. Data Validation - Drop Down List creation

8. IF, Nested if, if(And) command

9. Use of Conditional Formatting with Example

10. Remove Duplicates value in Excel

11. Linking from excel to mail (You can shoot mail by clicking button from excel directly)

12. Bar Chart, Pie Chart Creation - Dashboard

13. Understanding of VLOOKUP

14. Index - Match equation

15. Data Filter - Analyse data

16. Password Protected Mail shooting directly from excel

17. And many more...

Who this course is for:

Beginners to the excel
College students
To become expert in excel
Who wants to learn excel from basic, and want to become expert
Want to understand the real life corporate situation and solve from the basic

Meet Doshi

Engineer

4.2 Instructor Rating
1,931 Reviews
105,386 Students
1 Course

I am a Mechanical Engineer. And healthy knowledge in advanced excel. I always wanted to teach every one. Share knowledge and gain knowledge is best thing which I personally like. Preparing the course in excel is my prime motive. Always ready to help.

I always prefer to teach from scratch, so one can easily understand the basic and can apply the fundamentals in real life. I personally prefers that real life example can teach in easy way and that is why i prefers to take example in my course.