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

싱가포르

Advanced Excel for Professional | One Raffles Place에 관한 정보와 티켓을 찾고 계시나요? 트립닷컴이 도와드릴게요! 지금 Advanced Excel for Professional | One Raffles Place의 날짜와 일정, 기타 정보를 확인하시고 Advanced Excel for Professional | One Raffles Place에 참석하기 전에 마음에 드는 항공편과 호텔을 최저가로 예약해 보세요! 트립닷컴에서는 이와 유사한 액티비티와 항공권+호텔 패키지를 할인된 가격에 더 다양하게 만나볼 수 있답니다. 지금 바로 여행을 시작하세요!

Advanced Excel for Professional | One Raffles Place 날짜 및 일정 | 트립닷컴

Advanced Excel for Professional | One Raffles Place

Advanced Excel for Professional | 트립닷컴

싱가포르 관련 내용 더 보기

null | 트립닷컴

다른 친구들의 생각이 궁금하신가요? 답변을 공유하고 이야기를 나눠보세요!

15241명이 즐겨찾기에 추가했어요

래플스 싱가포르

싱가포르 '멀라이언 파크'에서 가까움|마리나 베이

럭셔리 호텔

13059명이 즐겨찾기에 추가했어요

리조트 월드 센토사 비치 빌라

싱가포르 '유니버셜 스튜디오 싱가포르'에서 가까움|센토사 아일랜드

패밀리 호텔

유니버셜 스튜디오 싱가포르

즉시 이용 가능

오늘부터 이용가능

패밀리 추천 명소

놀이공원

야경

익명 사용자

가족과 즐거운 하루를 보냈습니다. 일부 놀이기구는 줄이 길었기 때문에 패스트트랙 티켓을 추천합니다! 아침에 날씨가 안 좋아서 입장이 늦어져서 약 7시간 동안 공원에 있었습니다. 음식은 비싼 편입니다. 전반적으로 훌륭한 경험이었습니다. 이 공원에 닌텐도 존이 추가되면 좋겠네요! 제 평점은 7/10입니다.

가든스 바이 더 베이

Pintettaii

시어머니께 드리는 완벽한 생일선물 묶음 체험.. 시티투어버스 + 플라워돔 + 클라우드포레스트 🫶🏻

20205명이 즐겨찾기에 추가했어요

카펠라 싱가포르

현지스타일 호텔

72081명이 즐겨찾기에 추가했어요

마리나 베이 샌즈 싱가포르

싱가포르 '마리나 베이 샌즈 싱가포르'에서 가까움|마리나 베이

인스타 핫플 호텔

9884명이 즐겨찾기에 추가했어요

더 풀러턴 베이 호텔 싱가포르

만다이 와일드라이프 리저브

사파리와 야시장은 독특하고 아름다운 경험이었지만, 사람이 많아서 밤에는 동물들을 보기가 어려웠고, 낮에 레인포레스트 와일드라이프 아시아를 방문한 후에는 좀 지루했습니다. 45달러라는 가격에 두 시간 동안 방문하는 것은 가성비가 좋지 않습니다.

나이트 사파리

이 여행 정말 즐거웠어요. 가격 대비 가치가 충분히 있어요. 꼭 한번 가보시길 추천합니다.

스카이라인 루지

케이블카

Memego

강력 추천합니다!! 너무 재밌어서 쿠알라룸푸르에도 가서 놀았어요. 모든 연령대가 즐길 수 있는 재밌고 중독성 있는 게임이에요.

시간:	Aug 20, 2025(UTC+8)
주소:	One Raffles Place

Advanced Excel for Professional | One Raffles Place

상세 정보

투표하기

Advanced Excel for Professional에 관심이 있으신가요?