Description
Table of Content
Excel for Beginners (Basic Excel)
Chapter – 01 4 ways to Start Excel
Chapter – 02 Excel Complete Structure
Chapter – 03 Write, Enter, Delete, Modify, Select Value
Chapter – 04 File Menu – New, Open, Save, Save AS, Print, Share, Export, Close, Account, Option
Chapter – 05 Quick Access Toolbar – Save, undo, Redo, Add or Remove Command
Chapter – 06 Cut, Copy, Paste, Format Painter, Clipboard
Chapter – 07 Font & Settings
Chapter – 08 Alignment & Settings
Chapter – 09 Number Format & Settings
Chapter – 10 Complete Conditional Formatting
Chapter – 11 Format As Table, Benefit of Converting Data in a Table, Cell Style
Chapter – 12 Insert and Delete Cell, Row, Column, Sheets
Chapter – 13 Format Commands All Options
Chapter – 14 AutoSum – Sum, Average, Count Numbers, Max, Min Fill – Down, Right, Up, Left, Across Worksheets, Series, Justify, Flash Fill Clear – Clear All, Clear Formats, Clear Contents, Clear Comments, Clear Hyperlinks, Remove Hyperlinks
Chapter – 15 Sort and Filter Find and Select – Find, Replace, Go To, Go To Special, Formulas, Comments, Conditional formatting, Constants, Data Validation, Select Objects, Selection Pane
Chapter – 16 Illustrations – Pictures, Online Pictures, Shapes, SmartArt, ScreenShot
Chapter – 17 Charts – All Types of Charts – Chart Filter, Chart Element, Chart Style, Chart Color
Chapter – 18 Hyperlink, Text – Text Box, Header & Footer, WordArt, Equation – Draw Equation (Math Input Tools), Symbol
Chapter – 19 Page Layout – Margins, Orientation, Size, Print Area, Breaks, Background, Print Titles, All Option in Page Setup
Chapter – 20 Text To Column Function
Chapter – 21 Remove Duplicate Function
Chapter – 22 Consolidate Function – Summarize Data
Chapter – 23 Goal Seek Function with 2 Examples
Chapter – 24 Group Ungroup Subtotal Function
Chapter – 25 Comments – New, Delete, Edit, Previous, Next, Show/Hide Comments, Show All Comments
Chapter – 26 View Tab Complete
Chapter – 27 Start new Line in Same Cell
Chapter – 28 Reference – Why we lock Cells/Range
Chapter – 29 Save 1000s Excel Charts as image in 1 second
Chapter – 30 How to Use Flash Fill
Chapter – 31 Sort Data Row Wise
Chapter – 32 Filter Secret Tips and Tricks
Chapter – 33 Convert image to Excel
Chapter – 34 Data Entry Work in excel
Chapter – 35 Write Big Number in Excel
Chapter – 36 How to Use Macro in Excel
Chapter – 37 Remove Extra Space from Excel Sheet
Chapter – 38 How to Save Excel File as PDF
Chapter – 39 How to Use Hyperlink on Same Sheet
Chapter – 40 Link Excel File to MS Word Automatic Update
Chapter – 41 How to Protect Excel File to and open
Chapter – 42 7 Ways to SUM, Subtract, Multiple, Divide
Chapter – 43 Percentage Calculation (3 examples)
Chapter – 44 Index Formula
Chapter – 45 Match Formula
Chapter – 46 Count, Counta, CountBlank Formula
Chapter – 47 Vlookup Formula
Chapter – 48 SUMIF and SUMIFS Formula
Chapter – 49 If Formula
Chapter – 50 Hlookup Formula
Chapter – 51 Rand & RandBetween Formula
Chapter – 52 SumProduct Formula
Chapter – 53 Create Normal and 3D Check Box
Chapter – 54 Split Data from One Column to Multiple Column
Table of Content
Advanced MS Excel
Chapter – 01 Data Connection – Link Multiple Sheets
Chapter – 02 Pivot Table & Pivot Chart
Chapter – 03 Refresh Pivot Table (4 Method)
Chapter – 04 Create Pivot Table from Multiple Sheets
Chapter – 05 Split Data from Master Sheet to Multiple Sheets
Chapter – 06 How to Use Slicer in Excel
Chapter – 07 Prepare Dynamic MIS Report
Chapter – 08 Maintain Multiple Stock / Inventory in Excel
Chapter – 09 Prepare Attendance Register
Chapter – 10 Make Search Box Using Conditional Formatting (New Rule)
Chapter – 11 Google Translate formula
Chapter – 12 3 Best Method to Transpose Excel Data
Chapter – 13 5 Way to Remove Duplicates Data
Chapter – 14 4 Way to Add Zero Before any Number
Chapter – 15 Excel Sheets Tips and Tricks
Chapter – 16 Make Automatic Update Drop Down List
Chapter – 17 How 50 people can work on 1 Excel file at same time
Chapter – 18 Best Method to Calculate Running Total
Chapter – 19 Create Notification or Reminder for Due Dates
Chapter – 20 160+ MS Excel Keyboard Shortcuts
Chapter – 21 Make Fully Automatic GST Invoice – Multi GST Rate & Items
Chapter – 22 How to Save Each Invoice in PDF format automatically
Chapter – 23 Unstack Excel Data from One Column to Multiple Column
Chapter – 24 How to Convert any Image or Printout to Excel
Chapter – 25 Mail Merge with Decimal Problem Solution
Chapter – 26 Recover Unsaved Excel file without software or website
Chapter – 27 Prevent/Stop Duplicate Entries in Excel
Chapter – 28 Excel Trick to Find Wrong Mobile Number
Chapter – 29 7 way to Jump on any Excel Sheet
Chapter – 30 Amazing Use of 1 Number Value
Chapter – 31 How to Hide Formula
Chapter – 32 Convert any Text to lower Proper UPPER case in same cell
Chapter – 33 How to Highlight a Particular Word or Number
Chapter – 34 Serial No. and formula Error in Data Filtering
Chapter – 35 Create Data Entry form
Chapter – 36 Highlight Active Cell Row and Column
Chapter – 37 Unlock Password Protected Sheet without knowing Password
Chapter – 38 Maintain Overtime & Overtime Wages
Chapter – 39 3 Formula to Calculate Rank
Chapter – 40 Amazing Use of Double Vlookup Formula
Chapter – 41 Amazing Use of Hlookup Formula
Chapter – 42 How Fuzzy lookup Better than Vlookup and Hlookup
Chapter – 43 Picture Lookup in Excel
Chapter – 44 Subtotal – the most powerful formula in excel
Chapter – 45 Sumif Vs Sumifs – Know the real difference
Chapter – 46 Value Formula – You must know about it
Chapter – 47 Index + Match Formula better than Vlookup & Hlookup
Chapter – 48 Quotient and Mod Formula
Chapter – 49 How to Add Search Box in Slicer Function
Chapter – 50 Compare Two List with Match Formula
Chapter – 51 Import 1000s Contact Number in Smartphone from Excel Sheet
Chapter – 52 Convert Formula – Easy way to convert units
Chapter – 53 Forecast Formula – Get estimated growth
Chapter – 54 Average Vs Averageif Formula in Excel
Chapter – 55 Countif Formula in Excel (many examples)
Chapter – 56 Concatenate Formula and & symbol alternative
Chapter – 57 Average, Averageif and Averageifs Formula
Chapter – 58 Make Searchable Drop Down List
Chapter – 59 Insert Right Tick and Cross Tick
Excel Tips and Tricks Section
Part 1 Excel 12 Tips and Tricks
Part 2 Excel 06 Tips and Tricks
Part 3 Excel 06 Tips and Tricks
Part 4 Excel 02 Tips and Tricks
Part 5 Excel 07 Tips and Tricks
Part 6 Excel 05 Tips and Tricks
Part 7 Excel 05 Tips and Tricks
Part 8 Excel 04 Tips and Tricks
Part 9 Excel 01 Tips and Tricks
Most Important :
Course Language – Hindi
Course Validity – Lifetime
Course Duration – 26+ Hours
File Size for All Videos & Practice File – 5 GB
Access – TV Mobile Computer
Delivery Method – Online
Video Quality – Full HD
Refund – Money not refunded to you if you purchase this course
*Certificate – We will conduct Online Exam, if you qualify in the exam than course completion certificate will be provided
Reviews
There are no reviews yet.