Microsoft Excel - Beginner to Advance with Example 2023 Course For Free With Certification | Free Udemy Course | First 1000 Users for Free |
Microsoft Excel - Beginner to Advance with Example
Basic to Advance - including Equation, Dashboard creation, VBA, Data validation, Shortcuts, Charts. Zero to Hero guide
- 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. 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...
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
8 sections • 39 lectures • 4h 15m total length
Preview
06:20
Preview
09:20
Data filtration, Border, Sr No., Format Painter
08:48
Home Tab Overview
08:18
Attachment format
02:06
Function today() and Equation additing
06:08
Command Dollar {$} understanding
04:00
Data Validation - Drop Down List creation
05:50
IF, Nested if, if(And) command
15:22
Highlight cell which contains - by Conditional Formatting
07:04
Conditional Formatting - Manage Rule
02:15
Can you automate the boarder? (Wherever data is available - Auto border)
2 questions
if statement use for mail shooting - VBA lecture
03:31
Remove Duplicates value in Excel
03:21
Automate Boarder - Where data available
02:49
Understanding of VLOOKUP
03:41
Index - Match equation
06:18
Instructor
Nishant Tiwari
Python Developer
Nishant Tiwari
4.3 Instructor Rating
1,392 Reviews
80,404 Students
10 Courses
It has now been seven years since I am exploring my ways in the world of New Age technology. In all these years, what is my favourite thing in the whole world? I would say my keyboard! If it’s a war, I got my code as the skill and my keyboard as the weapon. When I was a kid, I wondered what it would feel like to be a hacker. I kept feeding my curiosity in the bits and pieces. I was getting introduced with new things everyday and over time, that interest got diverted towards Cyber-security because I now believe a hacker, if not a villain, is a role similar to the anti-villain and I am more like a Superman guy. This was the first taste I got when I challenged myself to do something new. Now, I am pretty much unstoppable.
All this passion has made me targeted towards my main objective, which is, to learn everything which is out there about computers. For now, I have got a good grip over Python, JavaScript, C, and C++. I have also collected a number of certificates on a variety of IT fields. During those courses, I fell in love with programming. After doing that, I got the gist of loving your own creation. It invoked me further and pretty much became the reason for both of my projects. The first one is a simple image search app made using React. What it does is it uses API via the Pixabay website as the source and provides free images. The other one is my biggest achievement so far and it is the one and only the ‘Goodwill Calculator’ out there. This program is used to find goodwill using all five methods possible. I made this to ease all the Commerce students regarding their goodwill-related problems.
I think the main reason for my motivation is that I strongly believe, if you keep your mind clear and devote yourself to pure learning, there will come a time when your own reality will get surrounded by your self-made uniqueness.
This course includes:
4.5 hours on-demand video
Assignments
11 downloadable resources
Access on mobile and TV
Full lifetime access
Certificate of completion
Coupon Code: MAY2023
Click Here To Apply
Comments
Post a Comment
If you have any doubts, please let me know