Microsoft Excel

icon5

培训中使用的工作软件: Microsoft Excel 2013

课时: 1次课(每次课8小时)

Microsoft Excel 培训项目分为初级,中级和高级三个不同程度的培训。学员将在培训中学习如何使用Excel工作软件对数据和信息进行分析、分享和管理,从而使得决策者在充分了解相关数据和信息的情况下作出更有效的决策。

初级Excel培训内容:

  • Getting Started with Excel
  • Excel Selection Techniques
  • Manipulating rows and columns
  • Manipulating cells and cell content
  • Sorting a Cell Range
  • Excel Worksheets
  • Freezing Row and Column Titles within Excel
  • Font, Number and Alignment Formatting within Excel
  • Excel Formulas
  • Functions and Chart
  • Customising Excel

中级Excel培训内容:

  • Excel Setup and Viewing Options
  • Excel Functions and Formulas
  • Excel Time and Date Functions
  • Excel Mathematical, Logical and Statistical Functions
  • Excel Financial, Lookup, and Database Functions
  • Excel Named Ranges
  • Excel Cell and Range Formatting
  • Advanced Worksheet Manipulation within Excel
  • Excel Templates
  • Paste Special Options within Excel
  • Proofing and Printing

高级Excel培训内容:

  • Excel Pivot and Input Tables
  • Excel Charts and Hyperlinks
  • Linking within Excel
  • Embedding within Excel
  • Importing Text Files into Excel
  • Sorting, Filtering and Totalling Data within Excel
  • Tracking and Reviewing Changes in Excel
  • Excel Scenarios
  • Validating within Excel
  • Auditing Techniques in Excel
  • Macros within Excel
  • Excel Passwords and Security Issues

培训期间学员将获得:

全程上机操作实战培训

针对个人情况定制培训方式

免费提供硬件设施和学习材料

行业精英培训师的专业指导

拥有CPA资质的导师亲自培训

线上内部论坛独家资料分享

培训毕业证书 Certificate of Completion