px804726
95%
Dołączył: 30 Lip 2010
Posty: 236
Przeczytał: 0 tematów
Ostrzeżeń: 0/5
Skąd: qpthbv
|
| Temat postu: Excel in the enterprise management in the use _139 |
|
|
Excel Application in Enterprise Management
article was published in vPro Management Online | [link widoczny dla zalogowanych] | 35
1. using the IF function to achieve logic
2. AND, OR, NOT logic
3.
three nested logic functions, ; string functions
1. commonly used string functions Introduction
2. free to extract the contents of the string anywhere
3. Walkthrough:
a) and from one generation Automatic Extraction of second-generation ID card date of birth and sex
b) a combination of text
c) conversion between text and figures
Fourth, find the function
1. ; common search function Introduction
2. HLOOKUP use VLOOKUP and automatic look-up table
3. how to achieve a double row of data to find
a) automatically looks for the product and the product model number
b) based on the sales performance of sales staff and working attitude automatically match the data in the performance Jiugongge
4. how to achieve a convenient query program
5. How to find the given data
five matches, a function of time
1. often a function of time profile
2. Remove from the date of the data DATE
3. to obtain a current time and before a time
4. automatically calculated based on length of service time entry
5. According to automatically calculate the age of identity
6. set the time display format
six, Financial Functions
1. Interest
2. Depreciation
3. income
seven commonly used statistical functions
1. Introduction
common statistic function 2. how to achieve the conditions count
3. how time conditions summary
4. How to automatically rank
5. how to calculate the dispersion of the data distribution
VIII ; data classification summary and perspective
1. How to make a cascading sheet
2. how to make a cross-table
3. a subtotal
4. multi-level subtotals
5. dynamic data filtering
6. based on year, quarter, month, day data aggregation
7. automatically calculate the various statistical indicators
a) the average sales Amount
b) sales difference degree
c) total percentage of the same column
d) the percentage of total peer
e) custom indicators
8. data points Section Statistics
9. aggregated data back to the detail data
】 【training objects:
general manager, department heads, finance, marketing, marketing and other related department staff, and Excel applications to improve the level of interested parties.
】 【training objectives:
◆ quickly master Excel to use the various functions to improve efficiency
◆ Excel data to grasp the various data collecting method and improve data level of analysis
attend courses to receive Excel Yang developed BladeOffice Excel tool set, includes the following features:
1. Function Fact Sheet: functional classification by function, to display all listings function of the features that give you all the functions and capabilities of Excel at a glance. Fuzzy Query feature allows you to quickly locate the Chinese description of the corresponding function quickly and conveniently.
2. Excel chart of a key color: Excel chart ways to modify the color and fill time and effort, you can now change a button to complete. Change color, fill direction, light and dark only a mouse click to complete, is not easy in general.
】 【training costs: 1400 (unit: RMB) (Note: The price and time and place of commencement of the training channel programs to display pages prevail.)
information】 【Lecturer:
Yang Hongyu Microsoft Authorized Training Center for Senior Lecturer, Microsoft added Storm special lecturer, freelance technology consultant company, Microsoft Gold seed program instructor. Young teacher training courses easy to understand, lively and practical, targeted, teaching style, humor, logical, process of interaction, case lively and always bring the students to use advanced software concepts and methods of the enormous impact, so that students will benefit.
as Microsoft office training consultant, Yang both have a solid theoretical knowledge but also for its extensive experience in the field known; in the accumulation of years of teaching experience in a large number of training techniques and applications, all over the country should be invited to Microsoft large number of customers at the Microsoft Office training courses taught hundreds of games.
Yang layman teacher training courses, lively and practical, targeted, teaching style, humor, logical, process of interaction, case lively and always bring the students to use advanced software concepts and methods of the enormous impact, so that students benefited from shallow.
Teaching Courses: Office consolidation of various versions of programs, Word, Excel, PowerPoint, Outlook, Visio,[link widoczny dla zalogowanych], Dreamweaver, Firework, Flash, Photoshop and other programs.
once part of the training companies are: China Mobile, Swire Coca-Cola, Guangzhou Honda, Petroleum BP, Wrigley McCormick, Guangzhou record Electronics, Oki Electric Industry in Shenzhen, Gu Sung plastic, Ka Ling switch, a hundred Viagra beer.
Post został pochwalony 0 razy
|
|
Hydepark 
Autor
