from42.00EUR/ h
Proficiency in Excel software (formulas, graphs, pivot tables)
Translated by Google. Click to view original.
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
Extra information
Translated by Google. Click to view original.
A computer with the Office packLocation
Online via webcam
General info
Skills:
Age: | Children (7-12 years old) Teenagers (13-17 years old) Adults (18-64 years old) Seniors (65+ years old) |
---|---|
Student level: | Beginner Intermediate |
Duration: | 60 minutes |
The class is taught in: | French, English |
About Me
Translated by Google. Click to view original.
I'm Anthony, 31 years old and I live in Paris.Previously a company accountant, I made my professional reconversion in training in 2020.
As a trainer, I have carried out training missions in different centers and structures with an audience ranging from 7 to 77 years old.
I am very patient in listening to my learner. Its success is my main goal.
I teach accounting and payroll, mastery of Microsoft Office and Google family software and also English, both academic and professional.
Education
Translated by Google. Click to view original.
Professional Title - Professional Adult Trainer (2024)Higher Technician Certificate - Accounting and Organizational Management (Le Rebours, Paris, 2014)
Experience / Qualifications
Translated by Google. Click to view original.
Accounting, English and office automation trainer (as a freelancer and employee)Supplier accountant
General accountant
Microsoft Word is word processing software developed by Microsoft. It is part of the Microsoft Office suite and is widely used for creating, editing and formatting text documents. Word offers a variety of tools for editing text, formatting, inserting graphics, as well as advanced features like reviewing, commenting, and online collaboration tools.
Introduction to Word
1. Interface and Navigation
Overview of the Word interface
Ribbons, tabs and toolbars
Windows, Documents, and Reading Views
2. Basic Operations
Creating and opening documents
Backup and file management
Entering and editing text
3. Formatting Text and Paragraphs
Text Formatting
Text font, size, style and color
Using predefined styles
4. Alignment and Spacing
Paragraph alignment
Line spacing and paragraph spacing
5. Lists and Bullets
Creating bulleted and numbered lists
Customizing Lists
6. Page Management and Layout
Page Setup
Margins, orientation and page size
Headers, footers and page numbering
7. Sections and Jumps
Page and section breaks
Managing headers and footers for each section
8. Inserting Elements
Graphic Elements
Inserting and formatting images
9. Using Shapes, SmartArt and Graphics
Paintings
Creating and formatting tables
Cell fusion and splitting
10. Objects and Links
Insertion of hyperlinks
Inserting symbols and equations
11. Review and Collaboration Tools
Revision
Using the spelling and grammar checker
Track changes and insert comments
12. Collaboration
Document sharing and collaborative work in real time
Using co-authoring tools and document versions
13. Advanced Functions
References and Citations
Creation of tables of contents, indexes and bibliographies
Using footnotes and endnotes
14. Templates and Automation
Using and creating document templates
Automation with macros
15. Forms and Protection
Creating and using interactive forms
Document Protection and Restriction of Edition
General accounting is an essential discipline that concerns the collection, classification, recording and analysis of a company's financial transactions.
Goals :
1. Master current accounting operations:
Recording of accounting entries (purchases, sales, banks, various operations).
Monitoring customer and supplier accounts.
Management of receipts and disbursements.
2. Ensure the keeping of accounting books:
Updating the journal and general ledger.
Establishment of the balance of accounts.
3. Participate in closing work:
Assistance in the preparation of monthly and annual closing operations.
Participation in inventory and regularization operations.
Preparation of balance sheets and income statements.
4. Management of tax and social declarations:
Preparation of VAT returns.
Preparation and control of tax declarations (IS)
5. Payroll management (if applicable):
Collection and recording of variable payroll elements.
Participation in the preparation of pay slips and social declarations.
6. Use of IT tools:
Mastery of accounting software (such as Sage, Ciel, EBP).
Use of spreadsheets and other office tools for accounting monitoring.
7. Advice and support for customers:
Financial analysis of results.
Tax optimization and financial management advice.
Supporting clients in their financial projects (forecasts, budgets, etc.).
School English aims to develop the basic language skills needed for everyday and academic communication. This course emphasizes hands-on learning of grammar, vocabulary and communication skills.
Module 1: Foundations of the English Language
1. Introduction to English
Alphabet and pronunciation
Numbers and time
Greetings and common expressions
2. Basic Grammar
Personal pronouns
Verbs “to be” and “to have”
Simple present tense of regular and irregular verbs
Past tenses
Times of the future
Module 2: Thematic Vocabulary
1. Daily Life
Ice Breaker Vocabulary
Food and drink, clothing and weather
2. Education and Leisure
Schooling and school subjects
Leisure, sports and outdoor activities
Module 3: Communication Skills
1. Oral and Written Expression
Practice simple conversations: introduce yourself, talk about your tastes and preferences
Writing simple emails and messages
2. Oral and Written Comprehension
Listening and understanding simple dialogues
Reading texts adapted to grade level
Module 4: Advanced Grammar and Complex Structures
1. Verbal Tenses
Present continuous, past simple and near future
Conditional and comparative
2. Sentence Structures
Using Adverbs of Frequency and Prepositions
Formation of questions and negative sentences
Module 5: Culture and Context
1. English-speaking culture
Traditions, festivals and customs
Educational institutions and daily life
2. Practical Use
Simulations of real situations (travels, visits, etc.)
Oral presentations on various topics
Module 6: Assessment and Exam Preparation
Revision and Practice
Assessment of acquired language skills
Preparation for school exams and certification (if applicable)
Microsoft PowerPoint is presentation software developed by Microsoft. It is part of the Microsoft Office suite and is widely used for creating visual presentations. PowerPoint allows users to create slides containing text, images, graphics, videos, and other multimedia elements. It offers tools for layout, animations and transitions, making it easier to create attractive and professional presentations.
Introduction to PowerPoint
1. Interface and Navigation
Overview of the PowerPoint interface
Using Ribbons, Tabs, and Toolbars
Exploring the different views (normal, slide sorter, slideshow mode)
2. Basic Operations
Creating and opening presentations
Saving and managing files
Adding and organizing slides
3. Slide Design
Using themes and templates
Choosing and Applying Slide Layouts
4. Layout and Formatting
Text formatting (font, size, color, styles)
Using bullets and numbering
Aligning and spacing elements
5. Images and Graphics
Inserting and manipulating images
Creating and Formatting Charts
6. Objects and Media
Inserting shapes, SmartArt and icons
Insertion of videos, sounds and hyperlinks
7.Animations
Adding and customizing animations for objects
Using the Animation pane to manage effects
8. Transitions
Applying and customizing slide transitions
Adjusting timings and transition effects
9. Revision
Using spelling and grammar checking tools
Adding comments and reviewing slides
10. Collaboration
Sharing presentations and collaborative work in real time
Using co-authoring and versioning tools
11. Preparation of the Presentation
Slideshow setup (presenter mode, timing, repeat)
Using Presenter Notes and Commentary Pages
12. Broadcast
Exporting and sharing presentations (PDF, videos, etc.)
Using printing options (handouts, note pages)
Ask a question
Send a message explaining your needs and Anthony 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 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 42€Online via webcam
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 July 2024
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 42€Online via webcam
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
Private lessons
online via webcam
Similar classes
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.
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.
Salah Eddine
Excel with Microsoft Office: Unlock Your Potential in the Gulf Region
Do 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.
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
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
Azzedine
Use Excel, Word and PowerPoint for optimal performances and unlimited creativity!
Boost your product and edit your creativity with Microsoft Office: Liberate all your capabilities to create this file!
Do I find a solution to improve your effectiveness, stimulate your creativity and increase your productivity at home? Don't share anything else with Microsoft Office.
Why choose Microsoft Office?
Explore your creativity: with Word, Excel, PowerPoint and other applications, you can find out which files you want to donate to your IDs, which is suitable for creating professional documents, creating calculus complexes or performing percutantes.
Turn on the high-temperature automation: Excel simplifies complex touches with intelligent formats, dynamic table rotations and intelligent functions.
Available part: If you travel to your office, place it or your home, access Microsoft Office to all your devices, you will be able to use it anywhere else.
Benefit from the Microsoft Office revolution!
Do not allow any obstacles to enter your progression. Invest in the Microsoft Office box to edit all your photos.
Transform your travel façon and lancez-vous facilement in new records with Microsoft Office. Inscribe your main content to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint to all of your children, which you can do now, in the future or later.
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.
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,
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.
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.
Alberto
Basic Excel - Intermediate - Advanced. Customized solutions. Oriented to Office Work or students.
In this Course you will learn everything you need to know about Excel. To get your new job. Forms, functions, tables. dynamic tables. Queries. We can also automate your daily work. You will learn how to update your tables as you receive new information.
Yasmine
I have a Master 2 in Audit and management control, I offer Excel courses
Excel lessons based on exercises.
Learn to use formulas, pivots, useful shortcuts.
Demonstration and practice via exercises.
The lessons depend on the level of the student and depending on their needs, this can be adapted gradually.
I have a Master 2 in Audit and Management Control and 10 years of experience in finance with multinationals (in different countries).
As well as experiences in coaching and mentoring in international competitions for students.
Sufyan
Learn to use Excel. Student in e-Business teaches Excel.
Excel is an effective tool when you master it. However, for a neophyte, its operation may seem a little cryptic.
My courses are mainly aimed at people with a beginner or intermediate level in Excel.
"A good teacher does everything to have no more students".
I don't have a predefined method for teaching. Just as a doctor does not give the same remedy to all his patients, I treat each person on a case-by-case basis.
What interests me is to be able to advance and improve the student's skills.
From cell management to logical and mathematical formulas, including date and time management, table or graphic insertion, or conditional formatting, etc. I can follow a pre-established program or possibly arrange one.