EXCEL FOR ACCOUNTANTS

Leave a Comment / Uncategorized / By
This online course will help you gain the core fundamental Excel skills that every accountant or financial professional should have. From logical tests and IF statements to Pivot tables and the new dynamic array functions. This course will teach you about key Excel features used by Accountants and financial professionals on a daily basis, giving you the skills and efficacy that are currently in high demand.
DATE : 1ST AND 2 ND APRIL, 2021
MODE OF DELIVERY : WHATSAPP AND ONLINE SELF PACED
COURSE MATERIALS : VIDEO AND ADUIO
COURSE FEE : N2,000
Payment Info
BANK: FCMB
ACCOUNT NAME: INVIN INTEGRATED SOLUTIONS LTD
ACCOUNT NUMB: 7537315017
Call 08068787631 for details
EXCEL FOR ACCOUNTANTS AND ACCOUNT MANAGERS COURSE OUTLINE
Module One
• Working with Functions
• Using the paste function tool
• Absolute and relative cell references
• Using range name in functions
• Using Nested functions
• Logical functions (SUMIF, COUNTIF)
Module Two
• Working with Data
• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tool
• Working with External Data
Module Three
• Writing formulas in cells
• Using the formula bar
• AutoSum and other basic functions
• Working with External Data
• Data consolidation
• Linking to another workbook
• Linking to an external database
• Getting data from the web
Module Four
• Collaboration tools
• Protecting a workbook
• Protecting worksheets and cells
• Adding comments to cells
• Sharing workbooks
• What-if Analysis
• Using the scenario manager
• Creating and editing scenarios
• Creating a scenario report
• Using Goal Seek
Join WhatsApp Class

Leave a Comment

Your email address will not be published. Required fields are marked *