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
- Complete idea about Pivot Table & Pivot chart
This course includes:
- 4.5 hours on-demand video
- Assignments
- 14 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Closed captions
- Audio description in existing audio
- Certificate of completion
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, working professional, businessman
- To become expert in data analytics by using 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
How to Get this course FREE?
Get a 100% Discount On Udemy courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Apply this Coupon: SEPTLAST24 is applied  (For 100% Discount)
For Latest Udemy Courses Coupon, Join Our Official Free Telegram Group :https://t.me/freecourseforall
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course for 100% Free. After that, you will get this course at a discounted price.
Important Notice and Disclaimer:- CareerBoostZone platform is a free Job Sharing platform for all the Job seekers. We don’t charge any cost and service fee for any job which is posted on our website, neither we have authorized anyone to do the same. Most of the jobs posted over Seekajob are taken from the career pages of the organizations. Jobseekers/Applicants are advised to check all the details when they apply for the job to avoid any inconvenience.