facebook
    Mahmoud
    member icon
    Trusted teacher
    favorite buttonAdd to Wish List
    favorite buttonAdd to Wish List
    member icon
    Trusted teacher
    from12.41GBP/ 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:
    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.
    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

    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 £12.41Online 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 £12.41Online 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
    Excel with Microsoft Office: Unlock Your Potential in the Gulf Region
    Do you aspire to maximum efficiency, limitless creativity and unparalleled productivity in the Gulf region? Let us guide you to excellence with Microsoft Office. Why Choose Microsoft Office? Harness Your Creativity: With Word, Excel, PowerPoint and more, you'll have powerful tools to bring your projects to life, whether creating corporate documents, developing cutting-edge financial tables or delivering presentations breathtaking. Save Time with Automation: Excel simplifies complex tasks with its smart formulas, pivot tables and many other innovative features. Accessible Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is available on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Do not accept compromises in your daily professional life. Invest in the power of Microsoft Office and unlock your full potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office. Register now to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint at all levels and drive your business to excellence in the Gulf region.

    Yassine
    Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint.
    Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.

    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.

    Safar
    Master Excel, Word & PowerPoint – Online Private Lessons Tailored to You!
    Master Excel, Word & PowerPoint – Online Private Lessons Tailored to You! Boost your productivity and confidence with personalized one-on-one online classes in Microsoft Excel, Word, and PowerPoint. Whether you're a beginner or looking to sharpen your skills, these private sessions are customized to meet your goals. 🔹 Learn at your own pace 🔹 Step-by-step guidance 🔹 Practical, real-world examples 🔹 Flexible scheduling to suit your routine Perfect for students, professionals, and anyone wanting to improve their digital skills. Book your session today and unlock the power of Microsoft Office!

    Zahr
    Master Excel Today: Private Online Classes for All Levels! / Transform Your Excel Skills: Private Classes at Your Convenience!
    Are you ready to take your Excel skills to the next level? Our personalized online classes are designed to meet your unique needs, whether you’re a beginner looking to learn the basics or an advanced user wanting to master complex functions. What We Offer: Tailored Learning: Customized lessons focused on your specific goals and areas of interest. Flexible Scheduling: Learn at your own pace from the comfort of your home, at times that work for you. Hands-On Practice: Engage in real-world projects and exercises to reinforce your skills. Expert Guidance: Benefit from one-on-one instruction with experienced Excel professionals. Join us today and become proficient in Excel! Sign up for your first class and start your journey toward mastering this essential tool.

    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!

    Ikrami
    Microsoft Office programmes (Word, Excel, and PowerPoint) / Online Private Classes
    I would guide you step by step to get familiarised with the tools of Microsoft Office programmes (Word, Excel, and PowerPoint) that you believe you might need to meet your purposes. Your level of experience will determine where we start and how we proceed through the course. Contact me

    Amine
    Moroccan Darija Distance Course: ONLINE!
    I give online Moroccan colloquial language lessons for all levels. Questions and answers are scheduled. The colors are not intended to be put in line. Ask your questions. Contact me for more information.

    Farass
    Online Private Classes in Excel for Beginners / Master Excel from the comfort of your home with personalized, one-on-one training!
    Online Private Classes in Excel for Beginners Master Excel from the comfort of your home with personalized, one-on-one training! Why Choose Our Excel Classes? ✅ Tailored for Beginners – No prior experience needed! ✅ Flexible Scheduling – Learn at your own pace. ✅ Hands-On Training – Practical exercises & real-world examples. ✅ Certification – Get a completion certificate to boost your resume. What You’ll Learn: 📊 Basic spreadsheet navigation & formatting 🔢 Essential formulas & functions (SUM, AVERAGE, IF, VLOOKUP) 📈 Creating charts & graphs 📑 Data sorting, filtering & basic analysis 💡 Time-saving tips & tricks How It Works: 1️⃣ Book a Session – Choose a convenient time. 2️⃣ 1-on-1 Live Training – Interactive lessons via Zoom/Teams. 3️⃣ Practice & Improve – Get assignments & expert feedback. Who Should Join? 🔹 Students 🔹 Professionals 🔹 Job Seekers 🔹 Small Business Owners 📩 Enroll Now! Limited slots available.

    Zakaria
    Training in office software that adapts to your constraints.
    This training adapts to your needs: Several durations and methods are offered. The objective is to master the 3 office software of the Microsoft suite. You assimilate the essential knowledge to use Word, Excel and PowerPoint: models, style, layout, tabulations, lists, simple and advanced calculations, functions, pivot tables, design of clear and dynamic presentations, mastery of transitions and animations, etc.

    Azzedine
    Develop your expertise in Power BI and Business Intelligence: Create impactful dashboards and professional data visualizations
    Whether you're involved in finance, management, planning, project management, human resources, or perhaps an ambitious student looking to hone your professional dashboarding skills, you've come to the right place. If you're looking for a solution that goes beyond the limitations of Excel and PowerPoint, then you've come to the right place: allow me to introduce you to Power BI. With Power BI, I offer you much more than just a tool. It's a gateway to interactive reporting, efficient data management, and advanced analytics. Here's what I can offer you: - Expert creation and management of interactive reports. - Careful transformation and cleaning of data for maximum accuracy. - Use of powerful DAX formulas for advanced data analysis. - Creation of custom visualizations and impactful dashboards. - Secure sharing and publishing of your reports for seamless collaboration. -Automation of repetitive tasks with Power BI & Power Query. Whatever your specific needs—whether they relate to professional projects, studies, or personal aspirations—I'm here to offer you a tailor-made solution. Together, we'll create a program tailored to your goals, guiding you through every step of your learning journey. Whether you're a beginner looking to master the basics or an expert looking to deepen your knowledge of data analysis, I'm here to provide the expertise and support you need to succeed.

    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

    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.

    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.

    Carlos Alberto
    Basic and Intermediate Excel Classes Online for Beginners
    Microsoft Excel is a powerful tool that facilitates data management and analysis, streamlining our daily tasks more efficiently. Mastering its functions not only improves productivity but also opens up new career and professional opportunities. In this course, you'll learn everything from the basics, such as opening the application and familiarizing yourself with its interface, to using essential formulas and intermediate tools for data management. Upon completion, you'll be able to use Excel with greater confidence and apply its functions to optimize your daily work.