Microsoft Excel from Beginners to Advanced with Certificate

Sale!

399

What you’ll learn

  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, HLOOKUP, INDEX, MATCH, SLICER, PIVOT TABLS, FLASH FILL, IF, AVERAGE, COUNTA, SUMIF, SUBTOTAL, VALUE, and many more…)
  • Create Dynamic MIS report with Excel PivotTables
  • Learn how to work with charts in excel
  • 160+ Keyboard Shortcuts to make your excel superstar
  • 40+ Excel Magical Tips and Tricks to make your office work easier
  • 40+ Excel basic and Advanced formulas

This course Includes

  • 26+ Hours Course Duration
  • Course Completion Certificate
  • Downloadable Video
  • Practice Files
  • Lifetime Access
  • New update
  • Access on Mobile TV Computer

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

Microsoft Excel from Beginners to Advanced with Certificate

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel from Beginners to Advanced with Certificate”

Your email address will not be published. Required fields are marked *

Scroll to top