FavouritesAdd to Wish List
FavouritesAdd to Wish List
from21.97EUR/ h

EXCEL complete training: Beginner, Intermediate and Advanced

Translated by Google. 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 Dynamic Cross Tables...
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.IF, NB.EMPTY, ...
• Relate data with the VLOOKUP function.
• Calculate dates, times: MONTH.SHIFT, END.MONTH...
• Handle 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 by Google. 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

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 by Google. 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 by Google. 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 by Google. 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 -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
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    Wednesday 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  Friday at 8:00    
9  Monday at 9:00  Tuesday at 9:00  Wednesday 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    Tuesday at 13:00    Thursday 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  Monday at 16:00    Wednesday at 16:00    Friday at 16:00    
17              
18              
19              
20              
21              
22              
23              
from 21.97€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 -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
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    Wednesday 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  Friday at 8:00    
9  Monday at 9:00  Tuesday at 9:00  Wednesday 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    Tuesday at 13:00    Thursday 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  Monday at 16:00    Wednesday at 16:00    Friday at 16:00    
17              
18              
19              
20              
21              
22              
23              
from 21.97€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


Salah Eddine
Master Microsoft Excel, Word and PowerPoint from zero to expert!
Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level! If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office. Why Choose Microsoft Office? Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations. Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features. Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Mourad
Engineer| Excel course|Flexible from 8:00 a.m. to 9:00 p.m., Weekends too|Satisfied or refunded. Flexible cancellation | Invoice possible (Self-employed
Whether you are a management controller, HR, auditor, accountant or finance professional, and you have a taste for Numbers, Statistics and Analysis. I offer you a complete range of Excel and VBA training courses adapted to your needs. Remote training on Skype or Zoom or Google Meet or Microsoft Teams, for greater efficiency. NB. I could currently provide distance learning. Regarding the working method, according to your availability we fix the sessions, then I will send you the course support / exercises. We do the sessions on Skype or Zoom or on Google Meet at your own pace, where we can share the screen. Excel 365 Training Modules: Module 1 - Basics - References - SI Logic Function - SI Nested Logic Function - Basic Math / Statis Functions - Functions COUNTIF, SUMIF, COUNTIFENT, SUMIFENT, LARGEVALUE, SUMPRODUCT... - ResearchV - INDEX and EQUIV and EQUIVX search functions - ResearchX - Error Management Study of practical professional cases Module 2 - Validation and data protection - INDIRECT function - OFFSET function - Dynamic Array (Sort, Unique, Filter. ..) - LET Function - LAMBDA FUNCTION - LAMBDA Helper Functions (MAP, REDUCE, SCAN, MAKEARRAY, BYROW, BYCOL, ISOMITTED) - New Data Types - Matric functions - 3D functions (Multi-Sheets) Study of professional practical cases Module 3 - Data table / Sort / Automatic and custom filter - Advanced Filter / Database Functions - Dynamic Pivot Table / Advanced Tips - Solver / Analysis Scenarios Study of professional practical cases Module 4 Power Query Language M Data Preparation Data Analytics Study of professional practical cases Module 5 - Simple Chart - Advanced Chart - Dashboard Study of practical professional cases

Zanèl
Microsoft Office: Word, Excel, PowerPoint, Outlook
Microsoft Office is used worldwide by a variety of companies. I will empower you starting from scratch to using Office as a pro. I do not use computer terminology that will confuse you, but rather speak in a way that you will comprehend and help you to become the boss of the computer.

Mousab
Professor Mousab: Office training in Word, Excel, PowerPoint
The Word, Excel and PowerPoint office course aims to teach students the essential skills to effectively use these three popular applications in the Microsoft Office suite. This course is designed for beginners or those with basic knowledge of office software, and it provides a practical mastery of the key features offered by Word, Excel and PowerPoint. Here is a description of typical course content: Microsoft Word: Introduction to Microsoft Word and its user interface. Creation, formatting and editing of text documents. Using layout tools such as margins, alignment, tabs and bullets. Inserting and modifying images, tables and objects in a document. Using spelling and grammar checking features. Creating document templates for repeated use. Microsoft Excel: Introduction to Microsoft Excel and its user interface. Creation and management of spreadsheets. Using formulas and functions to perform calculations. Formatting data, cells and tables for professional presentation. Creating graphs and charts to visualize data. Using sorting, filtering, and search functions to analyze data. Microsoft PowerPoint: Introduction to Microsoft PowerPoint and its user interface. Creating professional presentations with slides. Adding text, images, graphics and media to slides. Using transitions and animations to make presentations dynamic. Effective oral presentation and use of notes and presenter mode. Integration between applications: Learn to copy and paste data between Word, Excel and PowerPoint. Using bindings to automatically update data in different applications. Embedding objects and graphics into documents and presentations. The Word, Excel and PowerPoint office course is essential for anyone who wants to improve their skills in word processing, data management and creating professional presentations. By the end of the course, students should be able to use these applications independently and effectively, which will benefit them both in their professional and personal lives.

Zakaria
Online computer course in 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 computer and office automation trainer, and I offer home lessons adapted to your situation.

Leo
Finanzas corporativas y modelos financieros en Excel
Análisis Financieros en general. Proyección de estados financieros (estado de resultados, estado de situación financiera) Indicadores financieros Flujos económicos, cálculo de VAN y TIR Modelamiento financiero en excel Plan Financiero para tesis o trabajos

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.

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations. Why choose Microsoft Office? Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation. Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily. Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters. Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management. Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master. Available Everywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Dewanshi
Microsoft Word for the College students as well as Work Professionals
Microsoft Word is an essential skill required when it comes to assignment creation or for any other business or academic purposes. Knowing its features can enhance the quality of work and can also save your time making you more efficient, productive as well as creative to excel in your respective fields and work profile. Learning Microsoft Word is easy but crucial to cater to your day to day requirements in job and academic aspects and is also one of the most used software which is why it becomes necessary to learn and explore its various features to ease the work. Learning Microsoft Word with me will become a fun and enjoyable journey.

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.

Ruth
Learn to use online Digital Tools, whether for personal use or for teaching.
I provide the digital tools course for adolescents and young people who want to deliver their tasks in a digital and creative way, adults and teachers who want to carry out their classes with technology, making them more dynamic and attractive for students. The platforms that I can teach you how to use are: -Canvas - Microsoft Word -Microsoft PowerPoint - Genial.ly - Word Wall -Google slides - Classroom - Google Forms -Google drive - Play tomi digital - Padlet - Book creator

Rafael Andres Altamar
Marketing and sales skills: boost your business
Marketing and Sales Course: Drive your Business towards Success Do you want to learn the most effective strategies to promote your business and increase your sales? Then this marketing and sales course is for you! In this course, you will immerse yourself in the world of digital marketing and the most innovative sales techniques, guided by experts in the field. You will learn how to identify and understand your target audience, develop marketing strategies tailored to your specific needs, and use digital tools to reach your customers effectively. Additionally, you will explore the fundamentals of consumer psychology and how to apply them to influence purchasing decisions. You'll learn how to create persuasive advertising campaigns and use social media and content marketing to build a strong online presence. When it comes to sales, we'll teach you proven techniques to close deals, handle objections, and build lasting relationships with your customers. From the prospecting process to post-sale follow-up, you'll gain the skills necessary to convert potential customers into loyal customers. Whether you are starting your own business or looking to improve your company's marketing and sales strategies, this course will provide you with the knowledge and practical tools you need to achieve success in today's competitive business world. Enroll now and take your business to the next level with our Marketing and Sales course!

Azzedine
Développez votre expertise en Power BI et Business Intelligence : Créez des tableaux de bord percutants et des visualisations de données pro
Vous êtes impliqué dans les finances, la gestion, la planification, la gestion de projet, les ressources humaines, ou peut-être même un étudiant ambitieux désireux de perfectionner ses compétences en matière de tableau de bord professionnel. Si vous recherchez une solution qui va au-delà des limitations d'Excel et de PowerPoint, alors vous êtes au bon endroit : permettez moi de vous présenter Power BI. Avec Power BI, je vous propose bien plus qu'un simple outil. C'est une passerelle vers des rapports interactifs, une gestion efficace des données et une analyse avancée. Voici ce que je peux vous offrir : - Création et gestion experte de rapports interactifs. - Transformation et nettoyage minutieux des données pour une précision maximale. - Utilisation des puissantes formules DAX pour une analyse de données avancée. - Création de visualisations personnalisées et de tableaux de bord percutants. - Partage sécurisé et publication de vos rapports pour une collaboration sans heurts. -Automatisation des tâches répétitives avec Power BI & Power Query. Peu importe vos besoins spécifiques - qu'il s'agisse de projets professionnels, d'études ou d'aspirations personnelles - je suis là pour vous offrir une solution sur mesure. Ensemble, nous créerons un programme adapté à vos objectifs, vous guidant à chaque étape de votre parcours d'apprentissage. Que vous soyez un novice cherchant à maîtriser les bases ou un expert désireux d'approfondir vos connaissances en analyse de données, je suis là pour vous fournir l'expertise et le soutien nécessaires pour réussir.

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.

Albert López
Learn how to use Excel and become an expert!
Have you always wanted to learn Excel but don't know where to start? Do you want to advance in your professional career by being a reference in Excel? You've come to the right place! My name is Albert, a professional in the Pharmaceutical Industry with more than 10 years of experience. Excel has been the key to my success both in the professional and personal spheres. Its versatility and ease of use make it an essential tool. Mastering Excel will not only allow you to start projects that you have always wanted to do, but it will also open doors for you in a job market with HIGH DEMAND for Excel experts. What can you expect from my classes? - 100% Online Classes in Spanish, Catalan or English. - Theoretical concepts and practical examples for comprehensive learning. - You will learn from the most basic concepts to the most advanced. - You will master tables, graphs and formats to analyze any type of data. - I will teach you how to create automatic tools and professional reports. Featured Topics: - Simple formulas (sum, average, max, min, count,...) - Advanced formulas (if, addif, vlookup, unref, match, ...) - Graphics (simple and dynamic) - Simple Tables and Dynamic Tables - Filters and Data Validation - Macros and automation - Creation of professional reports Any idea you have can be done in Excel! Feel free to contact me to design a CUSTOM class and take your Excel skills to the next level.