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