X
Sign up
Menu
X
Menu

Advanced Excel Expert By Nazim Khan

by Nazim Khan

4.9 (2206 Users)
Computer skills , Microsoft
Language: Hindi

Mode- Online
Videos- 75
Study Notes- 71
Validity- Lifetime
Language- Hindi
No. of Views- Unlimited

WHAT WILL I LEARN?

  • A Step By Step Online Training Course
  • Be an Excel Expert
  • Learn Advanced Excel Course from the Best
  • Get Your Dream Job by Enhancing Your Excel Skills.
  • Practice Your Skills with Free Practice Sheets given in this Course
  • Lifetime Access of the Course

Click Here To Download Table of Content Download CourseDownload Table of Content PDF

Curriculum

Chapter 01

  • EXCEL INTRODUCTION
    WORKBOOK, TITLE BAR, QUICK ACCESS TOOLBAR,
    RIBBON, TAB, NAME BOX,
    FORMULA BAR, COLUMN, ROW,
    SPREADSHEET , GRID AREA, CELL,
    SCROLL BAR, ZOOM SELECTION,
    RANGE, NAME A RANGE

Chapter 02

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

Chapter 3

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

Chapter 4

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

Chapter 5

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

Chapter 6

  • 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
  • Practice Sheet

Chapter -7

  • 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,
  • Practice Sheet

Chapter 8

  • 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 FORMAT ING
  • Practice Sheet

Chapter 9

  • 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,
  • Practice Sheet

Chapter -12

  • ENTERING & FORMATTING DATA IN EXCEL
  • Practice Sheet

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
  • Practice Sheet

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
  • Practice Sheet

Chapter -15

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

Chapter -16

  • CREATING FORMULA AND FUNCTION
  • Practice Sheet

Chapter -17

  • FORMATTING DATA IN EXCEL
  • Practice Sheet

Chapter -18

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

Chapter -19

  • ROUND FORMULAS
    ROUND, ROUND UP, ROUND DOWN, MROUND
  • Practice Sheet

Chapter -20

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

Chapter -21

  • MAKING OF AUTOMATIC INVOICING SOFTWARE IN EXCEL
    WI TH VLOOKUP, IF FORMULA,
    DEVELOPER TOOL -SPIN BUTTON & IF ERROR FORMULAS
  • Invoice Example
  • Invoice Format Ready

Chapter -22

  • IF ELSE FORMULA, INSERT BLANK ROW BETWEEN HUGE
    DATA, MERGE 2 COLUMN DATA IN SINGLE COLUMN
  • Code List
  • Name and Address List

Chapter -23

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

Chapter -24

  • MAKING OF GST REPORT FROM POS SOFTWARE EXPORTED DATA
  • Practice Sheet

Chapter -25

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

Chapter -26

  • UPPER, LOWER, PROPER FORMULAS IN EXCEL
  • Practice Sheet

Chapter -27

  • USE OF TABLE FUNCTION AND DATA VALIDATION
  • Practice Sheet

Chapter -28

  • VLOOKUP AND HLOOKUP WITH FULL EXPLANATION
  • Data Full List
  • Vlookup and Hlookup Formula Sheet

Chapter -29

  • VLOOKUP WITH MULTIPLE CONDITIONS
  • Practice Sheet

Chapter -30

  • FORMULAS - SUM, SUMIF , SUMIFS, SUMPRODUCT
  • Practice Sheet

Chapter -31

  • SEPARATING NUMBER AND TEXT FROM ONE CELL
  • Practice Sheet- Separate Number and Text
  • Separate Number and Text ( Code )

Chapter -32

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

Chapter 33

  • PIVOT TABLE PART -1 WITH GST DATA LIVE EXAMPLE
  • Practice Sheet

Chapter 34

  • PIVOT TABLE PART -2 WITH STATE BANK OF INDIA LIVE
    EXAMPLE
  • Practice Sheet

Chapter -35

  • PIVOT TABLE PART -3 WITH RESTAURANT FOOD DATA LIVE
    EXAMPLE
  • Practice Sheet

Chapter 36

  • PIVOT TABLE PART -4 WITH SALES TEAM DATA LIVE
    EXAMPLE
  • Practice Sheet

Chapter 37

  • HOW TO CONVERT NUMBER TO TEXT IN EXCEL FULL
    EXPLAINED
  • Number_to_Text
  • Number_to_Text_Example

Chapter 38

  • MAKING OF SALES CHART IN EXCEL, LINE CHART,
    PIE CHART, BAR CHART, FULLY CUSTOMIZATION
  • Practice Sheet

