netjagat

Excellence in Excel

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.

Excellence-in-Excel

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