Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 34 Minute(s)
Language
English
Taught by
Meet Doshi • 200000+ students
Rating
Course Overview
The complete Microsoft Excel Course, All-in-one excel, Hands on project with real world Example - Pivot - Data analysis
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
Course Content
- 9 section(s)
- 44 lecture(s)
- Section 1 Introduction
- Section 2 Basic Excel Function and Equations (if)
- Section 3 More about Excel - Conditional formatting, remove duplicates, Automate border
- Section 4 Data filter using Vlookup, Index-Match, Filter data.
- Section 5 Create Analytical DashBoard
- Section 6 User Input From Creation And Macro Coding
- Section 7 Conclusion
- Section 8 Section - 2
- Section 9 Pivot Table
What You’ll Learn
- Go from complete beginner to confident Excel user with this step-by-step course, featuring over 4 hours of engaging, easy-to-follow content., Complete idea about Pivot Table & Pivot chart, Learn all about: Excel tables, charts, formatting, formulas, functions, macros, pivot tables and charts, and much more!, Data analysis, Data cleansing, Shortcuts used in excel, Analytical dashboard creation, Data filtration, Border, Sr No., Format Painter, Hands on experience to the excel with understanding of shortcuts, Email shooting by using VBA Directly from excel to specific users, 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, Basic excel equations widely used in
Skills covered in this course
Reviews
-
LLamssaoui Othmane
thanks for this cours
-
CChinaemerem Miracle Chidiebere
Exactly what I was looking for. He's a great teacher.
-
PPeter Jones
This is a well-designed course with examples to practice as you go along, perfect for learning. i am very satisfied.
-
ZZeel Patel
good and easy understanding all
