facebook
    Mahmoud
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    from20.00USD/ 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
    90 minutes
    The class is taught in:English, Arabic

    About Me

    Current PHD candidate, Cairo university
    Master degree 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

    Current PHD candidate, 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
    الإحصاء الوصفي انواع المتغيرات الجداول التكرارية مقاييس المركز مقاييس الانتشار مقاييس الالتواء عرض اليبانات متغير واحد عرض اليبانات متغيرين فترات الثقة لمعلمة سكانية واحدة ومعلمتين سكانيتين فرضية الاختبار لمعلمة مجتمعية واحدة ومعلمتين سكانيتين تحليل التباين ANOVA تحليل الارتباط تحليل الانحدار

    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 $20Online 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 $20Online 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


    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.

    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

    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.

    Morad
    Online Excel classes are designed for everyone, from beginners to advanced users.
    You want to boost your Excel skills and unlock the full power of spreadsheets? Our online Excel classes are designed for everyone, from beginners to advanced users. Learn how to organize data, create powerful formulas, generate charts, and streamline your workflow with ease. Led by expert instructors, our interactive lessons offer hands-on practice, covering everything from basic functions to advanced Excel techniques. Whether you're looking to improve your job performance, manage data more efficiently, or learn new skills, our flexible online classes allow you to learn at your own pace, from anywhere. Take control of your data—sign up for our online Excel classes today and become an Excel pro!

    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.

    Mowatin
    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.

    Nassim
    Microsoft Office (Word, Power-Point, Excel), preparation and learning
    This course is designed to provide comprehensive instruction and practice in all aspects of Microsoft Office. Whether you are a beginner starting from scratch or an advanced learner looking to advance your Microsoft Office skills, this course provides a supportive and dynamic learning environment. We will focus on the four core skills: Word, Power-Point and Excel. Through a variety of interactive activities, exercises and discussions, you will enjoy a comprehensive and engaging learning experience. Contact me.

    Patricia
    Microsoft Excel for beginners and intermediate, support with your Excel assignment or job
    Microsoft excel lessons for beginners and intermediates. I will take you from the start in learning excel. Whether or not using your own examples or projects. I teach you things like working with formulas, formatting, graphs, pivot tables, data logic, data editing. Support with your Excel assignment or project is also possible. In various functions I have gained experience with excel in recent years. I have also designed small applications. I taught myself the basic and advanced steps, after which I followed a small-scale and interactive expert training where mainly many tips and tricks were discussed.

    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

    Kamal
    Microsoft Excel: Operation, Formulas, Calculations, Macros...
    The purpose of this session is to allow the learner to understand the usefulness of Excel, to understand its principle and how it can be used at the school and professional level. It is also about Excel formulas, application exercise. contact me

    Doychin
    Excel for Beginners and Intermediates: Formulas, Charts and Pivot Tables
    Do you want to master Excel to save time and make better decisions? My courses, designed for beginners and intermediates, will teach you how to use key features effectively. My expertise in the Automotive industry will allow you to apply your new skills directly to your professional projects.

    Achref
    Master Excel with Flexible Online Classes – Start Today!
    Unlock the full potential of Excel with expert-led online courses tailored to your schedule. Whether you're a beginner or looking to sharpen your skills, our flexible classes are designed to meet your needs. Learn at your own pace with engaging, easy-to-follow lessons and hands-on practice. Don’t wait—start mastering Excel today and boost your productivity!"

    Salem
    Learn Microsoft Office: Courses for All Levels
    Expand your professional skills with our Microsoft Office courses! Whether you're a beginner or want to take your skills to the next level, our courses will guide you through the essential features of Word, Excel, PowerPoint, and Outlook. Learn how to create professional documents, analyze data, and deliver impactful presentations through interactive teaching methods and hands-on exercises. Maximize your productivity and prepare to excel in your career. Enroll today and turn your Microsoft Office proficiency into an essential asset!

    Samuel Oyakhilome Kwasi
    Data Analytics Tutorials -- Join the Data Dive: Your Guide to Excel, SQL, Power BI and Python
    Excel, SQL, and Python: Essential Tools for Data Analysts As a data analyst, mastering Excel, SQL, and Python is crucial for effectively extracting, manipulating, and analyzing data. This comprehensive course is designed to equip you with the practical skills needed to excel in these essential tools. Key areas of focus include: Excel: Learn advanced Excel techniques, including data manipulation, pivot tables, and data visualization. SQL: Gain proficiency in SQL for querying databases, extracting relevant data, and performing data analysis. Python: Discover the power of Python for data analysis, including data cleaning, manipulation, and visualization using popular libraries like Pandas, NumPy, and Matplotlib. Through hands-on exercises and real-world examples, you'll develop the confidence and expertise to tackle complex data analysis challenges and drive informed decision-making.