IT & Software
Other
Excel Dashboard
Learn Excel from beginner to advance with Example
4.1 (708 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
43,305 students enrolled

Learn Excel from beginner to advance with Example

For every beginner
4.1 (708 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
43,305 students enrolled
Created by Meet Doshi
Last updated 5/2020
English
English [Auto]
Preview this course
Learn Excel from beginner to advance with Example
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 36 lectures 04:31:02
+ – Introduction
5 lectures 40:25

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

Enrol Now..

Enjoy Now...

Introduction to the course
Preview 06:20

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


Hands on experience to the excel with understanding of shortcuts
Preview 11:08

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


Data filtration, Border, Sr No., Format Painter
10:46

Home Tab overview and different commands available in excel.

Home Tab Overview
10:04

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

ALL THE BEST.

Attachment format
02:07
+ – Basic Excel Function and Equations (if)
4 lectures 40:14

Function today() and basic of equation

Function today() and Equation additing
07:27

Understand and proper practise of use of command $.

Command Dollar {$} understanding
05:03

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

Data Validation - Drop Down List creation
07:15

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.

IF, Nested if, if(And) command
20:29
+ – More about Excel - Conditional formatting, remove duplicates, Automate border
5 lectures 21:39

Understand the better way by taking example of conditional formatting.


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


Use of Conditional Formatting with Example
08:31

Understand the tab of conditional formatting - Manage rule.

Conditional Formatting - Manage Rule
02:29
You have to apply Conditional formatting, and by doing so, wherever data is available outside boarder must be created automatically. Try by your self for practise. This is 10 minute task, challenge yourself and best luck.
Can you automate the boarder? (Wherever data is available - Auto border)
2 questions

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

if statement use for mail shooting - VBA lecture
04:13

Understand in easy way to remove duplicates in Excel.

Remove Duplicates value in Excel
03:42

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

Automate Boarder - Where data available
02:44
+ – Data filter using Vlookup, Index-Match, Filter data.
5 lectures 27:50

Understand VLookup.

Understanding of VLOOKUP
04:26

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

Index - Match equation
07:41

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.

More about Nested if - Example
06:04

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

Data Filter - Analyse data
06:30

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.

Briefing video - Download file
03:09
+ – Create Analytical DashBoard
6 lectures 38:03

Analytical Dashboard Layout creation in easy way.

Analytical Dashboard Layout
07:16

Calculate the data under dashboard.

One additional Assignment is given - Try by your self.

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

Calculate the data for Dashboard
12:34

Here is the solution to calculate the values of Dashboard.

Solution to the question - Under Dashboard
03:02

Understand the Bar chart for dashboard.

Bar Chart - Dashboard
05:14

Understand the PIE CHART and its element in easy way.

Pie Chart - Dashboard
08:01

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

Quick Revision - Download attachment for reference
01:56
+ – User Input From Creation And Coding
10 lectures 01:34:44

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

Enable Developer Tab and Saving under Macro enabled file
02:29

Create User Input Form in Easy Way.

VBA Form Creation
08:23

Add Code to the Submit button.

Find out the code under the Resources.

For any Query drop under Q&A.

Coding to the Submit Button
13:46

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

Find out the code under the Resources.

For any Query drop under Q&A.

Coding to Close, Clear & Goto Main Page
05:17

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.

Code to Open up outlook and Send Mail
17:08

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.

Create Email Body by Code
22:47

Understand the VBA by example.

Explanation of Email body and codding.

Easy Explanation of VBA code
06:40

Short out issue under the coding, and lets try.

Shorting out issues and take trial
11:51

Convert direct mail shooting to Password protected mail shooting.

Password Protected Mail shooting
05:25

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

Download Final Excel Sheet
00:58
+ – Conclusion
1 lecture 08:07

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... ! :)



Conclusion
Preview 08:07