Microsoft Excel is an excellent business tool because it has numerous functions and formulas to store, evaluate, and modify data effectively. Our course offers in-depth knowledge of Excel's various tips, tricks, formulas, functions, and shortcuts. The course is designed for participants who are already using Excel and need to enhance their professional financial analysis and financial modeling skills. Furthermore, participants of this course will learn to work without a mouse and use keyboard shortcuts to improve and enhance their spreadsheet designing abilities drastically. By enrolling in this course, you will stand out in an interview or move up the ladder in your career with excellent Microsoft Excel skills.
Overview
The course will provide a detailed explanation of the basic concepts and swiftly moves to an advanced level to teach new concepts even to Excel pros. The course is designed to ensure that complex ideas are delivered to participants, thereby supporting them in building a solid base needed to create advanced Excel spreadsheets. The course also offers a deep insight into Excel's various functions and complicated formulas, thereby delivering a better understanding of financial analysis and modeling. In addition, the course also covers finance-specific formulas that are important in performing financial analysis.
Who should attend 
All individuals who want to improve their advanced excel skills should attend this course
Middle to senior managers from different industries
All professionals who want to deal or currently deal with financial modeling in their company
Consultants, advisors, and other professionals who wish to improve their advanced Excel skills
Methodology 
Nontheoretical methodology includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability.
 
Trainer
We carefully choose all our trainers with rich and vast experience in the financial sector. The course will be conducted by an experienced training consultant having more than 20 years of industry experience with some of the world’s leading financial institutions, specializing in corporate finance, investment banking, and corporate fundraising.
Course Content
Module – 1
Excel: Layout and Keyboard Shortcuts
• An overview of the Excel layout
• What are workbooks, worksheets, cells, and formula bar?
• The ribbon – home, insert page, layout, formulas, reviewing data, view, and help.
• Learning keyboard shortcuts to navigate the ribbon.
Module – 2
Various Settings in Excel
• Reviewing the different general settings in Excel
• What are the formula settings in Excel?
• Studying data proofing, save the language, and the ease of access settings.
• Learning advanced Excel settings, customizing the ribbon, and quick access toolbar.
Module – 3
Effective Presentation Methods
• An overview of inputs vs. formulae.
• Learning how to extract data from pdf into Excel.
• Customizing numbers.
• Developing style templates and merging styles between models.
Module – 4
Formulating Adaptable and Auditable Formulas in Excel
• An overview of relative vs. absolute referencing.
• How to use names to increase formula efficiency?
• Learning various spreadsheet debugging skills.
• Link elimination and circularity issues.
Module – 5
Basic and Advanced Financial Analysis Structure
• Formatting background, special numbers, and column width.
• Font colors, format numbers, and subtotals with paste special.
• Anchoring, formating, grouping cells, naming cells, and editing multiple sheets.
• Conditional formatting and going to special.
Module – 6
Formulas and Functions
• How to use date functions, time periods, and yearfrac function?
• Use of sum, average, sumproduct, and median.
• Rounding and absolute functions.
• Use min, max, small, and large functions?
Module – 7
Data Management and Evaluation in Excel
• How to sort and filter data in Excel?
• Use of SUMIF and COUNTIF functions.
• IF statements in Excel?
• Using the IFERROR function.
Module – 8
Data Mining in Excel
• How to use text and dates in Excel?
• Analyzing the uses and dangers of conditional formatting.
• Various auditing tools.
Module – 9
Constructing Flexible Charts in Excel
• Studying chart setups
• formatting of charts.
• What are dynamic labels?
• Constructing bridge charts.
Module – 10
Pivot Tables Evaluation
• Pivot tables.
• Feature and application for data sorting and analysis
Module – 11
Depreciation with Excel
• Straight Line Method (SLN)?
• Declining Balance Method (DB)?
• Learning about Sum of Years Digits Method (SYD).
• Double Declining Balance (DDB) and Variable Declining Balance (VDB)?
Module – 12
Investment Analysis
• Simple and compound interest in Excel.
• Financial ratio analysis.
• How to calculate PV and FV?
• Calculating PV and FV of the annuity.
• What are NPV and XNPV?
• What are IRR and XIRR?
Module – 14
Nominal, Effective Rate of Interest, Loan Repayment, and Mortgage
• Loan repayment concepts.
• How to convert nominal rate to effective rate?
• Convert effective rate to nominal rate?
• Use of PMT and PPMT functions.
• How to use IPMT and CUMIPMT functions?
Module – 15
Bond Valuation
• Studying price (market value).
• What is yield (investor’s required rate or kd)?
• Bond valuation on a coupon date
• Bond valuation between coupon dates.
Module – 16
What-if Analysis, Scenario Analysis, and Sensitivity Analysis
• Goal seek and applications
• Data table and two-way data table.
• Differences between scenario and sensitivity analysis.
• What are the advantages of sensitivity analysis?
Module – 18
Complicated Formulas and Shortcuts for Date, Index, Match, etc.
• How to create complex formulas in Excel?
• Shortcuts for date format, one/two- week intervals, EO and EOM.
• INDEX and MATCH with date format and blank cells.
Module – 19
Macros Analysis
• What are macros in Excel?
• How to build macros in Excel?
• Coding macros in Excel.
If you need further information, please visit www.riverstonetraining.com.sg or send mail at info@riverstonetraining.com.sg
Riverstone – Corporate Traininghttps://www.riverstonetraining.com.sg
Information Source: Riverstone Training Pte Ltd | eventbrite

