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.90
4.6/5

Description

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.

  • Understand and Identify the principles of data analysis
  • Effectively summarize and present data clearly
  • Use effective design principles when creating and presenting data
  • Take full advantage of the built in tools Microsoft Excel offers in order to
    analyze and build dashboard reports
  • Build interactive dashboard reports
  • Analyze Excel data using Excels TEXT based Functions
  • Data Mine using Excels Array Functions
  • Build Interactive Dashboard Reports with Buttons and Drop Down Menus
  • Streamline and Analyze Data with Excel Pivot Tables and Pivot Charts
  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day
    tasks through shortcut and formulas
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, Pivot tables

₹2,000    ₹ 4,000

* No Extra charges

  • From Basic to Advance Level
  • 90 Chapters in Videos Format
  • 80 Excel Data / Practice Sheets
  • Validity – Lifetime
  • Entire Course in Hindi
  • No limitation for views (Unlimited)
  • All content-Downloadable 
  • Video Quality – HD
    Delivery Method – Google Drive
  • Accessible on Mobile, Computer/Laptop, Table, TV
  • Course Duration – 920 minutes
  • Version support Excel 2007,2010,2013,2016,2019
Advance Excel Course with MIS Report & Dashboard Report

SUPPORT
Call & Whatsapp +91 9536250020
Email - nazim.khan09@gmail.com

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

ABOUT INSTRUCTOR – NAZIM KHAN

TechGuruPlus.com owner Nazim Khan

Nazim Khan is a Microsoft Word & Excel Expert & Trainer, dedicated to helping you create outstanding tools and reports in Word & Excel. His courses are for those who want to learn Word & 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 Word, Excel & Tally. All the while using Microsoft Word & Excel to automate and improve processes.

For 5 years, Nazim runs his own website TechGuruPlus.com and has an active YouTube channel with many engaging, high-quality videos. He provides customized Word & Excel Report seminars, enhanced visualization techniques, and advanced Word & 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 Word & Excel tips and tricks he shares is based on the questions received from experienced professionals in his Word & Excel training sessions.

He places great value on keeping his Word & 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.

Screenshots