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

Singapore

Searching for information and tickets regarding Advanced Excel for Professional | One Raffles Place taking place in Singapore on Aug 20, 2025 (UTC+8)? Trip.com has you covered. Check the dates, itineraries, and other information about Advanced Excel for Professional | One Raffles Place now! Trip.com has also prepared more similar exciting activities and discounted flight and hotel packages.

Advanced Excel for Professional | One Raffles Place: Tickets, Dates & Itineraries | Trip.com

Advanced Excel for Professional | One Raffles Place

Advanced Excel for Professional | Trip.com

null | Trip.com

Spread the word! Share your result with friends and discover their opinions!

Raffles Singapore

Luxury Hotels

Resorts World Sentosa - Equarius Villas

Near Universal Studios Singapore|Sentosa Island, Singapore

Family Hotels

Universal Studios Singapore

Immediate access

Book now for today

Best Things to Do

Amusement parks

Night view

Anonymous user

Great day out with the family. Recommend the fast track tickets as the Queues for some rides were long! Weather was bad in the morning so we delayed our entry and so we were in the park for approx 7 hours. Food is pricey. Overall a great experience. I wish they add a Nintendo zone to this park! My rating 7/10

Gardens by the Bay

che***su

The whole trip was perfect! Singapore is really a place for people! Not only the scenery is beautiful, but Singapore citizens are also very, very friendly to the Chinese! The attractions that I especially want to recommend are Singapore Changi Airport and Binhai Garden, which is really amazing. The hotel I chose is also very good, Trip.com The recommended hotel is really cost-effective. Special thanks to Xiaoxiao, the housekeeper of this Singapore trip. He is really a very responsible consultant. He took good care of us throughout the whole process, including the entry list to help us fill it out. I have any problems during the trip. I have serious and responsible help solve them. The pick-up and drop-off arrangement is very intimate, the recommended places to go shopping are very good, there are questions and answers! Really intimate good housekeeper! Praise! In short, I recommend everyone to come to Singapore, it is really a good tourist country!

Capella Singapore

Cultural Hotels

Marina Bay Sands Singapore

Near Marina Bay Sands|Marina Bay, Singapore

Instagrammable Hotels

The Fullerton Bay Hotel Singapore

Mandai Wildlife Reserve

135***16

Located in the north of Singapore, Singapore Wildlife World is one of the best tropical rainforest zoos in the world. Managed by the Wildlife Conservation Group, it has four parks: Singapore Zoo, Night Safari, River Safari, Singapore Bird Park, and Rainforest Adventure Park.
Singapore Zoo is well worth a visit. As one of the top ten zoos in the world, its open design, rich animal species and unique ecological experience make it an ideal choice for family travel and nature lovers.

Night Safari

M32***44

I rarely write reviews. I have been calm for a long time and feel that I should write. It is not for small compositions, but simply record this bad night and the pit I encountered, and give tips to the later tourists and friends. I don&#39;t know if I can help you. July 17, 2025 Singapore Safari Park Night Safari Let me say the conclusion: the zoo is great, the night experience is also very novel, it is definitely a must-check attraction in Singapore, no one. The only thing to pay attention to is: tens of millions of [do not] book tickets on Trip.com . Because you may find that you have to wait two hours outside the door to enter the park; what is to take the small train to listen to Chinese explanations before dark, no matter how much homework you do, you can&#39;t think of Trip.com pit you, a pit will be a big pit; I have to stand honestly when I take a taxi from the city center, and I have to be questioned by Trip.com that we are fools and four fools. Four of us bought tickets as shown in the picture, keyword: [No reservation required] [7:15PM], it should be noted that this product contains two tickets, one [Chinese small train], and the other [entering the park ticket]. On the purchase page, you only need to choose the time of the small train, because the production The product interface clearly states that there is no need to make an appointment for admission tickets. [You can enter the park according to the time of the Chinese small train, and show the voucher to the staff]. OK, then the purchase was successful, I clicked on the confirmation form, and looked at the precautions with satisfaction, the wonderful experience of the first night tour of the zoo in my life. The big one is coming. Because there was still work in the afternoon, the four of us took a taxi to the zoo after the end. At 19:20, we arrived at the door and found that about 20 meters before the gate, five or six park staff checked the tickets one by one, and shouted at 19:15. Now you can enter the park, but when you see our ticket, the other party said a word NO. Because although our small train time is no problem, there is a line of small characters [Admission from 9:15 PM] under the QR code of [entering the park ticket], which means that the reserved entry time is after 9:15 pm. I was buzzing in my head and immediately contacted customer service: Why is the entry time for this ticket later than the small train time in the park? The customer service is very professional, and they immediately contacted the merchant. The merchant said that there is no need to check the ticket, and you can enter by scanning the code directly. I said that people will not let us scan the code step, and someone stopped it. Merchants: &quot;You can enter the park by showing them the ticket for the small train directly, without showing them the ticket at the back.&quot; Me: &quot;But people are going to see the ticket at the back now.&quot; The result is that we waited from dawn to dark, and waited until the staff at the door were off work before we arrived. Friends laugh at the merchants &quot;partly right&quot;, maybe they come after 9 pm. The customer service patiently asked me what I had, and they would negotiate with the merchant. I honestly don&#39;t have any demands, what can I have? My demands are just hanging out with friends at a zoo in once in a lifetime, and that&#39;s all.

Skyline Luge Singapore

Cable car

Memego

very recommended !! it was so fun that we went to kuala lumpur to play there too. fun and addictive for all ages

Advanced Excel for Professional | One Raffles Place

Details

Vote

Are you interested in Advanced Excel for Professional?

Recommended Products for Advanced Excel for Professional | One Raffles Place

Raffles Singapore

Resorts World Sentosa - Equarius Villas

Universal Studios Singapore

Gardens by the Bay

Capella Singapore

Marina Bay Sands Singapore

The Fullerton Bay Hotel Singapore

Mandai Wildlife Reserve

Night Safari

Skyline Luge Singapore

Advanced Excel for Professional | One Raffles Place

Details

Vote

Are you interested in Advanced Excel for Professional?

Recommended Products for Advanced Excel for Professional | One Raffles Place

Raffles Singapore

Resorts World Sentosa - Equarius Villas

Universal Studios Singapore

Gardens by the Bay

Capella Singapore

Marina Bay Sands Singapore

The Fullerton Bay Hotel Singapore

Mandai Wildlife Reserve

Night Safari

Skyline Luge Singapore

More contents about Singapore