新加坡

正在搜尋Aug 20, 2025（UTC+8）在新加坡舉辦的Advanced Excel for Professional | One Raffles Place的資料和門票？ Trip.com 幫助您。 立即查看Advanced Excel for Professional | One Raffles Place的日期、行程和其他資訊！ Trip.com 更有其他類似的精彩活動。 立即起程！

Advanced Excel for Professional | One Raffles Place: 日期及行程 | Trip.com

Advanced Excel for Professional | One Raffles Place

Advanced Excel for Professional | Trip.com

探索更多關於新加坡的內容

null | Trip.com

分享你的結果，看看朋友們怎麼說！

新加坡萊佛士酒店

新加坡, 鄰近魚尾獅公園|濱海灣

奢華酒店

新加坡濱海灣金沙酒店

Instagram打卡酒店

新加坡環球影城

隨買隨用

即日可用

人氣景點

主題樂園

夜景

CJ7wonders

有趣、緊湊，一天就能玩遍。雖然它不是最大的環球影城，但維護得很好，運作也很高效，變形金剛和太空堡壘卡拉狄加都很棒&hearts;️&hearts;️&hearts;️。可惜木乃伊工程關閉了🥲🥲。

新加坡濱海灣花園

Stella_s

建議下午3,4點入園 這樣可以連同夜景 燈光秀一起看喔本來免費看的燈光秀遇上聖誕節限定活動 燈光秀要收費了😂

新加坡嘉佩樂酒店

新加坡, 鄰近新加坡環球影城|聖淘沙島

當地風情酒店

新加坡聖淘沙萊佛士酒店

新加坡, 鄰近巴拉灣海灘|聖淘沙島

新加坡富麗敦海灣酒店

萬態野生動物世界

zhang_ja

常說的新加坡動物園，其實分4個單獨的園區▫️新加坡動物園：老虎獅子大象啥的🐯🦁▫️夜間野生動物園：世界上首個夜間動物園🎑▫️新加坡飛禽公園：各種飛鳥為主🦜🦤🦩🦚▫️河川生態園：世界上最大淡水水族館🐟🐠🐡

夜間野生動物園

匿名用戶

門票物有所值，步道有點黑，所以夜視能力不好的人可能需要帶手電筒。露天劇場的表演一般，但可以算是對一些夜行動物的初步了解。亮點是火車之旅&mdash;&mdash;幾乎所有動物都很活躍，而且都在火車的視線範圍內。食物價格還可以，但比外面略貴一些。工作人員熱情友善。我會推薦給任何想在晚上體驗健康活動的人。

新加坡天際線斜坡滑車

親子景點

纜車

雖然今天去玩碰到了下雨，但是下了一會兒就停了，還是很好玩的，小朋友直呼再來幾圈，買了4圈還不夠玩，山上景色也不錯，也很好上手玩，不排隊，很幸運的一天

時間：	Aug 20, 2025（UTC+8）結束
地點：	One Raffles Place

Advanced Excel for Professional | One Raffles Place

詳情

投票

你對Advanced Excel for Professional感興趣嗎？