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. Example here taken to send email to the specific person directly from excel by using one button and navigating to the outlook in easy way.
You are going to learn
1. Basic excel equations widely used in
2. Hands on experience to the excel with understanding of basic and widely use shortcuts
3. Analytical dashboard creation – Pie chart, Bar chart
4. Data filtration, Border, Sr No., Format Painter
5. Email shooting by using VBA from excel to specific users from outlook using single button
6. Codes used in VBA
7. Data Validation – Drop Down List creation
8. IF, Nested if, if(And) command as a equation
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 for arranging and fetching right data
15. Data Filter – Analyze data
16. Password Protected Mail shooting directly from excel
17. And many more new things covered
Basic Excel Function and Equations (if)
-
1Introduction to the course
Introductory lesson. You will go through each and every steps in details, which are shown in the video.
Enroll Now..
Enjoy Now...
-
2Hands 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
-
3Data 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
-
4Home Tab Overview
Home Tab overview and different commands available in excel.
-
5Attachment format
Download attachment, practise as much as you can, and get ready for next lecture.
ALL THE BEST.
More about Excel - Conditional formatting, remove duplicates, Automate border
-
6Function today() and Equation additing
Function today() and basic of equation
-
7Command Dollar {$} understanding
Understand and proper practise of use of command $.
-
8Data Validation - Drop Down List creation
Understand the use of data validation and drop down list creation.
-
9IF, 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.
Data filter using Vlookup, Index-Match, Filter data.
-
10Highlight cell which contains - by Conditional Formatting
Understand the better way by taking example of conditional formatting.
Practise by your self, for any query drop in Q&A.
-
11Conditional Formatting - Manage Rule
Understand the tab of conditional formatting - Manage rule.
-
12Can you automate the boarder? (Wherever data is available - Auto border)
-
13if statement use for mail shooting - VBA lecture
We are going to use this generated data while shooting email by VBA.
-
14Remove Duplicates value in Excel
Understand in easy way to remove duplicates in Excel.
-
15Automate Boarder - Where data available
Automate the border where ever data is available and see magic.
Create Analytical DashBoard
-
16Understanding of VLOOKUP
Understand VLookup.
-
17Index - Match equation
Understand the use of Index - Match syntax, Practise as much as you can.
-
18if - or equation
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.
-
19Data Filter - Analyse data
Strong and power full tool to Analyse the data - Data filter
-
20Briefing 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.
User Input From Creation And Coding
-
21Analytical Dashboard Layout
Analytical Dashboard Layout creation in easy way.
-
22Counta, CountIf, Sum, Freeze Row - 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.
-
23Solution to the question - countif
Here is the solution to calculate the values of Dashboard.
-
24Bar Chart - Dashboard
Understand the Bar chart for dashboard.
-
25Pie Chart - Dashboard
Understand the PIE CHART and its element in easy way.
-
26Quick Revision - Download attachment for reference
Quick briefing what we done till now, and downloadable resources.
Conclusion
-
27Enable Developer Tab and Saving under Macro enabled file
Enable Developer tab under options menu and save excel sheet under macro enabled workbook.
-
28VBA Form Creation
Create User Input Form in Easy Way.
-
29Coding to the Submit Button
Add Code to the Submit button.
Find out the code under the Resources.
For any Query drop under Q&A.
-
30Coding 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.
-
31Code 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.
-
32Create 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.
-
33Easy Explanation of VBA code
Understand the VBA by example.
Explanation of Email body and codding.
-
34Shorting out issues and take trial
Short out issue under the coding, and lets try.
-
35Password Protected Mail shooting
Convert direct mail shooting to Password protected mail shooting.
-
36Download Final Excel Sheet
Download final excel which we have created in the lecture series from the resources.