13 Most common option in excel used in every Business or Job.

Data Entry & Organization

Mathematical Calculations

Pivot Tables

Data Sorting & Filtering

Statistical Functions

Charting & Graphing:

Financial Analysis

Conditional Formatting

Automation with Macros

Data Import/Export

Collaboration

Project Management

Live Assignments

What is Microsoft Excel?

Microsoft Excel is a powerful spreadsheet software that allows users to organize, format, and calculate data using formulas. It is part of the Microsoft Office suite and is widely used in business, finance, research, and other fields for data analysis, reporting, and documentation. This Advance excel course will help you to learn 150+ most used formula, which you can master it for best job in every industry.

Highlights Points

Excel Introduction
• An Overview of The Screen, Navigation And Basic Spreadsheet Concepts, Various Selection Techniques
• Shortcut Keys & Create New Shortcut Keys
Customizing Excel
• Customizing the Ribbon
• Using and Customizing Autocorrect
• Changing Excel’s Default Options
Using Basic Functions
• Using Functions – Sum, Average, Max, Min, Count, Counta
• Absolute, Mixed and Relative Referencing Formatting and Proofing
• Currency Format
• Format Painter
• Formatting Dates
• Custom and Special Formats
• Formatting Cells with Number Formats, Font Formats, Alignment, Borders, Etc
• Basic Conditional Formatting

Mathematical Functions
• Sumif, Sumifs Countif, Countifs Averageif, Averageifs,
Nested If, Iferror Statement, And, Or, Not Protecting Excel
• File Level Protection
• Workbook, Worksheet Protection
Text Functions
• Upper, Lower, Proper
• Left, Mid, Right,• Trim, Len, Exact
• Concatenate, Find, Substitute, Search
• Char, Code, • Concat, Exact Textjoin
• Trim, Date And Time Functions
• Today, Now, • Day, Month, Year
• Date, Datedif, Date
• Eomonth, Weekday
• Workday, Workday.Intl
• Networkday, Networkday.Intl
Advanced Paste Special Techniques
• Paste Formulas, Paste Formats
• Paste Validations
• Go To Special

Transpose Tables
• Combo Charts – Secondary Axis
• Adding Slicers Tool In Pivot & Tables
• Sparklines -Line, Column & Win/ Loss
• New Controls In Pivot Table – Field, Items And Sets
• Various Time Lines In Pivot Table
• Auto Complete A Data Range And ListSorting And Filtering
• Filtering On Text, Numbers & Colours
• Sorting Options (Basic To Advance)
• Advanced Filters On Different Criteria(S) & Reply
Printing Workbooks
• Setting Up Print Area
• Customizing Headers & Footers
• Designing The Structure Of A Template
• Print Titles –Repeat Rows / Columns
What If Analysis
• Goal Seek
• Scenario Analysis
• Data Tables (Pmt Function)

Logical Functions• Simple If Statements• The Elseif Statements• Defining Select Case Statements• Merge Multiple Excel Files Into One Sheet• How To Fix Errors – Iferror, Nested If• Complex If And Or Functions (And, Or)• Nested If Data Validation• Number, Date & Time Validation• Text And List Validation• Custom Validations Based On Formula For A Cell• Dynamic Dropdown List Creation Using Data Validation – Dependency List Lookup Functions Lookup & References• Vlookup / Hlookup (2d & 3d Vlookup)• Index And Match• Creating Smooth User Interface Using Lookup• Nested Vlookup• Choose Function• Worksheet Linking Using Indirect Function• Vlookup With Helper Column• Array With Lookup Functions.• Column & Columns• Formulatext• Row & Rows• Xlookup• Offset• Transpose

Error Handling
• Aggregate
• Iferror
Pivot Tables For Mis Reporting
• Creating Simple Pivot Tables
• Basic And Advanced Value Field Setting
• Classic Pivot Table
• Choosing Field
• Filtering Pivottables
• Modifying Pivottable Data
• Grouping Based On Numbers And Dates & Text Group
• Calculated Field & Calculated Items
Charts And Slicers
• Various Charts I.E. Bar Charts / Pie Charts / Line Charts
• Using Slicers, Filter Data With Slicers

• Manage Primary And Secondary Axis
Excel Dashboard
• Planning A Dashboard
• Adding Tables And Charts To Dashboard
• Adding Dynamic Contents To Dashboard
• Multiple Dashboard Connection
Arrays Functions
• What Are The Array Formulas, Use Of The Array Formulas?
• Basic Examples Of Arrays (Using Ctrl+Shift+Enter).
• Array With If, Len And Mid Functions Formulas. Financial Function
• PMT • IPMT• PPMT
• NPV• NOMINAL
• EFFECTIVE• FV
• RATE• IRR
• AMORDEGRC• AMORLINC
• DB• DDB• SLN• SYD
• CUMPMT• CUMPRINC