CALL US NOW: Tel no. 0713 388 317/ 0757 749 641
RE: INVITATION FOR IN-HOUSE ADVANCED EXCEL TRAINING OPPORTUNITIES CONDUCTED BY STEP AHEAD FINANCIAL CONSULTANT
RE: INVITATION FOR IN-HOUSE ADVANCED EXCEL TRAINING OPPORTUNITIES CONDUCTED BY STEP AHEAD FINANCIAL CONSULTANT
Step Ahead Financial Consultant (SAFCo) is a globally registered Consultancy Firm providing Professional Services on areas of Trainings, Accounting & Auditing, Finances, Taxation and Treasury Management Consulting. It has over 5 years experience in conducting consultancy services to various organizations.
The firm has been fully registered by the National Board of Accountants and Auditors (NBAA) as a Consultancy Firm. It has also been registered as an Approved Learning Partner of the Association of Chartered Certified Accountants (ACCA) based in the United Kingdom-UK.
The firm is delighted to invite you to an in-house Advanced Excel training which will be tailored according to your needs at work-place.
ADVANCED MICROSOFT EXCEL TRAINING COURSE
ABOUT THIS TRAINING
This highly-practical, intensive, hands-on course is packed with cutting edge spreadsheet design ideas to take your staff’s model structuring skills to the highest level. By adopting a structured design strategy and utilizing best practice spreadsheet modeling standards and conventions, staffs can develop better robust and dynamic business models. No wonder this course is highly demanded globally! If you want your staffs to move with ease, speed and stay ahead of competition and increase productivity by saving time, then your staffs are highly encouraged to enroll for this course with SAFCo.
On attending this course, participants will be able to:
- Get an understanding of Advanced Excel formulas and Functions used in workplace
- Be able to prepare various management reports as quickly as possible using various techniques inbuilt in Excel program
- Be able to finish various tasks in a short period of time and save time.
- Understanding how to develop various business models for task simplification
- Understanding how to build interactive dashboards for professional presentation
- Be able to do Data analysis for Decision Making in Complex business scenarios
- Learning about Data Visualization and Summarization in Microsoft Excel, etc.
ADVANCED EXCEL TRAINING COURSE CONTENTS
- Relative, Mixed & Absolute referencing
- Freeze Panes; Inserting, Editing & Deleting Comments inside cells;
- Use of the Format Painter, and Creating Hyperlinks to jump from one sheet to another.
- SUBTOTAL, GROUPING & UNGROUPING AND CONSOLIDATION
- Text to Columns, LOWER, UPPER, PROPER, TEXT & CONCATENATE FUNCTION.
- Text functions—LEFT, MID, RIGHT, LEN, TRIM
- Removing Duplicates
- Embedding and linking documents into Excel, eg. Word, PowerPoint, PDF, etc.
- IF function & NESTED IF Functions
- Advanced Logical fx: IF AND, IF OR and AGING ANALYSIS REPORTS
- CONDITIONAL FORMATTING
- Vlookup, HLOOKUP, ROW, COLUMN.
- ADVANCED PIVOT TABLES AND DASHBOARDS.
- COUNT, COUNTA, COUNTIF, COUNT BLANK, COUNTIFS, SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF AVERAGEIFS.
- How to protect formulas or ranges of data using PASSWORDS
- INDEX; MATCH; CHOOSE; & OFFSET FUNCTIONS
- Loan Amortisation functions:- PMT; IMPT; & PPMT,
- Depreciation Functions:- SLN; DB;
- Capital Budgeting Functions:- NPV; IRR.
- Advanced Date and Time functions EOM,TEXT, MAX and MIN Functions
- Mastering DATA VALIDATION techniques
- What-IF Data Analysis tool for Decision Making.
The course is designed for financial officers, budget officers, middle and senior management, Accountants, Financial controllers, managers, Auditors, Tax Consultants, Administrators & directors/ Partners, Financial & Business Analysts, etc. Also business professionals who uses Excel regularly and anyone who needs to really get to grips with Excel.
COURSE DURATION AND MINIMUM NUMBER FOR IN-HOUSE TRAINING
The course above takes full five (5) working days to cover all important aspects of the course intensively. In order to carry out this in-house training, the minimum number of participants should be at least ten (10) participants.
TRAINING DATES
Our in-house training dates are flexible according to organization needs. We highly value our clients’ training schedules; therefore, it is the client organization that arranges about training start dates and venue and just informs us accordingly.
COURSE FEES
Step ahead is always committed to deliver high quality services at minimum cost affordable to all clients. Our in-house courses above are conducted at a price of TZS 300,000/= (VAT Exclusive) only per each participant for a whole one week training. The fee above does not include venue costs and lunch arrangements for participants. These are left with specific organization arrangement logistics.
MODES OF PAYMENT:
Payments can be made by direct bank transfer through one of our two bank accounts whose details are provided below; or else, Cheques can be written in the name of Step Ahead Financial Consultants and delivered to our office.
PAYMENT METHODS:-
BANK NAME: CRDB BANK
ACCOUNT NAME: STEP-AHEAD FINANCIAL CONSULTANT
ACCOUNT NUMBER: 015C448187900
BANK NAME: EQUITY BANK
ACCOUNT NAME: STEP-AHEAD FINANCIAL CONSULTANT
ACCOUNT NUMBER: 3009211372848
Other Courses offered by Step Ahead Financial Consultant on in-house basis
S/N | COURSE DESCRIPTION |
1 | Review of IFRS/IPSAS: Updates and Implications |
2 | Strategic Financial Management |
3 | Cash Flow and Working Capital Optimization |
4 | Advanced Financial Modeling & Dashboards |
5 | Finance and Accounting for Non Finance Managers/Directors |
6 | Practical IFRS/IPSAS for Preparation of Financial Statements |
7 | Preparation, Analyzing, Interpreting & Reporting on Financial Statements |
8 | Advanced Cash and Treasury Management |
9 | Micro – Finance Management |
10 | Financial Markets, Investment Analysis and Management |
11 | Advanced Cash Flow and Working Capital Management |
12 | Advanced Cash Management and Bank Accounts Reconciliation |
13 | Application of International Accounting Standards: IPSAS, IAS & IFRS |
14 | Internal Auditing and Report Writing for Internal Auditors |
15 | Effective Revenue Collection and Treasury Management |
16 | Advanced Budgeting Workshop |
17 | Financial Management and Disbursement for Donor Funded Projects |
18 | IPSAS (Accrual Basis ) – Immersion Workshop |
19 | IFRS – Immersion Workshop |
N.B
The Short Profile of the Key Training Instructor is attached at the end.
If you are also interested in one of our in-house training courses above, please contact us immediately for further arrangements using the following contact details provided below:
Step Ahead Financial Consultant, Uhindini Street, National Housing Mpwapwa Flats, Opposite Vision Fund offices, P.O. Box 2796, Dodoma, Tanzania.
Email address: info@safco.co.tz
Tel no. 0713 388 317/ 0757 749 641
Yours sincerely
YUSTINO NYENDEZA
MANAGING DIRECTOR
SHORT PROFILE OF THE KEY TRAINING INSTRUCTOR
Yustino is a Fellow Chartered Certified Accountant (FCCA) fully registered with the Association of Chartered Certified Accountants (ACCA) and an Associate Certified Public Accountant (ACPA) fully registered with the National Board of Accountants and Auditors (NBAA). He also holds a MSc. Degree in Finance and Investment from the Institute of Finance Management-IFM. His Bachelor Degree majored in Accounting and Finance from Mzumbe University. He is a Founder and Managing Director of Step Ahead Financial Consultant, a professional consulting firm based in Dodoma, Tanzania.Yustino has more than five years experience in Financial Modeling training, model design and development and business consultancy. He has vast experience in the application and development of Financial Models in Microsoft Excel. He has high creative capability of planning, designing and building treasury, accounting and auditing systems, specifically on generation of useful management reports as well as preparation of annual financial statements models. Generally, he is a Financial Modeler and Interactive Dashboard designer. His journey in learning Microsoft Excel started in early 2011 when he was still working as an External Auditor at PwC.
He is an experienced External Auditor worked with one of the “Big Four” Audit firms-PwC; he audited various multinational corporations as well as National organizations. He has multi-industry knowledge and experience from various audits undertaken by then. He has also an extensive Experience in Treasury Management affairs with more than seven (7) years in that field.
He has presented and facilitated many workshops for various professions chief among them are accounting professional bodies such as ACCA and NBAA. He is an experienced Trainer with more than Five (5) years in conducting various Trainings to extensive number of Professionals and Various Organizations mainly in the areas of Advanced Microsoft Excel training, International Financial Reporting Standards (IFRS), International Public Sector Accounting Standards (IPSAS) as well as Advanced Treasury Management strategies.
Tel no. 0713 388 317/ 0757 749 641
