Download Tally TDL

Work Smarter not Harder

This course will get you confident and comfortable designing simple to complex spreadsheets.  You’ll go beyond Excel basics. As you go through the course, you’ll be able to apply what you learnt immediately to your job. You’ll master new formulas and find better ways to setup your existing spreadsheets. Management loves efficiency. In this course, you’ll solve dozens of practical real-world examples. They’ll help you think outside the box so you can work smarter not harder.

 
0
Video Chapters​
0
Excel Data / Practice Sheets
0 +
Excel Topics​
0
Minutes Duration

ADVANCE EXCEL COURSE IN HINDI

₹ 4,000 ₹2,000

* No Extra charges

  • ✓ From Basic to Advance Level
  • ✓ 90 Chapters in Videos Format
  • ✓ 80 Excel Data /Practice Sheets
  • ✓ Validity Life time
  •  
  • ✓ Entire Course in Hindi
  • ✓ No limitation in views
  • ✓ All content-Downloadable 
  • ✓ Video Quality – HD
    ✓ Delivery Method – Google Drive
  • ✓ Course Duration – 920 minutes
  •  
  • ✓ Accessable on Mobile, Computer/Laptop, Table, TV
  •  
  • ✓ Version support Excel 2007,2010,2013,2016,2019
  •  

OTHER PAYMENT OPTIONS

Paytm +91 9536250020
Google Pay ID [email protected]
PayPal ID [email protected]

Bank Transfer
Account Name Nazim Khan
A/c No 0167104000183253
Bank Name IDBI BANK
Branch New friends colony, New Delhi, India
Type Saving A/c
IFS Code IBKL0000167
Swift Code IBKLINBB010

COURSE DEMO VIDEO

Play Video

TABLE OF CONTENT

