Learn Excel from beginner to advance with Example

For every beginner

3.87 (1884 reviews)
Udemy
platform
English
language
Other
category
instructor
students
4.5 hours
content
May 2021
last update
regular price

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

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...



Screenshots

Learn Excel from beginner to advance with ExampleLearn Excel from beginner to advance with ExampleLearn Excel from beginner to advance with ExampleLearn Excel from beginner to advance with Example

Content

Introduction
Introduction to the course
Hands on experience to the excel with understanding of shortcuts
Data filtration, Border, Sr No., Format Painter
Home Tab Overview
Attachment format
Basic Excel Function and Equations
Function today() and Equation additing
Command Dollar {$} understanding
Data Validation - Drop Down List creation

Reviews

P.Rajashekar
24 August 2021
I found it useful to learn the advanced excel with vba coding of mail shooting it gave me an idea on how the code works.
Abdul
10 May 2021
This is a very amazing course, I have learnt so many cool tricks and awesome techniques as well as I have learned how to code.
Preetpalkaur
20 April 2021
Yes, extremely pleased with the content and the tutor's slow teaching which makes it easy to understand. Thanks for this course.
Wayne
21 February 2021
This course is a good match I am learning so much more information on being more efficient and knowledgeable about Excel spread sheets
Dashrath
16 January 2021
Explanation of the course is very good that any individuals who are very new to MS.Excel can also follow the course content easily.
Claudia
5 January 2021
In terms of content, the lesson was appropriate for me. For total beginners it might have been too fast. Unfortunately, the English, especially in the pronunciation, is poor. I often don't understand it and have to rewind.
Gustavo
14 December 2020
El contenido practico es bueno. El curso toma por hecho el conocimiento básico en Visual Basic aunque no lo especifique en la descripción. El ingles del profesor puede ser un poco difícil de entender por momentos. En definitiva, deja buenas enseñanzas practicas pero el contenido no esta brindado de la forma mas clara posible.
Karamat
12 December 2020
Teaching method is overall good but the communication and words that are explained is not been catch up to students i.e. Me. Fluency is the key to understanding things that are explained to get the particular topics.
AdityaVarma
8 November 2020
For beginners this tutorial would be nice boost and a better learning platform. There should be some detailing about macros and VBA so you can increase the lectures and define the reason you are writing the macros and also how to use and where to use
Yogesh
4 November 2020
It is a good course to learn excel from beginner to intermediate level only. The advance level is bit fast and selective to some topics only. The creator could have made advance level slightly easy and cover other concepts as well.
Ayokunnu
4 November 2020
There is need for cohesiveness by the instructor has he need to explain better for someone learning will understand.
Shresth
4 November 2020
it was not good because in many videos the visuals were not clear and in many places the English of the tutor was also not clear
Olagunju
25 September 2020
I did enjoy this lectures..... I grab easy ways; shut-cuts to working and using excel quickly to handle my work. Thanks
Maitry
25 September 2020
I got to learn about the short cut keys, I have learned and memorize the shortcut keys it will help me a lot in my project completion faster
Fhiline
21 August 2020
Too Much Information!!! I am learning a lot!!! I can say that i will be expert in excel after this!! I will surely practice the codings....

Charts

Price

Learn Excel from beginner to advance with Example - Price chart

Rating

Learn Excel from beginner to advance with Example - Ratings chart

Enrollment distribution

Learn Excel from beginner to advance with Example - Distribution chart

Coupons

DateDiscountStatus
5/1/2020100% OFF
expired
5/2/2020100% OFF
expired
5/8/2020100% OFF
expired
6/5/2020100% OFF
expired
6/18/2020100% OFF
expired
6/28/2020100% OFF
expired
7/12/2020100% OFF
expired
7/26/2020100% OFF
expired
8/12/2020100% OFF
expired
8/17/2020100% OFF
expired
8/25/2020100% OFF
expired
9/24/2020100% OFF
expired
9/30/2020100% OFF
expired
10/6/2020100% OFF
expired
10/16/2020100% OFF
expired
10/27/2020100% OFF
expired
1/20/2021100% OFF
expired
4/11/2021100% OFF
expired
4/15/202146% OFF
expired
10/14/2021100% OFF
expired
2996272
udemy ID
4/13/2020
course created date
5/1/2020
course indexed date
Lee Jia Cheng
course submited by
TwitterTelegramTelegram