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
- Day 1 Session
- Day 2 Session
- Day 3 Session
- Day 4 Session
- Day 5 Session
- Day 6 Session
- 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
