Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Enquire

Submit your enquiry for Mastering Microsoft Excel

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Vivekananda

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Mastering Microsoft Excel

Mastering Microsoft Excel

Vasundhra, Ghaziabad

6,000

5 Reviews
0 Interested

About the Course


Todays, any managerial or analyst role requires that you work with data. Microsoft Excel remains one of the most powerful and easy to use tools when it comes to crunching 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 and people that matter. As one of the most used computer software programs for businesses today, Expertizing Microsoft Excel is an important skill that employees should have. It is no wonder that companies and businesses demand that their employees learn Excel so that they can stay competitive. Excel helps companies maximize the value of their data, helping to control costs more effectively and obtain business information. Excel is commonly used across business to display financial information and other data relevant to the running of the business. This could be information relevant to the Engineering, Sales, Marketing, HR, Quality or Finance department. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business. Looking at it from the employer’s point of view, especially for those in the field of information technology system, Excel is an essential end-user computing tool that can help perform a wide range of tasks. From making some of the mundane tasks more bearable through automation, to everyday functional tasks. Microsoft Excel is also used as a decision-making support for employers. It isn’t surprising how Excel has been dominating the spreadsheet product industry with a share of more than 90%. It is important to stay on top of career, Future in Hands wants to make sure you have the edge when it comes to Microsoft Excel training. Expertizing Microsoft Excel will arm you with the knowledge of how to use Excel more effectively and efficiently and ultimately help you make smarter decisions.


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.

Content
Reviews

Zeeloo

"The way of teaching is superb. Very supportive and helpful in teaching. He always solve our queries. Its a great experience to learn from Vivekananda. "

attended Mastering Microsoft Excel


Satyveer Chauhan

"Vivekananda sir is an expert in excel, his way of teaching is excellent..topics covered in this course are really in depth and essential from a professional point of view. I am glad that I have found a teacher like him!!" "

attended Mastering Microsoft Excel


Nitin

"I have no word for define the excellency of viveakananda sir I am word less I would like to say only That he is a outstanding teacher "

attended Mastering Microsoft Excel


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 3 of 3

Vivekananda 09/03/2014

Hi Neeraj, Please call me so that I can guide you with the details. A new batch is going to start coming Saturday.

0 0

Answer

You can add upto 6 Images

U

Neeraj 07/03/2014

Please let me know the below details:
Course Duration?
Timings?
Week days/Week end?
Address?
Contact No.?

0 0

Answer

You can add upto 6 Images

A

Amit 26/03/2013

I am interested

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Zeeloo

"The way of teaching is superb. Very supportive and helpful in teaching. He always solve our queries. Its a great experience to learn from Vivekananda. "

attended Mastering Microsoft Excel


Satyveer Chauhan

"Vivekananda sir is an expert in excel, his way of teaching is excellent..topics covered in this course are really in depth and essential from a professional point of view. I am glad that I have found a teacher like him!!" "

attended Mastering Microsoft Excel


Nitin

"I have no word for define the excellency of viveakananda sir I am word less I would like to say only That he is a outstanding teacher "

attended Mastering Microsoft Excel


Vinay Means Polite

"He is an expert in excel, his way of teaching is excellent..topics covered in this course are really in depth and essential from a professional point of view. I am glad that I have found a teacher like him!!"

attended Mastering Microsoft Excel


Manish Saluja

"I was searching for a experienced and a knowledgeable trainer who can teach me excel in very short span of time. I got his suggestion from one of my collegues who already attended his trainings earlier. The purpose of attending the training in a short span of time was to face the Interview for Assistant Manager in an International KPO where the requirement was to have excellent Reporting and Analytical skills. I learnt almost all the things in Microsoft Excel in approx 10 hours of session provided by sir. He is relly a great combination of knowledge and query handling skills. The session was like a magic show for me where I learn the things in excel that made my routine tasks very easy. Finally, I got selected as an Asst. Manager. Thanks to him for guiding me. Wating for more sessions to attend."

attended Mastering Microsoft Excel


Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Vivekananda Sinha picture

Vivekananda Sinha

Certified Microsoft Office Specialist


8 Years industrial experience in core MIS.

Trained Executives, Engineers, Managers, Students.

Received MICROSOFT OFFICE SPECIALIST title from Microsoft Corporation.

Awarded several times as Best Trainer at corporate level for receiving excellent feedback for trainings on Advance Excel, Statistical Analysis using Excel, VBA Macros and Microsoft Productivity Tools.

Developed Global Content Repository System, a 20,000 USD project developed in VBA for an IT company in South America. Received excellent customer feedback for the application.

Been as a Project Guide on Construction Site Layout Planning System, a VBA project initiated by group of Civil Engineers of Indian Institute of Technology, New Delhi. This project emphasizes on the planning of different facilities of a site in an optimized way. This is a generic-algorithm based model for site layout planning.

Developed and Implemented Utilities for Excel, a multi functionality tool that helped in saving lots of time for the Excel users. It covers the functionalities such as Sending Mails, Format Cells, Workbook Management, Workbook Library, Text Operations, Arithmetic Operations, Color Themes and Printing.

Developed various Consolidation Tools using VBA that helped in the reduction of 99% of the time taken in manual consolidation of Reports. It proved great at the time of Yearly Baseline Analysis.

Developed and Implemented Awareness Evaluation System, a VBA project to check the skills of the internal employees in different domains. This project includes SQL Server 2005 for storing questions, scores, user information and other details of the application. Login is based on windows Authentication.

Developed a Solution for Human Resource to taken user inputs in email. The data received are automatically saved to central database.

Developed Document Management System Plug-In for Microsoft Excel. This is a VBA Application that facilitates the users, to have documents easily available without wasting their time and efforts in searching them in the drive.
Seats Left-

Students Interested 0

Course Id: 7137