Mastering Microsoft Excel - Beginner to Advance with Example
Microsoft Excel Basic to Advance, Learn A to Z, Office 365/2023, 2010, 2013, 2016, Excel 2019, Zero to Hero guide
Excel,Computer Skills,Data & Analytics,Microsoft Excel,Excel Dashboard
Lectures -44
Resources -13
Duration -4.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course 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.
Goals
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
Prerequisites
No prior knowledge is required, You will learn everything you need to know from basic
Any Fresher to the Excel
You will learn everything at one place, whatever you need
![Mastering Microsoft Excel - Beginner to Advance with Example Mastering Microsoft Excel - Beginner to Advance with Example](https://d3mxt5v3yxgcsr.cloudfront.net/courses/19606/course_19606_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
5 Lectures
-
Introduction to the Excel course 05:11 05:11
-
Hands on experience to the excel with understanding of shortcuts 09:20 09:20
-
Data filtration, Border, Sr No., Format Painter 08:48 08:48
-
Home Tab Overview 08:18 08:18
-
Attachment format 02:06 02:06
Basic Excel Function and Equations (if)
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
More about Excel - Conditional formatting, remove duplicates, Automate border
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data filter using Vlookup, Index-Match, Filter data.
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Create Analytical DashBoard
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
User Input From Creation And Macro Coding
10 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conclusion
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Section - 2
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Pivot Table
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Meet Doshi](https://www.tutorialspoint.com/assets/profiles/1288336/profile/200_2411532-1718103450.jpg)
Meet Doshi
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.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)