Excel formula for professionally use a function (certificate) 7-8 July 2011

[TPMthai Training and Consulting]

This seminar course. "Excel formula for professionally use a function (certificate) 7-8 July 2011" To consider sending participants. As detailed below it.

Mr.Samroeng Yingthawornsuk.	Excel formula for professionally use a function (certificate). Thursday 7 - Friday 8, July, 2011, 09.00 - 16.00 (registration 08.30). The Palazzo Bangkok Hotel.
	Course guide For those who want to prepare yourself. To use Excel as a professional. The training must be taken with a Notebook Computer. To facilitate training workshops on the program Microsoft Excel. This course is suitable for: -. - Human Resources Department. - Development and Training. - Sales and marketing - Maintenance Department. - Administration. - Excel and all those interested.

Rationale.
"Love does not happen easily. I have come to love. If not .... I love " love me like someone. It takes time to actually see it. I was sure. Know him well. They agreed to decide to live together. So shall also likewise. Ask yourself if "you know Excel well, but" experience has taught dozens of versions of Excel. The problem is most commonly used. "Users who fall into the trap of" self-imagining that Excel is good enough as a major obstacle. Can not learn or continue to use Excel to develop a system gave rise to it.

This course is designed to allow users to make Excel more than just "work" but to "use" and preparation skills. To develop their work further. The staff and personnel records, purchasing and account maintenance forms, etc., etc. So these programs as a first line. Using Excel to move to a professional.

Excel has received widespread popularity decades. Ready-to-use functions in different ways, each with 400 functions divided into categories. Cover the material in several ways. It also allows the users. Can create their own formula. The typical user will use Excel to create a form, just hit the most. A chance to discover the true ability of Excel.

However, the user will be able to learn and implement various functions. Was tied into the formula. It takes us time to practice. You can learn so much. It makes the work more efficient, only Simplify, reduce time and error to work for them.

This course will provide an important technical functions of Excel and use a variety of ways. Learn techniques to write a clever and intelligent Smart Formula to work. Creating the conditions in the calculation. As well as tips. That allows for faster and more convenient to be able to continue. To develop projects in the future.

Topics of the seminar.

- Customizing the default key. Prior to use Excel.
- The keyboard shortcuts (Keyboard Shortcut).
- To correct the error (Error) features such as # N / A, # NAME?, # VALUE!, # DIV / 0! Etc.

- Learn about the various groups. And practice a basic formula (Basic Formula).
- The functions of the Finance (Financial Functions).
- The function of the date and time (Date & Time Functions).
- The function of mathematics (Math & Trigonometry Functions).
- The statistical functions (Statistical Functions).
- The search function on the reference (Lookup & Reference Functions).
- The function of the database (Database Functions).
- Group functions and text messaging (Text Functions).
- The built-in logic (Logical Functions).
- The functionality of the system (Information Functions).
- Equipped with special functions, Add-Ins.
- Featured Add-Ins ThaiFunction.xla.

- Naming the data range (Range Name) to increase performance.
- Naming a cell or range of Static.
- Naming a cell or range of cells by using Name box.
- The names range from the database (Create from Selection).
- Naming cells using the Name Manager.
- Naming a cell or range of Dynamic.
- Named range by using the Name Manager OFFSET, COUNTA, MATCH, etc..

- Validation error (Data Validation) ways.
- Formatting cells (Cells format) and conditional formatting (Conditional formatting).

- The formula for computing professionals (Advanced and Smart Formula).
- The Protect Workbook (Worksheet Protection).

- The formulas and data protection solutions.
- The hidden formula.
- The cancellation of the password protected workbook.

- Working with the main command menu.
- The lecture / questions - questions.
- Etc..

Note

- This training course takes 2 days (9:00 to 16:00 pm, approximately).
- Practical training (Workshop) for the duration of training. Using examples from the real world. Under the guidance of the trainers and the team closely.
- This course is suitable for people of all professions that work with Excel and use Excel's full potential.
- We reserve the right to knowledge. Or censoring the content of the training. To be consistent with the actual time and knowledge of participants.

Annual Price membership for 6,400 Baht per person and Price 7,000 Baht per person for Guest price.

* Special price for the payment Membership On or before July 1, 2011 price 5200 baht per person.

* Download Form Training Confirmation here.

** Prices excluding VAT 7%.
*** We reserve the right to change the scheduled date, time, place, as appropriate, will notice it by the book.
** All courses can be used to pay the tax to 200%.
Call for reservations or more information. Tel (66) 2-171-0211 Fax: (66) 2-171-0209.
Email: ad...@tpmthai.com website: http://www.tpmthai.com or http://www.hrdconnect.com.

Best Regards,.
Thitinun Phusamlee.
TPMthai Training and Consulting Co.,Ltd.
11/3 Phayasurain Rd, Samwatawantok,
Klongsamwa,Bangkok 10510
Tel.       : (66) 2-171-0211
Fax.      : (66) 2-171-0209
Office  : (66) 85-131-1083
Maximize your Efficiency.