
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
-
Call / Whatsapp Support
-
+91 9536250020
-
Email Support
-
nazim.khan09@gmail.com
OTHER PAYMENT OPTIONS
Paytm | +91 9536250020 |
Google Pay ID | nazim.khan09.nk@okaxis |
PayPal ID | nazim.khan09@gmail.com |
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




























