Location

Community Services & Continuing Education - Cairo

Objectives

• Familiarity with the use of Excel as a tool for quick and easy analysis and understanding of products derived from raw databases. Excel can analyze local data, imported and even linked data.

Outcomes

Familiarity with scheduled databases - How to create a valid table in Excel and allowed and blocked rules in a table.Sorting and sorting in non-alphanumeric levels according to a pre-sorted sort list.Filter - Auto Filter and Advanced FilterRemove duplicates - find duplicate records (new in version 2019)Subtotals - how to implement summary, counting, average with a known key.Pivot tables: PIVOT TABLES cut and analyze data according to the number of axesGroup data - by date, number, or individual settingsCharts - based on a pivot tableVlookup function - to find information in databases.Financial jobs - recognition and action rules

Course Contents

- Part I:-- ADVANCED DATA• Logical Functions (simple if, Nested If, if error)• Statistic al Functions ( Sumif, Countif, averageif, sumifs, count ifs, average ifs)• Look functions (Vlookup, Hlookup, Index, Match )• Math & Trig functions ( Subtotal ,Aggregate)• Text Functions & concatenate)• Date & Time Calculations (day,month, year ,text, date, mod, today,now)- Part II:-- ADVANCED FORMAT TOOLS• Conditional Formatting• Advanced Trick of conditional Formatting• Linking to off ice documents from workbook• Creating Advanced Chart and Sparkline's- Part Ill :-- Operational Tools• Data Validation to do drop down list• Record Macro• Protect workbook and worksheet with Password• Consolidate• Text to column• Range, Define Name and name manager,Table- Part IV :-- ANALYSIS TOOLS• Conditional Formatting• Using Data Validation to create drop-down list• Filtering and sorting in table with Slicers• Finding and correcting error• Using watch window tool ,.- Part V :--