loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for EXCEL WORK SHOP

Please enter valid question or comment

Please enter your name.

Please enter valid email

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 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

Share

EXCEL WORK SHOP

EXCEL WORK SHOP

New Nallakunta, Hyderabad

6,500

No Reviews Yet
1 Interested

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
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

VR Lecturers picture

VR Lecturers

Msc Information systems, MCA


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.
Seats Left-

Students Interested 1

Course Id: 19732