EXCEL FOR BEGINNERS (Hindi)

Course Fee - Just Rs 1500/- only 

Why it's important!

Microsoft Excel is the most powerful and much used tool all over the world. It's is an aeroplane, while we tend to ride a bicycle. Let's learn some smart features of Excel in these 6 Days session. By enrolling in this course, you will learn simple, easy and efficient solutions to issues you face in your day-to-day reports and workings. Learn MS Excel in just 6 Days.

COURSE CURRICULUM

Excel for Beginners (Hindi)
  • Day 1 Session
  • Day 2 Session
  • Day 3 Session
  • Day 4 Session
  • Day 5 Session
  • Day 6 Session
Working File
  • 6 Days Session working file

Special Highlights of the Course 

πŸ‘‰Introduction to Excel: Versions 2007...Office 365: Why Latest Version!

πŸ‘‰ Excel Screen Unexplored Basics - Great Time Saver

πŸ‘‰ Smart Copy/Paste

πŸ‘‰ Smart Formatting

πŸ‘‰ Custom Lists      

πŸ‘‰ How to Create Shortcut Keys (Customize Quick Access Tool Bar)      

πŸ‘‰ Excel Magic - Flash Fill

πŸ‘‰ Select Blanks/visible/formulas/errors/constant cell only (F5)

πŸ‘‰ Conditional Formatting- Data Bars, ICON Sets, Duplicates

πŸ‘‰ Data Filter/Advanced Filter - Single click filtering

πŸ‘‰ Removing/Copying Duplicates

πŸ‘‰ Data Consolidation

πŸ‘‰ Single Click Filtering

πŸ‘‰ Sub Totals, Grouping

πŸ‘‰ Data Consolidation, Name Manager

πŸ‘‰ Text Functions - LEFT, RIGHT, MID, UPPER, LOWER, PROPER, LEN, TRIM, MID, SEARCH

πŸ‘‰ New Function TEXTJOIN

πŸ‘‰ Text to Column

πŸ‘‰ Logical Functions - IF, NESTED IF, IFS

πŸ‘‰ Rounding Functions

πŸ‘‰ Date and Time Functions

πŸ‘‰ Most Used Formulas in Excel - Lookups

     VLOOKUP/XLOOKUP

πŸ‘‰ COUNT, COUNTA, COUNTIFS, SUMIFS, AVERAGEIFS

πŸ‘‰Protect Sheet, Protect few Cells/Column of a sheet

πŸ‘‰ Pivot Table

πŸ‘‰ Dashboards

πŸ‘‰ Macros - Overview

SUBSCRIBE
CONNECT WITH US