facebook
Mohamed
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from9.91GBP/ h

Comprehensive Course: Mastering Microsoft Office from Beginner to Advanced

Ready to Excel with Microsoft Office Tools?
Discover the full potential of Microsoft Office, a suite of software renowned for its versatility. This comprehensive online course delves into the core components: Microsoft Word, Microsoft PowerPoint, and Microsoft Excel. Whether you're taking your first steps or seeking to enhance your existing skills, this course is for all levels.

Unlock the power of Microsoft Office in a seamless learning journey that suits your pace, whether you're embarking on this solo or with a group.

For any inquiries or clarifications, please don't hesitate to reach out to us.

Extra information

Bring your Laptop

Location

At student's location: Around Oujda, Morocco
Online via webcam
At teacher's location: Mosquée, Hay El Qods, Oujda, Morocco

|
Use ⊞+wheel to zoom!
+

General info

Age:
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level:
Beginner
Intermediate
Advanced
Duration:
60 minutes
The class is taught in:French, English, Arabic

About Me

My teaching method focuses on adapting to each student based on their needs and academic gaps. I also take into account external factors that may influence their success. I encourage the development of self-confidence, personal efficiency, discipline, as well as other skills to help the student overcome challenges and achieve their goals.

Education

- Pursuing a Ph.D. in Physics, specializing in Optics and Photonics.
- Master's degree in Physics, specializing in Physics of Matter and Radiation.
- Preparatory classes for prestigious engineering schools, specializing in Physics, Chemistry, and Engineering Sciences.
- Achieved a Bachelor's degree in science with the distinction of "Mention Très Bien" (Very Good).

Experience / Qualifications

I am currently a dedicated tutor at Germannstika Center, where I have been working with passion and commitment for 2 years. My goal is to help students reach their full potential by providing them with high-quality educational resources and strategies. I firmly believe that everyone can succeed if they are given the right tools and guidance, and I take pride in doing my part to assist them in achieving their academic goals.

Reviews (1)

Mohamed is an excellent teacher, my daughter really liked the way he explained the lessons and the resolution of the series, I invite the students to benefit from his knowledge
Translated by Google. Click to view original.
Ce programme vous offre les compétences nécessaires pour comprendre et maîtriser les mathématiques et la physique. Nous aidons les étudiants de toutes disciplines. Les sessions se basent sur le programme scolaire et sont divisées en deux parties : - Compréhension du cours. - Application practique. Les sessions sont adaptées à chaque étudiant en fonction de son niveau. Pour plus d'informations, veuillez nous contacter.
LaTeX, a renowned typesetting program, finds extensive usage across academia to communicate and publish documents across diverse fields. It excels in providing robust and consistent formatting, seamless citation management, and document organization. Its standout features include powerful syntax, swift composition of mathematical equations, and effortless maintenance of uniform formatting throughout documents. LaTeX stands as an indispensable tool for science and engineering, while its prowess extends to various disciplines by allowing writers to focus on content creation, leaving formatting to the program. By the conclusion of this course, you will gain the following skills and insights: - Create and format documents using LaTeX. - Grasp LaTeX's project structure and the application of packages. - Develop proficiency in writing and understanding LaTeX syntax. - Embed figures, images, tables, and seamlessly reference them. - Construct lists, incorporate hyperlinks, and formulate equations. - Curate bibliographies with bibTeX, seamlessly citing references. Additional modules may encompass: - Crafting personalized title pages and advanced formatting. - Efficiently working across multiple files. - Crafting slides and presentations using LaTeX. - Developing impressive CVs using LaTeX.
This Python course is designed for beginners who want to learn programming using the Python language. We will start with the basic concepts of programming, such as variables, loops, and conditions, and then progress to more advanced skills like file manipulation and script creation. We will also cover the fundamental principles of object-oriented programming. Students will be able to apply what they have learned through practical exercises and real projects. The sessions will be interactive, and students will have the opportunity to ask questions and receive feedback on their code. This class is intended for anyone who wants to learn programming using Python, whether for their career or just for fun.

Ask a question

