Advanced Excel Training for Financial Analysts - The Expert
This training is suitable for the graduate looking for a job in large corporations and banks in the field of Financial, Accounting, Business and Data Analysts and those who want to grow in this field. We share with you our industry-specific experience and office environment.
The training is provided by an expert who has worked for large Corporations and Banks in the Senior Executive Position. The training is delivered on an ONE 2 ONE basis. We also provide training to Corporation staff at their premises.
The Advance Excel training covers the following in Detail:
1st SESSION - Introduction to Excel Ribbon - Insert Row, Column, copy/mover worksheet, - Merge cell, wrap text, find & replace, insert comments - Grouping - Transpose - Text to Columns - Concatenate, Ampersand, Trim - Left, Right, Mid Functions - Sort, Filter, Advanced Filter - Unique Value - Sub-total, Copy visible Cell only - Absolute and Relative $ signs - Name Range and Table - Direct and Indirect Data Validation and Dynamic
2nd SESSION - Sum-product function - Count-IF and Count-IFS functions - Sum-IF and Sum-IFS functions - Average, Average-IF and Average IFS Functions - If functions - IF(AND) Function - IF(OR) Function - IF Nested Function
3rd SESSION - Vlook-up Exact Match - Vlook-up Approximate Match - If error and Vlook-up - Vlook-up with data validation, name range, LRM - Nested Vlookup - Vlookup with the column reference
4th SESSION - Pivot Functions and Ribbons - Pivot with Name Range - Pivot with Table - Pivot with formula field and items - Pivot reconciliation - Pivot from Multiple Sheets or Files - Consolidated sheets
5th SESSION - Linke and Edit Link - Macros Absolute and relative - Conditional Formatting - Date and Time Functions - Print and Layout options
6th SESSION - Goal Seeking - Scenarios - Chart simple and dynamic - File, Cell and Formula Protection' - Formula Auditing
Projects - Projects Assignment on preparing reports for Management from raw data
In addition, we also provide Practical Training in the following Area 1) Mastering Basic Accounting 2) Quickbooks Practical Training -both Online and Desktop 2017 versions 3) Practical Bookkeeping and Filing Returns for Business Corporations
Should you need additional information, please feel free to contact me at Ph 647-622-3233 or pacemgroup.com