Signup as a Tutor

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

true
true

No Reviews Yet

Baner, Pune

Course ID: 38986

Baner, Pune

Students Interested 0 (Seats Left 0)

₹ 4,000

Trainer

No Reviews Yet

The following topics will be taught in the Course

• VLOOKUP (one table and two tables), HLOOKUP, INDEX, MATCH, ADDRESS, TRANSPOSE
• Conditional Formatting
• Pivot Tables
• Creating pivot Tables
• Using Pivot Tables
• Changing and Updating Data Range
• Formatting Pivot Tables
• Making Dynamic Pivot Tables
• Graphs
• Only Primary Axis
• Both Primary Axis and Secondary Axis
• Referencing – Absolute and Relative
• IF conditions
• Nested IF Conditions
• IF Conditions with OR and AND
• Functions
• Date (DATE, DATEValue, Second, Minute, Year, Now, Today, Month, Time, Weekday, NetworkDays)
• Info (Cell, ISERROR, ISERR, ISEVEN, IS LOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE)
• Time (Today, Now)
• Math (RAND, ROUND, MOD, SUMIFs, SUMIF, INT)
• Statistics (COUNTIFS, COUNTBLANK, AVERAGE, MIN, MAX)
• Text (LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, REPLACE, REPT, FIND, REPLACE, REPT, SEARCH, TRIM, TRUNC, CONCATENATE, LEN)
• Named Ranges
• Operators - =, <>, <, >, <=, >=
• Filters / Slicers [ALT SFT :]
• Protecting cells
• Protecting Workbooks
• Sheet referencing
• Data Validations
• Freeze Pane
• Split Worksheets
• Gridlines
• Print Features
• Multiple Sheets Handling

Copy

Not decided yet.

## Students also enrolled in these Courses

Avg Rating

0 Reviews

0 Students

1 Courses

Masters in computer application

12 Years of Experience

12 years of experience in teaching and working on advance excel features.

## Reviews

No reviews currently Be the First to Review

## Discussions

Trainer

No Reviews Yet

Students Interested 0 (Seats Left 0)

₹ 4,000

Copy

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

Enquire

Please enter valid question or comment

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 Enter valid Email or Phone Number

Forgot Password? Resend OTP OTP Sent

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

You have successfully registered

Class Scheduled at

hour

To join, click

Message copied

How to join a Class?

The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

Verify you Mobile Number

Please verify your Mobile Number to continue and book a FREE Demo class.

Update

Please enter 10 digit phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend