ADVANCE EXCEL EXPERT COURSE (HINDI)

Advance Excel Expert Course in Hindi

Call Now @ +91 9536250020

Price:- Rs. 2,000/- (INR)




 

What you’ll learn

  • 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 PivotTables and Pivot Charts
  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding of 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, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Learn how to automate daily routine tasks within Excel
  • Master the ESSENTIAL Excel formulas and features to accelerate your career
  • Learn Excel from scratch or fill in the gaps to become immediately confident
  • Learn to use Pivot Tables, Pivot Charts and Time Lines for Interactive Excel Reports
  • Access to a Professional Trainer with 10+ years of Excel Training

[divider][/divider]

WHY TAKE THIS SPECIFIC EXCEL COURSE?

Yes. There are many Microsoft Excel courses out there teaching you the important Excel functions and features you need to master. BUT, can you apply what you learnt to your own files? Do you get enough practice and challenges to remember all the new information?
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.
[divider][/divider]

TABLE OF CONTENT
DOWNLOAD PDF

CHAPTER NO. DURATION
(in minutes)
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 21:59 MAKING OF AUTOMATIC INVOICING SOFTWARE IN EXCEL
WITH VLOOKUP, IF FORMULA,
DEVELOPER TOOL-SPIN BUTTON & IF ERROR FORMULAS
CHAPTER-22 08:02 IF ELSE FORMULA, INSERT BLANK ROW BETWEEN HUGE DATA,
MERGE 2 COLUMN DATA IN SINGLE COLUMN
CHAPTER-23 04:35 TEXT TO COLUMN & FORMULAS AND PASTE SPECIAL FUNCTION,
CONVERT LAST NAME TO FIRST NAME
CHAPTER-24 17:32 MAKING OF GST REPORT FROM POS SOFTWARE EXPORTED DATA
CHAPTER-25 08:59 INSERT JUMPING SERIAL NO. & BLANK CELL WITH IF ELSE FORMULA
CHAPTER-26 03:46 UPPER, LOWER, PROPER FORMULAS IN EXCEL
CHAPTER-27 05:32 USE OF TABLE FUNCTION AND DATA VALIDATION
CHAPTER-28 09:46 VLOOKUP AND HLOOKUP WITH FULL EXPLANATION
CHAPTER-29 04:28 VLOOKUP WITH MULTIPLE CONDITIONS
CHAPTER-30 07:56 FORMULAS – SUM, SUMIF, SUMIFS, SUMPRODUCT
CHAPTER-31 06:03 SEPARATING NUMBER AND TEXT FROM ONE CELL
CHAPTER-32 10:30 SUM IF & COUNT IF FORMULA WITH 5 DIFFERENT EXAMPLE FILES
CHAPTER-33 07:17 PIVOT TABLE PART-1 WITH GST DATA LIVE EXAMPLE
CHAPTER-34 10:11 PIVOT TABLE PART-2 WITH STATE BANK OF INDIA LIVE EXAMPLE
CHAPTER-35 09:00 PIVOT TABLE PART-3 WITH RESTAURANT FOOD DATA LIVE EXAMPLE
CHAPTER-36 05:54 PIVOT TABLE PART-4 WITH SALES TEAM DATA LIVE EXAMPLE
CHAPTER-37 07:12 HOW TO CONVERT NUMBER TO TEXT IN EXCEL FULL EXPLAINED
CHAPTER-38 11:58 MAKING OF SALES CHART IN EXCEL
LINE CHART, PIE CHART, BAR CHART, FULLY CUSTOMIZATION
CHAPTER-39 06:05 FILTER IN EXCEL WITH DOCTORS LIVE DATA FULLY EXPLAINED
CHAPTER-40 04:39 EXCEL DATA AUTO SAVE SCRIPT WITH VBA CODE
CHAPTER-41 03:29 BLANK CELL FILL AUTOMATICALLY IN EXCEL
CHAPTER-42 05:58 IF ELSE FORMULA WITH PIVOT TABLE WITH SALES MAN COMMISSION DATA SHEET
CHAPTER-43 08:55 MACRO PART 2 – WITH SALARY DASHBOARD
CHAPTER-44 05:30 MACRO PART 3 – WITH SALES CHART
CHAPTER-45 05:51 MACRO PART 4 – WITH SALARY REGISTER
CHAPTER-46 11:06 MACRO PART 5 – MOBILE DEALER DATA AUTOSAVE IN SECOND EXCEL SHEET
CHAPTER-47 03:57 RANKING TOP 4 SUBJECTS FROM STUDENTS DATA
CHAPTER-48 17:48 ADVANCE DATA FORMATTING WITH 3 STUNNING EXAMPLE
SALARY CHART AND SALES CHART DATA
CHAPTER-49 05:45 DATA VALIDATION- INPUT MESSAGE, ERROR ALERT,
STYLING-STOP, WARNING, INFORMATION
CHAPTER-50 19:39 AUTOMATICL INVOICE SOFTWARE IN EXCEL
WITH CHECK BOX, RADIO BUTTON, GST AUTO-LOCAL & CENTRAL
CHAPTER-51 04:29 ABS ABSOLUTE FORMULA
CHAPTER-52 02:59 IF ELSE FORMULA WITH EASY EXAMPLE
CHAPTER-53 04:29 SORT DATA LEFT TO RIGHT AND TOP TO BOTTOM
CHAPTER-54 05:54 DOUBLE VLOOKUP & SINGLE VLOOKUP
CHAPTER-55 07:06 INDEX WITH MATCH FORMULA
CHAPTER-56 06:25 STOP DUPLICATE ENTRING VALUE
COUNTIF & DATA VALIDATION
CHAPTER-57 06:11 SUBTOTAL COMMAND, MIN, MAX, COUNT, AVERAGE, PRODUCT, VLOOKUP
CHAPTER-58 08:39 COMPARE TWO LIST WITH VLOOKUP AND FILTER
CHAPTER-59 07:46 SALES DATA MIS REPORT
CHAPTER-60 09:20 TIMELINE CHART WITH SMART ART GRAPHIC- STEP UP PROCESS GRAPH
CHAPTER-61 06:30 COMPARE TWO LIST WITH MATCH FORMULA AND FILTER
CHAPTER-62 07:03  IF FORMULA WITH PIVOT TABLE & CONDITIONAL FORMATTING
CHAPTER-63 07:09 MAKE INSHOP BRANDING FILE NAME LIST
CHAPTER-64 07:17 BANK STATEMENT PROBLEM SOLUTION
CHAPTER-65 06:03 CONVERT VERTICAL DATA TO HORIZONTAL
CHAPTER-66 16:47 ATTENDANCE SHEET PROBLEM SOLUTION
CHAPTER-67 04:15 ENTERING CROSS TICK RIGHT TICK
CHAPTER-68 04:02 COPY VISIBLE CELLS ONLY
CHAPTER-69 10:35 SCENARIO MANAGER COMMAND
CHAPTER-70 07:00 INDEPENDENT DROP DOWN LIST
CHAPTER-71 03:37 STUNNING USE OF IFS FORMULA
CHAPTER-72 07:55 EXCEL ERRORS EXPLAINATION
TYPE OF ERROR IN EXCEL
#DIV/0,   #VALUE!,    #REF!,    #NAME?
CHAPTER-73 08:06 FORMULAS- ISERROR, ISTEXT, ISFORMULA, ISNA, ISREF, DATA VALIDATION
CHAPTER-74 08:15 IF ELSE FORMULA WITH ISTEXT AND VLOOKUP
CHAPTER-75 08:23 EXCEL SHORTCUT KEYS 16NOS

[divider][/divider]

 

DESCRIPTION

Course Material Works in Microsoft Excel 2007, 2010, 2013, 2016 and 2019
Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Shortcut and Formulas.
  • Learn Excel from Scratch OR become more CONFIDENT.
  • Looking to learn Excel but don’t know where to start?
  • OR, you’ve been using Microsoft Excel for a while but don’t feel 100% confident?
I’ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.
In fact, I collected the most common Excel problems faced by my clients. I added in my 10+ years’ experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel Expert and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You’ll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don’t use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

[divider][/divider]

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

[divider][/divider]

Advance Excel Expert Course in Hindi

Call Now @ +91 9536250020

Price:- Rs. 2,000/- (INR)

 



 

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