Home / Courses / Advance Excel Course

Advance Excel Course with MIS Report & Dashboard Report

Learn how to effectively use Microsoft Excel to create Professional Business Documents, MIS Report Dashboard Report, Automate Complex Tasks with Microsoft Excel, Learn Advanced Excel Skills to Save Time, Impress others & Boost your career

Created by Nazim Khan

4.99
4.7/5
Advance Excel Course with MIS Report & Dashboard Report

CONTACT
+91 9536250020

Table of Content

CHAPTER-01

  • 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

  • FILE MENU-NEW FILE, OPEN, SAVE, SAVE AS, 
  • PRINT, SHARE, EXPORT, PUBLISH, ACCOUNT, ONEDRIVE INTRODUCTION, FEEDBACK, OPTIONS

CHAPTER-03

  • CUT, COPY, PASTE, FORMAT PAINTER,
  • FONT CHANGING,BOLD ITALIC, UNDERLINE, 
  • BORDER, CELL COLOR, TEXT COLOR

CHAPTER-04

  • ALIGNMENTS, ORIENTATION,INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,
  • MERGE ACROSS, MERGE CELLS, UNMERGE CELLS

CHAPTER-05

  • NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE, 
  • SCIENTIFIC FUNCTION

CHAPTER-06

  • 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

  • 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

  • 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

  • FLASH FILL COMMAND WITH 7 EXAMPLES

CHAPTER-10

  • SORT COMMAND, FILTER COMMAND, SUM WITH SUBTOTAL

CHAPTER-11

  • INSERTING LOGO AND IMAGE IN EXCEL
  • IMAGE BORDER, IMAGE CROPPING, ROTATE PICTURE
  • IMAGE CORRECTION, COLOR, ARTISTIC EFFECTS
  • PICTURE EFFECTS FUNCTION, SHADOW, REFLECTION,

CHAPTER-12

  • ENTERING & FORMATTING DATA IN EXCEL

CHAPTER-13

  • 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

  • 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

  • SPELLING CHECKER FUNCTION
  • THESAURUS FUNCTION
  • TRANSLATE FUNCTION
  • SWITCHING WINDOWS
  • USE COMMENT FUNCTION

CHAPTER-16

  • CREATING FORMULA AND FUNCTION

CHAPTER-17

  • FORMATTING DATA IN EXCEL

CHAPTER-18

  • PRINTING FULL CONFIGURATION
  • PAPER SIDE, MARGINS, SCALING,
  • FIT SHEET ON ONE PAGE
  • ROW TO REPEAT AT TOP, SET PRINT AREA,
  • FINAL PRINTING

CHAPTER-19

  • ROUND FORMULAS
  • ROUND, ROUND UP, ROUND DOWN, MROUND

CHAPTER-20

  • COUNT FORMULAS
  • COUNT, COUNT A, COUNT IF,
  • COUNTIFS, COUNTBLANK

CHAPTER-21

  • IF ELSE FORMULA, INSERT BLANK ROW BETWEEN HUGE DATA, MERGE 2 COLUMN DATA IN SINGLE COLUMN

CHAPTER-22

  • TEXT TO COLUMN & FORMULAS AND PASTE SPECIAL FUNCTION, CONVERT LAST NAME TO FIRST NAME

CHAPTER-23

  • INSERT JUMPING SERIAL NO. & BLANK CELL WITH IF ELSE FORMULA

CHAPTER-24

  • UPPER, LOWER, PROPER FORMULAS IN EXCEL

CHAPTER-25

  • USE OF TABLE FUNCTION AND DATA VALIDATION

CHAPTER-26

  • VLOOKUP AND HLOOKUP WITH FULL EXPLANATION

CHAPTER-27

  • VLOOKUP WITH MULTIPLE CONDITIONS

CHAPTER-28

  • FORMULAS – SUM, SUMIF, SUMIFS, SUMPRODUCT

CHAPTER-29

  • SEPARATING NUMBER AND TEXT FROM ONE CELL

CHAPTER-30

  • SUM IF & COUNT IF FORMULA WITH
  • 5 DIFFERENT EXAMPLE FILES