Send a message explaining your needs and Mohamed 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  Monday at 2:00  Tuesday at 2:00  Wednesday at 2:00  Thursday at 2:00  Friday at 2:00  Saturday at 2:00  Sunday at 2:00
3  Monday at 3:00  Tuesday at 3:00  Wednesday at 3:00  Thursday at 3:00  Friday at 3:00  Saturday at 3:00  Sunday at 3:00
4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00  Thursday at 4:00  Friday at 4:00  Saturday at 4:00  Sunday at 4:00
5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00  Thursday at 5:00  Friday at 5:00  Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from £9.91At teacher's location
from £9.91Online via webcam
from £11.90At 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  Monday at 2:00  Tuesday at 2:00  Wednesday at 2:00  Thursday at 2:00  Friday at 2:00  Saturday at 2:00  Sunday at 2:00
3  Monday at 3:00  Tuesday at 3:00  Wednesday at 3:00  Thursday at 3:00  Friday at 3:00  Saturday at 3:00  Sunday at 3:00
4  Monday at 4:00  Tuesday at 4:00  Wednesday at 4:00  Thursday at 4:00  Friday at 4:00  Saturday at 4:00  Sunday at 4:00
5  Monday at 5:00  Tuesday at 5:00  Wednesday at 5:00  Thursday at 5:00  Friday at 5:00  Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9  Monday at 9:00  Tuesday at 9:00  Wednesday at 9:00  Thursday at 9:00  Friday at 9:00  Saturday at 9:00  Sunday at 9:00
10  Monday at 10:00  Tuesday at 10:00  Wednesday at 10:00  Thursday at 10:00  Friday at 10:00  Saturday at 10:00  Sunday at 10:00
11  Monday at 11:00  Tuesday at 11:00  Wednesday at 11:00  Thursday at 11:00  Friday at 11:00  Saturday at 11:00  Sunday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00  Saturday at 12:00  Sunday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00  Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00  Friday at 16:00  Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00  Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from £9.91At teacher's location
from £9.91Online via webcam
from £11.90At 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


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.

Amin
Microsoft Office tools for beginners, intermediates and advanced
Looking to master Microsoft Office tools? This course covers the three most popular Microsoft Office products: Word, PowerPoint, and Excel. Designed primarily for beginners, the course also offers support for those already familiar with the basics, helping you achieve proficiency with these tools. The course can be tailored for individual or group learning. With our assistance, you'll be mastering Microsoft Office in no time. If you have any questions, please do not hesitate to contact us.

Nadia
Computer Science Basics – Build a Strong Foundation in Tech
Step into the world of technology with our Computer Science Basics class, perfect for beginners or anyone looking to refresh their knowledge. This course is designed to make complex concepts accessible and engaging, covering essential topics like programming, data structures, algorithms, and more. You'll learn the fundamental principles that drive the tech world, with hands-on exercises that reinforce your understanding. Whether you're aiming to start a career in tech or simply want to enhance your problem-solving skills, this class will equip you with the core knowledge you need to succeed. Join us and start your journey in computer science today!

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.

ولاء
Mathematics and Math Teaching mathematics in Arabic and math for all school and university levels in interesting and enjoyable ways. ☕ Solving all learning difficulties problems. 🎮T
Teaching mathematics in Arabic and math for all school and university levels in interesting and enjoyable ways. ☕ Solving all learning difficulties problems. 🎮 Providing math competitions and games. 🧊 Removing math anxiety among students and linking math to reality. 🥇📈 Ensuring full marks in exams while continuing to progress and excel.

Aniket
Certified Trainer For SQL, Excel and Html (Web Development) with 300+ Reviews
- B.tech and M.tech in Computer Science - Worked as a Software engineer in Virtusa Corp & DIGIDEZ - More than 6 years of teaching experience - Oracle Certified Developer - Helped students placed in FAANG Featured Review : Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!! Thanks Aniket

Rena
Excel - any level, any experience, interactive teaching
Excel is one of the main tools people need at work or university. I have professional excel experience due to the nature of my job. I have been teaching excel to junior analysts in my team for the last two years. I can teach you anything from basic formulas and shortcuts to more sophisticated spreadsheets construction.

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.

Dhruv
Maths Tutor as well as basic knowledge of Microsoft excel and word
Microsoft Word as well as Microsoft Excel is one of the major software in today's world.Maths is also a necessary subject to have a better understanding if you opt to select any programming language. I will tutor you to increase your proficiency in Maths and I can give you the basic overview of Microsoft Excel as well as Microsoft Word

