Excel for Finance

Home / Excel for finance

Excel for Finance Overview

Excel for Finance Professionals Training Program

Excel is so intuitive that professionals can start using it with little or no training, but its real value comes when one gets professional training. Training facilitates the participants to learn the latest trends and teaches you the right ways for solving their day to day problems in a fast and accurate manner. Excel for Finance Professionals course is designed for the users with intermediate level skill in using Excel, and who want to enhance their skills to the next level, so they can get the best output of their time. Apart from quick tips & tricks, advanced formulas & functions, macros and using Excel for creating/maintaining Financial Workbooks, this course further imparts skill and knowledge to the participants on creating slick dashboards with accurate data representation using Excel. Microsoft Excel.

Course Details

CMA Part 1

Friday 22 October, 2021

Run This Course
In-House

Enjoy this certified
program at your premise of choice, with lower costs, and schedule that suits you best.

FULLY CUSTOMIZED
ACCORDING TO YOUR NEEDS!

Training Outline

This training will enable participants to understand the best ways of using Microsoft Excel. Following are the key learning outcomes of this session:

Learn Core Excel Functions & Features
PivotTables & Slicer
Charts & Sparkline
Creating Dashboards
Understand & Create Macros
Analyzing Financial Statements an Excel Perspective

Financial Worksheetâ€™s Arithmetic
Learn 13 Core Functions
Working with Multiple Worksheet / Workbooks
Time Value of Money
Amortization Table
Analyzing Data Using PivotTables
Dynamic Sensitivity Analysis

Trainer Profile

Mr. Mirza Farrukh Baig, FCA
Harvard Trained | CEO Lynchpin Group |
Lead VAT Trainer & Consultant

Mirza Farrukh Baig-Harvard Trained, is one of our Decorated & Talented Trainer and Instructional Designer for Finance, Accounting, Risk Management training courses at Lynchpin Training. With him on the training venue, we guarantee the best style of delivery, team engagement, the energy level of the class and the WOW experience by your team is assured.

Mirza Farrukh Baig is a qualified Chartered Accountant and a career banker. He has over fifteen years of experience teaching CMA, ACCA, CFA and CA students. He is also the lead corporate trainer at Lynchpin delivering specialized training on Finance and Accounting He has served for eight years in a leading commercial bank in UAE where he was instrumental in strengthening the SME credit risk unit. Apart from approval of banking facilities for SME clients. He played an instrumental role in developing and implementing the SME credit risk policy of the bank.

Currently, he is the CEO of Lynchpin Training & Consulting and Chief Consultant for VAT
Advisory, Consulting & Implementation. Farrukh carries extensive experience in dealing
indirect taxes both for the UK and South Asia. Provided VAT (Value Added Tax) consultancy
services with due care, experience, resources, and exposure to tax regimes.

Farrukh is an associate member of the Institute of Chartered Accountant of Pakistan (ICAP).
He has been awarded a gold medal for outstanding performance in his CA final examination,
by ICAP. He also went to Harvard Business School to Executive Entrepreneurship training
program.

What our Clients have to say

I am implementing my real work in the training as it applies fully to what I do and it came to me at the right time, strategising now for my work based on the learnings from training

Excellent experience with Lynchpin and this session I will never forget. Their Trainer is very knowledgeable and has lots of examples from his experience. Keep up the good work lynchpin team !

Training was with live examples and case studies, Trainer has delivered the training with passion and sincerity. Both Venue and Training were Good.

Lynchpin workshop was great learning with my current tasks at work, which was taking me long time before the training.

Fun learning and I am implementing my real work in the training as it applies fully to what I do and it came to me at the right time, strategising now for my work based on the learnings from training

Lynchpin’s session was informative and required for business heads. Trainer went to the required level of audience to make them understand the concept. (Head of Corporate Planning, Eurostar) Everything was well organized,Lynchpin is very respectable Training Company –

Trainer is very knowledgeable and patient and passionate with training. He make sure the trainees have fun ensuring they have learning as well. I have been with Lynchpin for CMA and now this and for both i felt well taken care of.”

Very Persuasive approach by Lynchpin , very accurate and worth for whole day listening to the trainer. The group work in inhouse program is worth attending.Excel is never delivered like this before.

Lynchpin trainer is brilliant and have excellent delivery skills – a new way to learn Finance for Non-Finance.

Excel for Finance