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
- Preview06:20
- Preview11:08
- 10:46Data filtration, Border, Sr No., Format Painter
- 10:04Home Tab Overview
- 02:07Attachment format
Instructor
![Meet Doshi](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 1,695 Reviews
- 95,763 Students
- 1 Course
I am a Mechanical Engineer. And healthy knowledge in advanced excel. I always wanted to teach every one. Share knowledge and gain knowledge is best thing which I personally like. Preparing the course in excel is my prime motive. Always ready to help.
I always prefer to teach from scratch, so one can easily understand the basic and can apply the fundamentals in real life. I personally prefers that real life example can teach in easy way and that is why i prefers to take example in my course.