UrbanPro
true

Advance Excel

LIVE
Ongoing

Course offered by Gopal Kumar

5 reviews
This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Topics Covered

1. Important Advance Functions of Excel:- a. Writing Conditional Expression(using IF) b. Using Logical Function(AND, OR, NOT) c. Using Lookup & Reference Function(LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX) d. Date & Time Functions e. Text Functions 2. Concept of Cell Referencing:- a. Relative b. Absolute c. Mixed 3. Paste Special- 15 Diff Operations 4. Freeze Pane 5. What if Analysis- a. Scenario Manager b. Goal Seek c. Data Table d. Data Analysis e. Solver f. Correlation g. Histogram & Pareto analysis 6. Pivot Table:- a. Pivot Table Creating Method b. Custom Calculated Columns c. Creating Pivot from external data source, i.e. SQL, ACCESS. d. Consolidating Data from external source or multiple files e. Filter & Summarization of Pivot Table f. Grouping & ungrouping in Pivot g. Dynamic Pivot Table 7. Conditional Formatting:- a. Conditional formatting using formula & cell value b. Highlighting Duplicate c. Calculation based conditional formatting 8. Data Validation:- a. Custom & Dynamic Validation b. Multilevel Validation c. Input Message d. Error Alert 9. Filter:- a. Filter & Custom Filter b. Advance Filter (Multiple Criteria for Advance Filter) 10. Sort:- a. Sorting b. Custom Sort c. Sort on Custom List d. Sort on Colour 11. Name Manager:- Defining Static & Dynamic Name & its uses 12. New Feature of Excel 2010:- a. Slicer b. Sparkline 13. Consolidate & Connection from Database (SQL & Access) 14. Others Important topics:- a. Table Creation b. Cell Formatting c. Hyperlink for TOC d. Print Options e. Text to Columns f. Remove Duplicate g. Summarizing data using Group & Ungroup h. Subtotal i. Track Changes j. Sharing & Protecting a Sheet or Cell

Who should attend

Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.

Pre-requisites

Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

What you need to bring

Notepad & Pendrive

Key Takeaways

• Performing complex calculations more efficiently, using various Excel functions. • Organizing and analyzing large volumes of data. • Creating MIS reports. • Designing and using templates. • Consolidating and managing data from multiple workbooks.

About the Trainer

Gopal Kumar picture

5 Avg Rating

5 Reviews

21 Students

4 Courses

Gopal Kumar

MCA & Working as a Business Analyst

7 Years of Experience

Have experience of 6 yrs in Core Business Analytics Field.

Students also enrolled in these courses

LIVE
17 reviews
7 Hours

Course offered by Puneet

30 reviews
LIVE
3 Hours

Course offered by Arbind Gaba

8 reviews
LIVE
1 review
1 Hours

Course offered by Ramandeep Kaur

43 reviews
LIVE
2 reviews
4 Hours

Course offered by Abhishek Kumar Sharma

1 review

Reviews (1)

0.0 out of 5 review

Gopal K. https://p.urbanpro.com/tv-prod/member/photo/307315-small.jpg Laxmi Nagar Block D
0.0051
Gopal K.
S
Verified Student

Microsoft Excel Training

"Very good and useful tips for the excel given first "

View All
Have you attended any class with Isar Systems And Technologies ...?

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

Different batches available for this Course

0.0 out of 5 review

Gopal K. https://p.urbanpro.com/tv-prod/member/photo/307315-small.jpg Laxmi Nagar Block D
0.0051
Gopal K.
S
Verified Student

Microsoft Excel Training

"Very good and useful tips for the excel given first "

Have you attended any class with Isar Systems And Technologies ...?

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

Advance Excel by Gopal Kumar

Gopal Kumar picture
LIVE
(1 reviews)

Class
starts in

00

Days

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

Advance Excel by Gopal Kumar

Gopal Kumar picture
LIVE
(1 reviews)

Class
starts in

00

Days

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