Location

Community Services & Continuing Education - Cairo

Objectives

• You want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier. You want to learn how to setup and format different accounting tables and use advance functions to organize your data.We will start with basic functions and go on to more advance functions throughout the course. The functions and setups you will learn will prepare you for any accounting projec

Outcomes

How to enter numbers and formulas in ExcelPosting journal entriesPosting to the general ledgerBuild financial statementsIndex & matchPivot tablesCreate graphsBasic functions (sum, average, min, max)Data analysisBalance sheetIncome StatementStatement of cash flows

Course Contents

The basics of excel: how to input numbers, how to input formulas, and the different functions of ExcelHow to debit and credit journal entries in excelPosting to the general ledgerFunctions that will help you analyze your data at a deeperFormats that will make your spreadsheets look cleanVlookup, hlookup, index & match functionsSumifs & countifs functionsHow to build dynamic queriesHow to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)How to create debt schedules and pp&e schedulesForecasting revenuesHow to create pivot tables Flash fill functionsHow to create professional data tables