facebook
    Mahmoud
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    from13.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 -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 £13.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 -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 £13.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


    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.

    Anas
    Private lessons in math - physics - chemistry - engineering science
    Hello dear students and participants, As a former teacher, I had the privilege of supporting more than 40 students over the past year in their academic progress. I teach the following subjects: mathematics, physics, chemistry, engineering sciences and Excel. Thanks to my personalized and structured approach, I help my students develop their skills, their self-confidence and their autonomy. By working with me you will learn: *Effective resolution methods, *Intensive practice of exercises, *Educational coaching adapted to your needs, *The development of summary revision sheets, *Career guidance to inform your future choices, *Practical practical work in engineering sciences, to anchor concepts in reality. At the same time, as an information technology consulting engineer, I have in-depth expertise in the technical field, with the ability to design and implement innovative solutions in complex environments. Passionate about aeronautics and piloting aircraft, I cultivate essential qualities such as rigor, discipline and rapid decision-making in dynamic environments. This passion fuels my teaching by adding a practical and inspiring perspective.

    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.

    Claudia
    Excel courses (beginner to professional) -- Office Suite -- Math -- Accounting
    Graduated with a master's degree in Finance and employed in a multinational, I teach Excel from beginner to professional level. The course, which will be sent at the end of the course, is given using PowerPoint support and tailor-made exercises. This course is adapted according to the needs of the student, both theoretically and practically. I can give lessons in French, English and Italian. I also help you carry out projects/work in accounting, mathematics, finance (to be seen together). Contact me for more info!

    Ilesanmi
    Computer Information Technology/ Learn to be a computer literate.
    Technology is now the order of the day, as a computer Instructor for over 10 years with many experiences, I would be happy to help you be a computer literate from beginner to professional. You will learn how to operate the computer starting from the mouse to the system unit. You will learn how to be a data analyst, you will learn so much about the AI tools which is now the popular to the world. I am also happy to adapt our session according to the topic you wish to cover, etc. I am very flexible, my only goal is to help you improve and be a computer literate.

    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.

    Ilias
    Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (children and teenagers)
    Whether you are asked to create a spreadsheet for maths or science assessments, a database of pupils, or an engaging presentation for a school project, Microsoft Office is usually your choice. The more you know about advanced capabilities of Office programs the more impressive your work can be. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Communication with Teams - Presentations with PowerPoint - 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.

    Milan
    Microsoft Excel (+ Word, Powerpoint and other Office applications)
    I offer Microsoft Excel tutoring for anyone looking to improve their skills, from high school students to aspiring professionals. Whether you’re just starting out and want to learn the basics like formulas, graphs, and pivot tables, or you’re more advanced and want to set up automated models, I’m here to help. You determine the curriculum: we can work on specific tasks, such as school projects or work-related analyses, but I can also put together a structured curriculum to build your skills step by step. For advanced users, I offer guidance in developing smart templates and models, so that you can perform analyses faster and more efficiently in the future. With my lessons, you will not only learn to understand Excel, but also to apply it practically to save time and make an impression. Suitable for anyone who wants to distinguish themselves with strong Excel skills! Besides MS Excel, we can also delve deeper into the other Office applications and how to create attractive presentations in Powerpoint or Word.

    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. 🚀📈

    Yasmine
    I have a Master 2 in Audit and management control, I offer Excel courses
    Excel lessons based on exercises. Learn to use formulas, pivots, useful shortcuts. Demonstration and practice via exercises. The lessons depend on the level of the student and depending on their needs, this can be adapted gradually. I have a Master 2 in Audit and Management Control and 10 years of experience in finance with multinationals (in different countries). As well as experiences in coaching and mentoring in international competitions for students.

    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

    Alberto
    Basic Excel - Intermediate - Advanced. Customized solutions. Oriented to Office Work or students.
    In this Course you will learn everything you need to know about Excel. To get your new job. Forms, functions, tables. dynamic tables. Queries. We can also automate your daily work. You will learn how to update your tables as you receive new information.

    Loren
    Microsoft Excel from basic to advanced - specific problem or lessons about various tools
    From simple sums to cost overviews and pivot tables, Excel is a powerful tool that has become an indispensable part of the workplace for many of us! Do you have a specific problem or would you like a general introduction to Excel? Feel free to message me!

    Hajar
    Computer courses in Office automation (Beginner, Intermediate, Advanced): "Word", "Excel", "PowerPoint"
    Throughout my engineering student studies, I worked on multiple projects which require mastery of office automation tools ("Word", "Excel", "PowerPoint", ...). I would therefore like to share my knowledge with you, whether you are a student or not, in order to introduce you to office automation, to train you, and to guide you in your projects.