facebook
    Mahmoud
    member icon
    Trusted teacher
    favorite buttonAdd to Wish List
    favorite buttonAdd to Wish List
    member icon
    Trusted teacher
    from18.45EUR/ 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.45€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.45€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


    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.

    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.

    Unlock the Power of Microsoft Office – Learn from a 30-Year Expert
    Have you ever wished you could use Microsoft Word, Excel, or PowerPoint with ease and confidence? Whether you’re starting from scratch or only know the basics, here is your chance to learn from someone who’s been mastering these tools for over three decades. I offer practical training tailored to absolute beginners and those wanting to boost their skills. You’ll learn how to: Create polished documents in Word – from simple documents to mail-merge Organize and analyze data in Excel – formulas, charts, and time-saving tips Design impactful presentations in PowerPoint – slides that impress, not bore Step-by-step guidance and hands-on practice that helps you work smarter, save time, and feel confident. Perfect for: - Students - Job seekers - Professionals upgrading skills Anyone who wants to get the most from Microsoft Office With my 30+ years of daily experience in Microsoft tools, I’ll help you avoid common mistakes, discover shortcuts, and develop skills that will serve you for life. Your journey from beginner to confident user starts here!

    Master Microsoft Office with Expert Online Private Classes! 🔹📝 Microsoft Word 📊 Microsoft Excel 🎨 Microsoft PowerPoint
    Master Microsoft Office with Expert Online Private Classes! 🔹 Boost your skills with one-on-one training in: 📝 Microsoft Word – Professional document formatting, tables, mail merge, reports, and more. 📊 Microsoft Excel – Formulas, functions, pivot tables, charts, data analysis, and macros. 🎨 Microsoft PowerPoint – Stunning presentations, animations, slide design, and storytelling. Why Choose Our Classes? ✔ Personalized Lessons – Tailored to your skill level & goals. ✔ Flexible Scheduling – Learn at your own pace, anytime. ✔ Practical Training – Real-world exercises & tips. ✔ Certified Instructors – Experienced & patient teachers.

    Unlock your full potential with personalized online private classes in Microsoft Excel, Word, and PowerPoint!
    Unlock your full potential with personalized online private classes in Microsoft Excel, Word, and PowerPoint! Whether you are a beginner eager to learn the basics or an advanced user aiming to enhance your skills, these one-on-one sessions are tailored just for you. Learn to create professional documents in Word, analyze data and automate tasks in Excel, and design stunning presentations in PowerPoint—all from the comfort of your home. Our expert instructors provide live demonstrations, hands-on practice, and real-world projects to ensure you gain practical knowledge quickly. Flexible scheduling, customized lessons, and continuous teacher support make mastering Microsoft Office easy and convenient. Perfect for students, professionals, and anyone looking to boost productivity and confidence with essential office tools. Book your private class today and start your journey to Microsoft Office mastery!

    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!

    Data Engineer – Mathematics, SQL, Power BI & Data Analysis Courses
    As a Data Engineer with 9 years of experience, I am passionate about teaching and sharing knowledge. I work with students of all levels (middle school, high school, and higher education) and adults in training or retraining. My strength: combining solid technical mastery and clear teaching to make the most complex concepts simple and accessible. 🔹 What I offer Mathematics: homework help, refresher courses, exam/baccalaureate preparation, in-depth study (up to high school level). SQL & Data: simple to advanced queries, optimization, concrete projects Power BI: interactive dashboard design, modeling, custom indicators Methodology & logic: work organization, reasoning, problem solving 🔹 My method Courses 100% adapted to your level and your objectives Clear explanations, concrete examples and immediate practical application Visual aids and personalized exercises Regular monitoring of progress 🔹 For whom? Middle and high school students wishing to consolidate their skills Higher education students (BTS, DUT, bachelor's, master's) Professionals retraining or wishing to improve their skills in data 📍 Online or home courses (depending on location) 🕒 Flexible – available evenings and weekends

    Course of marocain distance to all of our neighbors
    I don't want to eat anywhere near the distance to all our neighbors. I'll offer my children's memories at a distance from all around the world. I'm sure you will receive a solution and be supported by outils of the application for more efficaces. Pour plus information, contactez moy.

    Excel Training for Adults/Students from an Industrial Engineer with 5 Years of Excel Experience
    Students will first be asked which MS Office program they want to learn and why, and then given an initial test. This initial test will clearly identify the student's goals, and a personalized program will be developed based on the test analysis. For example, for someone who simply wants to learn Excel from scratch, they will first be taught the basics of Excel, and we will interactively work with them at their pace. Any topics they don't understand or need to review will be explained again. While I share my screen during class, I record the lesson and create recordings. This way, students can rewatch the recordings and review them if they wish. Furthermore, students will have lifetime access to the practice questions we cover during class and those I create for them afterward via Google Drive. After completing all courses, students will receive feedback at 1, 3, 6, and 12 months to reinforce the topics learned. Additional courses will be provided if necessary, ensuring ongoing learning. This program is for those who want to learn all Office programs, from those with no prior knowledge to those with limited knowledge. Anyone who is at an intermediate level and wants to take things further can enroll in this course. Our training will be remote, and the time and day will be discussed between the instructor and the student to determine a suitable time. I can also provide English instruction for those who wish to take the course in English.

    Online Private Classes in Microsoft Word, Excel, and PowerPoint
    Online Private Classes in Microsoft Word, Excel, and PowerPoint Boost your productivity and master essential office skills with personalized one-on-one online training in: Microsoft Word – Document formatting, tables, mail merge, and more. Microsoft Excel – Formulas, pivot tables, data analysis, and automation. Microsoft PowerPoint – Professional presentations, animations, and design tips. ✅ Flexible schedules ✅ Customized lessons ✅ Beginner to Advanced levels ✅ Certification guidance 📩 Contact us today to book your session!

    Learn Python, SQL and MySQL databases from beginner to Advanced Level | Certified Data Science Professional
    Learn Python SQL Power BI Excel Data Science Data Engineering Data Analytics Data Modeling Data Warehousing ETL API's Machine Learning Lecture will be Hands-on, beginner friendly, solving real world problems just like I do in my job. So, if you’re just starting out like college, university student, switching careers, or preparing for a job in data field — book a trial lesson, and let’s begin your journey together. I look forward to seeing you in class!

    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.

    Online Private Classes in Microsoft Office ✈ Microsoft Word –Excel –PowerPoint
    Online Private Classes in Microsoft Office Boost your productivity with personalized one-on-one online training in: Microsoft Word – Create professional documents, reports, and letters with advanced formatting and tools. Microsoft Excel – Master formulas, pivot tables, data analysis, and automation for business and personal use. Microsoft PowerPoint – Design engaging presentations with animations, transitions, and multimedia elements. Why Choose Our Classes? ✔ Flexible scheduling – Learn at your own pace. ✔ Customized lessons – Tailored to your skill level and goals. ✔ Hands-on practice – Real-world exercises for better retention. ✔ Certified instructors – Experienced trainers for effective learning. Perfect for students, professionals, and beginners! 📩 Contact us today to book your session!

    Private Accounting and Excel Classes on Sundays
    I teach all types of accounting and Excel at different levels at home in La Paz, UMSA Teacher, such as commercial accounting, services, and Excel I II III, which include the use of 3 books per level. If you want virtual classes, I also teach them.

    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.