10 session course to become an expert in Excel
Course Fee - INR 3,999/- only
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 this 10 day journey. By enrolling in this course, you will be to learn simple, easy and efficient solutions to issues you face in your day-to-day reports and workings.
👉 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
👉 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