facebook
    Mahmoud
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    from15.69EUR/ h

    Data Analysis using Excel "Analysis and Visualization"

    Translated by Google. Click to view original.
    Module 1: Introduction to Data Analysis
    Understanding Data Analysis: Purpose and Scope
    Overview of Excel as a Data Analysis Tool
    module 2:Introduction to Excel Interface and Tools
    Data Entry and Formatting
    Basic Formulas and Functions
    SUM, AVERAGE, COUNT, etc.
    Introduction to Cell Referencing (Relative, Absolute, Mixed)
    Module 3:Data Cleaning and Preparation
    Importing Data from Various Sources (CSV, Text, Databases)
    Data Cleaning Techniques
    Removing Duplicates
    Handling Missing Data
    Data Validation
    Working with Text Functions
    LEFT, RIGHT, MID, TRIM, CONCATENATE
    Module 4: Data Analysis Tools in Excel
    Sorting and Filtering Data
    Conditional Formatting
    Using PivotTables and Pivot Charts
    Subtotals and Summarizing Data
    Data Tables and Scenario Analysis
    Practical Exercise: Analyzing Sales Data
    Module 5: Advanced Functions and Formulas
    Logical Functions
    IF, AND, OR, NOT
    Lookup Functions
    VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
    Mathematical and Statistical Functions
    ROUND, RANK, STDEV, MEDIAN
    Array Formulas
    Practical Exercise: Creating a Dynamic Dashboard
    Module 6: Data Visualization
    Principles of Data Visualization
    Creating Charts and Graphs
    Line, Bar, Pie, Scatter, Combo Charts
    Formatting and Customizing Charts
    Using Sparklines for Quick Insights

    Location

    Online via webcam

    General info

    Age:
    Adults (18-64 years old)
    Student level:
    Beginner
    Intermediate
    Advanced
    Duration:
    60 minutes
    120 minutes
    The class is taught in:English, Arabic

    About Me

    PHD in Statistics , Cairo university, Egypt.
    More than 10 years of experience in teaching statistics and relevant subjects, such as Statistics and Probability, Data Analytics, Mathematics, Calculus, Regression Analysis, Linear Algebra, Non parametric Statistics, operation research, and Econometrics
    Teaching and analyzing data using Excel, SPSS, Stata, Minitab and R-programming

    Education

    PHD in Statistics, Cairo university
    Master degree in Statistics, Cairo University, Egypt
    Bachelor degree in Statistics, minor computer science Cairo University, Egypt

    Experience / Qualifications

    More than 10 years of experience in teaching statistics and relevant subjects, such as Statistics and Probability, Data Analytics, Mathematics, Calculus, Regression Analysis, Linear Algebra, Non parametric Statistics, operation research, and Econometrics
    Teaching and analyzing data using Excel, SPSS, Stata, Minitab and R-programming.
    الإحصاء الوصفي انواع المتغيرات الجداول التكرارية مقاييس المركز مقاييس الانتشار مقاييس الالتواء عرض اليبانات متغير واحد عرض اليبانات متغيرين فترات الثقة لمعلمة سكانية واحدة ومعلمتين سكانيتين فرضية الاختبار لمعلمة مجتمعية واحدة ومعلمتين سكانيتين تحليل التباين ANOVA تحليل الارتباط تحليل الانحدار
    Course Description Running the Program Browsing the SPSS menus creating new file opening existing file importing data file variable view creating new variable Types of variables entering data descriptive statistics frequency tables graphical presentation confidence intervals for one population parameter and two population parameter testing hypothesis for one population parameter and two population parameter Analysis of Variance ANOVA Regression Analysis

    Ask a question

    Send a message explaining your needs and Mahmoud will reply soon:
    The more detail, the better.
    Ex. "Hi, when are you available to meet for a lesson?"

    Availability of a typical week

    (GMT -05:00) New York
    MonTueWedThuFriSatSun
    0              
    1              
    2          Friday at 2:00  Saturday at 2:00  
    3          Friday at 3:00  Saturday at 3:00  
    4          Friday at 4:00  Saturday at 4:00  
    5              
    6              
    7              
    8              
    9              
    10              
    11              
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00      Sunday at 12:00
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00      Sunday at 13:00
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00      Sunday at 14:00
    15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00      Sunday at 15:00
    16              
    17              
    18              
    19              
    20              
    21              
    22              
    23              
    from 15.69€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.

    Online reputation

    • Instructor since June 2023
    • Phone number verified
    • Google connected
    • Linkedin connected

    Availability of a typical week

    (GMT -05:00) New York
    MonTueWedThuFriSatSun
    0              
    1              
    2          Friday at 2:00  Saturday at 2:00  
    3          Friday at 3:00  Saturday at 3:00  
    4          Friday at 4:00  Saturday at 4:00  
    5              
    6              
    7              
    8              
    9              
    10              
    11              
    12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00      Sunday at 12:00
    13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00      Sunday at 13:00
    14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00      Sunday at 14:00
    15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00      Sunday at 15:00
    16              
    17              
    18              
    19              
    20              
    21              
    22              
    23              
    from 15.69€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


    Salah Eddine
    Master Microsoft Excel, Word and PowerPoint from zero to expert!
    Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level! If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office. Why Choose Microsoft Office? Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations. Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features. Available Anywhere: 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 daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

    Anas
    Private lessons in math - physics - chemistry - engineering science
    Hello dear students and participants, As a former teacher, I had the privilege of supporting more than 40 students over the past year in their academic progress. I teach the following subjects: mathematics, physics, chemistry, engineering sciences and Excel. Thanks to my personalized and structured approach, I help my students develop their skills, their self-confidence and their autonomy. By working with me you will learn: *Effective resolution methods, *Intensive practice of exercises, *Educational coaching adapted to your needs, *The development of summary revision sheets, *Career guidance to inform your future choices, *Practical practical work in engineering sciences, to anchor concepts in reality. At the same time, as an information technology consulting engineer, I have in-depth expertise in the technical field, with the ability to design and implement innovative solutions in complex environments. Passionate about aeronautics and piloting aircraft, I cultivate essential qualities such as rigor, discipline and rapid decision-making in dynamic environments. This passion fuels my teaching by adding a practical and inspiring perspective.

    Ilesanmi
    Computer Information Technology/ Learn to be a computer literate.
    Technology is now the order of the day, as a computer Instructor for over 10 years with many experiences, I would be happy to help you be a computer literate from beginner to professional. You will learn how to operate the computer starting from the mouse to the system unit. You will learn how to be a data analyst, you will learn so much about the AI tools which is now the popular to the world. I am also happy to adapt our session according to the topic you wish to cover, etc. I am very flexible, my only goal is to help you improve and be a computer literate.

    Professeur
    - Cours d'Excel à distance Pour tous les niveaux : EN LIGNE-
    - Cours d'Excel à distance Pour tous les niveaux : EN LIGNE- Je donne des Cours d'Excel à distance pour tous les niveaux. J'offre des séances en Excel à distance pour tous les niveaux. J'assure un soutien approfondi et bien supporté par des outils d'apprentissage les plus efficaces. Pour plus d'informations, contactez moi

    Youness
    Office Automation Training: Excel, Word, Remote Power Point / Online
    - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me. - I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely. - For more information, contact me.

    Milan
    Microsoft Excel (+ Word, Powerpoint and other Office applications)
    I offer Microsoft Excel tutoring for anyone looking to improve their skills, from high school students to aspiring professionals. Whether you’re just starting out and want to learn the basics like formulas, graphs, and pivot tables, or you’re more advanced and want to set up automated models, I’m here to help. You determine the curriculum: we can work on specific tasks, such as school projects or work-related analyses, but I can also put together a structured curriculum to build your skills step by step. For advanced users, I offer guidance in developing smart templates and models, so that you can perform analyses faster and more efficiently in the future. With my lessons, you will not only learn to understand Excel, but also to apply it practically to save time and make an impression. Suitable for anyone who wants to distinguish themselves with strong Excel skills! Besides MS Excel, we can also delve deeper into the other Office applications and how to create attractive presentations in Powerpoint or Word.

    Amine
    Microsoft Excel (Formules et création des tableaux et calculs)
    Une formation selon votre besoin et le niveau sur les fonctionnalités et formules Excel. Je divise la session sur 2 phases: Phase 1: Formules Avancées (formules de calculs, formules de logiques, formules mathématiques etc) Phase 2 : Cas pratique et création des tableaux Vous serez capable de manipuler les formules avancées Vous serez capable de les pratiquer dans la création de vos tableaux.

    Adil
    Excel pour les débutants / Microsoft Excel pour les débutants
    Je vous offre des séances pour apprendre l'excel. Vous allez pouvoir apprendre des différents outils qui vont vous permettre de mettre des tableaux sur Excel. Par ce cours, vous allez pouvoir calculer par des formules de calcul. Qu'est ce que vous attendez? Allez, réservez votre cours.

    Edoardo
    Excel Mastery: From Basics to Advanced Applications
    Excel is more than just a spreadsheet—it’s a powerful tool for data analysis, problem-solving, and automation. This course is designed to take you from foundational skills to advanced techniques, enabling you to harness Excel's full potential in real-world scenarios. Whether you're managing data, building models, or optimizing workflows, this hands-on course will equip you with the knowledge and practical expertise to excel (pun intended) in any professional environment. Introduction & Foundations - Overview of Excel’s interface and advanced formatting tools - Key functions like LOOKUP for efficient data handling Working with References & Logical Functions - Mastering relative and absolute references, INDIRECT function - Using ranges, lists, and logical/information functions Formatting, Functions, & Shortcuts - Conditional formatting for data insights - Text functions and essential keyboard shortcuts Data Import & Advanced Operations - Importing data from external sources - Working with dates, times, and matrices Data Analysis Tools - Creating and managing data tables - Data validation and pivot tables for deep analysis Advanced Functions & Formula Auditing - Math, statistical, and financial functions - Troubleshooting and auditing worksheets Advanced Analysis & Automation - Form controls, regression analysis, and scenario building - Introduction to macros for automation

    Amine
    Computer course for all levels , EXCEL, WORD, POWER-POINT, Coaching in Computer Science, Office Automation
    I offer courses in computer science for different languages and frameworks also intended for students in classes preparatory and license in computer science. Tailor-made training adapted to the profile of each student whatever his difficulties, with a pleasure of teaching; academic orientation sessions, and then the addition of other subjects that I master is surely possible.

    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.

    Ray
    Digital Skills in IT. Learn how to use Microsoft Word, Excel and PowerPoint
    I can and will teach anyone who has a desire to learn basic digital skills. You will learn basic file management and how to use Microsoft Word, Excel and PowerPoint. You wi learn how to use Google applications as well as how to send Emails. This class will teach you the basic skills of how to use these application proficiently and efficiently. I will teach how to use MS Word to write letters and create a variety of documents from posters to party leaflets. I will tech you how to use Excel to create tables, charts and how to create formulas. You will also learn how to create presentations using PowerPoint. This is just the tip of the iceberg of what you will learn. Please contact me to see if we are a good fit.

    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.

    Ilias
    Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (children and teenagers)
    Whether you are asked to create a spreadsheet for maths or science assessments, a database of pupils, or an engaging presentation for a school project, Microsoft Office is usually your choice. The more you know about advanced capabilities of Office programs the more impressive your work can be. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Communication with Teams - Presentations with PowerPoint - 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.

    Amine
    Introduction to Office Tools: Microsoft Word, Excel and PowerPoint etc 💻
    Course description: Introduction to Office Tools 💼📊📎 This introductory office tools course is designed to provide participants with a solid foundation in the effective use of commonly used business software, such as Microsoft Word, Excel and PowerPoint, as well as other essential applications such as e -emails. 🖥️📧 Graduate teacher in Information Systems and Service Science (Bachelor) and holder of a Bachelor's degree in Computer Networks, as well as an M1 in Digital Systems and Services, I am passionate about teaching essential digital skills to succeed in the modern professional world. 🎓💻 This course covers the basics of creating professional documents, managing data, and designing visually appealing presentations, while emphasizing effective communication via email. By the end of the course, participants will have acquired the skills to use these tools confidently and effectively, improving their productivity and employability. 🚀📈