Learn to create Websites from A to Z, HTML, CSS or WordPress (or choice)

Do you want well-managed and oriented courses? Do you want to prepare your job interview for access to higher schools as well as for immigration to usa and canada? do you want to prepare your english exams? do you want your training not to be a waste of time? it's possible ! Pticonseil Center announces the opening of registrations for general English, business English, communication, preparation for the English exams for the 2020 national bac, school program, private public mission. For more information, do not hesitate to contact us

We are organizing a Practical Training Seminar in Moroccan Taxation, in order to control your taxes within the framework of the 2019 finance law. ~~~~~~~~~~~~~~~~~~~~~~ TRAINING CONTENT : ___________________________ ▶ ️ 1st part: VAT- Value added tax ▶ ️ ♦ ️ ♦ ️ Taxable persons, activities and property. ♦ ️ ♦ ️ Exemptions and reductions. ♦ ️ ♦ ️ Partial deductions: Prorata de vat. ♦ ️ ♦ ️ The rule of base (generating event and taxable base of deductions. ♦ ️ ♦ ️ Practical case of VAT declaration ♦ ️ ♦ ️ Tele declarations in EFI and EDI mode of VAT… ▶ ️ 2nd part: IS- Corporate tax ▶ ️ ♦ ️ ♦ ️ Taxable persons, Excluded persons and Exempt persons total or partial or provisional. ♦ ️ ♦ ️ Assessment of charges and income. ♦ ️ ♦ ️ Practical case of calculating the IS and deposit. ♦ ️ ♦ ️ Regularization of balance to be paid and excess. ♦ ️ ♦ ️ IS Accounting and Down Payment ♦ ️ ♦ ️ Tele declaration of tax result and tele payment of payments ... ▶ ️ 3rd part: TP: Professional tax ▶ ️ ♦ ️ ♦ ️ The rental value. ♦ ️ ♦ ️ Taxable capital elements. ♦ ️ ♦ ️ The annexes to the relevant tax package. ♦ ️ ♦ ️ Declaration of taxable items… TRAINING AIMS : ____________________________ The purpose of this training cycle is to enable beneficiaries to master the tax aspect encountered in practice in corporate tax matters; value added tax and business tax. This training is consolidated with practical cases and exposed in computer mode while being based on the tele declaration and tele payment implemented by the general direction of the taxes. For more information, do not hesitate to contact us.

Formation's goal : - Master and combine the most advanced features of Excel, - Discover new tools and new very useful functions, - Prepare, organize and control the data to facilitate analysis, - Exploit the potential of Excel to automate and make calculations more reliable, - Master the creation of advanced calculation formulas, - Use data lists with management and summary tools, - Prepare dashboards via PivotTables… The training will be enhanced with examples and practical case studies… Training content : ➢ General and Reminder on Level 1: Excel introduction, ➢ Simple functions then advanced functions, ➢ Calculation audits and advanced graphics, ➢ Excel databases and Management of large workbooks, ➢ PivotTables and PivotCharts, ➢ Hypertext Excel links, ➢ Sort / Filter and Advanced Filter options (Advanced), ➢ The validation rules and Conditional formatting, ➢ Import, export or link data… Training program: Reminder on Level 1: Excel introduction: • Discover the Excel Ribbon, • Name cells, ranges and tables, • The options to hide, display, insert and delete, • Concept of workbook and Excel sheet management, • Insertion of comments. Using time-saving tools • Create custom formats. • Define conditional formatting rules. • Facilitate and control data entry with data validation. Build simple and elaborate calculation formulas • Master the copying of formulas: relative and absolute references, • Make calculations more reliable: name cells or ranges of cells, • Set up simple, complex, nested conditions: IF, OR, AND, • Calculate statistics: NBVAL, NB, NB.SI, NB.VIDE,… • Relate data with the VLOOKUP function. • Calculate dates and times: MOIS.DECALER, FIN.MOIS… • Manipulate text: LEFT, RIGHT, STXT, NBCAR,… • Protect the sheet or filing cabinet. Using a data list • Put the data in tabular form. • Apply multi-criteria and custom sorts. • Query, extract data with automatic filters. • Filter one or more tables with segments. • Remove duplicates. Illustrate your data with graphs • Generate a graph from a data table, • Modify the type: histogram, curve, sector, • Add labels, • Adjust the source data. Lists / Sorts and filters • Create a list, • Use the lists with a data grid, • Sort the data in a grid (Sort orders, sort by columns), • Sorting and Filtering, • Personalized sorting, • Group the data in a list, • Display the subtotals of a column, of several columns, • Filter the data. Validation rules and Conditional formatting: • On drop-down lists • On numbers (integer, decimal) • On dates, • Conditional formatting. Set up pivot tables • Set up pivot tables in 1, 2 or 3 dimensions. • Group information by period, by tranche. • Filter, sort, hide data. • Add ratios, percentages. • Insert a cross graph.