Hassan
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    FavouritesAdd to Wish List
    from18.35USD/ h

    EXCEL complete training: Beginner, Intermediate and Advanced

    Translated using Google Translate. Click to view original.
    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.

    Extra information

    Translated using Google Translate. Click to view original.
    Do the training at home as if you are in a fully equipped training room.
    I bring with me: my Datashow, My Practical Work, my PC ..

    Location

    At student's location: Around Casablanca, Morocco

    |
    Use ⊞+wheel to zoom!
    +

    General info

    Skills:

    Age:

    Teenagers (13-17 years old)
    Adults (18-64 years old)
    Seniors (65+ years old)

    Student level:

    Beginner
    Intermediate
    Advanced

    Duration:

    120 minutes

    The class is taught in:

    French, Arabic, English

    About Me

    Translated using Google Translate. Click to view original.
    Consultant Trainer with several Years of experience and MOS EXCEL, GOOGLE DIGITAL ACTIVE and FACEBOOK BLUEPRINT certified.
    I teach in:
    EXCEL any level
    Digital Marketing
    Facebook Ads
    GOOGLE Ads
    SEO and SEA natural referencing
    Marketing and Commercial Action
    Also courses in Office Automation.

    Education

    Translated using Google Translate. Click to view original.
    Master in Digital Marketing at ESITH
    Bachelor in Business Management at UNIVERSITY
    Bachelor of Life and Earth Sciences.

    Master in Digital Marketing at ESITH
    Bachelor in Business Management at UNIVERSITY
    Bachelor of Life and Earth Sciences.

    Experience / Qualifications

    Translated using Google Translate. Click to view original.
    5 years in DIGITAL domain as DIGITAL MANAGER
    7 years as a Training Manager.
    Currently GENERAL MANAGER
    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.
    "E-COMMERCE & WORDPRESS" TRAINING CYCLE You are full of imagination and you like to make neat and original presentations, this computer graphics training organized by the EMMGI Center, the LEADER SPECIALIST in professional training, continuous training and modular training, you will be perfectly suited. You will be able to juggle shapes, colors, photos, typography and illustrations, in addition to developing your creativity and speed of execution. In short, you will learn how to use the persuasive power of the image under Adobe suite software (Illustrator and Photoshop). TRAINING AIMS Know how to install and configure WordPress, Master administration interfaces (backoffice), Know how to create turnkey graphic themes, Discover the advanced concepts in website creation, Create a Complete E-Commerce Site ... TRAINING CONTENT Introduction to the Web and E-Commerce. WordPress Cases: Presentation. WordPress installation and configuration. Choice, installation and customization of theme. His first article and notion of category. Creation of the very first WordPress Page. Management of Navigation menus. Installation and integration of extensions and plugins. Make better use of the power of widgets. Final Project Website from A to Z. Backup and update of its website. Migrate and host your Wordpress website. TRAINERS Consultant Trainer Web Project Manager Having more than 8 Years of experience, DELIVERABLES WordPress software Full course material, Pdf format, More than 20 practical cases, Complete Web Project Training certificate.

    Ask a question

    Send a message explaining your needs and Hassan will reply soon:
    The more detail, the better.
    Ex. "Hi, when are you available to meet for a lesson?"

    Availability of a typical week

    MonTueWedThuFriSatSun
    7              
    8              
    9  Monday at 9:00    Wednesday at 9:00    Friday at 9:00    
    10  Monday at 10:00    Wednesday at 10:00    Friday at 10:00    
    11  Monday at 11:00    Wednesday at 11:00    Friday at 11:00    
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00    
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00    
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00      
    15    Tuesday at 15:00    Thursday at 15:00      
    16    Tuesday at 16:00    Thursday at 16:00      
    17    Tuesday at 17:00    Thursday at 17:00      
    18    Tuesday at 18:00    Thursday at 18:00      
    19  Monday at 19:00    Wednesday at 19:00    Friday at 19:00    
    20  Monday at 20:00    Wednesday at 20:00    Friday at 20:00    
    21  Monday at 21:00    Wednesday at 21:00    Friday at 21:00    
    22              
    23              
    from $18.35At student's home

    Good-fit Instructor Guarantee


    If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

    Online reputation

    • Instructor since August 2019
    • Google connected
    • Linkedin connected

    Availability of a typical week

    MonTueWedThuFriSatSun
    7              
    8              
    9  Monday at 9:00    Wednesday at 9:00    Friday at 9:00    
    10  Monday at 10:00    Wednesday at 10:00    Friday at 10:00    
    11  Monday at 11:00    Wednesday at 11:00    Friday at 11:00    
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00    
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00    
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00      
    15    Tuesday at 15:00    Thursday at 15:00      
    16    Tuesday at 16:00    Thursday at 16:00      
    17    Tuesday at 17:00    Thursday at 17:00      
    18    Tuesday at 18:00    Thursday at 18:00      
    19  Monday at 19:00    Wednesday at 19:00    Friday at 19:00    
    20  Monday at 20:00    Wednesday at 20:00    Friday at 20:00    
    21  Monday at 21:00    Wednesday at 21:00    Friday at 21:00    
    22              
    23              
    from $18.35At student's home

    Good-fit Instructor Guarantee


    If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

    Share


    Youness
    Online Power Point course for all levels: distance
    Hello, I am a computer teacher and I give online office automation courses and especially Microsoft power point. You will learn how you can create presentations according to your needs. You will also learn how to animate your projects and presentations, etc ..... For more information, contact me. You can contact me through the contact form via Apprentus. I'm waiting for you !!!

    Pavan
    VBA (Excel, Word, Outlook) training with Practical Sessions
    VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results. Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc... Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.

    Muhammad
    Learn Micosoft Excel, VBA, Word, Powerpoint. Lectures can be delivered online (e.g. Skype)
    I am specialized in accounting and finance. I am currently completing my PhD degree in the field of Finance from University Clermont Auvergne, France. I also have two master's degree in Business Administration (MBA) and Accounting and Finance. Furthermore, I have a two years experience in Audit in a bank. My goal is to keep students challenged, but not overwhelmed. I assign homework after lesson and provide periodic progress reports. Please note that I will teach in English.

    Suranjit
    English Language, Grammar, TOEFL, IELTS, GRE and computer program with Basic Excel, power point
    Specialized in English Language, Grammar and Computer and teaching for 15 years Experienced as English Teacher for all classes of students and TOEFL, IELTS GRE etc. specialized for University Admission Test Learn with pleasure and new technique that i have invented and one can easily learn reading, writing, speaking, listening English. I like to prefer computer application program, just try one class and feel.

    Boris
    Microsoft Excel, Finance, Investments, Economics, Math
    Lessons from an experienced tutor (8 years of tutoring privately and in groups). I have a B.Sc. and an MBA, specializing in Finance and international Business. If you are a student, a professional or just building up your business, then Excel is a MUST tool for you. I can also help you with financial planning, investment portfolios, sensitivity and feasibility analysis for your projects, and much more. Tutoring is either online (Zoom/Skype) or at my place.

    Amina
    Microsoft Excel Course, Pivot Tables, V & H Research. Office, outlook.
    Here are the courses that I propose for individual or professional: Setting up formulas (VLOOKUP, VLOOKUP etc.) Microsoft Excel, in French or in English. Very suitable for monthly reports and accounting. I can create dynamic, pre-fillable and customized Excel spreadsheets for your type of business.

    John
    Excel functions for both the classroom and business
    The class involves my demonstrating how to execute many Excel special functions. Such as linking information from one spreadsheet tab to another tab; creating V-Look ups, H-Look ups, Pivot Tables, Pivot Charts, Nested If's, Sumif's, "If/Then", “If/And” scenarios among many others. Included in the lesson is an interactive spreadsheet which contains actual working formulas with step-by-step instructions for easy implementation. You will see working, functioning examples of all the Excel functions I teach & explain during the lecture. Excel is one of my specialties. As an experienced CPA who has had both individual and corporate clients, I have constructed both simple to very complex spreadsheets – plus I was always ready to explain how they functioned to my employer, my co-workers, my tax clients, and even auditors!

    Syed Abdul
    Tutoring (Math, CAD, Excel, Primavera), Experience Pakistani and Indian foods
    I have an experience in teaching maths and other subjects for about 10 years. I have professional experience of 5 years also in Production Manufacturing and Project Management sector. I know how to cook Indian and Pakistani dishes. I can give you a company also.

    Felipe
    Marketing, Projects,
    In my classes you will learn all about marketing strategy, controlling projects and advanced excell

    Matías
    Microsoft Office Suite (Word, Excel, Access, Powerpoint)
    Office, in particular Excel and Access, are programs widely used both in industry and in the personal field. It is worth learning. I am used to working with people of different ages. I believe in segmentation, visualization of progress, objective results and practice. Beyond these general lines, there is no rule or magic method. Some things work with some students and not with others. Adapting to needs is really the goal of private lessons. So I will do my best to find what motivates and helps my student.

    Yves
    Excel avancé (+VBA) pour professionnels ou en Masters MBA
    Vous utilisez régulièrement Excel dans votre job et avez un projet que vous voulez développer; vous êtes à la recherche d'un nouvel emploi et nécessitez un approfondissement de vos connaissances en Excel; vous êtes en stage de formation type MBA et avez besoin d'aide dans les matières de mathématiques, statistiques ou analyse de données. Consultant en entreprise, je donne des cours individuels via webcam (Zoom) pour tous niveaux (débutant, intermédiaire, avancé, et programmation VBA) sur les versions Excel 2010, 2013, 2016, 2019, Office 365 en version anglaise ou française. De formation ingénieur génie chimique (ESCOM), je suis spécialisé dans l'industrie de Supply Chain, et peux vous aider quelque soit votre fonction actuelle. Contactez-moi pour programmer votre entretien personnalisé et définir ensemble un programme de formation adéquate. A bientôt

    Jerome
    Doctor in Cognitive Psychology helps you prepare for your oral defense.
    Oral defense in the sciences of education, especially in psychology, or in life sciences, particularly in biology requires some mastery of the slide editing tool (Microsoft Powerpoint or other), the taking of public speaking, as well as a fluid and dense speech to facilitate the understanding of your research. The main purpose of powerpoint support is to illustrate your subject as clearly and structurally as possible. It is important to master certain methodological aspects so that you can enhance your subject in the time allotted and be able to present your subject in a synthetic way. hierarchical according to the relevance of the information to be selected. In addition to your presentation, you will have to answer the questions of the jury, both formally and substantively (answer argued in a precise but concise manner). As part of my courses (which I have been providing since 2003), I therefore place the emphasis on a quick and effective methodological approach to enable you to obtain an original powerpoint, clear, structured in a logical and rewarding way. From a pedagogical point of view, the sessions are relatively interactive with the student to enable him to better appropriate his research. Finally I train each student to answer the potential questions of the members of the jury, both on the form of the answers and on the arguments used to convince the jury. Teacher and trainer at the Universities of Strasbourg and Paris 8, ESSEC Business School, ISTH, IONIS Education Group, EEEA, Acadomia etc. Possibility to record the session if necessary for the student, interactive course and generally very rich in remarks and methodological advice advised and appropriate

    Stephan
    Office applications for seniors such as word processing and spreadsheets!
    Especially for seniors I teach the office applications WORD, EXCEL and POWER POINT (as an ECDL advanced trainer experience in adult education) other computer applications can also be addressed as - Outlook - Internet and research - Telephoning over the Internet - Etc.

    Professeur
    Microsoft Excel course for all levels via distance learning
    Thanks to these Excel video training courses, you will learn to use spreadsheets, formulas and graphs. You master the tips and tricks that save time and become more productive. Create dashboards, create a complete business plan, edit your invoices, calculate your costs, manage your stocks. All these tasks are possible with Excel! Discover all the possibilities of Microsoft's spreadsheet. You progress and become adept at TDC (Dynamic Cross Tables), IS functions and other advanced techniques. Excel is also a powerful chart editor. You learn to do them dynamically so that they illustrate your numbers in clear and precise ways. These Excel trainings will help you choose the right form of graph to respect semiology and to best interpret your results. Excel also allows import and export in many data formats, from a simple text or .csv document to the Access database. You also work on new functions, in particular by developing macro in VBA. So you customize Excel to your specific needs. Our trainers are Microsoft MVP certified or have a very rich experience in the professional application of these tools. In these latest versions, Excel offers a large space for working in the cloud: online storage management, document sharing, online editing; a set of working methods that facilitate collaboration and productivity. Take advantage of Excel video training to get started with the most popular spreadsheet in the world!

    Dr S Iyer
    Highly experienced tutor : One-on-one online tutoring in Financial modeling with Microsoft Excel, Financial applications in Python
    I am Dr S Iyer- a tutor with over 16 years of teaching experience as of 2020 and students from across the globe. I teach one-on-one online (over Skype/ Google Hangout and other media) using a pen tablet and the screen-share feature. I teach from Bachelor's level to Masters level and professional certifications. I have helped several students from various parts of the world do remarkably well in several subjects like Financial modelling, Corporate Finance, Investments, Accounting, Microeconomics, CFA, FRM. But more than that, I trust that if I can replace fear of a subject with love for it, then I would have truly made a difference to the student.