

from23.42EUR/ 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 ctrl + 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 ESITHBachelor 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 MANAGER7 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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
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 23.42€At student's home
100% Satisfaction Guarantee
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
- Facebook connected
- Google connected
- Linkedin connected
- X connected
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
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 23.42€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
You are here
Similar classes
Salah Eddine
Excel with Microsoft Office: Unlock Your Potential in the Gulf RegionDo you aspire to maximum efficiency, limitless creativity and unparalleled productivity in the Gulf region? Let us guide you to excellence with Microsoft Office.
Why Choose Microsoft Office?
Harness Your Creativity: With Word, Excel, PowerPoint and more, you'll have powerful tools to bring your projects to life, whether creating corporate documents, developing cutting-edge financial tables or delivering presentations breathtaking.
Save Time with Automation: Excel simplifies complex tasks with its smart formulas, pivot tables and many other innovative features.
Accessible Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is available on all your devices, allowing you to work wherever and whenever you want.
Join the Microsoft Office Revolution!
Do not accept compromises in your daily professional life. Invest in the power of Microsoft Office and unlock your full potential.
Transform the way you work, create with ease, and reach new heights with Microsoft Office. Register now to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint at all levels and drive your business to excellence in the Gulf region.
Adham
Course of marocain distance to all of our neighborsI don't want to eat anywhere near the distance to all our neighbors.
I'll offer my children's memories at a distance from all around the world.
I'm sure you will receive a solution and be supported by outils of the application for more efficaces.
Pour plus information, contactez moy.
Salah
Learn MS (Word, Excel and PowerPoint) Microsoft Office / Expand your knowledge of Microsoft office!I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions
Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations...
Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc.
Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows...
I am waiting for your message.
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-employedWhether 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
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 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.
Mousab
Professor Mousab: Office training in Word, Excel, PowerPointThe 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.
Houssam
Master Microsoft Office with our private online classes! Learn Word, Excel, and PowerPoint at your own pace. Book your sessions now"Master Microsoft Office with our private online classes! Learn Word, Excel, and PowerPoint at your own pace. Book your sessions now!"
"Unlock your productivity potential with our online private classes in Microsoft Word, Excel, and PowerPoint. Gain confidence in creating documents, spreadsheets, and presentations. Flexible scheduling to fit your needs. Get started today!"
"Take your skills to the next level with our Microsoft Office classes! Learn how to:
Create professional documents in Word
Analyze data and create charts in Excel
Design engaging presentations in PowerPoint
Private online sessions tailored to your schedule and goals."
Afak
Boost your productivity and master essential office tools with personalized online training in Microsoft Word, Excel, and PowerPoint.Boost your productivity and master essential office tools with personalized online training in Microsoft Word, Excel, and PowerPoint. Our trusted teachers will guide you step-by-step to get familiarized with the tools of Microsoft Office programs that you need to meet your goals. Whether you are a beginner or looking to advance your skills, our courses are tailored to your level of experience.
In our Microsoft Word classes, you will learn document creation, formatting, advanced editing, and professional layout design. Excel classes cover managing data, creating visual representations, and automating processes. PowerPoint training includes creating engaging presentations, importing charts from Excel, and using multimedia and layered objects.
Our live instructor-led classes offer one-on-one training, where you share the same screen with your instructor, providing a private training experience from the comfort of your home or office. The instructor will demonstrate commands and provide exercises for you to practice, ensuring you gain hands-on experience and confidence in using these essential tools.
Join our comprehensive Microsoft Office Certification Program to earn certification in Excel, Word, PowerPoint, and more. This program includes group classes, private tutoring, and exams with free retakes and proctoring.
Don't miss this opportunity to enhance your skills and advance your career with our expert-led online classes. Contact us today to schedule your first class and start your journey towards mastering Microsoft Office!"
Adil
Master Microsoft Office with Personalized Online Private Classes! / ✔ Microsoft Word ✔ Microsoft Excel ✔ Microsoft PowerPointMaster Microsoft Office with Personalized Online Private Classes!
Boost your productivity and professional skills with one-on-one online training in:
✔ Microsoft Word – Create polished documents, reports, and resumes.
✔ Microsoft Excel – Master formulas, charts, pivot tables, and data analysis.
✔ Microsoft PowerPoint – Design stunning presentations with advanced techniques.
Why Choose Our Classes?
✅ Flexible Scheduling – Learn at your own pace.
✅ Customized Lessons – Tailored to your skill level and goals.
✅ Expert Trainers – Patient, experienced, and certified instructors.
✅ Practical Exercises – Hands-on learning for real-world applications.
Perfect for students, professionals, and beginners!
Sami
Master Microsoft Office from Anywhere! Microsoft Word, Excel, and PowerPointAre you looking to boost your productivity and enhance your professional skills? Unlock the full potential of Microsoft Word, Excel, and PowerPoint with personalized, one-on-one online classes tailored to your needs!
Flexible Scheduling: Learn at your own pace, on your own schedule, from the comfort of your home or office.
Yassine
Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint.Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.
Nawfl
Online Private Classes in Microsoft Word, Microsoft Excel and Microsoft PowerPointOnline Private Classes in Microsoft Word, Excel, and PowerPoint
Boost your productivity and master essential office tools with personalized online training in:
Microsoft Word – Learn document creation, formatting, advanced editing, and professional layout design.
Microsoft Excel – Master formulas, data analysis, pivot tables, charts, and automation for business or personal use.
Microsoft PowerPoint – Create stunning presentations with animations, transitions, and effective storytelling techniques.
Why Choose Our Classes?
✔ One-on-one sessions tailored to your skill level
✔ Flexible scheduling to fit your availability
✔ Hands-on exercises & real-world examples
✔ Certification guidance (if needed)
Ideal for students, professionals, or anyone looking to enhance their Microsoft Office skills efficiently.
📩 Contact us today to book your session!
Yassin
Transform Your Life: Join Our Personal Development Assistance Courses Today!Are you ready to unlock your full potential and take control of your personal growth? Our Online Classes in Personal Development Assistance are designed to help you achieve your goals, boost confidence, and enhance your overall well-being.
Whether you’re looking to improve time management, overcome challenges, or build better relationships, we offer practical tools and personalized support to guide you on your journey. Learn from experienced professionals at your own pace, from the comfort of your home.
What You’ll Gain:
- Enhanced self-awareness and emotional intelligence
- Improved communication and interpersonal skills
- Techniques to manage stress and foster resilience
- Actionable strategies for achieving personal and professional goals
Flexible, Affordable, and Empowering – start your transformation today! Enroll now to begin your journey to a better you.
Azzedine
Become an expert in Microsoft Excel, Word, and PowerPoint, even from scratch!Boost your productivity and unleash your creativity with Microsoft Office: unleash your potential at every step!
If you're looking for a solution to optimize your efficiency, boost your creativity, and increase your daily productivity, look no further than Microsoft Office.
Why choose Microsoft Office?
Express your creativity: With Word, Excel, PowerPoint, and more, you have 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 clever features.
Available everywhere: Whether you're in the office, on the go, or at home, Microsoft Office is accessible across all your devices, allowing you to work wherever and whenever you want.
Join the Microsoft Office revolution!
Don't let everyday obstacles stand in the way of 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—beginner, intermediate, or advanced.