from20.00USD/ h
Data Analysis using Excel "Analysis and Visualization"
Translated by Google. Click to view original.
Module 1: Introduction to Data AnalysisUnderstanding 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
Skills:
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 universityMaster 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 universityMaster 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 EconometricsTeaching 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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from $20Online via webcam
100% Satisfaction Guarantee
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
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
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
Private lessons
in Cairo
Similar classes
Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBAAre 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 advancedLooking 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 ApplicationsExcel 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 PowerPointI 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 learningThis 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 jobMicrosoft 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 ClassesI 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 TablesDo 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 LevelsExpand 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 PythonExcel, 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.