CHAPTERS Duration DESCRIPTION
CHAPTER-01 15:46 EXCEL INTRODUCTION
WORKBOOK, TITLEBAR, QUICK ACCESS TOOLBAR,
RIBBON, TAB, NAME BOX,
FORMULA BAR, COLUMN, ROW,
SPREADSHEET, GRID AREA, CELL,
SCROLLBAR, ZOOM SELECTION,
RANGE, NAME A RANGE
CHAPTER-02 15:22 FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS,
PRINT, SHARE, EXPORT,
PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION
FEEDBACK, OPTIONS
CHAPTER-03 10:35 CUT, COPY, PASTE,
FORMAT PAINTER, FONT CHANGING,
BOLD ITALIC, UNDERLINE,
BORDER, CELL COLOR, TEXT COLOR
CHAPTER-04 11:09 ALIGNMENTS, ORIENTATION,
INCREASE AND DECREASE INDENT
WRAP TEXT, MERGE & CENTER,
MERGE ACROSS, MERGE CELLS, UNMERGE CELLS
CHAPTER-05 08:46 NUMBER FORMATING FUNCTION,
PERCENTAGE STYLE, COMMA STYLE,
DECIMAL INCREASE & DECREASE,
SCIENTIFIC FUNCTION
CHAPTER-06 13:13 CONDITION FORMATTING-HIGHLIGHT CELLS RULES,
TOP-BOTTOM RULES, DATA BARS, COLOR SCALES,
ICON SETS, NEW RULE, CLEAR RULES,
MANAGE RULES, FORMAT AS TABLE,
MORE STYLING TOOL
CHAPTER-07 14:47 INSERT CELL, ROW, SHEET, DELETE CELL,
ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS,
RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,
CHAPTER-08 18:52 AUTOSUM, AVERAGE, COUNT NUMBERS,
MAX, MIN, FILL DOWN, RIGHT, UP, LEFT, SERIES, JUSTIFY,
CLEAR FORMAT, CONTENT, COMMENT, HYPERLINK,
FIND COMMAND & REPLACE COMMAND,
FIND COMMENT,FIND FORMULAS,FIND OBJECT, FIND CONDITION FORMATING
CHAPTER-09 06:01 FLASH FILL COMMAND WITH  7 EXAMPLES
CHAPTER-10 19:35 SORT COMMAND, FILTER COMMAND, SUM WITH SUBTOTAL
CHAPTER-11 05:22 INSERTING LOGO AND IMAGE IN EXCEL
IMAGE BORDER, IMAGE CROPPING, ROTATE PICTURE
IMAGE CORRECTION, COLOR, ARTISTIC EFFECTS
PICTURE EFFECTS FUNCTION, SHADOW, REFLECTION,
CHAPTER-12 06:52 ENTERING & FORMATTING DATA IN EXCEL
CHAPTER-13 23:35 CHARTS (LIKE-PIE OR BAR ETC.)
SHAPES
FORWARD AND BACKWARD FUNCTION
OBJECT FUNCTION IN EXCEL
INSERTING SYMBOLS IN EXCEL
USE OF TEXTBOX
EXCEL THEME- COLOR, THEME-FONT
EFFECTS FUNCTION
USE OF ZOOMING FUNCTION
SCREENSHOT WITH EXCEL
CHAPTER-14 18:58 PRINTING DATA, PAGE MARGINS FULL SETTING
ORIENTATION AND PAGE SIZE SETTING
PRINT AREA FUNCTION
PAGE BREAKS FUNCTION
WORKSHEET BACKGROUND
PRINT TITLES FUNCTION
SETTING OF WIDTH, HEIGHT AND SCALING OF PAGE
USE OF GRID LINE AND ITS EFFECT
GRIDLINE PRINTING
USE OF HEADING FUNCTION
CHAPTER-15 09:38 SPELLING CHECKER FUNCTION
THESAURUS FUNCTION
TRANSLATE FUNCTION
SWITCHING WINDOWS
USE COMMENT FUNCTION
CHAPTER-16 05:53 CREATING FORMULA AND FUNCTION
CHAPTER-17 06:19 FORMATTING DATA IN EXCEL
CHAPTER-18 10:04 PRINTING FULL CONFIGURATION
PAPER SIDE, MARGINS, SCALING,
FIT SHEET ON ONE PAGE
ROW TO REPEAT AT TOP, SET PRINT AREA,
FINAL PRINTING
CHAPTER-19 10:09 ROUND FORMULAS
ROUND, ROUND UP, ROUND DOWN, MROUND
CHAPTER-20 05:50 COUNT FORMULAS
COUNT, COUNT A, COUNT IF,
COUNTIFS, COUNTBLANK
CHAPTER-21 08:02 IF ELSE FORMULA, INSERT BLANK ROW BETWEEN HUGE DATA,
MERGE 2 COLUMN DATA IN SINGLE COLUMN
CHAPTER-22 04:35 TEXT TO COLUMN & FORMULAS AND PASTE SPECIAL FUNCTION,
CONVERT LAST NAME TO FIRST NAME
CHAPTER-23 08:59 INSERT JUMPING SERIAL NO. & BLANK CELL WITH IF ELSE FORMULA
CHAPTER-24 03:46 UPPER, LOWER, PROPER FORMULAS IN EXCEL
CHAPTER-25 05:32 USE OF TABLE FUNCTION AND DATA VALIDATION
CHAPTER-26 09:46 VLOOKUP AND HLOOKUP WITH FULL EXPLANATION
CHAPTER-27 04:28 VLOOKUP WITH MULTIPLE CONDITIONS
CHAPTER-28 07:56 FORMULAS - SUM, SUMIF, SUMIFS, SUMPRODUCT
CHAPTER-29 06:03 SEPARATING NUMBER AND TEXT FROM ONE CELL
CHAPTER-30 10:30 SUM IF & COUNT IF FORMULA WITH 5 DIFFERENT EXAMPLE FILES
CHAPTER-31 07:12 HOW TO CONVERT NUMBER TO TEXT IN EXCEL FULL EXPLAINED
CHAPTER-32 06:05 FILTER IN EXCEL WITH DOCTORS LIVE DATA FULLY EXPLAINED
CHAPTER-33 04:39 EXCEL DATA AUTO SAVE SCRIPT WITH VBA CODE
CHAPTER-34 03:29 BLANK CELL FILL AUTOMATICALLY IN EXCEL
CHAPTER-35 05:58 IF ELSE FORMULA WITH PIVOT TABLE WITH SALES MAN COMMISSION DATA SHEET
CHAPTER-36 08:55 MACRO PART 2 - WITH SALARY DASHBOARD
CHAPTER-37 05:30 MACRO PART 3 - WITH SALES CHART
CHAPTER-38 05:51 MACRO PART 4 - WITH SALARY REGISTER
CHAPTER-39 11:06 MACRO PART 5 - MOBILE DEALER DATA AUTOSAVE IN SECOND EXCEL SHEET
CHAPTER-40 03:57 RANKING TOP 4 SUBJECTS FROM STUDENTS DATA
CHAPTER-41 05:45 DATA VALIDATION- INPUT MESSAGE, ERROR ALERT,
STYLING-STOP, WARNING, INFORMATION
CHAPTER-42 04:29 ABS ABSOLUTE FORMULA
CHAPTER-43 02:59 IF ELSE FORMULA WITH EASY EXAMPLE
CHAPTER-44 04:29 SORT DATA LEFT TO RIGHT AND TOP TO BOTTOM
CHAPTER-45 05:54 DOUBLE VLOOKUP & SINGLE VLOOKUP
CHAPTER-46 07:06 INDEX WITH MATCH FORMULA
CHAPTER-47 06:25 STOP DUPLICATE ENTRING VALUE
COUNTIF & DATA VALIDATION
CHAPTER-48 06:11 SUBTOTAL COMMAND, MIN, MAX, COUNT, AVERAGE, PRODUCT, VLOOKUP
CHAPTER-49 08:39 COMPARE TWO LIST WITH VLOOKUP AND FILTER
CHAPTER-50 06:30 COMPARE TWO LIST WITH MATCH FORMULA AND FILTER
CHAPTER-51 07:03  IF FORMULA WITH PIVOT TABLE & CONDITIONAL FORMATTING
CHAPTER-52 07:09 MAKE INSHOP BRANDING FILE NAME LIST
CHAPTER-53 07:17 BANK STATEMENT PROBLEM SOLUTION
CHAPTER-54 06:03 CONVERT VERTICAL DATA TO HORIZONTAL
CHAPTER-55 16:47 ATTENDANCE SHEET PROBLEM SOLUTION
CHAPTER-56 04:15 ENTERING CROSS TICK RIGHT TICK
CHAPTER-57 04:02 COPY VISIBLE CELLS ONLY
CHAPTER-58 03:37 STUNNING USE OF IFS FORMULA
CHAPTER-59 07:55 EXCEL ERRORS EXPLAINATION
TYPE OF ERROR IN EXCEL
#DIV/0,   #VALUE!,    #REF!,    #NAME?
CHAPTER-60 08:06 FORMULAS- ISERROR, ISTEXT, ISFORMULA, ISNA, ISREF, DATA VALIDATION
CHAPTER-61 08:15 IF ELSE FORMULA WITH ISTEXT AND VLOOKUP
CHAPTER-62 08:23 EXCEL SHORTCUT KEYS 16NOS
CHAPTER-63 07:15 ADVANCE FILTER
DIFFERENCE BETWEEN NORMAL FILTER AND ADVANCE FILTER
CHAPTER-64 04:10 FLASH FILL AUTO FILL
CHAPTER-65 07:33 NAME A RANGE IN SALES REPORT
DIFFERENCE BETWEEN LIST, STATUS BAR TOOL,
CHAPTER-66 12:39 MAKING OF BANK RE-PAYMENT SCHEDULE
USING PMT, IPMT, PPMT FORMULA
CHAPTER-67 15:22 WORKING WITH OFFSET FORMULA WITH COMPANIES MONTHLY SALES REPORT
USING INDEX FORMULA, RAND BETWEEN FORMULA & DATA VALIDATION
CHAPTER-68 08:02 USING OF ADVANCE TRANSPOSE, HIDE CELL VALUE, DATE PICKET TOOL
CHAPTER-69 20:50 HOW TO MAKE MONEY ONLINE WITH EXCEL KNOWLEDGE
CHAPTER-70 21:11 MAKING OF EMPLOYEES ICARD IN EXCEL
USING INDEX AND MATCH FORMULA, DATA VALIDATION,
VLOOKUP, TRANSPOSE, LINKED PICTURE TOOL, NAME MANAGER

