Event Date: 30 Jan 2011
| Contact Information | | Email: | | | Website: | | | Phone: | | | Address: | Hotel The Vijay Park,
12 Jawaharlal Nehru Salai Inner Ring Road, Arumbakkam,
Chennai - 600 016,
Tamil Nadu [India]. |
It is a great oppurtunity to learn the MS Excel to excel in the work, as there is a workshop arranged in Chennai on 30th Jan 2011.
This workshop is organised by "Heuristic Knowledge Base Solutions and Services"
Here the workshop will be provided for "MS Excel" where it can be designed for different purposes like:-
- Accounts & Finance
- Commercial
- Sales & Marketing
- Engineering
- Quality
- R&D
- HR & Administration
- IT professionals
- Chartered Accountants
- Project Managers
- Executive Assistants
- Personal Assistants
- Secretaries
- Students of professional courses for campus placements and jobs
and for all those who want to make their life easy with the use of this wonderful tool.
Workshop Coverage:
• Excel Quick Overview :
Difference between Excel 2003 and 2007, Use of Excel, its boundaries & features
• Data Formatting & Custom settings :
Number, Text, Date, Currency, Custom settings. Data formatting & cleaning
• Conditional Formatting :
Once defined, Excel will automatically change the color of your values e.g. up or down, high or low, pass or fail, profit or loss etc.
• Filters, Queries & Data Sorting :
Drill down your data to your desired level based on multiple choices & conditions. Sort data based on your choice e.g. like North, East, West, South rather than alphabetically.
• Formula Writing & Fixing Errors :
Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc.
• If-Then-Else & Nested If commands :
You can produce different set of results based on slabs, conditions, stages etc.
• Vlookup / Hlookup :
You have large amount of data placed at different locations & you want to merge it based on common values & it's relevance. We will show how this can be done with Vlookup & Hlookup.
• Graphs & Charts :
In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc.
• Hyper / Data Linking :
Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically.
• Grouping / Ungrouping :
Sometime data needs to be grouped for summarized results and crisp view. No problem, grouping and ungrouping feature will help you do so.
• Pivot Tables :
It helps you summarizes your data as per your desire. You need to select data in a range & produce consolidated results in pre-defined or user defined reporting formats.
• Macros Recording, use, editing, linking :
Record, edit and use Macros with little or no programming knowledge, automated recording of functions or actions helps a lot for quick execution with shortcut keys.
• Security & Protection for worksheet and file :
It will help you protect your cells, worksheet or an excel file from unauthorized use.
• Data validation :
With this feature you can prevent wrong data entry in your specified format.
After attending this workshop you will be benefitted in your day to day life to achieve new milestones by bringing efficiency & accuracy in your work.
Venue Details:
Hotel The Vijay Park, (12 Jawaharlal Nehru Salai Inner Ring Road, Arumbakkam)
Chennai - 600 016,
Tamil Nadu [India].
Photos of Professional Training Workshop on MS Excel - Chennai
No photos listed.
|