FORGOT YOUR DETAILS?

Microsoft Excel 两天培训课程

本 Microsoft Excel 两天培训课程 经精心设计,助学员掌握 Microsoft Excel 技巧与知识,以提高工作效率以及简化日常事务

在此课程里,学员将会广泛的学习到 Microsoft Excel 的功能,格式设定以及各种高阶功能。

两天培训课程初级到高级

您可以选择两天的完整课程或是选择其中一天初级或高级的课程。但是我们建议您选择两天完整的从初级到高级的课程以学习所有您可能忽略了的基础及高阶的 Excel 功能和应用技巧。

第一天 - 初级

此课程是为初学者而设计的,但是如果您想要重新的学习更完整的 Excel 功能及应用技巧,欢迎来参加!

第二天 - 高级

此课程适合对 Excel 有着基本认识以及想要更深一层的了解 Excel 的高阶功能和应用技巧的学员。

完成!

您将会学习所有 Excel 的基本及高阶应用技巧,有助您将所学技巧应用到现实个人或商业环境。

课程大纲 - 第一天(初级)

课题 1: Introduction

  • Topic A: Using the menus
  • Topic B: Versions

课题 2: Data Entry

  • Topic A: Formula Bar
  • Topic B: Working with dates and times
  • Topic C: Format Cells/ Data Formatting
  • Topic D: Flash Fill Series

课题 3: Creating formulas

  • Topic A: AutoSum/Average
  • Topic B: Days Formula
  • Topic C: Formula Wizard
  • Topic D: Audit Formulas (Trace precedent/dependent)

课题 4: Formatting

  • Topic A: Inserting shapes, arrows, and other graphics
  • Topic B: Adding and deleting rows and columns
  • Topic C: Hiding data
  • Topic D: Moving, copying, and pasting
  • Topic E: Sorting and filtering data
  • Topic F: Conditional Formatting / Data Bars / Data Icon Sets

课题 5: Inserts

  • Topic A: Clipping Screens
  • Topic B: Images/ Shapes
  • Topic C: Recommended Charts
  • Topic D: Linking Charts in PowerPoint
  • Topic E: Advanced Charts / Combo Charts

课题 6: Print

  • Topic A: Print Area
  • Topic B: Repeat Titles on print
  • Topic C: Page Layout / Page Break

课题 7: Security

  • Topic A: Allow people to edit selected cells only (Creating Forms)
  • Topic B: Protecting Worksheet & Workbook (Read Only)
  • Topic C: Workbook Encryption (Password to open)

课程大纲 - 第二天(高级)

课题 1: Formulas in Depth

  • Topic A: IF Function
  • Topic B: 3D Formulas
  • Topic C: CHOOSE/MATCH/INDEX
  • Topic D: VLookup / H Lookup

课题 2: Define Names

  • Topic A: Create your own names
  • Topic 2: Define Names in formulas and references

课题 3: PivotTables

  • Topic A: Using PivotTables and Filters
  • Topic B: PivotCharts
  • Topic C: Creating extended charts / business charts
  • Topic D: Gantt Charts

课题 4: Goal Seek

  • Topic A: PMT Formula (Loan Calculator)
  • Topic B: Goal Seek

课题 5: Scenario Manager

  • Topic A: Create various scenarios
  • Topic B: Using Scenarios

课题 6: Macro, Record and Play

  • Topic A: Record repeated tasks with Macro
  • Topic B: Add new buttons to your Excel to playback Macros
  • Topic C: VBA and Macro

课题 7: Microsoft Office Specialist (77-420) Overview

课程大纲 - 第一天(初级)

Topic A: Formula Bar

Topic B: Working with dates and times

Topic C: Format Cells

Topic D: Fill Series

Topic A: AutoSum/Average

Topic B: Days Formula

Topic A: Inserting shapes, arrows, and other graphics

Topic B: Adding and deleting rows and columns

Topic C: Hiding data

Topic D: Moving, copying, and pasting

Topic E: Sorting and filtering data

Topic A: Tracking changes

Topic A: Recommended Charts

Topic A: Protect regions

课程大纲 - 第二天(高级)

Topic A: IF Function

Topic B: 3D Formulas

Topic C: CHOOSE/MATCH/INDEX

Topic A: HLookup

Topic A: PivotCharts

Topic A: Creating extended charts / business charts

Topic B: Gantt Charts

Topic C: Form Controls

Topic D: Linking Charts in Powerpoint

Topic A: Working with Scenarios

Topic B: Using Goal Seek

Topic C: Using One-Input Data Tables

Topic D: Using Two-Input Data Tables

Topic E: Understanding Solver

Microsoft Excel 培训课程手册

TOP