facebook
Become a Tutor

Discover the Best Private Microsoft excel Classes in Old Town

For over a decade, our private Microsoft excel tutors have been helping learners improve and fulfil their ambitions. With one-on-one lessons at home or in Old Town, you’ll benefit from high-quality, personalised teaching that’s tailored to your goals, availability, and learning style.

Private lessonsMicrosoft ExcelMicrosoft Excel in Old Town

0 microsoft excel teachers in Old Town

0 teachers in my wish list
|
+–

0 microsoft excel teachers in Old Town

star icon
active star icon
(12 reviews)
Anas - Brussels, Belgium287 CNY
287 CNYMaster 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 26 - 50 of 27626 - 50 of 276
Next »»

Our students from Old Town evaluate their Microsoft Excel teacher.

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

Python programming language explained very simply and interestingly for beginners (Vienna)
Ferdaws
rating star
rating green star
I contacted Ferdaws via Apprentus for my 10 years old son. We were very satisfied with our lesson. My son left the lesson in a very positive mood. Ferdaws' communication with the children is great. This situation motivated us a lot. It is very nice to meet him. Thank you!
Review by GÖKÇEN
Master Microsoft Excel (Beginner - Intermediate - Advanced) (Brussels)
Anas
rating star
rating green star
I recommend Anas as he is a smart person, he knows his way through excel. He commits through the lessons unlike others i have tried to reach through this platform.
Review by RAWAN
- Moroccan Darija Distance Course For all levels: ONLINE (Casablanca)
Professeur
rating star
rating green star
First lesson what can I say very good! Youness is a good teacher
Review by JAY

You are here

Private lessons
Microsoft Excel
Microsoft Excel in Old Town
map iconMap