Event Details

该培训的语言为中文。


目标与内容 Objectives and Content


This course introduces the advanced application of Excel functions, including mathematical and statistical functions, Text functions, Date functions, Lookup functions, Database functions, Information functions, Logical functions, Financial functions and Customized functions, etc. It helps students grasp those skills successfully through detailed explanation of selected examples. Students will be able to apply Excel functions more skillfully and effectively by the end of the course.

本课程为具有Excel中高级应用水平的学员而设置。课程全面地介绍了各类Excel函数的高级应用技巧,内容涉及数学函数、文本函数、日期函数、查找函数、数据库函数、信息函数、逻辑函数、财务函数,以及如何自定义函数等,并通过案例指导学员掌握综合运用函数的技能,使学员能够更灵活、高效地应用Excel,显著提高工作水平。


参加对象 Target Group


This course is catered to those who are experienced in Excel and need for further application of Excel functions.

本课程适合已能熟练应用Excel,并需要进一步深入应用Excel函数功能的各类人员。


大纲 Outline



  • Text Functions: Combining, Splitting and Extracting Characters
  • Information Functions: Checking Information
  • Logical Functions: Using Logical Judgment
  • Date Functions: Calculating Age and Workdays
  • Mathematical and Statistical Functions: Applying Wisely
  • Database Functions: Multi-conditional Statistics
  • Lookup Functions: Different Ways to Look Up Desired Values
  • Financial Functions: Loan, Investment and Depreciation
  • Customized Functions
  • 合并拆分提取字符---文本函数
  • 检验各类信息----信息函数
  • 建立逻辑判断----逻辑函数
  • 年龄计算和工作日计算----日期函数
  • 灵活运用----数学和统计函数
  • 多条件统计---数据库函数
  • 多种途径查找所需数据---查找函数
  • 贷款、投资效益、资产折旧计算-----财务函数
  • 自定义函数

Agenda

Speakers

  • VT

    Venus Training

    The VenusTrain Instructor Team:

    VenusTrain, established in 1993, is dedicated to providing target-oriented computer training services to many multinational enterprises, such as Siemens, GM, Volkswagen, Dell, Roche, etc.

    The instructors of VenusTrain are not only experts in computer technology, but, most importantly, they are also good at communicating and willing to share their knowledge with trainees. They pay close attention to improve trainee’s ability of applying computer skills to practical work.

    The instructors have benefited many clients and, therefore, they have been popularly recognised and trusted.

    view more

Tickets

Member

Advance payment is required.

e-Fapiao will be sent to your email in 10 business days after the event.

This will be a live event and the ticket is not refundable

Standard Price RMB 1,400
Non-member

Advance payment is required.

e-Fapiao will be sent to your email in 10 business days after the event.

This will be a live event and the ticket is not refundable

Standard Price RMB 1,600

Yearly Sponsors 2021/22