MIS & DASHBOARD REPORTING

CHAPTER-71 17:48 MIS REPORT (Part-1)
ADVANCE DATA FORMATTING WITH 3 STUNNING EXAMPLE
SALARY CHART AND SALES CHART DATA
CHAPTER-72 21:59 MIS REPORT (Part-2)
MAKING OF AUTOMATIC INVOICING SOFTWARE IN EXCEL
WITH VLOOKUP, IF FORMULA,
DEVELOPER TOOL-SPIN BUTTON & IF ERROR FORMULAS
CHAPTER-73 17:32 MIS REPORT (Part-3)
MAKING OF GST REPORT FROM POS SOFTWARE EXPORTED DATA
CHAPTER-74 07:17 MIS REPORT (Part-4)
PIVOT TABLE PART-1 WITH GST DATA LIVE EXAMPLE
CHAPTER-75 10:11 MIS REPORT (Part-5)
PIVOT TABLE PART-2 WITH STATE BANK OF INDIA LIVE EXAMPLE
CHAPTER-76 09:00 MIS REPORT (Part-6)
PIVOT TABLE PART-3 WITH RESTAURANT FOOD DATA LIVE EXAMPLE
CHAPTER-77 05:54 MIS REPORT (Part-7)
PIVOT TABLE PART-4 WITH SALES TEAM DATA LIVE EXAMPLE
CHAPTER-78 11:58 MIS REPORT (Part-8)
MAKING OF SALES CHART IN EXCEL
LINE CHART, PIE CHART, BAR CHART, FULLY CUSTOMIZATION
CHAPTER-79 19:39 MIS REPORT (Part-9)
AUTOMATICL INVOICE SOFTWARE IN EXCEL
WITH CHECK BOX, RADIO BUTTON, GST AUTO-LOCAL & CENTRAL
CHAPTER-80 07:46 MIS REPORT (Part-10)
SALES DATA MIS REPORT
CHAPTER-81 09:20 MIS REPORT (Part-11)
TIMELINE CHART WITH SMART ART GRAPHIC- STEP UP PROCESS GRAPH
CHAPTER-82 10:35 MIS REPORT (Part-12)
SCENARIO MANAGER COMMAND
CHAPTER-83 07:00 MIS REPORT (Part-13)
INDEPENDENT DROP DOWN LIST
CHAPTER-84 07:50 MIS REPORT (Part-14)
AUTO CHANGEABLE EXCEL DATA EMBEDDING TO WORD
NETWORK DAYS FORMULA
CHAPTER-85 07:56 MIS REPORT (Part-15)
GOAL SEEK TO GET TARGETED VALUE IN CELL
QUICK ANALYSIS TOOL
CHAPTER-86 12:25 MIS REPORT (Part-16)
APPLYING SLICER IN SALES REPORT
TABLE, CONVERT TO RANGE, SLICER DESIGN TOOL,
CHAPTER-87 44:32 MIS REPORT (Part-17)
SALES PERFORMANCE - INTRACTIVE DASHBOARD REPORT
ANALYSIS REPORT BY MONTHLY SALES,
ANALYSIS SALES REPORT BY PRODUCT,
ANALYSIS SALES REPORT BY QUANTITY,
ANALYSIS SALES REPORT BY COMPANY,
ANALYSIS SALES REPORT BY LOCATION
REPORT USING BY CHARTS, DIAGRAM, PIVOT TABLE, SLICER ETC.
CHAPTER-88 11:09 MIS REPORT (Part-18)
AUTO SEARCH FORMULA
SEARCH VALUE AUTOMATICALLY IN GST SALES DATA
CHAPTER-89 19:37 MIS REPORT (Part-19)
AUTO EXTRACT PARTIES LEDGER IN ANOTHER SHEET FROM BULK DATA
USING MACRO AND ADVANCE FILTER AND INTRACTIVE MANUS
CHAPTER-90 47:26 MIS REPORT (Part-20)
INTRACTIVE CORPORATE DASHBOARD REPORT
REPORT USING BY CHARTS, DIAGRAM, PIVOT TABLE
AUTOMATIC MONTHLY SALES REPORTING
COUNTRY WISE & CITY WISE SALES REPORT
PRODUCT WISE SALES REPORT
WITH COMPANY's SOCIAL MEDIA HYPER LINK
SLICER & TIMELINE CHART
SALES TARGET ACHIEVEMENT AUTO CHART
SLICER CUSTOMIZATION

ABOUT INSTRUCTOR – NAZIM KHAN

Nazim Khan is a Microsoft Excel Expert & Excel Trainer, dedicated to helping you create outstanding tools and reports in Excel. His courses are for those who want to learn Excel, accelerate their careers and achieve more in less time.
Nazim’s background is Master of Business Administration (MBA-Finance), For over 10 years he has worked in the Accounts-Finance and MIS department implementing reporting systems based on Excel & Tally ERP. All the while using Microsoft Excel to automate and improve processes.
Since 4 years, Nazim runs his own Excel site and has an active YouTube channel (Tech Guru Plus) with many engaging, high-quality videos. He provides customized Excel dashboard seminars, enhanced visualization techniques, and advanced Excel seminars to large corporations. Nazim has trained more than 50,000 people online.
His courses include examples based on his experience as well as the consulting work he has done for Indian & International companies. Many of the Excel tips and tricks he shares is based on the questions received from experienced professionals in his Excel training sessions.
He places great value on keeping his Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Nazim’s passion is learning, sharing and solving difficult Excel problems.

FOLLOW ME ON INSTAGRAM HERE 👉 Instagram Profile

Screenshots