Preview Microsoft Excel Expert

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

Preview - Microsoft Excel Expert