Hello Sir/Mam,
I hope you are doing excellent in your life. I’m glad to announce that I am going to start a program named as “Excellence in Excel”. It’s an Advanced Level Excel Program. If you work in MS-Excel then it will definitely help you out to have a mastery over EXCEL.
Here, you can find the details regarding this program.
If you feel to join this program please give your details by clicking on Register Here Button.
Program Content
Advanced Excel Syllabus
Pre-Requisite :- Basic knowledge of MS-Excel.
Introduction to Excel
A description of the interface, the menu system, and the fundamentals of spreadsheets.
Personalising Excel
Changing Excel’s Default Options Using AutoCorrect and Customizing it
Customizing the Ribbon
Proofing and Formatting
Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
Basic conditional formatting
Protecting Excel- Excel Security
File Level Protection
Workbook, Worksheet Protection
Printing Workbooks
Setting Up Print Area
Customizing Headers & Footers
Designing the structure of a template
Print Titles –Repeat Rows / Columns
Advance Paste Special Techniques
Paste Formulas, Paste Formats
Transpose Tables
Paste Validations
Understanding References
Relative, Absolute & Mixed reference
Referencing different workbooks & Merging
Consolidating data, linking cells in different work books
Utilizing Dynamic Named Ranges for writing formulas and functions
Understanding and Using Basic Functions
Using Functions – Sum, Average, Max, Min, Count, Counta
Absolute, Mixed, and Relative Referencing
Text Functions
Upper, Lower, Proper
Left, Mid, Right
Trim, Len, Exact
Concatenate
Find, Substitute
Arithmetic Functions
SumIf, SumIfs, CountIf, CountIfs, AverageIf, AverageIfs
Time and Date Functions
Today, Now
Date, Date if, DateAdd
Day, Month, Year
Month, Weekday
Filtering and Sorting
Filtering on Text, Numbers & Colours
Sorting Options
Advanced Filters
Advance Excel
What-If Analysis
Goal Seek
Data Tables (PMT Function)
Solver Tool
Scenario Analysis
Data Validation
Number, Date & Time Validation
Dynamic Dropdown List Creation using Data Validation – Dependency List
Custom validations based on a formula for a cell
Text and List Validation
Logical Analysis
If Function
Complex if and or functions
Nested If
How to Fix Errors – iferror
Lookup Functions
Vlookup / HLookup
Vlookup with Helper Columns
Creating Smooth User Interface Using Lookup
Index and Match
Reverse Lookup using Choose Function
Nested VLookup
Worksheet linking using Indirect
Pivot Tables
Creating Simple Pivot Tables
Classic Pivot table
Basic and Advanced Value Field Setting
Calculated Field & Calculated Items
Grouping based on numbers and Dates
Data Presentation with charts
Types of charts and their specific uses- Trend line and advanced charts.
Manage Primary and Secondary Axis
Modifying and formatting existing charts.
Slicers and Charts
Using SLICERS, Filter data with Slicers
Excel Dashboard
Planning a Dashboard
Adding Dynamic Contents to Dashboard
Adding Tables and Charts to Dashboard