Excel for Finance Course

Description

Our Excel for Finance Course for beginners is provided by a Microsoft Certified Academy in London. It has been developed through a collaboration with their state-of-the-art, interactive training system and our trainer’s financial expertise.

Excel Course Objective

Gain a strong skill base to an advanced level in using Microsoft Excel in a Financial Career. This is a vital part of Finance, Bookkeeping, and Accounting careers.

Excel for Finance Course

This is an online Excel course. Our Excel Courses are delivered using a Virtual Tutor function inside the program. The training system uses a state-of-the-art live server. The system instructs you, provides exercises and corrects you.

Course Content

The Excel for Finance Course includes:

• Pivot Tables and Pivot Charts
• Creating and working with Business Charts to explain your data
• Sparklines and creating more advanced charts
• Working with multiple views, worksheets and freeze panes
• Formulas, absolute references
• Formats and Tables
• Conditional formats
• Advanced Functions: Lookup functions, Array Formulas, Date Calculation, Time Calculations, Nested Functions, IF statements, Financial Functions, SUMIFS and much more.
• Data Sort and Filters
• Solver, Goal Seeks, Scenarios, Detecting errors, audit of your spreadsheet and Templates
• Introduction to Macros

Dates and Duration

This training course is entirely flexible and can be commenced at any time. You can study when you like and have access to the learning system for 12 months. The average learning time is 22 hours, but this can vary depending on your prior aptitude.

Course Requirements

This course starts at the beginner level, so there are no requirements. It goes to the expert level.

Benefits

• The course is interactive and delivered using a state-of-the-art training system by Microsoft Learning Partners.
• Learning content has been selected by experienced professionals
• CPD Accredited Certification in Excel for Finance Course on successful completion