No Comparison on Quality
Emphasize on Industry best practices
Fully Practical oriented sessions
Concentration on Individual's challenges
Customized training as per your needs
Free access to online Blogs
Topics Covered
• Overview of Basic Excel Skills o Worksheet Operations o Format Cells o Freeze Panes o Security features of MS Excel o Overview of backup features of MS Excel • Time Saving Utilities o Techniques of Paste Special o Format Painter o Text to columns with fixed and delimited parameters o Tricks of Data Sorting using custom list o Summarizing data using Group and Auto outline • Concept of Cell referencing o Introduction to cell referencing o Importance of cell referencing o Relative referencing o Absolute referencing o Mixed referencing • Important Functions in Excel o And, OR, NOT, COUNT, COUNTA, COUNTBLANK, COUNTIF, MAX, MIN, UPPER, LOWER, PROPER, RIGHT, LEFT, MID, POWER, SUM, SUMIF, AVERAGE, EXACT, CONCATENATE, LEN, NETWORKDAYS, IS FUNCTIONS, MATCH, INDEX, IF, VLOOKUP-1D, VLOOKUP-2D, REVERSE LOOKUP, HLOOKUP, LARGE, SMALL, SUBTOTAL, SUMPRODUCT, DATEDIF, NESTED FUNCTIONS • Name Manager o Defining Static & dynamic list using names o Use of Names in advance reports • Playing with Conditional Formatting o Conditional formatting using formulas and cell values o Highlighting duplicates in various ways o Highlighting top records, bottom records o Highlight above average, max, min, errors etc. o Highlight single color with multiple conditions o Calculation based conditional formatting o Complex formula based conditional formatting • Restriction using Data Validation o Different Data Validation in Excel o Complex calculation based Data Validation o Using Dynamic list in Data Validation • Prevent wrong Decisions using Excel Tables o Introduction to Excel Tables o Power of Excel Tables o Time saving features of Excel tables o Calculation logic of excel tables • Charts in Excel o Elements of Charts o Major charts used in Industry • The Power of Pivot Tables o Pivot Table Creating methods o Rearranging a Pivot Table o Filtering Pivot Table Data o Performing Custom calculation o Creating dynamic Dashboards using Slicer o Consolidating multiple sheets in less than a minute o Creating multiple sheets in a single click using Pivot • Data Filtering Techniques o Introduction to Auto Filter o Challenges in Auto Filter o Power of Advance Filter o Complex calculations based filter o Filter using Wild Cards • Array Functions for quick calculations o Introduction to Arrays o The internal logic behind arrays o The power of array functions o Techniques of creating complex array functions o Array functions using basic Excel functions • Analyzing data with What-If Analysis o Introduction to What-If Analysis o Determine unknown with Goal-Seek o Analyze Data with Data Table o Enable Decision making using Solver o View results with Scenario Manager • Summarizing Data using Subtotal o Introduction to Subtotal o Logic behind subtotal o Calculations in Subtotal • Sparklines for Data Trends o Introduction to Sparklines o Types of Sparklines in Excel o Different usages of Sparklines • Working on Macros
Who should attend
Trained Engineers, Managers,General Managers,Executives,BPO Executives, MIS Personals, Accounts Personal, HR, Quality Analyst, Software Engineers, Project Managers, Developers, Test Leads, Program Managers, Research workers, Data Analysis departments, Students etc
Pre-requisites
Basic knowledge of MS Excel and Passion to Learn
What you need to bring
Laptop if you have Notepad Pen""
Key Takeaways
Audio Video Coverage for complete training Training Presentations solved samples discussed during the class Example Files
View this Course
Certified
You have 
