Advance MS Excel

Learn Excel from basics to advance. Find out the information shared by our expert trainer Nazim in this Chapter.

Table of content

  • Advance and Complete Excel

    • 01 EXCEL INTRODUCTION and BASIC FUNCTIONS 15:49 m
    • 02 PRINT, SHARE, EXPORT AND OTHER BASIC FUNCTIONS 15:28 m
    • 03 CUT, COPY, PASTE, FORMAT PAINTER, FONT CHANGING 10:41 m
    • 04 ALLIGNMENTS, ORIENTATION, INCREASE AND DECREASE INDENT 11:41 m
    • 05 NUMBER FORMATING FUNCTION, SCIENTIFIC FUNCTION 08:51 m
    • 06 CONDITION FORMATTING-HIGHLIGHT CELLS RULES AND MORE 13:19 m
    • 07 RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD AND MORE 14:54 m
    • 08 AUTOSUM, AVERAGE, COUNT NUMBERS, MAX, MIN, FILL DOWN, RIGHT, UP, LEFT, SERIES, JUSTIFY 18:58 m
    • 09 FLASH FILL COMMAND WITH 7 EXAMPLES 06:07 m
    • 10 SORT COMMAND, FILTER COMMAND, SUM WITH SUBTOTAL 19:40 m
    • 11 INSERTING LOGO AND IMAGE IN EXCEL AND MORE 05:24 m
    • 12 ENTERING & FORMATING DATA IN EXCEL 06:54 m
    • 13 CHARTS (LIKE-PIE OR BAR ETC.), FORWARD AND BACKWARD FUNCTION AND MORE 23:37 m
    • 14 PRINTING DATA, PAGE MARGINS FULL SETTING AND MORE 19:00 m
    • 15 SPELLING CHECKER FUNCTION 09:40 m
    • 16 CREATING FORMULA AND FUNCTION 05:56 m
    • 17 FORMATTING DATA IN EXCEL 06:21 m
    • 18 PRINTING FULL CONFIGURATION PAPER SIDE, MARGINS, SCALING 10:06 m
    • 19 ROUND FORMULAS, ROUND, ROUND UP, ROUND DOWN, MROUND 10:11 m
    • 20 COUNT FORMULAS COUNT, COUNT A, COUNT IF 05:52 m
    • 21 MAKING OF AUTOMATIC INVOICING SOFTWARE IN EXCEL 22:01 m
    • 22 IF ELSE FORMULA, INSERT BLANK ROW BETWEEN HUGE DATA 08:04 m
    • 23 TEXT TO COLUMN & FORMULAS AND PASTE SPECIAL FUNCTION 04:36 m
    • 24 MAKING OF GST REPORT FROM POS SOFTWARE EXPORTED DATA 17:34 m
    • 25 INSERT JUMPING SERIAL NO. & BLANK CELL WITH IF ELSE FORMULA 09:01 m
    • 26 UPPER, LOWER, PROPER FORMULAS IN EXCEL 03:49 m
    • 27 USE OF TABLE FUNCTION AND DATA VALIDATION 05:34 m
    • 28 VLOOKUP AND HLOOKUP WITH FULL EXPLANATION 09:47 m
    • 29 VLOOKUP WITH MULTIPLE CONDITIONS 04:30 m
    • 30 FORMULAS - SUM, SUMIF, SUMIFS, SUMPRODUCT 7:58 m
    • 31 SEPRATING NUMBER AND TEXT FROM ONE CELL 06:05 m
    • 32 SUM IF & COUNT IF FORMULA WITH 5 DIFFERENT EXAMPLE FILES 10:36 m
    • 33 PIVOT TABLE PART 1 WITH GST DATA LIVE EXAMPLE 07:23 m
    • 34 PIVOT TABLE PART 2 WITH STATE BANK OF INDIA LIVE EXAMPLE 10:16 m
    • 35 PIVOT TABLE PART 3 WITH RESTAURANT FOOD DATA LIVE EXAMPLE 09:05 m
    • 36 PIVOT TABLE PART 4 WITH SALES TEAM DATA LIVE EXAMPLE 06:00 m
    • 37 HOW TO CONVERT NUMBER TO TEXT IN EXCEL FULL EXPLAINED 07:17 m
    • 38 MAKING OF SALES CHART IN EXCEL 12:03 m
    • 39 FILTER IN EXCEL WITH DOCTORS LIVE DATA FULLY EXPLAINED 06:11 m
    • 40 EXCEL DATA AUTO SAVE SCRIPT WITH VBA CODE 04:44 m
    • 41 BLANK CELL FILL AUTOMATICALLY IN EXCEL 03:34 m
    • 42 IF ELSE FORMULA WITH PIVOT TABLE WITH SALES MAN COMMISSION DATA SHEET 06:03 m
    • 43 MACRO PART 2 - WITH SALARY DASHBOARD 09:01 m
    • 44 MACRO PART 3 - WITH SALES CHART 05:35 m
    • 45 MACRO PART 4 - WITH SALARY REGISTER 05:57 m
    • 46 MACRO PART 5 - MOBILE DEALER DATA AUTOSAVE IN SECOND EXCEL SHEET 11:11 m
    • 47 RANKING TOP 4 SUBJECTS FROM STUDENTS DATA 04:03 m
    • 48 ADVANCE DATA FORMATTING WITH 3 STUNNING EXAMPLE 35:46 m
    • 49 DATA VALIDATION- INPUT MESSAGE, ERROR ALERT 05:50 m
    • 50 AUTOMATICL INVOICE SOFTWARE IN EXCEL 39:28 m
    • 51 ABS Fomula 4:35 m
    • 52 IF Else 03:05 m
    • 53 SORT DATA LEFT TO RIGHT AND TOP TO BOTTOM 04:35 m
    • 54 DOUBLE VLOOKUP & SINGLE VLOOKUP 05:59 m
    • 55 INDEX WITH MATCH FORMULA 07:11 m
    • 56 STOP DUPLICATE ENTRING VALUE 06:30 m
    • 57 SUBTOTAL COMMAND, MIN, MAX, COUNT, AVERAGE, PRODUCT, VLOOKUP 06:16 m
    • 58 COMPARE TWO LIST WITH VLOOKUP AND FILTER 08:44 m
    • 59 SALES DATA MIS REPORT 07:51 m
    • 60 TIMELINE CHART WITH SMART ART GRAPHIC- STEP UP PROCESS GRAPH 09:25 m
    • 61 COMPARE TWO LIST WITH MATCH FORMULA AND FILTER 6:34 m
    • 62 IF FORMULA WITH PIVOT TABLE & CONDITIONAL FORMATTING 07:08 m
    • 63 MAKE INSHOP BRANDING FILE NAME LIST 7: 14 m
    • 64 BANK STATEMENT PROBLEM SOLUTION 07:22 m
    • 65 CONVERT VERTICAL DATA TO HORIZONTAL 06:08 m
    • 66 ATTENDANCE SHEET PROBLEM SOLUTION 16:52 m
    • 67 ENTERING CROSS TICK RIGHT TICK 04:20 m
    • 68 COPY VISIBLE CELLS ONLY 04:07 m
    • 69 SCENARIO MANAGER COMMAND 10:40 m
    • 70 INDEPENDENT DROP DOWN LIST 07:05 m
    • 71 STUNNING USE OF IFS FORMULA 03:42 m
    • 72 EXCEL ERRORS EXPLAINATION 08:00 m
    • 73 FORMULAS- ISERROR, ISTEXT, ISFORMULA, ISNA, ISREF, DATA VALIDATION 08:12 m
    • 74 IF ELSE FORMULA WITH ISTEXT AND VLOOKUP 08:20 m
    • 75 EXCEL SHORTCUT KEYS 16NOS 08:29 m