Dr. Mohamed
Microsoft Excel standard level and professional level
As a university professor specializing in statistics and mathematics. In addition to that, I obtained many certificates in computer training, and after my previous experience as a computer trainer in many training centers, it was necessary for me to master the use of the Excel program at its basic and advanced levels. As a result, I prepared two lessons that included distinct explanations in Arabic and English, according to the trainee’s language. As a university professor specialized in statistics and mathematics, and with multiple certifications in computer training, in addition to my prior experience as a computer trainer in various training centers, it was imperative for me to master the use of Excel at both basic and advanced levels. . Consequently, I have prepared two lessons, presented in both Arabic and English, which include comprehensive explanations. Lesson One: Introduction to using Excel In this lesson, you will introduce basic concepts about Excel in a simplified way. You can include the following: Explanation of the Excel interface: Explanation of the main interface elements such as the toolbar and navigation bar. Create a simple table: How to create a basic table in Excel and enter data into cells. Simple Calculations: How to use basic arithmetic operations such as addition, subtraction, multiplication, and division. Data formatting: How to format data so that fonts, colors, and style can be changed. Lesson 1: Introduction to Using Excel In this lesson, I will provide a simplified explanation of basic Excel concepts, covering: Excel Interface: An overview of the main elements of the interface, such as the toolbar and the navigation bar. Creating a Simple Table: How to create a basic table in Excel and input data into cells. Basic Calculations: How to perform fundamental mathematical operations such as addition, subtraction, multiplication, and division. Data Formatting: How to format data, including changing fonts, colors, and styles. Lesson Two: Excel for the advanced level This lesson can be targeted at people who want to use Excel for more complex purposes. You can include the following topics: Functions and equations: An explanation of the use of built-in functions such as SUM and AVERAGE, but not limited to, and custom equations. Dynamic Tables: How to create dynamic tables and use them to analyze data. Conditional formatting: How to set up conditional formatting of cells based on certain rules. Graphs: How to create graphs and use them to visualize data. Data Review: Explain how to use review tools such as filters, sorting, and searching. Within each lesson, you can include interactive examples and hands-on exercises to help students apply the concepts explained. Students can also be directed to additional resources for delving deeper into Excel if they are interested. On the practical side, you can use Excel to create examples and practical exercises that help students apply the concepts taught in the lessons. Thus, you will have excellent lessons to teach basic and advanced use of Excel. Lesson 2: Advanced Excel This lesson is designed for individuals who wish to utilize Excel for more complex purposes. It will cover the following topics: Functions and Equations: Explanation of using built-in functions like SUM, AVERAGE, and more, as well as creating custom equations. Pivot Tables: How to create pivot tables and use them for data analysis. Conditional Formatting: How to set up conditional formatting for cells based on specific criteria. Charts and Graphs: Create charts and graphs to visualize data. Data Review: Explanation of tools for data review, such as filters, sorting, and search. Within each lesson, interactive examples and practical exercises will be included to help students apply the concepts taught. Additionally, students can be directed to additional resources for further in-depth exploration of Excel if they are interested. These lessons will ensure that students can learn how to use Excel effectively at both basic and advanced levels, benefiting from my expertise in the field.

Anthony
Proficiency in Excel software (formulas, graphs, pivot tables)
Excel is spreadsheet software developed by Microsoft, part of the Microsoft Office suite. Used by millions of people around the world, Excel allows you to create, manipulate and analyze data efficiently and intuitively. Introduction to Excel 1. Interface and Navigation Overview of the Excel interface Worksheets, columns, rows and cells Cell navigation and selection Basic Operations Data entry and formatting Using cell references 2. Data Management Data Handling and Cleaning Sort and filter data Use search functions Data validation and removal of duplicates 3. Creation of Dashboards Visualization Elements Creating and customizing charts Adding segments and form controls Layout Arrangement and alignment of elements Using Themes and Styles Preparing to print 4. Pivot Tables Creation and Manipulation Definition and benefits Creating and reorganizing fields Using segments and timelines Analysis Data grouping Creating pivot charts 5. Conditional Formatting Rules and Practical Applications Predefined and custom rules Highlighting trends Colorizing cells based on values

Ilias
Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (adults)
Whether you are asked to create a spreadsheet for statistical analysis, a database of customers, or an engaging presentation of a new product, Microsoft Office is usually your choice. Many users know the basics of what Office can do, but being aware of the more advanced capabilities of Office programs gives you many opportunities for impressive results. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Presentations with PowerPoint - Communication with Teams - 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.

