facebook
Become a Tutor

Private teachers in Bwrnmwth

Find your perfect private tutor in Bwrnmwth.
Learn with our teachers at home or in their studio.

Private lessonsPrivate lessons in Bwrnmwth

42081 private teachers in Bwrnmwth

0 teachers in my wish list
|
+-

42081 private teachers in Bwrnmwth

star icon
active star icon
(12 reviews)
Anas - Brussels33€
33€Master Microsoft Excel (Beginner - Intermediate - Advanced)
Trusted teacher: >>> 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.
Computer science · Microsoft excel
Translate this text using Google Translate.
« Previous«
Showing results 1601 - 1625 of 420811601 - 1625 of 42081
Next »»

Our students from Bwrnmwth evaluate their teacher.

To ensure the quality of our teachers, we ask our students from Bwrnmwth to review them.
Only reviews of students are published and they are guaranteed by Apprentus. Rated 4.9 out of 5 based on 88 reviews.

Reinforcement and tutoring of secondary and high school subjects (Madrid)
Maricielo
rating star
rating green star
Maricielo is an excellent math teacher who explains complex concepts in a clear and approachable way. Her lessons are well-structured, engaging, and encourage active participation. She is patient, supportive, and makes sure I feel confident in understanding the material.
Review by LUDWIG
School and University Return Preparation Course (Ségny)
Tony
rating star
rating green star
My son enjoyed his Physics studies with Tony even though it was his first class. He told me he learnt a lot already on the first day and is confident he will improve his grades within a short period.
Review by GENEVIEVE
Learn French in Montpellier! (you need French as a pragmatic tool) (Montpellier)
Sam
rating star
rating green star
Sam was adept in finding out my requirements and how best to achieve them. She was well prepared with material. I can highly recommend Sam and will arrange further lessons in the future.
Review by CHRISTOPHER

You are here

Private lessons
Private lessons in Bwrnmwth
map iconMap