Skip Main Navigation
Eventbrite
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content
This event has ended.
Advanced Excel for Professional

Actions Panel

Feb 13

Advanced Excel for Professional

The course will provide a detailed explanation of the basic concepts and swiftly moves to an advanced level to teach new concepts even to Ex

By Riverstone Training Pte Ltd

When and where

Date and time

February 13 · 9am - February 15 · 5pm +08

Location

One Raffles Place 1 Raffles Place Singapore, 048616 Singapore

Refund Policy

No Refunds

About this event

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

Tags

  • Singapore Events
  • Central Singapore Events
  • Things to do in Singapore
  • Singapore Classes
  • Singapore Business Classes
  • #training
  • #excel
  • #analysis
  • #excel_course
  • #excel_training
  • #excel_online_course
  • #excel_advanced
  • #advanced_excel_class

About the organizer

Organized by
Riverstone Training Pte Ltd

Riverstone Training is a leading provider of financial training programs to professionals from diverse backgrounds in the financial industry. As a specialized training company, Riverstone aims to bridge the gap between technical skills required by companies and the available talent by offering practical and work-oriented training courses in the field of finance.

Facebook profileOrganizer website
Sales Ended
Event ended

Advanced Excel for Professional


Follow this organizer to stay informed on future events

By Riverstone Training Pte Ltd

Events you might like

  • Advanced Excel for Professional

    Advanced Excel for Professional
    Advanced Excel for Professional

    Tue, Aug 1, 9:00 AM
    One Raffles Place • Singapore
    $2,772.95
  • Advanced Excel for Professional

    Advanced Excel for Professional
    Advanced Excel for Professional

    Mon, May 8, 9:00 AM
    One Raffles Place • Singapore
    $2,772.95
  • Advanced Excel for Professional

    Advanced Excel for Professional
    Advanced Excel for Professional

    Wed, Nov 8, 9:00 AM
    One Raffles Place • Singapore
    $2,772.95
  • Advanced Data Science Professional Using Python  - Onsite @ Singapore

    Advanced Data Science Professional Using Python - Onsite @ Singapore
    Advanced Data Science Professional Using Python - Onsite @ Singapore

    Tue, Jul 25, 9:30 AM
    CASUGOL • Singapore
    $499.17
  • Advanced Data Science Professional Using Python  - Onsite @ Singapore

    Advanced Data Science Professional Using Python - Onsite @ Singapore
    Advanced Data Science Professional Using Python - Onsite @ Singapore

    Tue, Nov 28, 9:30 AM
    CASUGOL • Singapore
    $499.17
  • Hands on MS Excel & VBA for Finance, Strategy & Managerial Professionals

    Hands on MS Excel & VBA for Finance, Strategy & Managerial Professionals
    Hands on MS Excel & VBA for Finance, Strategy & Managerial Professionals

    Sun, Mar 26, 2:00 PM
    Woodlands Regional Library • Singapore
    $100
  • Certified Strategic Intelligence Professional - Onsite @ Singapore

    Certified Strategic Intelligence Professional - Onsite @ Singapore
    Certified Strategic Intelligence Professional - Onsite @ Singapore

    Mon, Aug 14, 9:30 AM
    CASUGOL • Singapore
    $396.47
  • Certified Digital Transformation Professional - Onsite @ Singapore

    Certified Digital Transformation Professional - Onsite @ Singapore
    Certified Digital Transformation Professional - Onsite @ Singapore

    Mon, Aug 21, 9:30 AM
    CASUGOL • Singapore
    $396.47
  • Certified Digital Transformation Professional - Onsite @ Singapore

    Certified Digital Transformation Professional - Onsite @ Singapore
    Certified Digital Transformation Professional - Onsite @ Singapore

    Mon, May 15, 9:30 AM
    CASUGOL • Singapore
    $396.47
  • Certified Applied AI Professional - Onsite @ Singapore

    Certified Applied AI Professional - Onsite @ Singapore
    Certified Applied AI Professional - Onsite @ Singapore

    Wed, Aug 23, 9:30 AM
    CASUGOL • Singapore, Wilayah Persekutuan Kuala Lumpur
    $396.47

Site Navigation

Use Eventbrite

  • Create Events
  • Pricing
  • Eventbrite Boost
  • Eventbrite Mobile Ticket App
  • Eventbrite Check-In App
  • Eventbrite App Marketplace
  • Event Registration Software
  • Content Standards
  • FAQs
  • Sitemap

Plan events

  • Sell Tickets Online
  • Event Planning
  • Sell Concert Tickets Online
  • Event Payment System
  • Solutions for Professional Services
  • Event Management Software
  • Community Engagement
  • Virtual Events Platform
  • QR Codes for Event Check-In
  • Post your event online

Find events

  • Browse Local Events
  • Get the Eventbrite App

Connect with us

  • Report This Event
  • Help Center
  • Terms
  • Privacy
  • CA Privacy Notice
  • Accessibility
  • Community Guidelines
Eventbrite + Ticketfly

© 2023 Eventbrite