Location

Community Services & Continuing Education - Alexandria

Objectives

• • Understanding advanced concepts of Microsoft Excel for accounting calculation and analysis applications.

Outcomes

• Creating Accounting cycle using excel• Posting Real Time• Quick reports • Using excel in Registration All transactions• Using excel in Journal• Using excel To Posting transactions• Understanding Net profit or losses calculation

Course Contents

• Microsoft Excel Interface• Selecting• Interning data in Cells• Editing and deleting data from cells• Formatting cells• Adding Comments• Data Types• Cell referencing• Printing• Data Validation Drop list • IF functions To calculate Profit and Losses • IF using OR & AND To calculate General Ledger• Logical function• Sumif Function To Make American Journal • SumifS To calculate General Journal • T Account with if• Trial Balance With Index & Match• Balance Sheet – Income Statement