NZ$627.12 – NZ$836.32

High-Powered Excel for Finance 1 Day Training in Napier

Actions and Detail Panel

From NZ$627.12

Event Information

Share this event

Date and Time

Location

Location

The Venue will be announced soon

Napier

Napier, North Island 4104

New Zealand

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.

About this Event

Course Overview:

Advanced Excel features and functions for Finance and Accounting power users, including practical application.

This hands-on course goes far beyond simply explaining Excel’s features and functions – you’ll learn how to apply these to get more done and produce reliable, consistent, maintainable, user-friendly results.

You’ll literally gain the knowledge and skills you can use in your work every day to transform your Excel work and make decisions with confidence. This includes:

  • Valuable, time-saving techniques to reduce rekeying of data and increase automation.
  • Key features every budget needs to make it easy to maintain and easy to use.
  • The essential functions used by experts to increase consistency and reduce data entry.
  • Clever range name techniques that improve reliability and readability.
  • Best practices for producing flexible and reliable lookups.
  • Learn Excel’s hidden shortcuts to many common tasks that can save you hours of time everyday.
  • Techniques to make maintenance easier and make your models accurate, reliable and robust.
  • Powerful data analysis and visualisation techniques to identify trends and anomalies.
  • How and when to apply macros that will speed up the creation of your models
  • and more!

PLUS Q&A time so you can get answers to all those questions that have been bugging you! and handy tips to improve your productivity and reduce your frustration!

Target Audience:

  • Management Accountants
  • Financial Accountants
  • Cost Accountants
  • Business Analysts
  • Finance and Cost Analysts
  • CFO’s
  • Finance Managers
  • Business Bankers
  • Corporate Finance Analysts

Learning Objectives:

  • Go far beyond simply explaining Excel’s features and functions!
  • Learn how to apply these to get more done and produce reliable, consistent, maintainable, user-friendly results.
  • Gain knowledge and skills you can use in your work every day to transform your Excel work and make decisions with confidence.

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

There is no exam for this course.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Agenda:

Useful Techniques & Keyboard Shortcuts

  • Control key
  • Right click
  • The Ribbon & the Quick Access Toolbar
  • Options
  • Referring to Cells & Ranges

Range Names

  • Creating Range Names
  • Range Name Box
  • Creating Names Automatically
  • Defining Names

Useful Functions in Finance

  • COUNTIF
  • INDIRECT
  • AND, OR
  • ROUND
  • IF
  • VLOOKUP
  • AVERAGEIF
  • SUMIF/ SUMIFS
  • COUNTA
  • MAX & MIN
  • OTHER FUNCTIONS

Tables

  • Creating a Table
  • Table Functionality
  • Flexible (Dynamic) Ranges
  • Using INDIRECT with Tables

Pivot Tables and Pivot Charts

  • Creating a Pivot Table
  • Analysis with Pivot Tables
  • Pivot Charts

Conditional Formats

  • Preset Conditions
  • Formula Driven Formatting
  • Modifying Conditional Formats

Wrapping up with Ribbons

Related Courses

Excel VBA Training Course (3 days)

Excel Data Analysis in Finance (1 day)

Share with friends

Date and Time

Location

The Venue will be announced soon

Napier

Napier, North Island 4104

New Zealand

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved