Learn the world's most powerful reporting tool with one of the top ranked trainer in Excel
SEND THE SYLLABUS
Microsoft Excel remains one of the most powerful and advanced business tool as it is widely used by individuals and corporate to manage and analyze their data. It isn’t surprising how Excel has been dominating the spreadsheet product industry with a share of more than 90%. Businesses have relied on Excel to improve the productivity level of employees. Microsoft Excel is everywhere in any professional & business environment, and advanced Excel skills are welcome in almost everywhere.
As one of the most used reporting and analytics tools today, Microsoft Excel is a mandatory skill that employees should have. Today Excel is a must know tool for any job. It is no wonder that companies demand that their employees must learn Excel so that they can stay competitive. These days, any designation requires that you work with data.
Learning Excel in a proper, structured way can not only help you save time, but it will also help you become better at your job and can give you time to focus on things that matter. Microsoft Excel Masterclass is the most preferred choice for everybody looking to grow and survive in the industry.
This course is designed by a Mr. Vivekananda Sinha based on his 15+ Years of experience in Microsoft Excel Reporting, Data Analysis & Automation. This course is highly beneficial from freshers to professional who are looking for great career in analytics. Aspirants who want to start with a great profile such as Reporting Analyst, Data Analyst, MIS Analyst, Business Analyst as a fresher this course is highly recommended.
Learn Excel Core Capabilities
DATA CONSOLIDATION
This is one of the most demanding skills in the industry now a days. Excel offers flexible consolidation options depending upon the scenario. This course gives you in-depth knowledge of consolidating data in Excel.
CREATE MIS REPORTS
Excel is the industry leader when it comes to MIS Reporting. Creating awesome reports in Excel is quiet interesting. The thing is to know the perfect way. You will learn to create professional MIS reports in Excel.
DATA ANALYSIS
After you have created reports, the next step is to analyze the data and extract meaningful business information. Excel offers you tons of tools for data analysis. This course will develop your data analysis skills.
PERFORMANCE DASHBOARDS
Excel reports are incomplete without dashboards. Developing dashboards in Excel is quiet interesting. Creating dashboards will make you a rockstar in office. This course will guide you to create stunning dashboards.
REPORT AUTOMATION
Automation industry is booming. We has to upgrade from manual reporting to automated reporting in Excel. The thing is to know the proper skills. This course will train you to automate Excel reports and dashboards.
DECISIONS MAKING
Eventually, every data has to be transformed into a right decision. Excel has its powerful What-If Analysis tools that helps you to take right decision. This course will train you to take the data enabled decisions.
YEARS of EXPERIENCE
STUDENTS TRAINED
COMPANIES ENGAGED
INDUSTRIES COVERED
Detailed Syllabus
- Microsoft Excel Version History
- Version wise Features Comparison
- Advantages of Microsoft Excel
- Quick facts and figures about Microsoft Excel
- What's new in Microsoft Excel
- Portability features with earlier versions
- Application Areas of Microsoft Excel
- Microsoft Excel and Analytics
- Microsoft Excel and BIG Data
- Excel Beyond Excel
- Understanding Excel Navigation System
- Transformation from Menus to Ribbon
- Overview of Ribbon, Groups & Tabs
- Customizing Excel Ribbon
- Importing and Exporting Customization Settings
- Understanding Contextual Tabs
- Overview of Quick Access Toolbars
- Adding and Removing tools from Quick Access Toolbar
- Navigating Back Stage View
- Understanding Modules of Back Stage View
- Excel Keyboard Shortcuts
- Format Cell Basics
- Navigating Format Cells Dialog Box
- Understanding Excel Data Types
- Understanding Custom Formatting
- Transformation from Data Type to Custom
- Creating custom Date Formatting
- Creating custom Time Formatting
- Creating custom Number Formatting
- Creating custom Text Formatting
- Conditional Custom Formatting
- Custom Color Formatting
- Format Cells to multiple places
- Keyboard Shortcuts for Cell Formatting
- A walkthrough to Formatting Options in Home Tab
- Working with Paste Special - Magical
- Splitting Data using Text to Columns
- Sorting Data with Basic & Custom Options
- Working with Excel Comments
- Working with Goto Options – Magical
- Working with Freeze Panes
- Working with Grouping & Subtotals
- Excel Security – Protecting a Selected Range
- Excel Security – Protecting an Entire Sheet
- Excel Security – Allow users to edit Range
- Excel Security – Protecting Workbook Structure
- Excel Security – Full Protection of Workbook
- Excel Security – Partial Protection of Workbook
- Working on Excel Data Backup
- Introduction to Cell Referencing
- Importance of Cell Referencing
- Understanding Relative Referencing
- Understanding Absolute Referencing
- Understanding Mixed Referencing
- Common challenges while using Referencing
- Difference between Functions & Formulas
- 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, OFFSET, ADDRESS, INDIRECT, REPT
- Combinations of the above Functions
- Data Consolidation using 3D Formulas
- Concept of Precedents
- Concept of Dependents
- Introduction to Name Management in Excel
- Overview of Name Box
- Creating, editing and deleting Name
- Understanding Name Scope
- Defining Static and Dynamic List using names
- Displaying Name Map in Excel Worksheet
- Creating Single and Multidimensional Arrays using Name Manager
- Use of Names in advance Reports
- Common challeges in Name Management
- Use of Name Manager for Extracting Data - The Magical
- Introduction to Data Validation
- Creating basic Data Validation
- Creating Data Validation for Test
- Creating Data Validation for Numbers
- Creating Data Validation for Date and Time
- Creating basic drop down list using Data Validation
- Creating dynamic list using Data Validation
- Creating Basic Dependent List
- Creating Multilevel Dependent List
- Use of Basic Formulas in Data Validation
- Creating complex validation using Formulas
- Hacks of Data Validation
- Applying Data Validation to Multiple Places
- Using Custom Error Alerts in Validation Conflicts
- Using Data Validation as a Smart Comments
- Steps to remove Data Validation
- Highlighting Invalid Data
- Introduction to Conditional Formatting
- Understanding Static vs Dynamic Formatting
- Text based Conditional Formatting Rules
- Numbers based Conditional Formatting Rules
- Date based Conditional Formatting Rules
- Dealing with Unique and Duplicates in Conditional Formatting
- Top and Bottom Rules in Conditional Formatting
- Introduction to Data Bars, Icon Sets, Color Scales
- Creating Dashboard using Conditional Formatting
- Creating Conditional Formatting using Basic Functions
- Use Single Formatting with Multiple Conditions
- Implementing Conditional Formatting in Attendance Trackers - Case Study
- Using Complex Formulas in Conditional Formatting
- Setting Priorities on Conditional Formatting Conflicts
- Developing Smart Signalling System using Conditional Formatting
- Reusing Conditional Formatting
- Clear Conditional Formatting Rules
- 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
- 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 Earlier Versions
- Limitation of Excel Tables
- Introduction to Charts
- Understading elements of Chart
- Activating Chart Elements
- Major charts used in Industry
- Visualizing data using Column Charts
- Visualizing data using Bar Charts
- Visualizing data using Line Charts
- Visualizing data using Pie Charts
- Creating Combination Chart
- Changing Chart Themes
- Using Picture in Charts
- Introduction to Tiny Charts – Sparklines
- Creating Column Sparklines
- Creating Line Sparklines
- Creating Win-Loss Sparklines
- Introduction to Advanced Charting
- Why PivotTables?
- Structuring Your Source Data
- Inserting Your First PivotTable
- Navigating the Field List
- PivotTable Options: "Analyze" & "Design"
- Selecting, Clearing, Moving & Copying Pivots
- Refreshing & Updating Pivots
- Generating New Report from PivotTable
- Managing Grand Totals
- PivotTable Subtotals
- Dealing with Growing Source Data
- Removing & Reviving Data from Cache
- How PivotTables Works?
- Format Cells vs Number Format
- PivotTable Number Formatting
- Automatically Formatting Empty Cells in PivotTable (Pro Tip)
- Understanding Table Layouts & Styles
- Customizing Headers & Labels
- Introduction to Data Sorting in PivotTable
- PivotTable Sorting Options
- Filtering Data in PivotTables
- Filter using Wild Cards
- Using Slicers & Timelines to Filter Data
- Controlling multiple Pivots using Slicers and Timelines
- Working on PivotTable Grouping
- Date Grouping in PivotTable
- Grouping in Numbers and Text
- Value Summarization Modes
- Working on "Show Values As" Calculations
- Performing custom calculations using Calculated Fields
- Calculations in Pivots vs. Raw Data
- Inserting a Calculated Item for combined calculation
- The Solve Order & List Formulas Tools
- Introduction to PivotCharts
- Applying Slicers & Timelines to Multiple Charts
- Building dynamic dashboards using Slicer and Timeline
- Consolidating data from multiple sheets in few seconds
- Consolidating data from multiple files in few seconds
- Creating custom Page in PivotTable
- Splitting Data to Multiple Reports from huge data in seconds
- Developing Dynamic Tutorial using Slicer and Pivot (Pro Tip)
- Challenges in PivotTables - What Next?
- Introduction to Excel Filter
- Data Filtering Techniques
- Introduction to Auto Filter
- Auto Filter Checkbox
- Filter using free text
- Using predefined modes in Text Filter
- Using predefined modes in Number Filter
- Effectively using Custom Filters
- Using Color Filtering
- Conditional Formatting Icons Filtering
- Filter using wild Cards
- Refershing modified data while keeping Filter Intact
- Challenges in Auto Filter
- Introduction to Advance Filter
- Exploring Advance Filter Dialog Box
- Advance Filter Modes
- Implementing AND, OR, NOT in Advance Filter
- Advance Filter with basic calculation
- Using Excel Funtions in Advance Filter
- Using Advance Filter as a Lookup Tool
- Extracting unique list with Advance Filter
- Clearing Filters
- Introduction to Arrays
- Introduction to Excel Array Formulas
- Why and when to use Array Fomulas?
- The internal logic behind Arrays
- Concept of Logical Operators in Array Formulas
- The CSE Method
- Comparision Matrix with Excel conditional functions
- Array Formulas using basic Excel Functions
- How to create complex Array Formulas?
- How to Master Array Formulas - What Next?
- Introduction to What-If Analysis
- Why and when to use What-If Analysis?
- Working with Goal Seek for Reverse calculation
- Multiple case studies on Goal Seek
- Challenges in Goal Seek
- Working with Data Table for Sensitivity analysis
- Understanding 1 Variable and 2 Variables Data Table
- Selection Mechanism in Data Table
- Developing Bank Loan comparision analysis using Data Table
- Working with Scenario Manager for Scenarios Management
- Understanding Input & Output Variables in Scenario Manager
- Bank Loan Scenario Management - Case Study
- Introduction to Solver Add-In
- Understanding Algorithms and Optimizations
- Why and When to use Solver
- Creating Business Models
- Case Study - Resource Management
- Case Study - Logistics Optimization
- Case Study - Salary Management
SEND THE SYLLABUS
MASTERCLASS KEY FEATURES
Industry Level Content
The contents emphasize on the industry level examples and live case studies to make training more realistic & focused.
Certification
This is a certification course where you will get soft copy of course completion certificate once you complete the course.
Live Queries
As it is a virtual classroom training, you can ask your queries in real time as you do in the physical classroom training.
Interview Preparation
During the training, we provide you with the interview questions. By this, your interview preparation goes on real time.
Video Recording
Video recordings are done for all the classes. It helps you to revise the topics. It is also helpful if you miss a class.
Practice Files & Assignments
You will have the access to our google drive. After each class, we share you the files, assignments, videos, notes there.
Attend from Anywhere
You can attend the training from anywhere in the world. You just have to login from any device to attend the class.
Lifetime Support
Our students get lifetime support through Private Portal so that your queries and doubts should always gets resolved.
NOT just like other typical boring HOW-TO information courses
This course gives you detailed insight into basic to Advance Excel concepts, Data mining, Reports preparation, Data Analysis and decision-making tools. At the end of this training you will be able to make award winning reports and powerful dashboards, analyze data like a pro and bring efficiency in your day to day work life.
JOIN OUR UPCOMING BATCH
WEEKEND BATCH
Dates : 10-Feb-23 to 12-Feb-23
Days : Fri, Sat, Sun
Timing : 9AM to 5PM
Duration   : 3 Days
Seats : Limited
This course will complete in 3 days. Seats are filling fast.
Hurry ! Seats are limited
Still thinking whether to join this course?
Ok Mr. Vivekananda Sinha... Why should I join your course ? There are many other cheap courses available.
Please ask yourself a question.. Do you need just how-to information on features, or you are looking for real in-depth concepts? In today's fast moving world, TIME and IMPLEMENTATION is the key to success. Can you afford bitterness of TIME against sweet low cost and cheap courses?
Stay away from self-claimed gurus who will give you just one piece of puzzle. This course has everything you need to work on Microsoft Excel.
Future in Hands is always known for its quality and cost. The price you are investing on yourself will give you high return on investment.
Since 2013, We have trained over 99000+ students accross the globe including corporates and college students. We have delivered this course from Executive level to Sr. Management.
How can I attend this training ?
Once you make the payment, you will receive the credentials from our team to attend the training. As It will be a live classroom training, you will need these credentials to join the training. You can attend this training from any device - Laptop, Desktop, Tablet, Mobile.
Is this course a basic or advanced one ?
We cover everything from basic to advanced level. We will start from basic level with STEP by STEP and slowly slowly move to the advanced level. You donot have to do any Excel course in future.
What happens if I miss a class ?
Dont Worry! We do the audio-video recording for each and every class. We give you the access to those videos. You can view those videos at your own time, speed and convenience. So you will never miss a class.
What about Doubts and Queries ?
As it will be an online classroom training, you can ask your queries in the same time as you do in a physical classroom training. Plus, you will have the lifetime access to our Students Platform Future in Hands Connect where you can ask question anytime.
What will be the teaching language ?
Keeping in mind the majority of students, it will be done in both English & Hindi language. You will really find it easy to learn and enjoy the training since they are designed with simple yet in-depth explanations.
How Long can I access Videos ?
As this is a Live Training and not the Recorded Session, you will have the access to the recordings for the next 3 months. The purpose of recordings is only to view the missed sessions. However, we are always there to support you lifetime for your queries and doubts through our Students Platform Future in Hands Connect.
How will I get the Training Materials ?
You will have the access to our google drive. After each class, we share the training files, assignments, videos, theoretical notes into google drive. Each class will have separate folder for easy access.
Is this a Certification Course ?
Yes, this is a certification course. You will get soft copy of the course completion certificate once you complete the course.
Do you also provide Job assistance ?
We believe in Job Ready rather than Job Assistance. The contents we cover are industry oriented. Once you complete the course you will gain high confidence in Microsoft Excel and you can easily crack any Excel based interviews. The contents are trusted by thousands of our happy students. Our Students are the top performers in the industry. However, we have been associated with lots of companies where we help our students placed.
Will I Get Refund?
Honesty, we want serious learners in our eco-system who want to actualy learn and implement the concepts. If you are here just to experiment and doing nothing, please do not waste your valuable time and money. We do not provide refund. But I personally promise that the TRUST & TIME you are investing (forget about money), will be worth for it.
Want to ask something?
WhatsApp UsSTUDENT SPEAKS...
Vivekananda Sinha
Learn the world's most powerful reporting tool with one of the top ranked trainer in Excel
15+ Years Experience
Rich industry experience in Reporting and Analytics with big MNC. He is still exploring and learning new technologies.
MCA by Qualification
Packed with programming language, syntax and logic creation. Its a great combination of Programming and Analytics.
Microsoft Certified
Every skill must to be evaluated. Received Microsoft Office Specialist certification from Microsoft Corporation.
Best Trainer Award
Received several times Guru Award for best trainer for Productivity based workshops conduted for corporates.