Signup as a Tutor

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

EXCEL WORK SHOP

No Reviews Yet

New Nallakunta, Hyderabad

Course ID: 19732

New Nallakunta, Hyderabad

Students Interested 1 (Seats Left 0)

No Reviews Yet

About the Course

We work with businesses and individuals who need effective Microsoft Office training at unique & affordable pricing as per your budget. We provide a tailored training session for corporate clients as per their need.

Topics Covered

Advanced Excel
Content
Introduction
Formatting
Formatting In Excel
Adv Formating
Auto previews in excel 2007
Conditional Formatting

Linking In Excel
Across Sheets
Across Workbooks
Hyperlinks with Advance Sources like web queries & Objects

Referencing Working with Options and Macros
Cell Referencing In Excel
Relative Referencing
Absolute Referencing
Difference Between Relative & Absolute Cell Referencing
3D Reference

Functions In Excel
SUM,COUNT,AVERAGE,SUMIF,COUNTIF ETC
Sumproduct,subtotal,count,counta,
IF,AND,OR ETC
LOOKUP,VLOOKUP,HLOOKUP ETC
Days 360 (''mm/dd/yy'',''mm/dd/yy'') (Days - Functions)
LEN,UPPER,LOWER,PROPER ETC
PMT,RATE,PV,FV ETC
EOMONTH, TODAY(), WORKDAY(),
ISNUMBER, ISERROR, OR, AND, IF-THEN-ELSE
Financial Functions
Text Functions
Date & Time Functions
Using Function Wizards and Layouts
Understanding Syntax of Various Functions

Excel Charts
Working With 2D and 3D Charts
Working With Data Lists
Sorting with Multi Levels by using Clauses
Adding Form Wizards
Data Validation with Advance Options
Subtotals with Multi level Grouping Levels
Filtering by using Auto and Advanced Filters
Filtering by using Multiple Criteria Levels
Filtering and Sorting by Color Levels

Pivot Tables with Advance Feartures
Creating Pivot Table Using Wizard / Layouts
Formating Pivot Table With Auto Formats and Table Templates
Creating Pivot Charts by using Source data
Modifying The Pivot Charts
Modifying The Pivot Table
Creating a Pivot Table Report

Customization of toolbar and Quick Access Tool Bars
Worksheet protection and locking of cells
Cell Range Protections
Workbook Protection
Excel Keyboard shortcuts.
Auditing Excel Sheet
Working and editing with Hyperlinks
Adding and Working On Custom views


Working With Goal Seek
Creating Scenarios
Grouping the Columns and Rows
Importing the Text, Web Queries, Database
Practice
Macros
Macro's In Excel
Recording a Macro
Running a Macro
Assigning a Macro to a Tool Bar Button and quick access tool bars
Saving a Macro In Personal Macro Work Book
Editing a Macro in VBA
Deleting a Macro
Understanding VBA codings and Environment of VBA

Who should attend

Any one who is interested

Pre-requisites

NEED TO HAVE KNOWLEDGE ON BASIC EXCEL

What you need to bring

LAPTOP"

Key Takeaways

Subject..100%

Date and Time

Not decided yet.

Students also enrolled in these Courses

About the Trainer

VR Lecturers picture

4.6 Avg Rating

5 Reviews

6 Students

6 Courses

VR Lecturers

Msc Information systems, MCA

10 Years of Experience

Lecturers have got 10+ years of coaching experience and are well versed with Ms excel basics to advanced and also MACROS. Have given corporate trainings too.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 1 (Seats Left 0)

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

Enquire

Submit your enquiry for EXCEL WORK SHOP

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

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

Connect With Naveen

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 the OTP sent to your registered mobile number.

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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