Microsoft Excel Advanced 2010

Provider: “YAVYA EDU”

Yavya Technologies Pvt.Ltd.

Application: MS-Excel (2010)

Course Location: South Delhi, NEW DELHI

Course Duration: One day (8 HRS)

Course Participants: Minimum 8 to Maximum 20

Workshop Overview:-

Areas Covered:

• Advanced range names, including formulas and naming conventions

• Advanced conditional formatting, including formula-driven formatting

• Aggregation functions

• Goal seek and Solver

• Pivot Tables

• Scenarios

• Data tables

• Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH

• Advanced data validation techniques and form controls

• Introduction to macros and user-defined functions

Included are explanations of how these could typically be applied to Financial Modeling and Company Valuation.

Who Should Attend?

• One who is genuinely interested in exploring Excel as an analytical tool

• One who wants to save time by automating certain tasks in data handling

• One who uses Excel in his day to day job

• For advanced workshops, one who is comfortable with basic features of Excel like:

- Editing cells with basic data inputs and formats

- Sum, average, vlookup and other basic formulae

- Sorting and filtering Data

- Bar, Line, Pie and other basic charts

What Are The Benefits To Participants?

• Excel insights, tips, tricks and workarounds using logical reasoning

• Increased speed, productivity and efficiency resulting in competitive advantage over peers

• Networking opportunity with other participants

• Certification from “YAVYA EDU”

• Exposure to industry best practices

• Materials and Templates on MS-Excel

• Post training, user will be able to

- Handle huge data with ease

- Make complex analysis with less efforts

- Create effective dashboards and charts

- Automate work through templates and models

Instructional Method:-

This instructor-led course provides classroom lecture topics and the practical application of MS Excel 2007 through demonstrations, practices, and hands-on exercises, followed by a small case study on the last day.

Timings:-

9:30 am - 5:30 pm, Registration begins at 9:00 am

How To Register:-

• Fees: Rs. 750/- +10.3 % service tax per person

• Please write to / Call -011 45661970-73/9540047720

• Mention the name of participant, company, contact details.

• Cheques favoring” Yavya Technologies Pvt. Ltd.” payable at Delhi.

• Fees includes Tea/Coffee, Breakfast & course material etc.

From India, Delhi
Microsoft Excel Advanced 2010
Provider: “YAVYA EDU”
Yavya Technologies Pvt.Ltd.
Application: MS-Excel (2010)
Course Location: South Delhi, NEW DELHI
Course Duration: One day (8 HRS)
Course Participants: Minimum 8 to Maximum 20
Timings:-
9:30 am - 5:30 pm, Registration begins at 9:00 am
How To Register:-
• Fees: Rs. 750/- +10.3 % service tax per person
• Please write to / Call -011 45661970-73/9540047720
• Mention the name of participant, company, contact details.
• Cheques favoring” Yavya Technologies Pvt. Ltd.” payable at Delhi.
• Fees includes Tea/Coffee, Breakfast & course material etc.

From India, Delhi

Attached Files
File Type: pdf Microsoft Excel Advanced 2007.pdf (74.9 KB, 498 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 Cite.Co™