CN/EN

TEL:0757-22319618      Address: No. 38, Fengxiang Road, Daliang, Shunde District, Foshan City, Guangdong Province

 

Business capability

Latest News

products

Talent Center

Guangdong Jinbang Plastic Packaging Co., Ltd.     粤ICP备11066138号-1      PowerBy:300.cn      Manager

Address: No. 38, Fengxiang Road, Daliang, Shunde District, Foshan City, Guangdong Province
Tel: 0757-22213007/22227324
Fax: 0757-22229013

Learn more about it

Jinbang Home

>
>
Excel operation skills (advanced edition) training report
Search

Excel operation skills (advanced edition) training report

Page view

Excel training -- productivity is that simple

 

 

Excel has abused me for thousands of times. I treat Excel as my first love

Still in distress do table?

Do you do the same thing over and over again?
 
From Excel to master, you still need a training

In order to promote the efficient development of the company and improve the work skills and efficiency of employees,

May 24, 2019

The human resources department organized a training course on Excel operation skills (advanced version).

IMG_3053.JPG

1

This course is based on actual cases
 
Huang xinglin, Excel master and director of human resources department, gave the lecture
 
Mainly explain Excel in work
 
Questions of interest and common Excel skills
 
The courses mainly cover the preparation and skills of data dialysis tables,

Important functions, data analysis, data nesting, etc.

 

IMG_3060.JPG

Training session on site

2

In class, Excel expert huang xinglin stressed that in the process of using Excel at ordinary times, he should make more use of different learning tools such as books to learn more practical skills. He also encouraged everyone to combine theoretical knowledge with more practice and practice, and Excel operation would become easy.

Through this training, everyone present has gained a lot of Excel application skills. Many students said that the training content in the work of practical very strong, is conducive to improve their work efficiency.

3

 

Classroom knowledge sharing

 

Mathematics and trigonometry

SUM: calculate the SUM

SUMIF: sums the values of cells that satisfy the condition

COUNTIF: count the number of cells that meet this condition

 

The text function

LEFT: intercepts a specified number of characters from the first character of a text string

RIGHT: intercepts a specified number of characters, starting with the last character of a text string

MID: intercepts a specified number of characters from a specified position in a text string

 

Logic function

IF: returns different values depending on whether the condition is met or not

 

Three rules for pivottables

Rule 1: statistical reports have data sources.

Rule 2: there is no ambiguity between header and data row fields.

Rule 2: there is no ambiguity between header and data row fields.