Go Back Up

解鎖VBA新技能 Finance 同Consulting人士必備絕招 仲有新年利是大放送啊!🧧

Jan 24, 2023 8:00:00 AM 1 min read

解鎖VBA新技能Finance 同Consulting人士必備絕招仲有新年利是大放送啊!🧧今時今日樣樣野都要快,行路要快,返工老細都想你做事快😞但手就得一對,咁點先可以三頭六臂呢?其中一個最有效嘅方法,就係分辨出工作入面,有幾多係重複性又而浪費時間但績效唔高嘅東西,然後用Visual Basic for Applications (VBA)幫你!核心概念就係用呢個programming language去design要用嘅功能,取代你做一啲好重複嘅tasks,提升效率同productivity。不過好多人都有個誤覺,覺得VBA 只能處理Excel admin task,當然唔止啦!而家連Big 4、MBB consulting firms都用緊佢perform好多複雜嘅tasks啦!睇到尾仲有最新新年企劃利是大放送優惠,唔好錯過啊!🧧VBA隨咗可以令你喺microsoft三寶 - Excel, Word 同Powerpoint 自己去set up program,唔洗再手動copy&paste或者逐個search&replace,其實喺好多tasks、喺好多行業都可以用到。大部分top finance & consulting公司例如Deloitte、McKinsey 同 Boston Consulting Group 嘅員工都有用緊VBA,入data出錯機率低咗9成,完成繁複嘅task效率高咗85%💻,整體仲增加咗30% productivity。下面就話你知VBA可以點係Business同Consulting行業幫到手啦!就好似Deloitte咁,用 VBA 嚟automate financial models,分析完問題同set up個model,只要入返啲data就ok,同一個model唔洗再重新整過,執少少野同入其他data就可以用喺相似嘅case到,用少咗七成嘅時間就搞掂複雜嘅計算;McKinsey 就用 VBA管理大型data sets,更快 extract data,完成data manipulation同analysis,令efficiency提高咗三成🆙。Boston Consulting Group 都有用佢嚟自動gen一啲定時定候要交format一樣嘅ppt slide同reports,只要入啲新data,VBA就可以幫你改返,唔洗再逐份逐份copy。好多公司依家係請人嘅時候都愈嚟愈focus係applicant有無類似VBA呢類tech skills,因為做野真係會有效率好多。McKinsey嘅former Global Managing Director 都曾講過,data science同automation係公司甚至係行業嘅大趨勢,已經著手train員工點用VBA同其他tech skills去support clients。都開到聲喇,呢個時候都係學定穩陣!我地都知道programming對你嚟講可能感覺好複雜唔知點學起🤯,又唔知學咩先可以係自己份工到用到。我地依家就有個專為想投身金融及諮詢業嘅學生而設嘅 ⭐️IT Bootcamp - Essential Tech Skills for Finance and Consulting⭐️,係8個星期入面,由HSBC data engineer 及 Hedge Fund Quant Trader 專注教你工作需要嘅tools同技術,包括點樣用VBA去update同拎data,create solutions,仲會有real project比機會你實踐,唔驚學完唔識用,應付coding test及為自己未來晉升打好第一個基礎。🧧新年利是大放送企劃🧧相信呢幾日大家都有見到Career Hackers搞緊新campaign!就係拎利是交學費啦!只要參加我哋個Whatsapp minigame challenge,就可以拎到最高價值HKD 500利是,參加我哋個 IT Bootcamp - Essential Tech Skills for Finance and Consulting 就有學費減免,年初限定!快啲到story highlight 搵參加link或聯絡我哋問吓詳情啦。

Career Hackers Editorial

Since 2020, Career Hackers has successfully linked over 100,000 talented individuals worldwide, hailing from 150+ esteemed universities. With a pool of 100+ experienced coaches and advisors from the banking and finance, IT, consulting, and conglomerate sectors, we have helped more than 1,000 students secure more than 1200+ dream job offers at leading firms like Goldman Sachs, JPMorgan, UBS, HSBC, PwC, Bank of China, Deloitte, EY, Accenture, IBM, and many more.