- HOME
Welcome to Yet5.com
Yet5.com is India's Largest Training Information Portal
You can find 2,000 training courses and 7,500 training providers from 49 Cities.
Stay Connected with Yet5.com
- TRAINING INSTITUTES
Training Institutes List by Course
- TRAINING MARKET
Browse & Enroll Training coursesFree DEMO Classes & Online Booking
We recommend you to book FREE demo class from different training providers, attend the demo sessions then make your decision. We help you to arrange the demo class for you. Read more...
You will get best course fee discounts from reputed training providers along with Multiple payment options to book your training seat through Yet5.com.
- CORPORATE TRAINING
Looking for a Corporate Trainer?
We work with the BEST Corporate Training Companies and Freelancers across India.
Post your requirements and Get quotes from Multiple Training Providers.
Speak to us at +91 9514 400 400
- COURSE OFFERS
- INSTITUTES
 | ||||
| ( Hyderabad - Madhapur ) | ||||
MS Excel 2007 Course by INFINIZY at Madhapur in Hyderabad | ||||
| Training Method: | Classroom Training | Course Duration: | 1 Months | |
| Batch Size: | 10 members | Placement Support: | 100% Placement Assistance | |
| Demo Class: | Yes, Demo Available | Course Discount: | 500.00 INR Discount | |
Course Timings
Morning Batch (6am - 9am)
Daytime Batch (9am - 6pm)
Evening Batch (6pm - 9pm)
Weekend Batch ( Sat/Sun/Hoildays)
Daytime Batch (9am - 6pm)
Evening Batch (6pm - 9pm)
Weekend Batch ( Sat/Sun/Hoildays)
Trainer Type
Realtime Working Professionals
Trainer Profile
The Trainers are Corporate Traner and have great expertise.
Expert Knowledge
Corporate Trainers
Real time exposure
Technically sound profiles
Can have a free demo with the trainee
Online or Classroom training available
Expert Knowledge
Corporate Trainers
Real time exposure
Technically sound profiles
Can have a free demo with the trainee
Online or Classroom training available
Course Fees
Course Content
Complete Course will be delivered according to your need and convenience
Microsoft Excel - Advanced
This course provides users with the knowledge to use the more complex features of Excel. It is designed
to give an insight into some of the more advanced features in Excel and will be of particular interest to
those who want to build or work with financial models, carry out detailed data analysis and automate
tasks by recording macros.
What-if Analysis
Using the Scenario Manager
Creating and editing scenarios
Creating a Scenario Report
Using Goal Seek
Using the Solver
Data Tables
The single-variable data table
The two-variable data table
Adding conditional formatting
Working with Outlines
Applying an outline
Automatic outlining
Displaying and collapsing levels
Modifying outline settings
Creating subtotals
Analysing Data with Pivot Tables
Creating a pivot table
Defining the source range
Inserting. moving and deleting fields
Showing and hiding fields
Grouping and ungrouping fields
Renaming fields
Defining field properties
Formatting a pivot table
Refreshing a pivot table
Drilling down
Excel Macros
About macros and VBA
Macro security
Recording macros
Running a Macro
Absolute and relative references
Saving and distributing macros
Assigning a macro to a button
Editing macro code
Automatic macros
Microsoft Excel - Advanced
This course provides users with the knowledge to use the more complex features of Excel. It is designed
to give an insight into some of the more advanced features in Excel and will be of particular interest to
those who want to build or work with financial models, carry out detailed data analysis and automate
tasks by recording macros.
What-if Analysis
Using the Scenario Manager
Creating and editing scenarios
Creating a Scenario Report
Using Goal Seek
Using the Solver
Data Tables
The single-variable data table
The two-variable data table
Adding conditional formatting
Working with Outlines
Applying an outline
Automatic outlining
Displaying and collapsing levels
Modifying outline settings
Creating subtotals
Analysing Data with Pivot Tables
Creating a pivot table
Defining the source range
Inserting. moving and deleting fields
Showing and hiding fields
Grouping and ungrouping fields
Renaming fields
Defining field properties
Formatting a pivot table
Refreshing a pivot table
Drilling down
Excel Macros
About macros and VBA
Macro security
Recording macros
Running a Macro
Absolute and relative references
Saving and distributing macros
Assigning a macro to a button
Editing macro code
Automatic macros
Course Eligibility
Any One / Student or Employee
Contact Information
INFINIZY,
Call : 6305995838 ,
Website: www.infinizygroup.com
Call : 6305995838 ,
Website: www.infinizygroup.com
