1.对于没有工作经验或者刚接触工作的同学来说，excel可能会显得很难，无从下手
2.如果找到了会计工作，但想长期保持工作，excel是必须掌握的技能
3.在Assistant Accountant 或Financial Accountant的工作当中，excel的应用十分广泛，如果能够熟练使用excel，不但可以出色完成工作，并且还可以得到同事以及经理的认可和欣赏。
4. Nicole Accounting的Excel实战精英班，由在四大工作多年的老师进行讲课，包括了工作中常用的excel应用。选取的例子和教程都是工作当中非常实用的function。掌握好这些技巧以及excel功能，绝对能在工作面试时对excel充满自信，以及给工作提高效率。

课程设置

授课时间：6-7小时
授课内容：实战中级班和高级班，涵盖大部分工作中会用到的基本excel功能。

授课方式：采取小班教课，并且会布置课后作业。

课程简介——Excel 实战初中级班

Learning topics:

Intermediate Level:

Excel Dimensions - AA,FA,MA,FM必备技能

一个区域输入一个公式，对于多个worksheets快速输入同一个内容

 Working on multiple sheet

Basic Excel Introductory topics

Ø  Cell references， the use of absolute and relative cell reference in formulas

Ø  Linking in Excel, how to trace precedent and dependent cells,

Ø  3D formulas

Ø  Error checking in excel

Ø  Data Validation

Ø  Using range names

Ø  Printing in Excel.

Ø   Change settings in Excel

Ø  Customizing quick access Toolbar

Data Cleaning

财务会计模型数据清理技能，繁琐资料，条理呈现

Find and Replace data by formula

Deal with blanks in source data

Deal with duplicate record in source data

Basic Formulas and functions

Ø  Auto Sum, subtotal

Ø  Sum, Min, Max, Right, Large, Or, And,

Ø  Basic If/ Sumifs formula,

Ø  Basic Finance formulas

Ø  Mixed cell references, Change text to Numbers,etc.

Ø  Sorting and Filter, Advanced Filter,

Ø   3D Formula

Ø   Enter data on multiply spreadsheet simultaneously

Data Reconciliation

AA FA 日常对账必备技巧

Same structured data reconciliation

Different structured data reconciliation

Traditional reconciliation in a modern way – speak cell

Formatting in Excel

Ø  Merge cells, adjusting column and row sizes.

Ø  Adjusting Fonts in worksheets.

Ø  Adjusting format of cells, including custom formatting

Ø  Inserting and deleting columns and rows.

Ø  Copy and paste techniques,

课程简介——Excel 实战中高级班

Nicole Accounting的Excel 中高级班，由在四大工作多年的老师授课， 比较适合已经对excel有一定基础， 想进一步提高自己excel技能的同学。教学会包括复杂公式以及数据量大的excel spreadsheet。掌握好这些技巧以及excel功能，绝对能在工作面试时对excel充满自信，以及给工作提高效率。

PS:我们的中高级班，涵盖大部分工作中会用到的基本excel功能。采取小班教课，并且会布置课后作业。

Conditional Formatting 

财务报表差异，粉饰财务报表

Conditional formatting from cell value

Conditional formatting from a formul

Advanced Level:

Pivot Tables:

Ø  How to create pivot table

Ø  Editing and formatting pivot tables.

Ø  Formatting in Pivot Table Report

Ø  Report filters in Pivot Table

Ø  Using Slicer in Pivot Table

Ø  Advanced Pivot Table functions.

Ø  Pivot Chart

Data Organisation

AA，FA岗位公式高级应用，提高作效率高人一等

– Most useful formulas & functions application

Logical function: IF without IF, AND without AND, OR without OR

Vlookup with approximate match

Extracting data through text function

Sort & Filter by formula

Sumifs and Dynamic data range

Advanced Fomulas

Ø  Advanced Sumifs Functions, comparing Sumifs with Pivot Table

Ø  Match Function

Ø  If function, with multiple conditions.

Ø  Advanced vlookup  function, vlookup with different tables etc.

Ø  Nesting Functions, combining various formula functions

Ø  IF ERROR, ISNA functions

Ø  ISTEXT/ISNUMBER/IS ERROR

Ø  Array Formulas

Data Analysis : What-If Analysis

Ø  Goal Seeker

Ø  The solver

Ø  Data Tables

  Macro

Ø  Basic Macro introductory: how to record and run a Macro

Ø  Visual Basic Editor

Ø  Basic VBA Functions

  Other:

Ø  Export other types of files in Excel

Ø  Import and excel list into Access

Ø  Basic Conditional Formatting in Excel