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) 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
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
