About Us

BioTOP - Excel lecture 2014.08.21

time:08/26/2014 page views: resource:BioBAY
Excel lecture will mainly cover two most frequently used tools in office,i.e., PivotTable and Vlookup function, helping students understand the basic concept and roles of PivotTable in data analysis and learn how to look for and quote data via Vlookup function and check common errors, etc.
(1) Master the common tools in Excel to meet the demand for normalized data processing.

(2) Master the common statistical methods and tools in Excel and profoundly learn such analysis tools as PivotTable.

(3) Master the methods of function in Excel and know how to check common errors.
Time: 13:30-16:30 p.m., August 21, 2014

Venue: Circular lecture hall at A1

Attendees: those who frequently use Excel for data statistics and analysis, etc

Warm reminder: it is better to carry your own laptop for the convenience of learning
If you show any interest, please contact Guo Hua from the General Management Department of BioTOP ahead of time (Email:; Tel: 67995666-2702)
Introduction on lecturer Wang Peifeng:
The titles of MVP (Microsoft Most Valuable Professional), MCT (Microsoft Certified Trainer), MCITP (Microsoft Certified IT Professional), MCP (Microsoft Certified Professional) and MCSE (Microsoft Certified Systems Engineer) awarded by Microsoft headquarters for the successive five years (from 2009 to 2013) and 8-year enterprise training experience of Office.
Proficient in Microsoft office products, business intelligence and data mining; engaged in the popularization, teaching and redevelopment of Microsoft Office series software for a long period of time; once took charge of Q&A section of Microsoft Office 2010 official product presentation and the development of Suzhou land tax admission system and the qualifications assessment system of the Organization Department of Suzhou Municipal Committee; published series of books on Excel function - Not That Complicated; help numerous transnational enterprises solve the difficulties in data report processing via Office curriculum and released a great quantity of teaching videos on the Internet. The curriculum lays special emphasis on the skills and normalization of office automation applications, and help students have a general picture of Microsoft Office series software. The humorous classroom teaching with clear train of thought is greatly appreciated by students.