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
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
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
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
