Free Udemy Courses
Trending

Learn Excel from beginner to advance with Example

PUBLISHER :- Meet Doshi

LANGUAGE :- English

PRIZE :- 43.39$ 0$

Learn Excel from beginner to advance with Example

WHO CAN ACCESS THIS COURSE :-

  • 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

WHAT ARE YOUR REQUIREMENTS FOR THIS COURSE ?

  • No prior knowledge is required
  • Any Fresher to the Excel

WHAT YOU ARE GOING TO LEARN FROM THIS COURSE ?

  • 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 exce

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…

COURSE CONTENT

  • 7 sections • 36 lectures • 4h 31m total length

Introduction5 lectures • 40min

  • Introduction to the coursePreview06:20
  • Hands on experience to the excel with understanding of shortcutsPreview11:08
  • Data filtration, Border, Sr No., Format Painter10:46
  • Home Tab Overview10:04
  • Attachment format02:07

Basic Excel Function and Equations (if)4 lectures • 40min

  • Function today() and Equation additing07:27
  • Command Dollar {$} understanding05:03
  • Data Validation – Drop Down List creation07:15
  • IF, Nested if, if(And) command20:29

More about Excel – Conditional formatting, remove duplicates, Automate border5 lectures • 22min

  • Use of Conditional Formatting with Example08:31
  • Conditional Formatting – Manage Rule02:29
  • Can you automate the boarder? (Wherever data is available – Auto border)2 questions
  • if statement use for mail shooting – VBA lecture04:13
  • Remove Duplicates value in Excel03:42
  • Automate Boarder – Where data available02:44

Data filter using Vlookup, Index-Match, Filter data.5 lectures • 28min

  • Understanding of VLOOKUP04:26
  • Index – Match equation07:41
  • More about Nested if – Example06:04
  • Data Filter – Analyse data06:30
  • Briefing video – Download file03:09

Create Analytical DashBoard6 lectures • 38min

  • Analytical Dashboard Layout07:16
  • Calculate the data for Dashboard12:34
  • Solution to the question – Under Dashboard03:02
  • Bar Chart – Dashboard05:14
  • Pie Chart – Dashboard08:01
  • Quick Revision – Download attachment for reference01:56

User Input From Creation And Coding10 lectures • 1hr 35min

  • Enable Developer Tab and Saving under Macro enabled file02:29
  • VBA Form Creation08:23
  • Coding to the Submit Button13:46
  • Coding to Close, Clear & Goto Main Page05:17
  • Code to Open up outlook and Send Mail17:08
  • Create Email Body by Code22:47
  • Easy Explanation of VBA code06:40
  • Shorting out issues and take trial11:51
  • Password Protected Mail shooting05:25
  • Download Final Excel Sheet00:58

Conclusion1 lecture • 8min

  • ConclusionPreview08:07

HOW TO MAKE MONEY ONLINE & TIPS AND TRICKS

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker