4.41 out of 5
4.41
2105 reviews on Udemy

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
Instructor:
Meet Doshi
122,301 students enrolled
English [Auto]
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

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

Basic Excel Function and Equations (if)

Data filter using Vlookup, Index-Match, Filter data.

Create Analytical DashBoard

User Input From Creation And Macro Coding

Conclusion

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
2105 Ratings

Detailed Rating

Stars 5
755
Stars 4
742
Stars 3
452
Stars 2
90
Stars 1
63
0b15b26d352a48c3552cda32ba6756c9

Includes

4 hours on-demand video
Certificate of Completion