For those who need In House advanced Microsoft excel

chikuyu · 2019-12-16T21:16:09+00:00

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 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. Below are the key contents that will be covered in this intensive one week training. However, more contents can be modified according to staffs’ requirements depending on what each staff does on daily basis to make it more users tailored. 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. WHO SHOULD ATTEND? 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

Thread starter chikuyu
Start date Dec 17, 2019
Tags

who

chikuyu

JamiiForums uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn more…

Back

Top Bottom

Forums

New posts

For those who need In House advanced Microsoft excel

chikuyu

JF-Expert Member

Our Community

Regional Communities