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

Book now for tomorrow

Family-Friendly Attractions

Amusement parks

Night view

aldfsura

It may be because of the summer vacation. Even on weekdays, there are a lot of people. The roller coaster is 120 minutes, and the mummy is 70 minutes. Especially the projects where you can&#39;t use your mobile phone and can only wait are quite tiring. There will be a lot fewer people around 7 pm. Due to the weather and climate of Singapore 🇸🇬, occasional heavy rain may cause the project to wait for maintenance temporarily. Overall, the experience is not bad. It feels slightly better than the North Ring in all aspects. It is also one of the few second visits we have in Singapore❤️

Gardens by the Bay

Immediate access

Book now for today

Best Things to Do

M47***45

The free garden outside is very large and is also recommended. You may encounter giant lizards, otters, and city roosters on the way. In general, the free places outside are more beautiful than the places inside that require tickets. The inside is more like a botanical garden, artificial landscapes, etc.

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, but after a long time of calm, I feel that I should write some. It is not for a short essay, but to simply record this bad night and the pitfalls I encountered, and give tips to future tourists and friends. I don&rsquo;t know if it can help you. Let&rsquo;s encourage each other.

July 17, 2025 Singapore Wildlife Park Night Safari

First, the conclusion: the zoo is great, and the night experience is also very novel. It is definitely a must-visit attraction in Singapore, no one else.

The only thing you need to pay attention to is: don&rsquo;t book tickets on Ctrip. Because you may find that you have to wait outside the door for two hours before you can enter the park after you arrive; no matter how much homework you do, you will never think that Ctrip will cheat you, and it will be a big one; you have to stand honestly after taking a taxi from the city center, and Ctrip will question us as fools, and four fools.

Our group of four bought the tickets shown in the picture, with the keywords: [No reservation required] [7:15PM]. It should be noted that this product includes two tickets, one [Chinese train] and the other [entry ticket]. On the purchase page, you only need to select the time of the train, because the product interface clearly states that no reservation is required for the entrance ticket, [You can enter the park according to the Chinese train schedule and show the voucher to the staff].

OK, then the purchase is successful, I clicked on the confirmation form, looked at the precautions with satisfaction, and looked forward to the wonderful experience of my first night tour of the zoo in my life.

The big one is coming. Because we still had work to do in the afternoon, the four of us took a taxi to the zoo after the meeting. We arrived at the gate at 19:20 and found that there were five or six park staff standing about 20 meters in front of the gate checking tickets one by one, shouting that those who were waiting for 19:15 could enter the park now. As a result, when they saw our tickets, they said NO, because although our train time was fine, there was a line of small words under the QR code of [Entrance Ticket] [Admission from 9:15 PM], which means that the scheduled entry time was after 9:15 pm. My head buzzed at the time, and I immediately contacted the customer service: Why is the entry time of this ticket later than the train time in the park?
The customer service was very professional, and they immediately contacted the merchant. The merchant said that there was no need to check the ticket, and you could enter directly by scanning the code. I said that they didn&rsquo;t let us go to the step of scanning the code, and someone stopped us.
Merchant: &quot;Just show them the ticket for the train and they can enter the park. You don&#39;t need to show them the ticket behind.&quot;
Me: &quot;But they just want to see the ticket behind.&quot;
The result was that we waited from dawn to dusk, until the ticket inspectors at the gate had all gone off work, before we could enter. My friend smiled and praised the merchant for being &quot;partly right&quot;, maybe they came after 9pm.
The customer service patiently asked me if I had any demands, and they would negotiate with the merchant. I frankly said that I had no demands. What demands could I have? My demands were just to walk around and chat with friends in a once-in-a-lifetime zoo, that&#39;s all.

Skyline Luge Singapore

Cable car

Apart from Universal Studios, this is the only place my children visited twice. They played there both during the day and at night and returned very satisfied. It is sunnier in the daytime and in the morning, and each round of waiting time is longer than the last. In the morning, there is a long queue to exchange tickets, but those who buy current tickets can start playing directly.

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