Location

Community Services & Continuing Education - Alexandria

Objectives

• • Use excel in sales applications• Use excel in payroll applications• The stock movement (incoming - outgoing - Balance)• Accounting cycle using excel

Outcomes

Upon successful completion students should be able to:• use a range of lookup and reference functions • modify Microsoft Excel options • customize the formatting of charts in Microsoft Excel • create and use labels and names in a workbook • protect data in worksheets and workbooks • create summaries in your spreadsheets using subtotals • use data linking to create more efficient workbooks • use the Data Consolidation feature to combine data from several workbooks into one • understand and create simple PivotTable reports • construct and operate PivotTables using some of the more advanced techniques • create and edit a PivotChart • use goal seeking to determine the values required to reach a desired result • group cells and use outlines to manipulate the worksheet • use Solver to solve more complex and intricate problems • create recorded macros in Microsoft Excel • use the macro recorder to create a variety of macros

Course Contents

 Logical Functions  Text Functions  Date And Time Functions  Mathematical Functions  Basic Financial Functions  Database Functions  Lookup Functions  Conditional Formatting With Formulas PivotTable Data Validation  Remove Duplicates What – If – Analysis Solver User Form Module Macro Form Controls Spell Numbers  American Journal General Journal General Ledger Trial Balance Income Statement And Balance sheet Cash Flow Financial Statement analysis