课程介绍 （6小时）

此班的最大特色同时也是我们的学生能充满自信应付中介和雇主的面试，同时帮助学员很快找到和适应会计工作中大量的Excel的实战运用操作

1.对于没有工作经验或者刚接触工作的同学来说，excel可能会显得很难，无从下手

2.如果找到了会计工作，但想长期保持工作，excel是必须掌握的技能

3.在Assistant Accountant 或Financial Accountant的工作当中，excel的应用十分广泛，如果能够熟练使用excel，不但可以出色完成工作，并且还可以得到同事以及经理的认可和欣赏。

4. 360 Accounting的Excel实战精英班，由在四大工作多年的老师进行讲课，包括了工作中常用的excel应用。选取的例子和教程都是工作当中非常实用的function。掌握好这些技巧以及excel功能，绝对能在工作面试时对excel充满自信，以及给工作提高效率。

价格

$450

讲课大纲

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

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

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,

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

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

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