Excel (Basic & Advanced)

Book Demo

Excel (Basic & Advanced)

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.

Training Modes:

Online Training
Corporate Training
Video Training

Training Highlights:

  •  Excel Basics and Interface
  •  File Management and OneDrive Integration
  •  Data Formatting Essentials
  •  Alignment and Cell Merging Techniques
  •  Number Formatting and Styles
  •  Conditional Formatting Tools
  •  Data Entry and Quick Functions
  •  Sorting, Filtering, and Subtotals
  •  Sorting, Filtering, and Subtotals
  •  Pivot Tables for Data Analysis
  •  Charting and Visualization
  •  Creating MIS Reports and Dashboards

Excel (Basic & Advanced)

Brochure Download
Register Now

Mastering Excel: The Ultimate Guide to Data Magic, Analysis & Automation

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

  1. CUT, COPY, PASTE, FORMAT PAINTER,
  2. FONT CHANGING,BOLD ITALIC, UNDERLINE,
  3. BORDER, CELL COLOR, TEXT COLOR

  1. ALIGNMENTS, ORIENTATION,INCREASE AND DECREASE INDENT, WRAP TEXT, MERGE & CENTER,
  2. MERGE ACROSS, MERGE CELLS, UNMERGE CELLS

  1. NUMBER FORMATTING FUNCTION, PERCENTAGE STYLE, COMMA STYLE, DECIMAL INCREASE & DECREASE,
  2. SCIENTIFIC FUNCTION

  1. CONDITIONAL FORMATTING-HIGHLIGHT CELLS RULES,
  2. TOP-BOTTOM RULES, DATA BARS, COLOR SCALES,
  3. ICON SETS, NEW RULE, CLEAR RULES,
  4. MANAGE RULES, FORMAT AS TABLE,
  5. USE FORMULA IN CONDITIONAL FORMATTING

  1. INSERT CELL, ROW, SHEET, DELETE CELL,
  2. ROW SHEET, FORMAT ROW HEIGHT AND WIDTH, ORGANIZE SHEETS,
  3. RENAME, HIDE UNHIDE, TAB COLOR, LOCK CELL, PROTECT SHEET WITH PASSWORD,

  1. AUTOSUM, AVERAGE, COUNT NUMBERS,
  2. MAX, MIN, FILL DOWN, RIGHT, UP, LEFT, SERIES, JUSTIFY,
  3. CLEAR FORMAT, CONTENT, COMMENT, HYPERLINK,
  4. FIND COMMAND & REPLACE COMMAND,
  5. FIND COMMENT, FIND FORMULAS, FIND OBJECT, FIND CONDITION FORMATING

  1. FLASH FILL COMMAND WITH 7 EXAMPLES

  1. SORT COMMAND, FILTER COMMAND, SUM WITH SUBTOTAL

  1. INSERTING LOGO AND IMAGE IN EXCEL
  2. IMAGE BORDER, IMAGE CROPPING, ROTATE PICTURE
  3. IMAGE CORRECTION, COLOR, ARTISTIC EFFECTS
  4. PICTURE EFFECTS FUNCTION, SHADOW, REFLECTION

  1. ENTERING & FORMATTING DATA IN EXCEL

  1. CHARTS (LIKE-PIE OR BAR ETC.)
  2. SHAPES
  3. FORWARD AND BACKWARD FUNCTION
  4. OBJECT FUNCTION IN EXCEL
  5. INSERTING SYMBOLS IN EXCEL
  6. USE OF TEXTBOX
  7. EXCEL THEME- COLOR, THEME-FONT
  8. EFFECTS FUNCTION
  9. USE OF ZOOMING FUNCTION
  10. SCREENSHOT WITH EXCEL

  1. PRINTING DATA, PAGE MARGINS FULL SETTING
  2. ORIENTATION AND PAGE SIZE SETTING
  3. PRINT AREA FUNCTION
  4. PAGE BREAKS FUNCTION
  5. WORKSHEET BACKGROUND
  6. PRINT TITLES FUNCTION
  7. SETTING OF WIDTH, HEIGHT AND SCALING OF PAGE
  8. USE OF GRID LINE AND ITS EFFECT
  9. GRIDLINE PRINTING
  10. USE OF HEADING FUNCTION

  1. SPELLING CHECKER FUNCTION
  2. THESAURUS FUNCTION
  3. TRANSLATE FUNCTION
  4. SWITCHING WINDOWS
  5. USE COMMENT FUNCTION

  1. CREATING FORMULA AND FUNCTION

  1. FORMATTING DATA IN EXCEL

  1. PRINTING FULL CONFIGURATION
  2. PAPER SIDE, MARGINS, SCALING,
  3. FIT SHEET ON ONE PAGE
  4. ROW TO REPEAT AT TOP, SET PRINT AREA,
  5. FINAL PRINTING

  1. ROUND FORMULAS
  2. ROUND, ROUND UP, ROUND DOWN, MROUND

  1. COUNT FORMULAS
  2. COUNT, COUNT A, COUNT IF,
  3. COUNTIFS, COUNTBLANK

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

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

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

  1. UPPER, LOWER, PROPER FORMULAS IN EXCEL

  1. USE OF TABLE FUNCTION AND DATA VALIDATION

  1. VLOOKUP AND HLOOKUP WITH FULL EXPLANATION

  1. VLOOKUP WITH MULTIPLE CONDITIONS

  1. FORMULAS – SUM, SUMIF, SUMIFS, SUMPRODUCT

  1. SEPARATING NUMBER AND TEXT FROM ONE CELL

  1. SUM IF & COUNT IF FORMULA WITH
  2. 5 DIFFERENT EXAMPLE FILES

  1. HOW TO CONVERT NUMBER TO TEXT IN EXCEL
  2. FULLY EXPLAINED

  1. FILTER IN EXCEL WITH DOCTORS LIVE DATA
  2. FULLY EXPLAINED

  1. EXCEL DATA AUTOSAVE SCRIPT WITH VBA CODE

  1. BLANK CELL FILL AUTOMATICALLY IN EXCEL

  1. IF ELSE FORMULA WITH PIVOT TABLE WITH SALESMAN COMMISSION DATA SHEET

  1. MACRO PART 2 – WITH SALARY DASHBOARD

  1. MACRO PART 3 – WITH SALES CHART

  1. MACRO PART 4 – WITH SALARY REGISTER

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

  1. RANKING TOP 4 SUBJECTS FROM STUDENTS DATA

  1. DATA VALIDATION- INPUT MESSAGE, ERROR ALERT,
  2. STYLING-STOP, WARNING, INFORMATION

  1. ABS ABSOLUTE FORMULA

  1. IF ELSE FORMULA WITH EASY EXAMPLE

  1. SORT DATA LEFT TO RIGHT AND TOP TO BOTTOM

  1. DOUBLE VLOOKUP & SINGLE VLOOKUP

  1. INDEX WITH MATCH FORMULA

  1. STOP DUPLICATE ENTRING VALUE
  2. COUNTIF & DATA VALIDATION

  1. SUBTOTAL COMMAND, MIN, MAX, COUNT,
  2. AVERAGE, PRODUCT, VLOOKUP

  1. COMPARE TWO LIST WITH VLOOKUP AND FILTER

  1. COMPARE TWO LIST WITH MATCH FORMULA AND FILTER

  1. IF FORMULA WITH PIVOT TABLE & CONDITIONAL FORMATTING

  1. MAKE INSHOP BRANDING FILE NAME LIST

  1. BANK STATEMENT PROBLEM SOLUTION

  1. CONVERT VERTICAL DATA TO HORIZONTAL

  1. ATTENDANCE SHEET PROBLEM SOLUTION

  1. ENTERING CROSS TICK RIGHT TICK

  1. COPY VISIBLE CELLS ONLY

  1. STUNNING USE OF IFS FORMULA

  1. EXCEL ERRORS EXPLANATION
  2. TYPE OF ERROR IN EXCEL
  3. #DIV/0, #VALUE!, #REF!, #NAME?

  1. FORMULAS- ISERROR, ISTEXT, ISFORMULA, ISNA, ISREF, DATA VALIDATION

  1. IF ELSE FORMULA WITH ISTEXT AND VLOOKUP

  1. EXCEL SHORTCUT KEYS 16NOS

  1. ADVANCE FILTER, DIFFERENCE BETWEEN NORMAL FILTER AND ADVANCE FILTER

  1. FLASH FILL AUTO FILL

  1. NAME A RANGE IN SALES REPORT
  2. DIFFERENCE BETWEEN LIST, STATUS BAR TOOL,

  1. MAKING OF BANK RE-PAYMENT SCHEDULE
  2. USING PMT, IPMT, PPMT FORMULA

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

  1. USING OF ADVANCE TRANSPOSE,
  2. HIDE CELL VALUE, DATE PICKET TOOL

  1. HOW TO MAKE MONEY ONLINE WITH EXCEL KNOWLEDGE

  1. MAKING OF EMPLOYEES ICARD IN EXCEL
  2. USING INDEX AND MATCH FORMULA, DATA VALIDATION,
  3. VLOOKUP, TRANSPOSE, LINKED PICTURE TOOL & NAME MANAGER

