loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Expertizing Microsoft Excel

Please enter valid question or comment

Please enter your name.

Please enter valid email

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

Expertizing Microsoft Excel

Expertizing Microsoft Excel

Sector 65, Noida

4,500

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.
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 Expertizing 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 Expertizing 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 Expertizing 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

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 Expertizing 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 Expertizing 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 Expertizing 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 Expertizing 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 Expertizing Microsoft Excel


Date and Time

Not decided yet.

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