Florent
Excel VBA course - automation of tasks using VBA code
My name is Florent and I am a data analyst with over 5 years of experience. Graduated from ENSTA Paris in machine learning, I have acquired solid expertise in this field. My professional background has allowed me to collaborate with several renowned consulting companies, including Accenture. I developed algorithms in VBA, created forecasts in Python and C. I also worked on image recognition in Matlab Please feel free to contact me to discuss your needs and how I can help you achieve your goals. See you soon,

Anas
Master Microsoft Excel (Beginner - Intermediate - Advanced)
>>> What is Excel? Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs. >>> What about pedagogy? I favor the learning by doing method >>> Who am I? For information, I am consultant / trainer and certified Microsoft Excel Expert. I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private. >>> Location of the training? The place is to be agreed with the apprentice. Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...) >>> Content of the training I can adapt to your level and your needs in terms of content. Here is a non-exhaustive example of the subjects taught. **** Excel Training (Beginner and Intermediate) **** Part I: Basic Concepts What is Excel? Discover the Excel window. Workbooks, spreadsheets, cells. Use the toolbars, the menu, the help. Part II: Working in a spreadsheet Identify basic concepts Manage cells: capture and copy Set up formulas. Master the modes of referencing cells: absolute, relative. Insert, delete rows or columns, move fields. Part III: Formatting a spreadsheet Format cells: present numbers, text, titles. Define conditional formatting. Print the entire sheet or part. Build the layout: titles, pagination Part IV: Workbook Management Save, edit a workbook. Divide your data over several sheets. Insert, delete, move, copy a sheet. Edit multiple sheets simultaneously Part V: Data Analysis Using Functions Calculate percentages, establish ratios. Perform statistics: AVERAGE, MAX, MIN Apply conditions: SI. Use functions: NOW, TODAY. Consolidate multiple sheets of a workbook with the SUM function. Part VI: Linking spreadsheets Transfer data from one table to another Copy / paste with link. Create summary tables. Part VII: Illustrate with graphics Create a chart from a table Change the type: histogram, curve, sector. Add or delete a series. **** Excel Training (Advanced) **** Part I: Configure Excel Options Set up Excel options. Customize the interface. Part II: Gaining time to present his paintings Define styles, use themes. Define conditional formats. Insert Sparklines charts. Part III: Creating simple and complex calculation formulas Master the various modes of referencing: relative, absolute, mixed. Name cells. Set up simple and complex conditions: IF, OR, AND. Calculate statistics: NBVAL, NB, NB.SI. Use mathematical functions: Sum and SUM. Retrieve data with search functions: VLOOKUP Calculate dates, times: DATE(), DAY() and MONTH() ... Manipulate text: CAPITAL, MINISCULE and CONCATENATE. Protect formulas, sheets or binders. Part IV: Consolidation of data Link multiple cells in a workbook. Manage connections between workbooks. Consolidate tables in a workbook. Consolidate data from multiple workbooks. Part V: Exploiting Data Lists Tris multicriteria. Custom sorting: Numeric, Textual and Chronological. Extract data: advanced filters. Delete duplicates. Part VI: Implementing Pivot Tables / Charts Create charts / pivot tables Group the information by period and by slice. Filter and sort Segment filters Show / hide data. Add ratios and percentages.

Samuel
Engineer and Doctor | computer and office automation courses.
Hello ! Currently a teacher-researcher and independent trainer, I have been giving courses since 2013 online, but also in person to faculties, engineering schools and training organizations. I offer support for high school students, students in engineering faculties/schools, but also for professionals seeking to improve in IT and office automation. I am available for regular follow-ups with medium/long-term objectives to achieve (e.g. preparation for the Baccalaureate, weekly follow-up, skills development, etc.), but also for one-off interventions (help with preparation for a partial , project, DM, etc...). ============ = Method ============ I adopt a rigorous and methodical approach which allows me to optimize and maximize the results of any learner, whatever their initial level and objectives. To do this, we will first make an initial call/exchange of emails, aiming to identify the needs, expectations and initial level of the learner. Following this, I propose a session plan(s) to the student that would allow them to meet their needs. During the different sessions, I adopt an active pedagogy based on examples, demonstrations, sharing of experiences, practical cases and an evaluation of acquired knowledge throughout the training.