facebook
Become a Tutor

Microsoft excel lessons in Prague

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

Private lessonsMicrosoft ExcelMicrosoft Excel in Prague

2 microsoft excel teachers in Prague

0 teachers in my wish list
+–

2 microsoft excel teachers in Prague

Meet even more great teachers. Try online lessons with the following real-time online teachers:
(1 review)
Azzedine - Paris, FranceRecently active$26
$26Développez votre expertise en Power BI et Business Intelligence : Créez des tableaux de bord percutants et des visualisations de données pro
Trusted teacher: 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.
Computer science · Microsoft excel
Dr. Mohamed - Dubai, United Arab EmiratesRecently active$26
$26Microsoft Excel standard level and professional level
Trusted teacher: 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.
Computer science · Microsoft office · Microsoft excel
Translate this text using Google Translate.
(75 reviews)
Matías - Geneva, Switzerland$34
$34Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
Trusted teacher: 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.
Microsoft office · Microsoft excel · Visual basic
Translate this text using Google Translate.
(12 reviews)
Anas - Brussels, Belgium$38
$38Master 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.
Showing results 1 - 25 of 2221 - 25 of 222
Next »»

Our students from Prague evaluate their Microsoft Excel teacher.

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

Private coding / programming lessons with python (Paris)
Matías
Highly recommended teacher!!! Matias teaching methods are great. Very clear and concise. Doesn’t waste your time explaining meaningless background information and always lectures with the intent to help you understand the material. He’s helped me understand content for my master course on Python and is one of the best lecturers that I’ve had. Your passion and dedication is beyond words! Thank you for getting me through this hard quick semester, I honestly would have never passed if it was not for your help! Thank you so much once again!
Review by JURIS
Scientific subjects (Math, Physics, Chemistry) for students of the French mission/for middle and high school students (Casablanca)
Amin
So far, I've been getting help with my IGCSE 's in Math and Computer Science with Amin. In most of the lessons I've been with him, he's been really helpful and responsible. He has also been very patient. He helps me become more confident in my answers and makes the lessons pretty fun! After my lessons with him, I do understand my topics more and am able to go to my classes in school without feeling lost. If you're ever struggling with Physics or Programming, I'm sure he can help you too :)
Review by MANIJ
Support courses in mathematics intended for high school students, adapted to different sectors: Science Maths, Science Exp, Letters (Lyon)
Azzedine
Azzedine truly stands out as a remarkable instructor! Despite the short notice, he displayed remarkable consideration for our hectic timetable, ensuring to carve out time to equip me with Excel and Power BI skills for the assessment. A heartfelt thank you, Azzedine, for your exceptional teaching methods. I highly endorse Azzedine as your go-to teacher!
Review by IMANE

You are here

Private lessons
Microsoft Excel
Microsoft Excel in Prague