

Excel operation skills (advanced edition) training report
- Categories:NEWS
- Author:
- Origin:
- Time of issue:2019-05-27 01:31
- Views:
(Summary description)Exceltraining--productivityisthatsimple Excelhasabusedmeforthousandsoftimes.ItreatExcelasmyfirstloveStillindistressdotable?Doyoudothesamethingoverandoveragain? FromExceltomaster,youstillneedatrainingInordertopromotetheefficientdevelopmentofthecompanyandimprovetheworkskillsandefficiencyofemployees,May24,2019ThehumanresourcesdepartmentorganizedatrainingcourseonExceloperationskills(advancedversion).1Thiscourseisbasedonactualcases Huangxinglin,Excelmasteranddirectorofhumanresourcesdepartment,gavethelecture MainlyexplainExcelinwork QuestionsofinterestandcommonExcelskills Thecoursesmainlycoverthepreparationandskillsofdatadialysistables,Importantfunctions,dataanalysis,datanesting,etc. Trainingsessiononsite2Inclass,ExcelexperthuangxinglinstressedthatintheprocessofusingExcelatordinarytimes,heshouldmakemoreuseofdifferentlearningtoolssuchasbookstolearnmorepracticalskills.Healsoencouragedeveryonetocombinetheoreticalknowledgewithmorepracticeandpractice,andExceloperationwouldbecomeeasy.Throughthistraining,everyonepresenthasgainedalotofExcelapplicationskills.Manystudentssaidthatthetrainingcontentintheworkofpracticalverystrong,isconducivetoimprovetheirworkefficiency.3 Classroomknowledgesharing MathematicsandtrigonometrySUM:calculatetheSUMSUMIF:sumsthevaluesofcellsthatsatisfytheconditionCOUNTIF:countthenumberofcellsthatmeetthiscondition ThetextfunctionLEFT:interceptsaspecifiednumberofcharactersfromthefirstcharacterofatextstringRIGHT:interceptsaspecifiednumberofcharacters,startingwiththelastcharacterofatextstringMID:interceptsaspecifiednumberofcharactersfromaspecifiedpositioninatextstring LogicfunctionIF:returnsdifferentvaluesdependingonwhethertheconditionismetornot ThreerulesforpivottablesRule1:statisticalreportshavedatasources.Rule2:thereisnoambiguitybetweenheaderanddatarowfields.Rule2:thereisnoambiguitybetweenheaderanddatarowfields.
Excel operation skills (advanced edition) training report
(Summary description)Exceltraining--productivityisthatsimple Excelhasabusedmeforthousandsoftimes.ItreatExcelasmyfirstloveStillindistressdotable?Doyoudothesamethingoverandoveragain? FromExceltomaster,youstillneedatrainingInordertopromotetheefficientdevelopmentofthecompanyandimprovetheworkskillsandefficiencyofemployees,May24,2019ThehumanresourcesdepartmentorganizedatrainingcourseonExceloperationskills(advancedversion).1Thiscourseisbasedonactualcases Huangxinglin,Excelmasteranddirectorofhumanresourcesdepartment,gavethelecture MainlyexplainExcelinwork QuestionsofinterestandcommonExcelskills Thecoursesmainlycoverthepreparationandskillsofdatadialysistables,Importantfunctions,dataanalysis,datanesting,etc. Trainingsessiononsite2Inclass,ExcelexperthuangxinglinstressedthatintheprocessofusingExcelatordinarytimes,heshouldmakemoreuseofdifferentlearningtoolssuchasbookstolearnmorepracticalskills.Healsoencouragedeveryonetocombinetheoreticalknowledgewithmorepracticeandpractice,andExceloperationwouldbecomeeasy.Throughthistraining,everyonepresenthasgainedalotofExcelapplicationskills.Manystudentssaidthatthetrainingcontentintheworkofpracticalverystrong,isconducivetoimprovetheirworkefficiency.3 Classroomknowledgesharing MathematicsandtrigonometrySUM:calculatetheSUMSUMIF:sumsthevaluesofcellsthatsatisfytheconditionCOUNTIF:countthenumberofcellsthatmeetthiscondition ThetextfunctionLEFT:interceptsaspecifiednumberofcharactersfromthefirstcharacterofatextstringRIGHT:interceptsaspecifiednumberofcharacters,startingwiththelastcharacterofatextstringMID:interceptsaspecifiednumberofcharactersfromaspecifiedpositioninatextstring LogicfunctionIF:returnsdifferentvaluesdependingonwhethertheconditionismetornot ThreerulesforpivottablesRule1:statisticalreportshavedatasources.Rule2:thereisnoambiguitybetweenheaderanddatarowfields.Rule2:thereisnoambiguitybetweenheaderanddatarowfields.
- Categories:NEWS
- Author:
- Origin:
- Time of issue:2019-05-27 01:31
- Views:
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?

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).

Important functions, data analysis, data nesting, etc.

Training session on site
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.
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.

ADDRESS: NO. 38, FENGXIANG ROAD, DALIANG, SHUNDE DISTRICT, FOSHAN CITY, GUANGDONG PROVINCE
TEL:0757-22213007/22227324
FAX:0757- 22229013

LEARN MORE ABOUT IT
GUANGDONG JINBANG PLASTIC PACKAGING CO., LTD. 粤ICP备11066138号-1 POWERBY:300.CN MANAGER
TEL:0757-22319618 ADDRESS: NO. 38, FENGXIANG ROAD, DALIANG, SHUNDE DISTRICT, FOSHAN CITY, GUANGDONG PROVINCE