Since July 2024
Instructor since July 2024
Translated by Google
Proficiency in Excel software (formulas,
From 42 € /h
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
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
A computer with the Office pack
Location
Online from France
About Me
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.
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
Professional Title - Professional Adult Trainer (2024)
Higher Technician Certificate - Accounting and Organizational Management (Le Rebours, Paris, 2014)
Higher Technician Certificate - Accounting and Organizational Management (Le Rebours, Paris, 2014)
Experience / Qualifications
Accounting, English and office automation trainer (as a freelancer and employee)
Supplier accountant
General accountant
Supplier accountant
General accountant
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
Skills
Availability of a typical week
(GMT -05:00)
New York
Online via webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
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
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.).
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.).
Show more
Similar classes
Contact Anthony
1st lesson is backed
by our Good-fit Instructor Guarantee
by our Good-fit Instructor Guarantee
Similar classes
Good-fit Instructor Guarantee
Contact Anthony