📩 For booking and inquiries, please contact us via Haraj messages and we will respond immediately. 📩 For booking and inquiries, please contact us via Haraj messages and we will respond immediately. Or via WhatsApp 00201019340490 Advanced Excel First Lecture  Excel basics from the program interface (Workbook & Sheet)  Basic formulas (SUM-AVERAGE-MAX-MIN-COUNT-COUNTA-COUNTBLANK-LARGE-SMALL)  Learn the IF, RANK formulas with a practical example  Using the previous formulas in a real-world example to analyze data with these formulas  Learn some program skills (Filter-Search-Charts)  Using cell formatting and its shortcuts  Create a dropdown list using (Data Validation)  Save the Excel file in more than one way  Printing 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 practical example  Learn many Excel shortcuts Third Lecture  Create an example of data analysis using Pivot Table  Learn the SUBTOTAL formula and its use in a practical example  Create an example from Human Resources management to record employee attendance and absence days automatically using COUNTIF with CONDITIONAL FORMATTING  Create a practical example of a daily 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 understand 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 📩 For booking and inquiries, please contact us via Haraj messages and we will respond immediately. 📩 For booking and inquiries, please contact us via Haraj messages and we will respond immediately. Or via WhatsApp