This holiday Season, give the gift of a life-changing experience!
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from20.66EUR/ 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

Reviews (1)

good and professional teacher I loved the way of teaching

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

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3  Monday at 3:00    Wednesday at 3:00    Friday at 3:00    
4  Monday at 4:00    Wednesday at 4:00    Friday at 4:00    
5  Monday at 5:00    Wednesday at 5:00    Friday at 5:00    
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00    
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00    
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00      
9    Tuesday at 9:00    Thursday at 9:00      
10    Tuesday at 10:00    Thursday at 10:00      
11    Tuesday at 11:00    Thursday at 11:00      
12    Tuesday at 12:00    Thursday at 12:00      
13  Monday at 13:00    Wednesday at 13:00    Friday at 13:00    
14  Monday at 14:00    Wednesday at 14:00    Friday at 14:00    
15  Monday at 15:00    Wednesday at 15:00    Friday at 15:00    
16              
17              
18              
19              
20              
21              
22              
23              
from 20.66€At 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
  • Phone number verified
  • Google connected
  • Linkedin connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3  Monday at 3:00    Wednesday at 3:00    Friday at 3:00    
4  Monday at 4:00    Wednesday at 4:00    Friday at 4:00    
5  Monday at 5:00    Wednesday at 5:00    Friday at 5:00    
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00    
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00    
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00      
9    Tuesday at 9:00    Thursday at 9:00      
10    Tuesday at 10:00    Thursday at 10:00      
11    Tuesday at 11:00    Thursday at 11:00      
12    Tuesday at 12:00    Thursday at 12:00      
13  Monday at 13:00    Wednesday at 13:00    Friday at 13:00    
14  Monday at 14:00    Wednesday at 14:00    Friday at 14:00    
15  Monday at 15:00    Wednesday at 15:00    Friday at 15:00    
16              
17              
18              
19              
20              
21              
22              
23              
from 20.66€At 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


Brahim
General Accounting, Analytical Accounting, Financial Management, Budget Management, Management Control, Financial Mathematics,
At the end of this learning and this coaching, I will be able to master the in-depth techniques of general and analytical accounting and management control. From my long practical experience you will be impregnated with techniques and practical exercises using Microsoft Excel and Google Sheet.

Zakaria
Online distance learning computer course in home office automation (Word, Excel & PowerPoint)
Do you want to learn the basics of computers or the use of software such as Word, Excel or Powerpoint? I can give you the necessary skills to better understand the functionalities of these software to write, for example, a document, a request, an administrative letter, termination, etc. I can also provide you with advice on making the best use of the internet, protecting and backing up your data, or using your computer on a daily basis. I am a quality specialist in a company, previously a computer and office automation trainer, and I offer home courses adapted to your situation.

Amin
Microsoft Office tools for beginners, intermediates and advanced
Looking to master Microsoft Office tools ? One of the most popular pieces of software is Microsoft Office. The three most popular Microsoft Office products are Microsoft Word, Microsoft PowerPoint, and Microsoft Excel. All three items in this class of Microsoft Office are covered. Although the focus of this course is on the beginner or entry-level user, if you are already familiar with the Microsoft Office basics, we can still help you become proficient with these tools. With our assistance, you can master the Microsoft Office tools in no time. This class can be adapted for yourself or with others. If you have any further questions, please do not hesitate to contact us.

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
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.

Tirza
Office programs (:eg: Word, PowerPoint, etc.)
Office programs can be very important for work or study. For example, it is important to pay attention to certain points so that your report or presentation comes across as professional. In addition to the layout, there are also functions in the programs that can make it much easier for you, but also for the reader/spectator. Think, for example, of correct content or source processing (apa-style)

Irina
Learn how to use Microsoft Excel, PowerPoint and Word at work and at home.
Excel can be a powerful tool and a reliable assistant. I can teach you how to use formulas, how to make tables and analyse the data, how to make pivot tables and how to get data from one table to another based on different criteria. Please note: I don't teach macros and most of financial formulas. Knowing how to use PowerPoint will help you to enhance your presentations and give you the ability to choose the best way to showcase your ideas and report the results of your work. Word will help you to make your reports, essays or contracts look professional. I'll be happy to teach you how.

Dimitri
Data Analysis Course with Microsoft Excel - Mastery of Excel and Dashboard Design
Microsoft Excel is very powerful data analysis software. It is a practical solution in the short to medium and long term to automate your calculations, to have a global and detailed overview on your activities, and to analyze your data. As an accountant, marketer, commercial agent, secretary, merchant, salesperson or company manager, a good mastery of this software will improve your efficiency, your competitiveness, and will save you a lot of time and money. Whatever your field of activity, this software is designed to help you. During this training you will learn: - best practices, functionalities and tools; - functions and their use; - handling of Dynamic Cross Tables, dynamic graphics, - the design of dashboards, - and you will acquire reflexes that will be useful for your entire career. Duration of training: 1 month Number of hours: 24 hours I am expecting many of you because we have a lot to share.

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!

Nick
Econometrics, Statistics, Mathematics, Economics, Excel, Data Analytics - For University & School Students
I am an Economics graduate with the strong background in Econometrics, Statistics, Mathematics and Data Analytics. Moreover, I have worked for Unilever (Fortune 200 company) as a Data Analyst, where I have applied my Econometrics, Statistics, Mathematics, Economics and Data Analytics knowledge using tools such as: Python (Pandas, Numpy), MS Excel, MS PowerPoint, MS PowerBI and SQL. Due to my educational background I possess high level knowledge of regression and time series analysis. Also, I have excellent knowledge of descriptive and inferential statistics to aid the students overcome their challenges. I can help on various topics such as: -Linear, Multiple and Logistic regression and time series analysis. -Give interpretations and predictions of regression analysis. -Descriptive statistics (Mean, Median Mode, Skewness, Kurtosis, etc.) -Inferential statistics -Chi-Square Tests, Confidence Interval -Monte Carlo simulation -Anova Analysis -Hypothesis Testing (T -tests, Z test, F-tests), -Correlation Analysis and interpretation. -Non-Parametric Tests (Kruskal-Wallis, Wilcoxon Signed Rank Tests, etc.) -Probabilities, Conditional Probabilities Tools: MS Excel, MS PowerPoint, MS PowerBI, Python (Pandas, Numpy, Matplotlib, Spark), STATA, eViews, SQL

Ilias
Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (children and teenagers)
Whether you are asked to create a spreadsheet for maths or science assessments, a database of pupils, or an engaging presentation for a school project, Microsoft Office is usually your choice. The more you know about advanced capabilities of Office programs the more impressive your work can be. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Communication with Teams - Presentations with PowerPoint - Databases with Access If learners are advanced or not interested in any of the above modules, I could happily exclude those modules from the course.

Boris
Microsoft Excel, Finance, Investments, Economics 🔥 🔥 🔥
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.

Chouaib
Course on Microsoft Excel (Operation, Formulas,...)
The objective of this course is to enable the interested party to fully understand the usefulness of Excel, to understand how it works and how it can be used at school and professional level. It is also an exposition of the formulas of excel, application exercise,..

Ahmed
Maitrisez l'élaboration des présentations à l'aide de Microsoft Power Point ou Google Slides
Microsoft PowerPoint est un logiciel de présentation édité par Microsoft, faisant partie de la suite bureautique Microsoft. Il permet de créer un support visuel pour une présentation orale. La présentation peut être composée de plusieurs slides (Diapositives). Vous pouvez intégrer du texte, des images, des graphiques et des vidéos à vos diapositives. Vous avez la possibilité d’animer tous les éléments de votre présentation par le biais d’effets d’apparition, de disparition ou encore via des effets de zoom. Généralement le cours permet à l'étudiant d'assimiler : * Création d'un fichier Power Point, Ajouter des Slides, Supprimer des Slides ; * Les fonctionnalités de la barre d'Acceuil (Police, Police, Formes, Dessin, Paragraphes...) ; * Créer des animations ; * Créer et exploiter des Templates ; * Règles de forme. La composition du cours dépend du niveau de l'étudiant et ses propres objectifs. La première séance est une séance d'une heure d'évaluation qui permet le diagnostic du niveau et des besoins de l'étudiant. A partir de ce diagnostic nous établissons ensemble un programme que nous allons suivra durant notre cours.

Badr
Office automation Office automation is a term that includes software that helps the company in the drafting of documents. Microsoft Office
Office automation is a term that includes software that helps the company in writing documents. Microsoft Office is an office suite allowing, among other things, to write letters, write CVs (with Word), create presentations (with PowerPoint), create spreadsheets and graphs (with Excel).

Yanis
Courses or tutoring in computer science, Microsoft Office, Word, Excel, Powerpoint in Geneva
Repeater for over 8 years, my students are only improving their grades. Satisfied or refunded! Always save time for the student to bring exercises, theories, homework, failed tests and corrections ... I am patient, used, cool, flexible and honest. See you soon!