arrow_back
Back
lock
Section 1 - Introduction
lock
Introduction
lock
Trainer Introduction
lock
About Netbhet Elearning Solutions
lock
Download. - Sample Reference Files
lock
Download Sample Excel Files
lock
Section 2 - Basic Functions
lock
2.1 BASIC FUNCTIONS - SUM, COUNT, MIN, And MAX
lock
2.2 BASIC FUNCTIONS - AVERAGE, MODE, MEAN, And MEDIAN
lock
Section 3 - Text Functions
lock
3.1 TEXT FUNCTIONS - CONCATENATE
lock
3.2 TEXT FUNCTIONS - PROPER
lock
3.3 TEXT FUNCTIONS - LOWER AND UPPER
lock
3.4 TEXT FUNCTIONS - LEFT MID AND RIGHT
lock
3.5 TEXT FUNCTIONS - TRIM AND CLEAN
lock
3.6 TEXT FUNCTIONS - REPLACE AND SUBSTITUTE
lock
Section 4 - Logical Functions
lock
4.1 LOGICAL FUNCTIONS - TRUE AND FALSE
lock
4.2 LOGICAL FUNCTIONS - IF FUNCTION
lock
4.3 LOGICAL FUNCTIONS - AND and OR
lock
4.4 LOGICAL FUNCTIONS -IFERROR
lock
4.5 LOGICAL FUNCTIONS - IFNA
lock
4.6.1 SUMIF AVERAGEIF
lock
4.6.2 COUNTIF
lock
Section 5 - Date & Time Functions
lock
5.1 DATE AND TIME FUNCTIONS - TODAY,NOW,YEAR, MONTH,DAY AND DATE
lock
5.2 DATE AND TIME FUNCTIONS - WEEKNUM AND WEEKDAY
lock
5.3 DATE AND TIME FUNCTIONS - EDATE AND EOMONTH
lock
Section 6 - Lookup Functions
lock
6.1 LOOKUP FUNCTIONS - VLOOKUP
lock
6.2 LOOKUP FUNCTIONS - HLOOKUP
lock
6.3 LOOKUP FUNCTIONS - CHOOSE
lock
6.4 LOOKUP FUNCTIONS - LOOKUP
lock
Section 7 - Keyboard Shortcuts
lock
7.1 KEYBOARD SHORTCUTS - BASIC 1
lock
7.2 KEYBOARD SHORTCUTS - BASIC 2
lock
7.3 KEYBOARD SHORTCUTS - MOST IMPORTANT SHORTCUT KEY
lock
7.4 KEYBOARD SHORTCUTS - MOVING AROUND
lock
7.5 KEYBOARD SHORTCUTS - CTRL + ENTER
lock
7.6 KEYBOARD SHORTCUTS - PAGEUP & PAGEDOWN
lock
7.7 KEYBOARD SHORTCUTS - CTRL + ;
lock
Section 8 - Data Manipulation Tools & Techniques
lock
8.1 DATA MANIPULATION TOOLS - FILTERS
lock
8.2 DATA MANIPULATION TOOLS - SORTING
lock
8.3.1 DATA MANIPULATION TOOLS - PASTE SPECIAL
lock
8.3.2 DATA MANIPULATION TOOLS - PASTE SPECIAL
lock
8.4 CUSTOM CELL FORMATING
lock
8.5.1 CONDITIONAL FORMATTING 1
lock
8.5.2 CONDITIONAL FORMATTING 2
lock
8.5.3 CONDITIONAL FORMATTING 3
lock
8.6 FIND AND REPLACE
lock
8.7 GO TO SPECIAL
lock
8.7.1 GO TO
lock
8.8.1 DATA VALIDATION 1
lock
8.8.2 DATA VALIDATION 2
lock
8.9 DATA MANIPULATION TOOLS - TEXT TO COLUMN
lock
8.10 DATA MANIPULATION TOOLS - FLASH FILL
lock
8.11 DATA MANIPULATION TOOLS - REMOVE DUPLICATES
lock
8.12 DATA MANIPULATION TOOLS - GROUP AND UNGROUP
lock
8.13 DATA MANIPULATION TOOLS - WHAT IF ANALYSIS
lock
Section 9 - Charts & Graphs
lock
9.1 CHARTS AND GRAPHS
lock
9.2 CHARTS AND GRAPHS
lock
9.3 CHARTS AND GRAPHS
lock
9.4 CHARTS AND GRAPHS - line graph
lock
9.5 CHARTS AND GRAPHS - pie chart
lock
Section 10 - Pivot Tables
lock
10.1 PIVOT
lock
10.2 PIVOT TABLE DESIGN OPTIONS
lock
10.3 PIVOT TABLE - 4 WAYS TO CREATE PIVOT TABLE
lock
10.4 PIVOT TABLE - DATA ANALYSIS
lock
10.5 PIVOT TABLE - DATA SLICER
lock
Section 11 - Extras 1
lock
11.1 MS EXCEL मध्ये गृहकर्जाचा मासिक हप्ता (Homeloan EMI) कसा काढावा
lock
11.2 HOW TO CALCULATE PERSON'S AGE IN MS EXCEL
lock
11.3 HOW TO COPY ONLY VISIBLE CELLS IN EXCEL (Marathi videos by Netbhet)
lock
11.4 HOW TO USE LEN FUNCTION IN MS EXCEL
lock
11.5 TEXT FUNCTIONS - FILL JUSTIFY
lock
11.6 COPY VISIBLE CELLS
lock
11.7 CREATE HUNDREDS OF REPORTS FROM SINGLE PIVOT TABLE
lock
11.8 HOW TO CREATE RANKING LIST
lock
11.9 HOW TO CALCULATE COMPOUND INTEREST
lock
11.10 KEYBOARD SHORTCUTS TO DISPLAY ALL EXCEL FORMULAE
lock
Section 12 - Extras 2
lock
12.1 EXCEL PRINT PREVIEW KEYBOARD SHORTCUT
lock
12.2 LARGE & SMALL FUNCTIONS
lock
12.3 LOAN AMMORTISATION SCHEDULE
lock
12.4 ADD SPACES IN DIGITS
lock
13. Conclusion
lock
13.1 Conclusion
Preview - Microsoft Excel Expert
Discuss (
0
)
navigate_before
Previous
Next
navigate_next