No Content

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

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

  1. MIS REPORT (Part-3)
  2. MAKING OF GST REPORT FROM
  3. POS SOFTWARE EXPORTED DATA

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

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

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

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

  1. MIS REPORT (Part-8)
  2. MAKING OF SALES CHART IN EXCEL
  3. LINE CHART, PIE CHART, BAR CHART,
  4. FULLY CUSTOMIZATION

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

  1. MIS REPORT (Part-10)
  2. SALES DATA MIS REPORT

  1. MIS REPORT (Part-11)
  2. TIMELINE CHART WITH SMART ART GRAPHIC
  3. STEP UP PROCESS GRAPH

  1. MIS REPORT (Part-12)
  2. SCENARIO MANAGER COMMAND

  1. MIS REPORT (Part-13)
  2. INDEPENDENT DROP DOWN LIST

  1. MIS REPORT (Part-14)
  2. AUTO CHANGEABLE EXCEL DATA EMBEDDING TO WORD
  3. NETWORK DAYS FORMULA

  1. MIS REPORT (Part-15)
  2. GOAL SEEK TO GET TARGETED VALUE IN CELL
  3. QUICK ANALYSIS TOOL

  1. MIS REPORT (Part-16)
  2. APPLYING SLICER IN SALES REPORT
  3. TABLE, CONVERT TO RANGE, SLICER DESIGN TOOL

  1. MIS REPORT (Part-17)
  2. SALES PERFORMANCE – INTRACTIVE DASHBOARD REPORT
  3. ANALYSIS REPORT BY MONTHLY SALES,
  4. ANALYSIS SALES REPORT BY PRODUCT,
  5. ANALYSIS SALES REPORT BY QUANTITY,
  6. ANALYSIS SALES REPORT BY COMPANY,
  7. ANALYSIS SALES REPORT BY LOCATION
  8. REPORT USING BY CHARTS, DIAGRAM,
  9. PIVOT TABLE, SLICER ETC.

  1. MIS REPORT (Part-18)
  2. AUTO SEARCH FORMULA
  3. SEARCH VALUE AUTOMATICALLY IN GST SALES DATA

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

  1. MIS REPORT (Part-20)
  2. INTERACTIVE CORPORATE DASHBOARD REPORT
  3. REPORT USING BY CHARTS, DIAGRAM, PIVOT TABLE
  4. AUTOMATIC MONTHLY SALES REPORTING
  5. COUNTRY WISE & CITY WISE SALES REPORT
  6. PRODUCT WISE SALES REPORT
  7. WITH COMPANY’s SOCIAL MEDIA HYPERLINK
  8. SLICER & TIMELINE CHART
  9. SALES TARGET ACHIEVEMENT AUTO CHART
  10. SLICER CUSTOMIZATION

Why Choose Excel (Basic & Advanced)

  •  100% Real-Time and Practical
  •  Concept wise FAQs
  •  TWO Real-time Case Studies, One Project
  •  24/7 LIVE Server Access
  •  Realtime Project FAQs
  •  Course Completion Certificate
  •  Placement Assistance
  •  Job Support
REGISTER NOW

Book Your FREE Demo Now!

Council for Inclusive Development

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project.

REGISTER TODAY!
Live Online Training
Corporate Training
Videos Training
CALL NOW +7905830865
Scroll to Top