About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Microsoft Excel Basic to Advance Level
01. Excel from Scratch
01. Touring the Interface
02. Enter Data and Saving Workbook
03. Applying Formulas
04. Changing a Worksheet's Structure
05. Find, Replace and Spell Check
06. Applying Fonts, Background Colors, and Borders
07. Formatting Numbers and Dates
08. Making the Pieces Fit
09. Inserting Headers and Footers and Repeating Rows
10. Managing Large Workbooks
02. Excel Essentials
01. Formula Writing (Don't Miss This)
01. Ex - Formula Writing (Don't Miss This)
03. Sum Count Average Functionality (with Conditions)
01. SumIf and SumIfs
01. Ex - SumIf and SumIfs
02. Count Functions
02. Ex - Count Functions
03. AverageIf and AverageIfs
03. Ex - AverageIf and AverageIfs
04. Text Functions (Manipulating Text)
01. Change Case (Upper, Lower, Proper)
01. Ex - Change Case (Upper, Lower, Proper)
02. Separating Text on Symmetrical Data
02. Ex - Separating Text on Symmetrical Data
03. Separating Text on Non-Symmetrical Data
03. Ex - Separating Text on Non-Symmetrical Data
05. Logical Functions (Working with Conditions)
01. If Functionality
01. Ex - IF Functionality
02. If with AND
02. Ex - If with AND
03. If with OR
03. Ex - If with OR
04. If with AND and OR, IF with Countif
04. Ex - If with AND and OR, IF with Countif
05. Nested If (A Genie with 3 wishes)
05. Ex - Nested If
06. Lookup Functionality (Burn Simple Find Technique)
01. Vlookup (Exact Match) #1
01. Ex - Vlookup (Exact Match) #1
02. Type of References (Use of $ Sign)
03. Vlookup (Exact Match) #2
03. Ex - Vlookup (Exact Match) #2
04. Double Vlookup
04. Ex - Double Vlookup
05. Vlookup on Duplicate Values
05. Ex - Vlookup on Duplicate Values
06. Vlookup (Approximate Match)
06. Ex - Vlookup (Approximate Match)
07. Vlookup with IF (Conditional Vlookup)
07. Ex - Vlookup with IF (Conditional Vlookup)
08. Hlookup (Exact Match)
08. Ex - Hlookup (Exact Match)
09. Hlookup (Approximate Match)
09. Ex - Hlookup (Approximate Match)
10. Lookup (Don't Use This)
10. Ex - Lookup (Don't Use This)
11. Vlookup and Match (Create Magical Vlookup)
11. Ex - Vlookup and Match (Create a Magical Vlookup)
12. Match (Gives us Column and Row Number)
12. Ex - Match (Gives us Column and Row Number)
13. Index and Match (Made for Each Other)
13. Ex - (1) Index and Match (Made for Each Other)
13. Ex - (2) Index and Match (Made for Each Other)
07. Date and Time Function (a Tricky Game)
01. How Excel Records Date and Timer
02. Now, Today and Autofill
03. DateValue and TimeValue
04. Calculate Working Days
05. DatedIf
08. Financial Functions (Useful for Non-finance Guys Too)
01. Loan Calculation (PMT, PPMT, IPMT etc.)
01. Ex - Loan Calculation (PMT, PPMT, IPMT etc.)
02. Creating a Loan Table
02. Ex - Creating a Loan Table
03. Calculate Depriciation
03. Ex - Calculate Depriciation
09. Sort and Filter (Common for All)
01. Basic Sorting and Shortcut keys
01. Ex - Basic Sorting and Shortcut Keys
02. Sorting Using Custom List
02. Ex - Sorting Using Custom List
03. Horizontal Sorting
03. Ex - Horizontal Sorting
04. Basic Filter and Shortcut Keys
04. Ex - Basic Filter and Shortcut Keys
05. Filter Problem #1 (Copy Filtered Data Without Hidden Rows)
05. Ex - Filter Problem #1 (Copy Filtered Data Without Hidden Rows)
06. Filter Problem #2 (Pasting Values on Filtered Data)
06. Ex - Filter Problem #2 (Pasting Values on Filtered Data)
07. Filter Problem# 3 (Performing Calculation on Filtered Data)
07. Ex - Filter Problem #3 (Perform Claculation on Filtered Data)
08. Advanced Filter (Using Complex Criteria's)
08. Ex - Advanced Filter (Using Complex Criteria's)
10. Excel Charts (Its Time for Visual Presentation)
01. Excel Charts Introduction
02. How to Create a Chart
03. Play with Design and Layout of Chart
04. Link a Chart Title
05. How to Show Axis Title
06. How to Show Data Lable
07. Show Data with Chart in Data Table
08. Column Chart
09. Bar Chart
10. Line Chart 1
11. Line Chart 2
12. Area Chart
13. Pie Chart
14. Pie of Pie or Bar of Pie
15. Line Chart with Log Scale
16. Bubble Chart
17. Selecting Chart Elements
18. Use of Format Dialog box
19. Modifying Chart and Plot Area
20. Modifying Data Series
21. How to handle Missing Data
22. Modifying 3-D Charts
23. Creating Combination of upto 5 Different Charts
24. Creating a Chart Templates
25. Creating Picture Charts
11. Data Consolidation (Multiple Workbooks/Worksheets)
01. Consolidate Data using Excel Inbuilt Function
01. Ex - Consolidate data using Excel Inbuilt Function
12. Data Validation
01. Applying Data Validation
01. Ex - Applying Data validation
02. Dependent Dropdown List
02. Ex - Dependent Dropdown List
03. Using Data Validation with Vlookup and Match
04. Other Data Validation Examples
13. Protection of Worksheet/Workbook
01. Worksheet Level Protection
01. Ex - Worksheet Level Protection
02. Cell Level Protection
02. Ex - Cell Level Protection
03. Hiding Formulas from Formula Bar
03. Ex - Hiding Formulas from Formula Bar
04. Protecting Workbook Structure
04. Ex - Protecting Workbook Structure
05. Workbook Level Protection
05. Ex - Workbook Level Protection
14. Pivot Table and Techniques
01. Understanding Pivot Table
02. Using Pivot Table in Real Scenario
02. Ex - Using Pivot Table in Real Scenario
03. Grouping in Pivot Table
03. EX - Grouping in Pivot Table
04. Using Slicers (A Visually Attractive Filter)
04. Ex - Using Slicers (A Visually Attractive Filter)
15. What-if Analysis and Solver Add-in
01. Goal Seek (A Reverse Approach)
01. Ex Goal Seek (A Reverse Approach)
02. One Way Data Table
03. Two Way Data Table
04. Scenario Manager
05. Solver Add-In
16. Automation in Excel (Macros)
1601 Record your first Macro
1602 Record Another Macro
1603 Assigning Macros to a Shape, Button, Picture
04. Editing or Deleting a Macro
05. Security Settings of a Macro
Self Assessment Test
Self Assessment Test
03. DateValue and TimeValue
Microsoft Excel Basic to Advance Level
07. Date and Time Function (a Tricky Game)
By:
Lokesh Lalwani
2 minutes
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
You need to have access to the item to view this lesson.
One-time Fee
$49
Buy Class
€44.98
Buy Class
£38.69
Buy Class
CA$66.72
Buy Class
A$73.12
Buy Class
S$65.95
Buy Class
HK$382.32
Buy Class
CHF 44.68
Buy Class
NOK kr526.29
Buy Class
DKK kr336.36
Buy Class
NZ$79.87
Buy Class
د.إ179.97
Buy Class
৳5,707.93
Buy Class
₹4,081.72
Buy Class
RM229.68
Buy Class
₦72,030
Buy Class
₨13,577.38
Buy Class
฿1,763.67
Buy Class
₺1,579.92
Buy Class
B$250.12
Buy Class
R898.13
Buy Class
Лв88.15
Buy Class
₩66,365.11
Buy Class
₪180.95
Buy Class
₱2,834.64
Buy Class
¥7,628.07
Buy Class
MX$813.82
Buy Class
QR177.76
Buy Class
P660.46
Buy Class
KSh6,360.93
Buy Class
E£2,294.05
Buy Class
ብር2,799.78
Buy Class
Kz41,601
Buy Class
CLP$43,830.38
Buy Class
CN¥353.93
Buy Class
RD$2,855.31
Buy Class
DA6,597.40
Buy Class
FJ$109.18
Buy Class
Q378.71
Buy Class
GY$10,198
Buy Class
ISK kr6,753.55
Buy Class
DH485.31
Buy Class
L862.48
Buy Class
ден2,770.99
Buy Class
MOP$391.73
Buy Class
N$891.78
Buy Class
C$1,794.41
Buy Class
रु6,498.41
Buy Class
S/182.03
Buy Class
K189.29
Buy Class
SAR183.75
Buy Class
ZK1,244.16
Buy Class
L224.23
Buy Class
Kč1,113.18
Buy Class
Ft17,435.90
Buy Class
SEK kr525.13
Buy Class
ARS$43,198.56
Buy Class
Bs336.80
Buy Class
COP$186,551.23
Buy Class
₡24,946.57
Buy Class
L1,206.88
Buy Class
₲365,221.83
Buy Class
$U1,901
Buy Class
zł191.98
Buy Class
Already have an account?
Log In
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts