![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-rGagU0k_M_0XJjWqyD9pFC9hxpshK1YqNioBJTIrDqim6wvP95paO3uQOmRa9uQBoQ7QUFZv_un20bfgf0LTmTlz-WPsWIxWjhr647KMf1hDjxLQobH_EVoxAcg56EftGBhQYgUjAEKER3dG1u8luOC2qFS6muRvxfgWiyXfhMcg/awb.jpg)
【Excel 实战精英班课程】
包括Excel初中级班和中高级班的全部内容
【免费重听】
此班的最大特色同时也是我们的学生能充满自信应付中介和雇主的面试,同时帮助学员很快找到和适应会计工作中大量的Excel的实战运用操作。
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-qeaZbhVo8-EpHWfjGITEi1M1UHFzAcCjsBGfP5qzoEkzHpOQF7o9wncBPDSpp4G5XqLA-9ch3wyb6ZCuH1ukI2Jzpr-5QaabO4N_oy6mADxKBFcLnmwdRpdm8UmkXMediSkONadMgWk1vhDooWCMmy3xQMTjd-VYXrSmjPLMK6LA/awb.jpg)
![](https://i.aoweibang.com/img/-Kma-i0rs__B1BMjeYSjuf95RPU7xNvxQG_cMinnVXQ5WKnIqNsL6Jb2QaNchmjx_rrniUzCklWT8VDXqNlav_jxKwdeIcMXjZL7BiKuKTIunHyepVbKL55NJ8UpvuX8Rerz_tR8VbVL7y6gbOnJQt8rXuvZTHd8V2ACzxhQkFKE_lo7AjovTDimDpgbGcq-DZCy6dRdQG9UP97jtyRPBQ/awb.jpg)
1.对于没有工作经验或者刚接触工作的同学来说,excel可能会显得很难,无从下手
2.如果找到了会计工作,但想长期保持工作,excel是必须掌握的技能
3.在Assistant Accountant 或Financial Accountant的工作当中,excel的应用十分广泛,如果能够熟练使用excel,不但可以出色完成工作,并且还可以得到同事以及经理的认可和欣赏。
4. Nicole Accounting的Excel实战精英班,由在四大工作多年的老师进行讲课,包括了工作中常用的excel应用。选取的例子和教程都是工作当中非常实用的function。掌握好这些技巧以及excel功能,绝对能在工作面试时对excel充满自信,以及给工作提高效率。
![](https://i.aoweibang.com/img/-Kma-i0rs__B1BMjeYSjuf95RPU7xNvxQG_cMinnVXTOVOAiwQEdSZ2oxc6nn0BlDOht8hE0_1ThMb1EDZHODHq7ZIBkBfcRWygEH3s-lqwvFH2U39efKlqA-n2B7B839PlZCLMu-JcyEK32KY_KZqReIPEmY-N2cJPajYM5TBG_6V_P79n3MwLRkqppaqppRyHZiI-WUH7g-6UOT1MePg/awb.jpg)
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-q6UcZRKIPREYiSItceD9e46I9bh2OcilzZEL5-6LK5wMwvBtfW5phSStLpfb2cy6qnDKXhbNjGhLlo1H20ow7z4DgUwz5RSge9bpGS5Sebu8IeDsl5qspi4bppfPK2qXqSkONadMgWk1vhDooWCMmy3xQMTjd-VYXrSmjPLMK6LA/awb.jpg)
课程设置
授课时间:6-7小时
授课内容:实战中级班和高级班,涵盖大部分工作中会用到的基本excel功能。
授课方式:采取小班教课,并且会布置课后作业。
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-rW4LP0-GHddEsXt4b7b1_1V9OvFFJyDeVkEittPyFxBO_L5hYzx_DDkqsCIe8wJJn7HpxDW1Z-N-WwLH_mBKRBkDVL5poL1ckWXLBAvU5-mFdkuPJzzIwVEG2wOT8GigKBhQYgUjAEKER3dG1u8luOC2qFS6muRvxfgWiyXfhMcg/awb.jpg)
课程简介——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
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-q8llgdwAnQfiaMl98MXrYcF51u4UZ1dh46jZ2VU_el1WwWtIKMlo2eo1HlfEWbxlSrfd_QD0d3Cs68jkU1lStw44wa9ktjV4yR6DEQrF1PqPMBvosisjxp_J1RnKTCue3FCLPYGX6Cc5ogTKC6Y9Hn40aQqdRDoE6AQr3bW9WiDg/awb.jpg)
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
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-oL-JFCaUgDJNYaS3hm0KirpHIQ38092pxNPLVeob4MFrFiGQdcibhogITVQIlv0I9TlBR0yiGF0KsWtGwoRcDuprLsh2CLSyXi4n9hGIrCJaHkFjHKJEQdhPG9SZNgxEjFCLPYGX6Cc5ogTKC6Y9Hn40aQqdRDoE6AQr3bW9WiDg/awb.jpg)
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,
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-qeaZbhVo8-EpHWfjGITEi1M1UHFzAcCjsBGfP5qzoEk1X0hPrcoUMfiUCkkhpyaPIOoxuq3pgdEvxl6W3IYrW3g33SUgtkbwu9HPHvoFD8CcGKnvaok8iLsQOju6yvmbXFCLPYGX6Cc5ogTKC6Y9Hn40aQqdRDoE6AQr3bW9WiDg/awb.jpg)
课程简介——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
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-rtNZc3WuGPQrocSwolFXvrQepy1QMsq4Wqnlg6zgPE-GN5gA-THcHF3l67Hd9MIIrUnS7WUypyRDmvTU8B_e6QCXGsvXv4LSc1ldtRXY8tR3_WsmPrDisdpvwqSMtFlY6BhQYgUjAEKER3dG1u8luOC2qFS6muRvxfgWiyXfhMcg/awb.jpg)
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
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-ovxXnnUckF3l8FQllC2nMfUj19HCHQI8l79l6iqBi5p2LTooFXmtm7jx7fA_gMQFfAAwElwTsAoMA54cN8Nlw0-zeECXvtR6_IwuEkgAqh0W_Bf3Lvz1gGphd2-ATLdvqSkONadMgWk1vhDooWCMmy3xQMTjd-VYXrSmjPLMK6LA/awb.jpg)
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
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-pAEZTjGy4sLjLKDyefMhifoD39MyLsXD7nu0feTDEFOXu-HLxDCdhvDlRQH4HoKiZ8IYHV9_TIW8XUzC1nVAo4JMmmJ6FkRpf9J54Csd0tUOuREFhmKCFx1xck09xSM82VGaRAZceWfX-5_3v5rB9CwFNEbipZRYpx6Nx43RN51g/awb.jpg)
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-qdTEVdK3DTe_hvl63B_q1mCUF-evezbDVd_ddqdkC5I06v7lEDbZ8Jfs_3KnlwSOUcmZjsT8_-z-0PqieDzEG46yUsm_XL_ceE8MelUIYaQ7YJP8_J3SZc1iXutHwBfAp9EZGeNBVWXRLv9xIRCYWtLFtDF4wzJNtd_d_4lUaEnw/awb.jpg)
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-pZxOomN66fxFQkAhDgcoba-tbvLENkMLUtJ31U22laoaA5EECWlBeyZrGkFqYB-wnKxWTChzfS9xQX2nYaJMO_ouJQeAP2mVtHaHDCs8Br8AedIxGRVs9u57u5vypP8TyVGaRAZceWfX-5_3v5rB9CwFNEbipZRYpx6Nx43RN51g/awb.jpg)
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-od594KX4eOcAP4fQFY0zvywQFZWUlCOaOPxNxBlT0_lt5c24nidaPNN02s1wPzcyPdYt6jeJ6-t5zS7zEpFAp6bVRoniBkk8BCBxcbrTVepyVoBPPk06naw8quvzlQ1HnuX_tLXbvvRJ2aKVQHT9dMZ7robktNuH29wEg3Ny3Drg/awb.jpg)
![](https://i.aoweibang.com/img/aSjMr7651dyLBf41xuhHyvR9PfkKZcRmaOvx-ID5n-q9HekZa3mPM3ZTYpoKNQAcTTC3kRmDjbLI286faf-fZs9ioskcuccwyCO5b0n_GQX-xSKAWPGhSsXecOx5hiNp8aIbTcSZgLT1TpNfXGlaMcKSt4kNTU3g7c4c_35CtayBhQYgUjAEKER3dG1u8luOC2qFS6muRvxfgWiyXfhMcg/awb.jpg)