Chapter 39

  • FILTER IN EXCEL WITH DOCTORS LIVE DATA FULLY
    EXPLAINED
  • Practice Sheet

Chapter 40

  • EXCEL DATA AUTO SAVE SCRIPT WITH VBA CODE
  • Chapter 40 Code

Chapter 41

  • BLANK CELL FILL AUTOMATICALLY IN EXCEL
  • Practice Sheet

Chapter 42

  • IF ELSE FORMULA WITH PIVOT TABLE WITH
    SALES MAN COMMISSION DATA SHEET
  • Practice Sheet

Chapter 43

  • MACRO PART 2 - WITH SALARY DASHBOARD
  • Salary Sheet with Command Button
  • Salary Sheet

Chapter 44

  • MACRO PART 3 - WITH SALES CHART
  • Practice Sheet

Chapter 45

  • MACRO PART 4 - WITH SALARY REGISTER
  • Practice Sheet

Chapter 46

  • MACRO PART 5 - MOBILE DEALER DATA AUTOSAVE
    IN SECOND EXCEL SHEET
  • Company Data
  • Macro Coding File

Chapter 47

  • RANKING TOP 4 SUBJECTS FROM STUDENTS DATA
  • Practice Sheet

Chapter 48

  • ADVANCE DATA FORMATTING WITH 3 STUNNING EXAMPLE
    SALARY CHART AND SALES CHART DATA
  • Formated Report
  • Not Formated (Sheet for Practice)

Chapter 49

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

Chapter 50

  • AUTOMATIC INVOICE SOFTWARE IN EXCEL
    WITH CHECK BOX, RADIO BUTTON,
    GST AUTO- LOCAL & CENTRAL
  • Practice Sheet

Chapter 51

  • ABS ABSOLUTE FORMULA
  • Practice Sheet

Chapter 52

  • IF ELSE FORMULA WITH EASY EXAMPLE
  • Practice Sheet

Chapter 53

  • SORT DATA LEFT TO RIGHT AND TOP TO BOTTOM
  • Practice Sheet

Chapter 54

  • DOUBLE VLOOKUP & SINGLE VLOOKUP
  • Practice Sheet

Chapter 55

  • INDEX WITH MATCH FORMULA
  • Practice Sheet

Chapter 56

  • STOP DUPLICATE ENTRING VALUE
    COUNTIF & DATA VALIDATION
  • Practice Sheet

Chapter 57

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

Chapter 58

  • COMPARE TWO LIST WITH VLOOKUP AND FILTER
  • Practice Sheet

Chapter 59

  • SALES DATA MIS REPORT
  • Practice Sheet

Chapter 60

  • TIMELINE CHART WITH SMART ART GRAPHIC- STEP UP
    PROCESS GRAPH
  • Timeline Chart
  • Timeline Chart Data

Chapter 61

  • COMPARE TWO LIST WITH MATCH FORMULA AND FILTER
  • Practice Sheet

Chapter 62

  • IF FORMULA WITH PIVOT TABLE & CONDITIONAL
    FORMATTING
  • Practice Sheet

Chapter 63

  • MAKE INSHOP BRANDING FILE NAME LIST

Chapter 64

  • BANK STATEMENT PROBLEM SOLUTION

Chapter 65

  • CONVERT VERTICAL DATA TO HORIZONTAL
  • Practice Sheet

Chapter -66

  • ATTENDANCE SHEET PROBLEM SOLUTION
  • Practice Sheet

Chapter 67

  • ENTERING CROSS TICK RIGHT TICK
  • Practice Sheet

Chapter 68

  • COPY VISIBLE CELLS ONLY
  • Practice Sheet

Chapter 69

  • SCENARIO MANAGER COMMAND
  • Practice Sheet

Chapter 70

  • INDEPENDENT DROP DOWN LIST
  • Practice Sheet

Chapter 71

  • STUNNING USE OF IFS FORMULA
  • Practice Sheet

Chapter 72

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

Chapter 73

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

Chapter 74

  • IF ELSE FORMULA WITH ISTEXT AND VLOOKUP
  • Practice Sheet

Chapter 75

  • EXCEL SHORTCUT KEYS 16NOS

About Nazim Khan

Nazim Khan

Professional Excel Expert & Excel Trainer with more than 10 years of experience in Microsoft Excel, B.com & MBA in Finance. Trained more than 50,000 people online. Currently, Trainer with We Make Creators providing online Professional Excel Training with his skill & expertise.

If you have any doubts about how to get and access this course,watch this video.

Student's Feedback

10000 2000

Includes 18 % GST

Mode- Online

Videos- 75

Study Notes- 71

Validity- Till Lifetime

Language- Hindi

No. of Views- Unlimited