Advanced Excel First Lecture  Excel basics from the program interface (workbook & sheet)  Basic formulas ((sum-Average-Max-Min-count-count a-count blank-large-small)  Learn the IF, RANK formulas with a practical example  Using the previous formulas in a real-world example to analyze data with those formulas  Learn some program skills (Filter-Search-Charts)  Using cell formatting and its shortcuts  Create a drop-down list using (data validation)  Save the Excel file in more than one way  Print from the program Second Lecture  Using conditional formatting  Create a practical example on conditional formatting  Learn and use IF, COUNTIF, SUMIF formulas in data analysis  Learn and use the following formulas (TRIM-LEN-SUBSTITUTE-RIGHT-LEFT)  Learn the VLOOKUP formula and use it in a real-world example  Learn many Excel shortcuts Third Lecture  Create an example of data analysis using pivot tables  Learn the SUBTOTAL formula and its use in a practical example  Create an example from Human Resources Management to automatically record employee attendance and absence days using COUNTIF with conditional formatting  Create a practical example of a general journal  Create links to connect more than one worksheet or Excel file to each other Odoo ERP First Lecture  Definition of financial accounting and understanding the accounting equation  Journal entries and understanding the nature of each party  Display all recognized financial statements (Balance Sheet – Income Statement – Trial Balance)  Definition of ERP  How to register and log in to Odoo  How to create a database from scratch  Download important applications in (Purchases – Sales – Warehouses – Accounts)  What is the chart of accounts and how to set it up Second Lecture  How to set up journals  How to set up product categories  How to set up products and their types  How to add a new warehouse and a new location in the warehouse module  How to create and add a customer and a supplier  How to create a purchase order and a sales order, and how to receive and dispatch from warehouses for this order, fully or partially  How to create an invoice and its impact on accounts  How to make partial or full payment of the created invoice and its impact on accounts Third Lecture  How to create a price list for customers  Definition of advances and how to settle them on the program  Explanation of prepaid expenses and accrued income and how to handle them on the program  Explanation of assets and their depreciation and how to handle them on the program  Create a service and commercial project and discuss them Please contact WhatsApp at the number: 00201019340490