Kalyan Best Web Designing Service | IT Institute

Advance Excel Course Training

Duration: 1 Month

Looking for an advanced Excel course in Kalyan? Our Excel training program in Kalyan offers top-notch instruction to help you master advanced Excel skills. We provide the best advanced Excel certification and advanced Excel classes designed to enhance your expertise. Whether you're seeking Excel expert training or a comprehensive course, join us today and elevate your Excel skills to the next level!

Download Advance Excel Syllabus

Excel Introduction

An overview of the screen, navigation and basic spreadsheet concepts
Various selection techniques
Shortcut Keys
What is Spreadsheet
Using Basic Functions
Using Functions – Sum, Average, Max, Min, Count, Counta
Subtotal
Use of Ctrl+D
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
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
Date and Time Functions
Today, Now
Day, Month, Year
Date, Date if, DateAdd
EOMonth, Weekday
Advanced Paste Special Techniques
Paste Formulas, Paste Formats
Paste Validations
Transpose Tables
New in Excel 2013 / 2016 & 365
New Charts – Tree map & Waterfall
Sunburst, Box and whisker Charts
Combo Charts – Secondary Axis
Adding Slicers Tool in Pivot & Tables
Using Power Map and Power View
Forecast Sheet
Sparklines -Line, Column & Win/ Loss
Using 3-D Map
New Controls in Pivot Table – Field, Items and Sets
Various Time Lines in Pivot Table
Auto complete a data range and list
Quick Analysis Tool
Smart Lookup and manage Store
Sorting and Filtering
Filtering on Text, Numbers & Colors
Sorting Options
Advanced Filters on 15-20 different criteria(s)
Printing Workbooks
Setting Up Print Area
Customizing Headers & Footers
Designing the structure of a template
Print Titles –Repeat Rows / Columns
Advance Excel
What If Analysis
Goal Seek
Scenario Analysis
Data Tables (PMT Function)
Solver Tool
Logical Functions
If Function
Nested If
Complex if and or functions
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
Vlookup / HLookup
Index and Match
Creating Smooth User Interface Using Lookup
Reverse Lookup using Choose Function
Worksheet linking using Indirect
Vlookup with Helper Column
Pivot Tables
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
Calculated Field & Calculated Items
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.
Array with Lookup functions.
Advanced Use of formulas with Array.
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
If and select statements
Simple If Statements
The Elseif Statements
Defining select case statements

Please Fill Your Information

Advance Excel Course Training

Start Learning Today - Enroll Now and Begin Learning!

Fill Form And Download - Syllabus