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

    Rony
    Master Microsoft Word, Excel and Powerpoint: Transform From a Beginner to a Pro!
    Microsoft Office is the most essential toolset for students, professionals, and anyone looking to improve their productivity. This beginner-friendly course will teach you the key skills needed to confidently use Microsoft Word, Excel, and PowerPoint for personal, academic, and professional tasks. In this course, you will learn how to: ✅ Microsoft Word – Create, format, and edit professional documents with ease ✅ Microsoft Excel – Organize data, use formulas, and create charts for better analysis ✅ Microsoft PowerPoint – Design stunning presentations with animations and transitions ✅ Use shortcuts and best practices to work more efficiently ✅ Collaborate with others using sharing and review features By the end of this course, you’ll have the skills to create polished documents, manage data effectively, and deliver engaging presentations. No prior experience is needed—just a desire to learn!

    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

    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.

    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.

    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.

    Jean Marc
    Excel course Word ACCESS PowerPoint general IT
    EXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.

    Azzedine
    Développez votre expertise en Power BI et Business Intelligence : Créez des tableaux de bord percutants et des visualisations de données pro
    Vous êtes impliqué dans les finances, la gestion, la planification, la gestion de projet, les ressources humaines, ou peut-être même un étudiant ambitieux désireux de perfectionner ses compétences en matière de tableau de bord professionnel. Si vous recherchez une solution qui va au-delà des limitations d'Excel et de PowerPoint, alors vous êtes au bon endroit : permettez moi de vous présenter Power BI. Avec Power BI, je vous propose bien plus qu'un simple outil. C'est une passerelle vers des rapports interactifs, une gestion efficace des données et une analyse avancée. Voici ce que je peux vous offrir : - Création et gestion experte de rapports interactifs. - Transformation et nettoyage minutieux des données pour une précision maximale. - Utilisation des puissantes formules DAX pour une analyse de données avancée. - Création de visualisations personnalisées et de tableaux de bord percutants. - Partage sécurisé et publication de vos rapports pour une collaboration sans heurts. -Automatisation des tâches répétitives avec Power BI & Power Query. Peu importe vos besoins spécifiques - qu'il s'agisse de projets professionnels, d'études ou d'aspirations personnelles - je suis là pour vous offrir une solution sur mesure. Ensemble, nous créerons un programme adapté à vos objectifs, vous guidant à chaque étape de votre parcours d'apprentissage. Que vous soyez un novice cherchant à maîtriser les bases ou un expert désireux d'approfondir vos connaissances en analyse de données, je suis là pour vous fournir l'expertise et le soutien nécessaires pour réussir.

    Josè
    Master Learning&Training Innovation in the Italian language and mathematics disciplines
    Improve yourself with the Italian language with mathematics applied to a good motivation. I am a native speaker in Italian and have been familiar with Excel for 25 years and have been motivated all my life. Let's develop together a growth path made of tangible results that you can use immediately on a practical level.

    Said
    Microsoft office : Excel / Word for everyone, Online session
    Yes, I know you want to learn Microsoft office like Excel, word and PowerPoint, so you can find everything you need about Microsoft office. I will teach you how draw tables in Excel and how to calculate using different formulas. I will teach you how to write a text using Word. I will teach you how present your projects using power point. Contact me.

    Salomé
    University graduate gives computer/excel/word/typing lessons
    A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services. Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location Educational and organized teacher with excellent revision and organizational techniques Microsoft Office - Excel/Word/PowerPoint - email - typing - ... Educational and patient with a good methodology adapted to each student 97% success rate with regular monitoring Feel free to contact me for more information! See you soon

    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.

    Ilias
    Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (adults)
    Whether you are asked to create a spreadsheet for statistical analysis, a database of customers, or an engaging presentation of a new product, Microsoft Office is usually your choice. Many users know the basics of what Office can do, but being aware of the more advanced capabilities of Office programs gives you many opportunities for impressive results. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Presentations with PowerPoint - Communication with Teams - 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. 🚀📈