All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsIT & SoftwareExcel Dashboard
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
Created by Meet Doshi
4.5 hours
Video Content
44
Lectures
165,910
Students
4.4
Rating
4.4
(165,910 students enrolled)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
Course Content
9 sections • 44 lectures • 04:34:38 total length
Introduction
5 lectures • 33:43
Introduction
5 lectures • 33:43
Introduction to the Excel course05:11
Hands on experience to the excel with understanding of shortcuts09:20
Data filtration, Border, Sr No., Format Painter08:48
Home Tab Overview08:18
Attachment format02:06
+1 more lectures
Basic Excel Function and Equations (if)
4 lectures • 31:20
Basic Excel Function and Equations (if)
4 lectures • 31:20
Function today() and Equation additing06:08
Command Dollar {$} understanding04:00
Data Validation - Drop Down List creation05:50
IF, Nested if, if(And) command15:22
Quiz 24 questions
More about Excel - Conditional formatting, remove duplicates, Automate border
5 lectures • 19:00
More about Excel - Conditional formatting, remove duplicates, Automate border
5 lectures • 19:00
Highlight cell which contains - by Conditional Formatting07:04
Conditional Formatting - Manage Rule02:15
Can you automate the boarder? (Wherever data is available - Auto border)2 questions
if statement use for mail shooting - VBA lecture03:31
Remove Duplicates value in Excel03:21
+1 more lectures
Data filter using Vlookup, Index-Match, Filter data.
5 lectures • 22:57
Data filter using Vlookup, Index-Match, Filter data.
5 lectures • 22:57
Understanding of VLOOKUP03:41
Index - Match equation06:18
if - or equation04:59
Data Filter - Analyse data05:11
Briefing video - Download file02:48
Create Analytical DashBoard
6 lectures • 27:45
Create Analytical DashBoard
6 lectures • 27:45
Analytical Dashboard Layout05:31
Counta, CountIf, Sum, Freeze Row - Calculate the data for Dashboard08:33
Solution to the question - countif02:23
Bar Chart - Dashboard04:07
Pie Chart - Dashboard05:56
+2 more lectures
User Input From Creation And Macro Coding
10 lectures • 01:09:52
User Input From Creation And Macro Coding
10 lectures • 01:09:52
Enable Developer Tab and Saving under Macro enabled file01:48
VBA Form Creation06:02
MACRO Coding to the Submit Button10:17
Coding to Close, Clear & Goto Main Page03:55
Code to Open up outlook and Send Mail12:11
+5 more lectures
Conclusion
1 lectures • 05:57
Conclusion
1 lectures • 05:57
Conclusion05:57
Section - 2
3 lectures • 16:26
Section - 2
3 lectures • 16:26
Introduction to Section - 201:38
All About Mid & Search07:14
All About Mid, Search, Trim & Len - Part 207:34
Pivot Table
5 lectures • 47:38
Pivot Table
5 lectures • 47:38
Pivot Table - Basics - How to create a Pivot Table05:26
Data refining with Pivot table02:24
Convert data in to Table06:52
Everything you should know about Pivot Table23:40
Pivot Chart09:16
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
This course includes:
- 4.5 hours on-demand video 0
- 14 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructor
Meet Doshi
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython