Advanced Excel Training for Financial Analysts - The Expert

Posted over a month ago
L5B, Canada(View Map)

Description

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

19 visits
About the Poster
Sign in or register to see this poster's details, including:
  • When they joined Kijiji
  • How quickly they respond
  • Other ads they have posted
  • Phone number (if available)

Contact Poster

Kijiji filters and masks emails for security reasons. By clicking on "Send Email", you consent to this action in accordance with our Terms of Use and Privacy Policy.

Take steps to make your Kijiji transactions as secure as possible by following our suggested safety tips.Read our Safety Tips

My Favourites ()

Recently Added: