Training Report: “Advanced Excel Skills”
Classification： Blog
Time：2019-05-27
Excel Training Course — Boosting Efficiency Has Never Been Easier
Excel may have mistreated me countless times, but I still cherish it like my first love.
Still struggling with spreadsheets? 
Are you still repeating the same steps over and over??
From Excel beginner to expert—there’s still one training session standing between you.
To promote the company’s efficient growth and enhance employees’ professional skills and productivity,
May 24, 2019
The Human Resources Department organized One field Excel Advanced Skills Training session 。
This course is based on real-world case studies.
Presented by an Excel expert and the head of the Human Resources Department.
Primarily explains how to use Excel in the workplace.
Common concerns and frequently used Excel tips
The course primarily covers Creating a Data Pivot Table and techniques 、
Important functions 、 Data analysis 、 Data nesting Wait. 
Training session venue
During the class, the Excel expert emphasized that, in everyday use of Excel, students should make full use of various learning resources such as books to master more practical techniques. He also encouraged everyone to integrate theoretical knowledge with hands-on practice, so that they can become proficient in Excel operations.
Through this training, every participant gained a wealth of Excel‑related skills. Many attendees noted that the content was highly practical for their work and would help them boost their productivity.
Classroom Knowledge Sharing
Mathematics and Trigonometric Functions
SUM: Summation calculation
SUMIF: Sums the values in cells that meet a specified condition.
COUNTIF: Counts the number of cells that meet a specified condition.
Text functions
LEFT: Extracts a specified number of characters starting from the first character of a text string.
RIGHT: Extracts a specified number of characters from the last character of a text string.
MID: Extracts a specified number of characters from a text string, starting at a specified position.
Logical function
IF: Returns different values depending on whether a condition is met.
The Three “Rules” of Pivot Tables
Rule 1: Statistical reports must have a data source.
Rule 2: The header row and the data rows must have a one-to-one correspondence in field names, with no ambiguity.
Rule 3: Data sources must adhere to strict standards, and merged cells are not permitted.
Keywords： Training Report: “Advanced Excel Skills”
Related Information
A new PVC sheet processing technology boosts production efficiency by 30%.
Recently, a groundbreaking PVC sheet‑processing technique has drawn significant attention within the industry. By optimizing the extrusion process and employing an advanced temperature‑control system to precisely regulate thermal variations during production, this method ensures more uniform molecular alignment in the extruded sheets, substantially reducing the defect rate. Additionally, a newly introduced high‑speed traction unit boosts production speed by 30% while maintaining product quality. This innovative process is expected to lower the cost of PVC sheet manufacturing and drive growth across the related sector.
2025-08-19
PET sheets achieve a better balance of transparency and strength.
Through repeated experimentation, researchers have developed an improved formulation for PET sheets. By incorporating a specific proportion of nano‑scale additives into the raw material and employing a unique blending and stirring process, these additives are uniformly dispersed throughout the PET molecular structure. This not only enhances the transparency of the PET sheets, achieving a light transmittance of over 92%—approaching optical‑grade standards—but also boosts their tensile strength, increasing it by 20% compared with conventional PET sheets. This breakthrough offers a new option for high‑end applications such as premium packaging and optical displays, where PET sheet performance requirements are particularly stringent.
2025-08-19
Key progress has been made in the self-healing technology of PE protective films.
A research team has successfully developed a self‑healing polyethylene (PE) protective film. When the surface sustains minor damage such as scratches, the film can autonomously reorganize and repair the affected area under specific temperature conditions, thanks to a unique internal chemical molecular mechanism. The researchers incorporated polymers containing dynamic chemical bonds into the film material; upon damage, the broken bonds are re‑formed in response to thermal stimulation, enabling rapid self‑repair. Currently, this technology has completed laboratory validation and is expected to enter industrial production soon, bringing significant benefits to industries—such as electronics and automotive—that require long‑term surface protection.
2025-08-19