CHAPTER-31

  • HOW TO CONVERT NUMBER TO TEXT IN EXCEL
  • FULLY EXPLAINED

CHAPTER-32

  • FILTER IN EXCEL WITH DOCTORS LIVE DATA
  • FULLY EXPLAINED

CHAPTER-33

  • EXCEL DATA AUTOSAVE SCRIPT WITH VBA CODE

CHAPTER-34

  • BLANK CELL FILL AUTOMATICALLY IN EXCEL

CHAPTER-35

  • IF ELSE FORMULA WITH PIVOT TABLE WITH SALESMAN COMMISSION DATA SHEET

CHAPTER-36

  • MACRO PART 2 – WITH SALARY DASHBOARD

CHAPTER-37

  • MACRO PART 3 – WITH SALES CHART

CHAPTER-38

  • MACRO PART 4 – WITH SALARY REGISTER

CHAPTER-39

  • MACRO PART 5 – MOBILE DEALER DATA AUTOSAVE IN SECOND EXCEL SHEET

CHAPTER-40

  • RANKING TOP 4 SUBJECTS FROM STUDENTS DATA

CHAPTER-41

  • DATA VALIDATION- INPUT MESSAGE, ERROR ALERT,
  • STYLING-STOP, WARNING, INFORMATION

CHAPTER-42

  • ABS ABSOLUTE FORMULA

CHAPTER-43

  • IF ELSE FORMULA WITH EASY EXAMPLE

CHAPTER-44

  • SORT DATA LEFT TO RIGHT AND TOP TO BOTTOM

CHAPTER-45

  • DOUBLE VLOOKUP & SINGLE VLOOKUP

CHAPTER-46

  • INDEX WITH MATCH FORMULA

CHAPTER-47

  • STOP DUPLICATE ENTRING VALUE
  • COUNTIF & DATA VALIDATION

CHAPTER-48

  • SUBTOTAL COMMAND, MIN, MAX, COUNT,
  • AVERAGE, PRODUCT, VLOOKUP

CHAPTER-49

  • COMPARE TWO LIST WITH VLOOKUP AND FILTER

CHAPTER-50

  • COMPARE TWO LIST WITH MATCH FORMULA AND FILTER

CHAPTER-51

  • IF FORMULA WITH PIVOT TABLE & CONDITIONAL FORMATTING

CHAPTER-52

  • MAKE INSHOP BRANDING FILE NAME LIST

CHAPTER-53

  • BANK STATEMENT PROBLEM SOLUTION

CHAPTER-54

  • CONVERT VERTICAL DATA TO HORIZONTAL

CHAPTER-55

  • ATTENDANCE SHEET PROBLEM SOLUTION

CHAPTER-56

  • ENTERING CROSS TICK RIGHT TICK

CHAPTER-57

  • COPY VISIBLE CELLS ONLY

CHAPTER-58

  • STUNNING USE OF IFS FORMULA

CHAPTER-59

  • EXCEL ERRORS EXPLANATION
  • TYPE OF ERROR IN EXCEL
  • #DIV/0, #VALUE!, #REF!, #NAME?

CHAPTER-60

  • FORMULAS- ISERROR, ISTEXT, ISFORMULA, ISNA, ISREF, DATA VALIDATION

CHAPTER-61

  • IF ELSE FORMULA WITH ISTEXT AND VLOOKUP

CHAPTER-62

  • EXCEL SHORTCUT KEYS 16NOS

CHAPTER-63

  • ADVANCE FILTER, DIFFERENCE BETWEEN NORMAL FILTER AND ADVANCE FILTER

CHAPTER-64

  • FLASH FILL AUTO FILL

CHAPTER-65

  • NAME A RANGE IN SALES REPORT
  • DIFFERENCE BETWEEN LIST, STATUS BAR TOOL,

CHAPTER-66

  • MAKING OF BANK RE-PAYMENT SCHEDULE
  • USING PMT, IPMT, PPMT FORMULA

CHAPTER-67

  • WORKING WITH OFFSET FORMULA WITH COMPANIES MONTHLY SALES REPORT USING INDEX FORMULA,
  • RAND BETWEEN FORMULA & DATA VALIDATION

