Basic to Advanced (Hindi) 

Course Fee - INR 3,000

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 10 sessions. 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.

COURSE CURRICULUM

Basic to Advanced (Hindi)
  • Basic to Advanced (Hindi) Day 1
  • Basic to Advanced (Hindi) Day 2
  • Basic to Advanced (Hindi) Day 3
  • Basic to Advanced (Hindi) Day 4
  • Basic to Advanced (Hindi) Day 5
  • Basic to Advanced (Hindi) Day 6
  • Basic to Advanced (Hindi) Day 7
  • Basic to Advanced (Hindi) Day 8
  • Basic to Advanced (Hindi) Day 9
  • Basic to Advanced (Hindi) Day 10
Downloadable Working Files
  • Downloadable Working Files

Special Highlights of the Course


👉 Excel Screen Basics 

👉 Smart Copy/Paste 

👉 Creating own shortcut keys

👉 Paste specials 

👉 Go To Command 

👉 Advanced Sorting

👉 Excel Magic – Flash Fill

👉 Conditional Formatting- Data Bars, ICON Sets, Duplicates

👉 Data Filter/Advanced Filter/Group/Subtotal - Single click filtering

👉 Data Validation

👉 Data Consolidation

👉 Formulas - Concepts, Absolute & Relative Referencing

👉 Text function - LEFT, RIGHT, TEXT, TRIM, MID, SEARCH, SUBSTITUTE, CONCAT, TEXT JOIN ETC 

👉 Logical function - IF, NESTED IFS

👉 Statistical function -AVERAGE, AVERAGEIFS, COUNT, COUNTA, COUNTBLANK, COUNTIFS

👉 Math Function- ROUND, CEILING, FLOOR, SUMIFS Etc. 

👉 Date and time function -EOMONTH, EDATE, Workday, Network day, Date, Month, Year Etc.

👉 LookUps – VLOOKUP, Dynamic Lookups, Lookup from Left Side, Multi VLookups

👉 Advanced and New Formulas of Office 365

👉 Pivot tables : Basic Concepts and Pre Conditions

👉 Creating pivot tables, Pivot tables options Changing and updating data range

👉 Create weekly Report, Monthly Report, yearly Report, quarterly Report

👉 Ageing Analysis

👉 Multiple reports with Single Click

👉 Pivot Charts

👉 Slicer, Time Lines

👉 Dash Boards

👉 Goal Seek, Watch Window

👉 Protection Sheet, Cell, Workbook, File

👉 In Between Exercises 

👉 Q&A

SUBSCRIBE

CONNECT WITH US