UrbanPro
true

MS Excel Training for Corporate Professionals:

LIVE
Ongoing

Course offered by Indian Institute Of Excellence

0 review
In this competitive world, good knowledge of Microsoft Excel can help you to grow faster. Our Program – MS Excel Training for Corporate Professionals is a must do program for all who work in Corporate World. This Excel Workshop includes all those functions and formulas that are much needed to use MS Excel efficiently and effectively. We have spread MS Excel Training program on two weekends that allow participants to do practice. Program is full of Illustrations & Case study that are based on real business problems.

Topics Covered

Shared best use of Microsoft Excel. - Program is based on real scenario problem. - All MS Excel Training Classes are full of illustration and case study. - Practical experience of Program Director will help to have a practical view of each function. - Program is spread over couple of weekends that give time to practice and raise question in subsequent sessions. Excel Training Course: Excel Essentials: Excel Basics. - Keyboard Shortcuts and Commands. - Working with Ribbon Tabs. - Advance techniques of Copy and Paste. - Basics about Date and Time. - How to use Auto List. - Wild Characters. (How to make powerful use of Wild Characters, Find, Replace and Go To. How date and time works in excel, how to create different QAT for different files and much more…..) Formats, Conditional Formatting & Sorting Cell Format. - Data Bars, Color Scales & Icon Sets. - Conditional formatting with formulas. - Conditional formatting with Form Controls. - Sorting basic. - Sorting based on Customized List. - Customized Sorting (Advanced). (What are commonly committed errors and how to overcome them, different type of conditional formatting, creating customized list and sorting on the basis of customized list. Data Management: Data Validation and dealing with Invalid Data. Group and Outline Data. Data Filter - Data Consolidation. Data text to column - Custom Views (Consolidating data vertically and horizontally on few clicks (without using any formula), Viewing & printing multiple reports on same data and same sheet on click of button and much more) Formula’s & Functions: Text Formula’s (Left, Right, Trim, Len, Upper, Lower, Proper etc. Lookup Formula’s (Vlookup, Hlookup, Index, Transpose, Row, Column etc Logical Formula’s (If, And, Or, etc.) Date & Time (Day, Month, Year, Date, Datevalue, EOMonth, Workday etc.) Math & Trig (Sumif, Sumifs, Sumproduct etc.) Vlookup can extract value from multiple tables on multiple sheets. Using Vlookup for two way lookup. (Vertically and Horizontally at same time). Vlookup can calculate Income Tax on any Income falling in any slab. Using Vlookup for AR Aging analysis. When to have Range lookup True in Vlookup and how it impacts? Charts & Graphs: Chart Basics Line Chart, Column Chart Sparklines Others How to create multiple chart type in one graph, using primary and secondary axis for different chart type in one chart, how to make best use of newly added feature of sparklines Data Analysis: Pivot Table (Including Slicer). Scenario Modeling. GoalSeek. Advanced Filters Introduction to Form Controls, Macros Introduction to Form Controls Macros Create and Edit a Macro Absolute and Relative with reference to Macro. Miscellaneous: 3D Reference. Customizing standard Excel options to user specific needs. Different techniques to remove duplicate. Talk to Excel. Mini Word in Excel. Screenshot and its usage (Newly added feature) Data Protection. Dealing with Objects.

Who should attend

All professional or Students can also join

Pre-requisites

Understanding of Computer

What you need to bring

Laptop

Key Takeaways

Participation Certificate – “MS Excel Training for Corporate Professionals” will be issued to those who will attend all four sessions

About the Trainer

Avg Rating

0 Reviews

0 Students

4 Courses

Indian Institute Of Excellence

Newyork University, Villanova University

More than 18 years of experience with approx fifteen quality and security related organization level
assessments/certifications (managed more than 25 initiatives) and with personal certifications like PMP,
ITIL, Lean Six Sigma Black Belt, Scrum Master, ISO27001 Lead Auditor, CSQA· A Lead, Coach, Trainer, Consultant and Mentor. And a catalyst for transformation. Leveraging global work experience in starting/leading organizations and developing talent capability and processes
capability. Multi-cultural experience, having lived and worked in Asia and North America. Responsible for the quality of delivery of products and services to our clients. Areas of responsibility
include: Quality Process Management, Institutionalizing Business Excellence, Customer/Client
Satisfaction, ITSM Compliance, Service and Software Delivery, Transaction and Process quality delivery,
Information Security Management, Portfolio and Project Management Office and Quality Assurance. Leader and Member of CMMI assessment team (ATM) : thrice, Functional Area Representative (FAR) :
thrice, conducting appraisals/ audits : more than 40, Lean Six Sigma projects : 7 Black Belt and around 15
Green Belt, ISO 27001 LA : thrice.

Students also enrolled in these courses

LIVE
4 reviews
8 Hours

Course offered by Ritu Arora

2 reviews
LIVE
15 reviews
16 Hours

Course offered by Shashank Maheshwari

14 reviews
LIVE
15 reviews
4 Hours

Course offered by Shashank Maheshwari

14 reviews
LIVE
15 reviews
16 Hours

Course offered by Shashank Maheshwari

14 reviews

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

MS Excel Training for Corporate Professionals: by Indian Institute Of Excellence

Shreyash Mehrotra picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

MS Excel Training for Corporate Professionals: by Indian Institute Of Excellence

Shreyash Mehrotra picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more