4.22 out of 5
4.22
1660 reviews on Udemy

Learn Excel from beginner to advance with Example

For every beginner
Instructor:
Meet Doshi
93,106 students enrolled
English [Auto]
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

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…

Introduction

1
Introduction to the course

Introductory lesson. You will go through each and every steps in details, which are shown in the video.

Enrol Now..

Enjoy Now...

2
Hands on experience to the excel with understanding of shortcuts

Hands on experience to the excel with understanding of,

F2  ---   To edit particular cell

Ctrl + Z -- Undo

Ctrl + Y -- Redo

Shift + Space-bar -- TO select entire row

Ctrl + Space-bar -- To select entire column

Ctrl + "+" -- Addition row / column

Ctrl + "-" -- Delete row / Column

Ctrl + C -- Copy

Ctrl + V -- Paste

Ctrl + B -- Bold


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

Data Filtration and Border with Fotomat Painter, with short cuts of,

Altr + H + O + I -- Fit column width

Altr + H + O + A -- Fit to row width

Altr + H + B + A -- Border

Altr + H + B + N -- To remove border


4
Home Tab Overview

Home Tab overview and different commands available in excel.

5
Attachment format

Download attachment, practise as much as you can, and get ready for next lecture.

ALL THE BEST.

Basic Excel Function and Equations (if)

1
Function today() and Equation additing

Function today() and basic of equation

2
Command Dollar {$} understanding

Understand and proper practise of use of command $.

3
Data Validation - Drop Down List creation

Understand the use of data validation and drop down list creation.

4
IF, Nested if, if(And) command

Learn IF, Nested If and if-and statement by example.


Video is long, but proper explanation is given in layman language. Please watch, and practise as much as you can.

More about Excel - Conditional formatting, remove duplicates, Automate border

1
Use of Conditional Formatting with Example

Understand the better way by taking example of conditional formatting.


Practise by your self, for any query drop in Q&A.


2
Conditional Formatting - Manage Rule

Understand the tab of conditional formatting - Manage rule.

3
Can you automate the boarder? (Wherever data is available - Auto border)
4
if statement use for mail shooting - VBA lecture

We are going to use this generated data while shooting email by VBA.

5
Remove Duplicates value in Excel

Understand in easy way to remove duplicates in Excel.

6
Automate Boarder - Where data available

Automate the border where ever data is available and see magic.

Data filter using Vlookup, Index-Match, Filter data.

1
Understanding of VLOOKUP

Understand VLookup.

2
Index - Match equation

Understand the use of Index - Match syntax, Practise as much as you can.

3
More about Nested if - Example

Based on Students request, here is one more example of Nested If.


Request you to practise as much as you can. If any Query ask in Q&A Section.

4
Data Filter - Analyse data

Strong and power full tool to Analyse the data - Data filter

5
Briefing video - Download file

What we have done till now, I am taking and revising within 3 min. Just check once. Download excel file. For any query drop question under Q&A.

Create Analytical DashBoard

1
Analytical Dashboard Layout

Analytical Dashboard Layout creation in easy way.

2
Calculate the data for Dashboard

Calculate the data under dashboard.

One additional Assignment is given - Try by your self.

Understand the use of Countif, CountA, Sum, Freezing pan.

3
Solution to the question - Under Dashboard

Here is the solution to calculate the values of Dashboard.

4
Bar Chart - Dashboard

Understand the Bar chart for dashboard.

5
Pie Chart - Dashboard

Understand the PIE CHART and its element in easy way.

6
Quick Revision - Download attachment for reference

Quick briefing what we done till now, and downloadable resources.

User Input From Creation And Coding

1
Enable Developer Tab and Saving under Macro enabled file

Enable Developer tab under options menu and save excel sheet under macro enabled workbook.

2
VBA Form Creation

Create User Input Form in Easy Way.

3
Coding to the Submit Button

Add Code to the Submit button.

Find out the code under the Resources.

For any Query drop under Q&A.

4
Coding to Close, Clear & Goto Main Page

Fundamentals of codding for Close, Clear & Goto Main Page Button.

Find out the code under the Resources.

For any Query drop under Q&A.

5
Code to Open up outlook and Send Mail

Understanding of VBA coding to send email from Outlook directly from Excel.

Code to open Outlook.

Find out the code under the Resources.

For any Query drop under Q&A.

6
Create Email Body by Code

Understanding of VBA coding to send email from Outlook directly from Excel.

Code to Create Email Body.

Find out the code under the Resources.

For any Query drop under Q&A.

7
Easy Explanation of VBA code

Understand the VBA by example.

Explanation of Email body and codding.

8
Shorting out issues and take trial

Short out issue under the coding, and lets try.

9
Password Protected Mail shooting

Convert direct mail shooting to Password protected mail shooting.

10
Download Final Excel Sheet

Download final excel which we have created in the lecture series from the resources.

Conclusion

1
Conclusion

At the last,

What we have learnt under this full lecture series, we have covered under this video.

Hope you get all the concepts with fundamentals.

Still you have query, you can ask me any time.

So finally you have completed  Learn Excel from Beginner to Advance with Example Cousre.

And with the help of fundamentals, Now you are ready to Rock.

All the best - you excel expert... ! :)



You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.2
4.2 out of 5
1660 Ratings

Detailed Rating

Stars 5
577
Stars 4
601
Stars 3
359
Stars 2
75
Stars 1
48
1f8034f172e4a54d6c7fb619ff3dac28
30-Day Money-Back Guarantee

Includes

5 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Don't Miss Any Course Join Our Telegram Channel Join Channel
+ +