Learn Excel From Beginner To Advance With Example

Function today() and Equation additing Preview 07:27

Function today() and basic of equation

Command Dollar {$} understanding Preview 05:03

Understand and proper practise of use of command $.

Data Validation - Drop Down List creation Preview 07:15

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

IF, Nested if, if(And) command Preview 20:29

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.

Use of Conditional Formatting with Example Preview 08:31

Understand the better way by taking example of conditional formatting.

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

Conditional Formatting - Manage Rule Preview 02:29

Understand the tab of conditional formatting - Manage rule.

Can you automate the boarder? (Wherever data is available - Auto border)

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.

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

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

Remove Duplicates value in Excel Preview 03:42

Understand in easy way to remove duplicates in Excel.

Automate Boarder - Where data available Preview 02:44

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

Understanding of VLOOKUP Preview 04:26

Understand VLookup.

Index - Match equation Preview 07:41

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

More about Nested if - Example Preview 06:04

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.

Data Filter - Analyse data Preview 06:30

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

Briefing video - Download file Preview 03:09

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.

Analytical Dashboard Layout Preview 07:16

Analytical Dashboard Layout creation in easy way.

Calculate the data for Dashboard Preview 12:34

Calculate the data under dashboard.

One additional Assignment is given - Try by your self.

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

Solution to the question - Under Dashboard Preview 03:02

Here is the solution to calculate the values of Dashboard.

Bar Chart - Dashboard Preview 05:14

Understand the Bar chart for dashboard.

Pie Chart - Dashboard Preview 08:01

Understand the PIE CHART and its element in easy way.

Quick Revision - Download attachment for reference Preview 01:56

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

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

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

VBA Form Creation Preview 08:23

Create User Input Form in Easy Way.

Coding to the Submit Button Preview 13:46

Add Code to the Submit button.

Find out the code under the Resources.

For any Query drop under Q&A.

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

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

Find out the code under the Resources.

For any Query drop under Q&A.

Code to Open up outlook and Send Mail Preview 17:08

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.

Create Email Body by Code Preview 22:47

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.

Easy Explanation of VBA code Preview 06:40

Understand the VBA by example.

Explanation of Email body and codding.

Shorting out issues and take trial Preview 11:51

Short out issue under the coding, and lets try.

Password Protected Mail shooting Preview 05:25

Convert direct mail shooting to Password protected mail shooting.

Download Final Excel Sheet Preview 00:58

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

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