Topics Covered
Initial Warmups Microsoft Excel Version History Advantages of Microsoft Excel Overview of Ribbon, Groups & Tabs Customization of Tabs Overview of Quick Access Toolbars Customization of Quick Access Toolbar Overview of Back Stage View Overview of Basic Excel skills Overview of Common Keyboard Shortcuts Worksheet Operations Cells & Range Operation Tricks of Format Cells Working with Custom Number Formatting Calculations in Number Formatting Freeze Panes with Different Scenarios Working with Excel Comments Excel Security – Protecting a Selected Range Excel Security – Protecting an Entire Sheet Excel Security – Protecting different Range with different Password in the Same Sheet Excel Security – Protecting Workbook Structure Excel Security – Full Protection of Workbook Excel Security – Partial Protection of Workbook Working on Excel Data Backup Time Saving Utilities Format Painter Splitting Data using Text to Columns with fixed and delimited parameters Tricks of Data Sorting in different Scenarios Summarizing data using Group and Outline Summarizing Data using Subtotal Concept of Cell Referencing Introduction to Cell Referencing Importance of Cell Referencing Relative Referencing Absolute Referencing Mixed Referencing Working with Functions & Formulas Difference between Functions & Formulas with scenarios Concept of Nested Formulas Formula Auditing Various Calculation Modes and How to use them Circular References – What are they? Concept of Wild Cards Concept of important Functions: AND, OR, NOT, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, LARGE, SMALL, UPPER, LOWER, PROPER, RIGHT, LEFT, MID, SEARCH, TEXT, VALUE, POWER, SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, EXACT, CONCATENATE, LEN, SUBSTITUTE, NETWORKDAYS, NETWORKDAYS.INTL, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, WORKDAY, WORKDAY.INTL, EOMONTH, DATEDIF, VALUE, INT, ISERROR, ISTEXT, ISNUMBER, ISBLANK, ISODD, ISEVEN, MATCH, INDEX, IF, VLOOKUP – 1D, VLOOKUP – 2D, Reverse LOOKUP, HLOOKUP, CHOOSE, RANDBETWEEN, ROW, ROWS, COLUMN, COLUMNS, MOD, IFERROR, SUBTOTAL, SUMPRODUCT, INDIRECT, REPT Numerous Combinations of the above Functions Data Consolidation using 3D Formulas Array Formulas for quick conditional calculations Introduction to Arrays Concept of Logical Operators in Array Formulas The internal logic behind Arrays The power of Array Functions Techniques of creating complex Array Functions Array Formulas using basic Excel Functions Name Manager Introduction to Name Management in Excel Overview of Name Box Defining Static & Dynamic List using names Use of Names in advance Reports Use of Name Manager for Extracting Data Dynamic views using Conditional Formatting Conditional Formatting using Formulas & cell values Highlighting Duplicates in various ways Highlighting top records, bottom records Highlight above average, Max, Min Errors, etc. Highlight single color with multiple conditions Calculation based Conditional Formatting Complex formula based Conditional Formatting Creating Dashboard using Bars & Icons Restriction using Data Validation Introduction to Data Validation Different Data validation in Excel Complex calculation based data validation Using Dynamic list in validation Using Basic Dependent List Using Multilevel Dependent List Hacks of Data Validation Highlighting Invalid Data Prevent wrong decisions using Excel Tables Introduction of Excel Tables Power of Excel Tables Time Saving features of Excel Tables Calculation Logic of Excel Tables Format As Table Understanding Table Formatting Options Filters, Can Get Multiple Filters In The Same Sheet Total Row, Ability To Select Type Of Summary Structured References – What Are They? Advantages Of Tables Convert Table To Named Range Compatibility Of Tables With Excel 2003 And Earlier Limitation of Excel Tables Charts in Excel Elements of Charts Major charts used in Industry Column Charts Bar Charts Line Charts Pie Charts Donought Charts Scatter Chart Combination Chart Introduction to Tiny Charts – Sparklines Column Sparklines Line Sparklines Win-Loss Sparklines The Power of Pivot Tables Pivot Table creating methods Rearranging a Pivot Table Filtering Pivot Table data Performing custom calculation Creating dynamic dashboards using Pivot Charts and Slicer Creating dynamic views using Timeline Consolidating data from multiple files in less than a minute Consolidating data from multiple sheets in less than a minute Splitting Data to Multiple Reports in less than a minute Creating Pivot Tables through Database Connections Analyzing Data using Advance Filter Introduction to Auto Filter Challenges in Auto Filter Power of Advance Filter Complex calculations based filter Filter using wild Cards Extracting Unique list with Advance Filter Analyzing Data with What-If Analysis Introduction to What-If Analysis Determine unknown with Goal Seek Analyze data with Data Table Enable Decision making using Solver View results with Scenario Manager Case Studies
Who should attend
Executives Managers General Managers Vice Presidents Senior Management MIS Personal BPO Professionals KPO Professionals Finance & Accounts Personal Human Resources Quality Analyst Analyst Data Analyst Reporting Analyst Project Managers Software Engineers Research Professionals Business Analyst Business Development Professionals Software Testing Engineers Banking Professionals Entrepreneur Businessman Freelancers Students
Pre-requisites
Ready to Learn.
What you need to bring
Notebook Pen Laptop (Preferred)"
Key Takeaways
POWER PACKED KNOWLEDGE Participants will get Power Packed knowledge for Data Reporting and Analysis The workshop will focus on the detailed Tips and tricks to work with Basic and Advance Excel Reporting. Creating dynamic Reports within a minute to impress your Management. PROGRAMME COMPLETION CERTIFICATE The Participants will get the Programme Completion Certificate from Future in Hands. PEN DRIVE FULL OF FREEBIES All the Participants will get an exclusive Pen Drive loaded with Freebies. It will contains: Theoretical concepts in Microsoft Excel Sample Files covered during the Programme Audio Video Coverage for the Entire Workshop Interview Preparation Tips Interview Questions Resume Writing Tips Sample Resumes to take your career to Next level Bulk Files and Assignments for Practice 30 Premium eBooks to become Excel Ninja Applications developed in Microsoft Excel Excel Templates Much More PREMIUM ACCESS TO ILEARN All the candidates will get the life Premium Access to iLearn – Your Learning Management System. This is our Learning Portal where you can get the access to the world of Learning that includes: Knowledge Bank Brilliant Tips & Tricks related to difference technologies and industries Library with great collection Career Planners Interview Questions Assessments and Mock Tests Job Opening Information Lounge to meet our Alumni s Much more PREMIUM ACCESS TO FUTURE IN HANDS CLUB All the candidates will get the lifetime Premium Access to Future in Hands club. It is our Discussion Forum specially designed for our learners across different location. The club is meant for our learners to help each other in any point of time. There are lots of idea sharing and helping each other on their work. You can get the best solutions by other experts. It will help you to solve your queries even after the Training. PLACEMENT ASSISTANCE Future in Hands offers placements assistance to all the students right from designing their resumes, helping them with frequently asked interview questions and conducting mock interviews when they have interviews coming up. We also help them get recruited in various companies who approach us for hiring. We also keep them updated on various openings in the market. Further to this, FIH uses its wide network of alumni and industry relations to refer students for suitable positions. View Current Placements FREE TRAINING PASS One Complementary Professional Training Pass is applicable for those candidates who refers minimum 2 Candidates for the upcoming Workshops. It is only applicable if the referred candidates joins the next Workshop.
View this Course
Certified
You have 
