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)

₹ 6,500

No Reviews Yet

Date and Time

Not decided yet.

VR Lecturers picture
VR Lecturers

Msc Information systems, MCA

10 Years of Experience

About VR Lecturers

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.
No reviews currently Be the First to Review

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%

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 1 (Seats Left 0)

₹ 6,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 6,500 Enquire

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.

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