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
Introductory lesson. You will go through each and every steps in details, which are shown in the video.
Enrol Now..
Enjoy Now...
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
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
Home Tab overview and different commands available in excel.
Download attachment, practise as much as you can, and get ready for next lecture.
ALL THE BEST.
Basic Excel Function and Equations (if)
Function today() and basic of equation
Understand and proper practise of use of command $.
Understand the use of data validation and drop down list creation.
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
Understand the better way by taking example of conditional formatting.
Practise by your self, for any query drop in Q&A.
Understand the tab of conditional formatting - Manage rule.
We are going to use this generated data while shooting email by VBA.
Understand in easy way to remove duplicates in Excel.
Automate the border where ever data is available and see magic.
Data filter using Vlookup, Index-Match, Filter data.
Understand VLookup.
Understand the use of Index - Match syntax, Practise as much as you can.
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.
Strong and power full tool to Analyse the data - Data filter
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
Analytical Dashboard Layout creation in easy way.
Calculate the data under dashboard.
One additional Assignment is given - Try by your self.
Understand the use of Countif, CountA, Sum, Freezing pan.
Here is the solution to calculate the values of Dashboard.
Understand the Bar chart for dashboard.
Understand the PIE CHART and its element in easy way.
Quick briefing what we done till now, and downloadable resources.
User Input From Creation And Coding
Enable Developer tab under options menu and save excel sheet under macro enabled workbook.
Create User Input Form in Easy Way.
Add Code to the Submit button.
Find out the code under the Resources.
For any Query drop under Q&A.
Fundamentals of codding for Close, Clear & Goto Main Page Button.
Find out the code under the Resources.
For any Query drop under Q&A.
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.
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.
Understand the VBA by example.
Explanation of Email body and codding.
Short out issue under the coding, and lets try.
Convert direct mail shooting to Password protected mail shooting.
Download final excel which we have created in the lecture series from the resources.
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... ! :)