facebook
    Mahmoud
    member icon
    Trusted teacher
    favorite buttonAdd to Wish List
    favorite buttonAdd to Wish List
    member icon
    Trusted teacher
    from18.32EUR/ h

    Data Analysis using Excel " Analysis and Visualization"

    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:
    Teenagers (13-17 years old)
    Adults (18-64 years old)
    Student level:
    Beginner
    Intermediate
    Advanced
    Duration:
    60 minutes
    90 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.
    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
    Descriptive statistics Types of variables Frequency tables Center dimensions Diffusion measures Torsion scales Display data in one variable The data display is variable Confidence intervals for one and two population parameters Test hypothesis for one population parameter and two population parameters Analysis of variance (ANOVA) Correlation analysis Regression analysis
    This course provides a comprehensive introduction to econometrics—the application of statistical methods to economic data. It equips students with the tools to model, estimate, interpret, and test economic relationships using real-world data. The course blends theory with hands-on empirical practice, emphasizing understanding the assumptions behind models, diagnosing issues like multicollinearity and heteroscedasticity, and making sound inferences. By the end of the course, students will be able to formulate econometric models, estimate parameters using regression techniques, interpret empirical results, and evaluate the reliability and limitations of statistical inferences in an economic context.

    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 -04: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 18.33€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 -04: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 18.33€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.

    Adil
    Master Microsoft Office with Personalized Online Private Classes! / ✔ Microsoft Word ✔ Microsoft Excel ✔ Microsoft PowerPoint
    Master Microsoft Office with Personalized Online Private Classes! Boost your productivity and professional skills with one-on-one online training in: ✔ Microsoft Word – Create polished documents, reports, and summaries. ✔ Microsoft Excel – Master formulas, charts, pivot tables, and data analysis. ✔ Microsoft PowerPoint – Design stunning presentations with advanced techniques. Why Choose Our Classes? ✅ Flexible Scheduling – Learn at your own pace. ✅ Customized Lessons – Tailored to your skill level and goals. ✅ Expert Trainers – Patient, experienced, and certified instructors. ✅ Practical Exercises – Hands-on learning for real-world applications. Perfect for students, professionals, and beginners!

    Sami
    Master Microsoft Office from Anywhere! Microsoft Word, Excel, and PowerPoint
    Are you looking to boost your productivity and enhance your professional skills? Unlock the full potential of Microsoft Word, Excel, and PowerPoint with personalized, one-on-one online classes tailored to your needs! Flexible Scheduling: Learn at your own pace, on your own schedule, from the comfort of your home or office.

    Nawfl
    Online Private Classes in Microsoft Word, Microsoft Excel and Microsoft PowerPoint
    Online Private Classes in Microsoft Word, Excel, and PowerPoint Boost your productivity and master essential office tools with personalized online training in: Microsoft Word – Learn document creation, formatting, advanced editing, and professional layout design. Microsoft Excel – Master formulas, data analysis, pivot tables, charts, and automation for business or personal use. Microsoft PowerPoint – Create stunning presentations with animations, transitions, and effective storytelling techniques. Why Choose Our Classes? ✔ One-on-one sessions tailored to your skill level ✔ Flexible scheduling to fit your availability ✔ Hands-on exercises & real-world examples ✔ Certification guidance (if needed) Ideal for students, professionals, or anyone looking to enhance their Microsoft Office skills efficiently. 📩 Contact us today to book your session!

    Mounir
    Private Online Excel & Word Classes / Master Excel and Word from the comfort of your home! Our personalized one-on-one online classes
    Unlock Your Potential: Private Online Excel & Word Classes Master Excel and Word from the comfort of your home! Our personalized one-on-one online classes are designed to help you gain confidence and proficiency. Whether you're a beginner needing basics, a student tackling projects, or a professional aiming to boost productivity, we tailor lessons to your specific goals. Flexible Scheduling Customized Curriculum Experienced Instructor Boost Your Skills, Boost Your Career!

    Yasser
    Elevate Your Skills: Online French Classes Tailored for You! \/ Speak French with Confidence
    Are you ready to embark on a journey to fluency? Our online French classes are designed for learners of all levels, from beginners to advanced speakers. With engaging lessons, experienced instructors, and interactive resources, you’ll build the skills you need to communicate effectively in French. Join a supportive community where you can practice speaking, listening, reading, and writing in a fun and dynamic environment. Whether you’re preparing for travel, work, or personal enrichment, our classes will empower you to express yourself with ease and confidence. Don’t let language barriers hold you back. Sign up today and take the first step toward speaking French fluently!

    Anwar
    🎓 Excel Training for Beginners 📊 Learn step by step to master the basics of Excel
    🎓 Excel Training for Beginners 📊 Are you new to Excel? This training is for you! Learn step by step to master the basics of Excel: ✔️ Creation of simple tables ✔️ Essential formulas and functions ✔️ Formatting and graphics ✔️ Time-saving tips 👩‍🏫 Clear, practical training accessible to all, even without any prior experience. 📅 Join us and boost your digital skills!

    Yassin
    Transform Your Life: Join Our Personal Development Assistance Courses Today!
    Are you ready to unlock your full potential and take control of your personal growth? Our Online Classes in Personal Development Assistance are designed to help you achieve your goals, boost confidence, and enhance your overall well-being. Whether you’re looking to improve time management, overcome challenges, or build better relationships, we offer practical tools and personalized support to guide you on your journey. Learn from experienced professionals at your own pace, from the comfort of your home. What You’ll Gain: - Enhanced self-awareness and emotional intelligence - Improved communication and interpersonal skills - Techniques to manage stress and foster resilience - Actionable strategies for achieving personal and professional goals Flexible, Affordable, and Empowering – start your transformation today! Enroll now to begin your journey to a better you.

    James
    Data and Statistical Analysis for beginners to Pro
    Data analysis is a valuable skill for students in many fields, from business and science to social studies. As a student, you'll need to understand how to collect, organize, and interpret data to support your research, class projects, or future career goals. I’ve designed this course as a hands-on introduction to data analysis that's made specifically for students. You’ll learn how to use tools like Excel, Google Sheets, and basic Python to clean data, create charts and graphs, and draw meaningful conclusions from real datasets. This class will help you build strong analytical skills that will not only boost your academic performance but also prepare you for data-driven world.

    Azzedine
    Become an expert in Microsoft Excel, Word, and PowerPoint, even from scratch!
    Boost your productivity and unleash your creativity with Microsoft Office: unleash your potential at every step! If you're looking for a solution to optimize your efficiency, boost your creativity, and increase your daily productivity, look no further than Microsoft Office. Why choose Microsoft Office? Express your creativity: With Word, Excel, PowerPoint, and more, you have 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 clever features. Available everywhere: Whether you're in the office, on the go, or at home, Microsoft Office is accessible across all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office revolution! Don't let everyday obstacles stand in the way of 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—beginner, intermediate, or advanced.

    Walters
    Applied Statistics for Economic Growth and Data-Driven Decision Making
    This class is designed to help students understand how to apply statistical tools and methods to real-world economic growth scenarios. Whether you're a beginner or looking to sharpen your data analysis skills, this course will walk you through the fundamentals of applied statistics, including descriptive and inferential statistics, regression analysis, and forecasting techniques—using Microsoft Excel. We will focus on interpreting economic data, identifying trends, and making data-driven decisions to better understand factors that influence economic growth. The class is practical and interactive, with examples drawn from global and regional economies to ensure relevance. By the end of this course, students will be able to: Analyze economic data using Excel Apply statistical methods to real-world economic issues Interpret results and present findings clearly Build confidence in working with quantitative data

    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.

    Linh
    Microsoft Office Basics: Word, PowerPoint, or Excel (Student’s Choice)
    In this single-session, hands-on class, students will choose one Microsoft Office program to focus on—Word, PowerPoint, or Excel—based on their individual interests or needs. Each session offers beginner-friendly instruction and practical exercises: Word: Learn how to create, format, and save professional documents PowerPoint: Design visually appealing slides and practice presentation tips Excel: Organize information, create simple formulas, and use basic charts No prior experience is needed. This class is perfect for those looking to build confidence using Microsoft Office for school, work, or personal projects.

    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.

    Angel
    Master Microsoft Excel, Word and PowerPoint On Line
    Do you want to master the most widely used tools in the professional and academic world? This class is for you! In my personalized tutoring sessions, you’ll learn how to use Microsoft Excel, Word, and PowerPoint from scratch or improve your current skills with real-life exercises tailored to your needs. 📘 What you’ll learn: Microsoft Excel -Essential formulas and functions (SUM, VLOOKUP, IF, etc.) -Pivot tables and charts -Automation with macros and conditional formatting -Data analysis and advanced features Microsoft Word -Professional document formatting -Creating indexes, tables of contents, and sections -Inserting images, tables, and objects -Designing academic or business documents Microsoft PowerPoint -Creating engaging presentations -Using themes, transitions, and animations -Inserting multimedia -Designing for professional impact 🎯 Method & format Fully personalized lessons based on your level (beginner, intermediate, or advanced) Learn by doing: practical exercises and real examples Support outside of class for quick questions 🧑‍🎓 Ideal for: Students who want to stand out in their assignments Professionals looking to boost productivity Anyone preparing for new job opportunities or interviews