CHAPTER-68

  • USING OF ADVANCE TRANSPOSE,
  • HIDE CELL VALUE, DATE PICKET TOOL

CHAPTER-69

  • HOW TO MAKE MONEY ONLINE WITH EXCEL KNOWLEDGE

CHAPTER-70

  • 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

  • MIS REPORT (Part-1)
  • ADVANCE DATA FORMATTING WITH 3 STUNNING EXAMPLE
  • SALARY CHART AND SALES CHART DATA

CHAPTER-72

  • MIS REPORT (Part-2)
  • MAKING OF AUTOMATIC INVOICING SOFTWARE IN EXCEL
  • WITH VLOOKUP, IF FORMULA, DEVELOPER TOOL-SPIN BUTTON & IF ERROR FORMULAS

CHAPTER-73

  • MIS REPORT (Part-3)
  • MAKING OF GST REPORT FROM
  • POS SOFTWARE EXPORTED DATA

CHAPTER-74

  • MIS REPORT (Part-4)
  • PIVOT TABLE PART-1 WITH GST DATA LIVE EXAMPLE

CHAPTER-75

  • MIS REPORT (Part-5)
  • PIVOT TABLE PART-2 WITH STATE BANK OF INDIA
  • LIVE EXAMPLE

CHAPTER-76

  • MIS REPORT (Part-6)
  • PIVOT TABLE PART-3 WITH RESTAURANT FOOD DATA LIVE EXAMPLE

CHAPTER-77

  • MIS REPORT (Part-7)
  • PIVOT TABLE PART-4 WITH SALES TEAM DATA LIVE EXAMPLE

CHAPTER-78

  • MIS REPORT (Part-8)
  • MAKING OF SALES CHART IN EXCEL
  • LINE CHART, PIE CHART, BAR CHART,
  • FULLY CUSTOMIZATION

CHAPTER-79

  • MIS REPORT (Part-9)
  • AUTOMATIC INVOICE SOFTWARE IN EXCEL WITH CHECK BOX, RADIO BUTTON,
  • GST AUTO-LOCAL & CENTRAL

CHAPTER-80

  • MIS REPORT (Part-10)
  • SALES DATA MIS REPORT

CHAPTER-81

  • MIS REPORT (Part-11)
  • TIMELINE CHART WITH SMART ART GRAPHIC
  • STEP UP PROCESS GRAPH

CHAPTER-82

  • MIS REPORT (Part-12)
  • SCENARIO MANAGER COMMAND

CHAPTER-83

  • MIS REPORT (Part-13)
  • INDEPENDENT DROP DOWN LIST

CHAPTER-84

  • MIS REPORT (Part-14)
  • AUTO CHANGEABLE EXCEL DATA EMBEDDING TO WORD
  • NETWORK DAYS FORMULA

CHAPTER-85

  • MIS REPORT (Part-15)
  • GOAL SEEK TO GET TARGETED VALUE IN CELL
  • QUICK ANALYSIS TOOL

CHAPTER-86

  • MIS REPORT (Part-16)
  • APPLYING SLICER IN SALES REPORT
  • TABLE, CONVERT TO RANGE, SLICER DESIGN TOOL

CHAPTER-87

  • 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

  • MIS REPORT (Part-18)
  • AUTO SEARCH FORMULA
  • SEARCH VALUE AUTOMATICALLY IN GST SALES DATA

CHAPTER-89

  • MIS REPORT (Part-19)
  • AUTO EXTRACT PARTIES LEDGER IN ANOTHER SHEET FROM BULK DATA
  • USING MACRO AND ADVANCE FILTER AND INTERACTIVE MANUS

CHAPTER-90

  • MIS REPORT (Part-20)
  • INTERACTIVE 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 HYPERLINK
  • SLICER & TIMELINE CHART
  • SALES TARGET ACHIEVEMENT AUTO CHART
  • SLICER CUSTOMIZATION

Need Help Call Now
+91 9536250020

SUPPORT
Email - nazim.khan09@gmail.com