Professional Course

Excel for Finance - Essentials

ACF Academy, In London (+2 locations)
Length
1 day
Price
685 USD, 500 - 550 GBP
Next course start
29 February, 2024 (+3 start dates)
Delivery
Classroom, Virtual Classroom
Length
1 day
Price
685 USD, 500 - 550 GBP
Next course start
29 February, 2024 (+3 start dates)
Delivery
Classroom, Virtual Classroom
This provider usually responds within 48 hours 👍

Course description

Excel for Finance - Essentials

The Essentials of Excel for Finance course is a practical one-day class that will empower participants to become adept in using Excel for a wide range of applications in business and finance.

What really sets our program apart is the combination of small classes, personal supervision from an experienced instructor, and plenty of hands-on exercises where participants can immediately put their newly-acquired skills into practice.

By the end of the course, participants will become proficient at creating professional spreadsheets from scratch, and in using Excel effectively in real-world business applications.

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Upcoming start dates

Choose between 3 start dates

29 February, 2024

  • Classroom
  • London

11 March, 2024

  • Classroom
  • New York City

29 April, 2024

  • Virtual Classroom
  • Online

Who should attend?

Who Should Attend

Anyone who wants to understand the essentials of Excel for practical application in business and finance.

Prerequisites

None

Training content

Introducing Excel

  • The Excel interface
  • The main tabs
  • The ribbon
  • Worksheets and workbooks
  • Rows and columns
  • Cells
  • Ranges
  • Numbers and text
  • Simple Excel formulas
  • Simple formatting options
  • Some Excel shortcuts
  • Creating an invoice spreadsheet

Excel Tips and Techniques

  • Organizing the ribbon and QAT for optimal efficiency
  • Absolute and relative references
  • Copy and pasting
  • Pasting values,formulas,and formats
  • Using"drag and drop"for moving and copying cells
  • Filling cells
  • Merging and unmerging cells
  • Organizing the workbook
  • Exploring a financial model
  • Freezing rows and columns
  • Formatting numbers and dates
  • The format painter
  • Using borders,fonts,colors,and shading
  • Using Names for cells and areas
  • Auto-formatting for tables
  • Creating and formatting charts
  • Printing
  • Excel workshop

Excel Functions for Finance

  • Math and Statistical: SUM, AVERAGE, MEDIAN, MAX, MIN, COUNT, SUMIF, RANK, ROUND, MROUND
  • Lookup: HLOOKUP, VOOKUP, LOOKUP, INDEX, MATCH, CHOOSE
  • Financial: FV, PV, PMT, RATE, NPER, NPV&XNPV, IRR MIRR & XIRR
  • Logical: IF, AND, OR, NOT
  • Date and Time: DATE, DATEVALUE, TODAY, WEEKDAY, EDATE, EOMONTH, YEARFRAC
  • Excel functions workshop

Essential Excel Techniques

  • Data validation
  • Protecting worksheets and workbooks
  • Hiding and un-hiding sheets and formulas
  • Grouping of rows and columns
  • Arrays and array formulas
  • Goal seeking and the solver
  • Investment optimization challenge
  • Data tables for sensitivity analysis
  • Macros
  • Recording and running macros
  • Macro recording and editing workshop
  • Pivot tables
  • Working with a pivot table

Costs

  • New York: $685
  • London: £550 (plus VAT)
  • Virtual: £500 (plus VAT)

Certification / Credits

CPD: 7 hours

Learning Outcomes

By attending this course, you will:

  • Understand how to use Excel to perform a wide range of tasks for business, finance, accounting, modeling, scheduling, planning, and more
  • Explore the Excel interface, and how to create a professional-looking spreadsheet
  • Pick up useful tips and techniques for using Excel efficiently
  • Learn “best practice” in laying out spreadsheets and designing workbooks
  • See how to customize Excel by creating a personalized toolbar and ribbons
  • Examine the most important Excel functions for finance
  • See how to accelerate common tasks by using powerful keyboard shortcuts and mouse actions
  • Gain insight into some of the more advanced features like data validation, goal seek, macros, and pivot tables

Why choose ACF Academy?

Over 100,000 professionals trained globally

Award-winning practical financial simulations

Consistently high ratings

Contact this provider

Contact course provider

Tell us what kind of professional training you're looking for and we'll put you in touch with relevant training providers who will send you a quote.

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
ACF Academy
28 King Street
EC2V 8EH London

ACF Academy

ACF Consultants are a global leader in providing practical and effective training for financial professionals. Leading banks, companies and financial institutions from all over the world partner with us to develop their people to achieve their goals. They trust our...

Read more and show all training delivered by this supplier

Ads