Data Analysis using Excel " Analysis and Visualization"

From 18.4 € /h

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 from Egypt

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.

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

Skills

Microsoft excel

Availability of a typical week

(GMT -05:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

استخدام برنامج SPSS في التحليل الإحصائي (مبتدئ - متقدم)

18.4 € /h

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

Data Analytics, Statistics, and Statistical Analysis

18.4 € /h

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

Matías

4.88

(84)

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.

Ilias

4.88

(84)

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.

Hajar

4.88

(84)

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.

Yanis

4.88

(84)

Repeater for over 8 years, my students are only improving their grades.

Satisfied or refunded!

Always save time for the student to bring exercises, theories, homework, failed tests and corrections ...
I am patient, used, cool, flexible and honest.

See you soon!

Zakaria

4.88

(84)

This training adapts to your needs: Several durations and methods are offered.
The objective is to master the 3 office software of the Microsoft suite. You assimilate the essential knowledge to use Word, Excel and PowerPoint: models, style, layout, tabulations, lists, simple and advanced calculations, functions, pivot tables, design of clear and dynamic presentations, mastery of transitions and animations, etc.

Salah

4.88

(84)

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.

Zahr

4.88

(84)

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.

Yassine

4.88

(84)

Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.

Yassin

4.88

(84)

Master Word, Excel & PowerPoint with Private Online Classes!
Boost your productivity and skills with one-on-one sessions tailored to your level and goals. Learn at your own pace—from beginner to advanced. Perfect for students, professionals, and job seekers!

✅ Personalized Lessons
✅ Flexible Scheduling
✅ Real Projects & Practical Skills

Book your class today and start mastering Microsoft Office!

Fatima

4.88

(84)

Master Microsoft Office, the essential tools of the professional world!

Do you want to gain efficiency and confidence with Excel, Word, and PowerPoint? Whether you're a beginner or already familiar with the basics, my customized course will guide you step by step to become independent and efficient.

What you will learn:
Excel: from data entry and formatting to advanced formulas, pivot tables, etc.

Word: Professional document creation, styles, table of contents, mail merge, and advanced layout.

PowerPoint: Design impactful presentations, animations, and visual storytelling techniques.

Why choose this course?
✔️ Adapted progression: from total beginner to advanced user, everyone progresses at their own pace.
✔️ Practical and personalized approach: concrete exercises linked to your personal or professional projects.
✔️ Flexible: online courses, individual
✔️ Complete educational support: documents, tips and personalized follow-up between sessions.
✔️ Certified expertise: experienced trainer with an engineering background and several years of professional training

Yassine

4.88

(84)

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!

Alishaan

4.88

(84)

This course is designed for learners ready to move beyond the basics and master advanced accounting principles. You will explore complex topics such as consolidated financial statements, auditing practices, cost accounting, and in‐depth financial analysis. Through practical examples and step‐by‐step guidance, the class equips you with the skills needed to interpret sophisticated financial data, strengthen decision‐making, and prepare for professional qualifications or career advancement in accounting and finance.

Laeticia

4.88

(84)

Hello,

I offer personalized courses in:
- Excel (basics, advanced functions, pivot tables, automation...)
- VBA (macros, automation, file optimization)
- Python (basics, scripts, data, programming logic)

I graduated from Paris-Dauphine University with a Master's degree in Economic and Financial Engineering, and I adapt my lessons to your level and objectives:
- Complete handling
- Help with a specific project or file
- Understanding of key concepts
Courses can be taken in person or online.
Feel free to contact me to discuss your needs or schedule an initial meeting!

Sheersh

4.88

(84)

These Microsoft Excel classes are designed to help students, freshers, and working professionals build strong Excel skills that are directly applicable in real corporate environments. The course focuses on hands-on learning, real business scenarios, and practical problem-solving rather than just theoretical functions.

With guidance from an industry professional currently working as a Pricing Analyst at Honeywell International, learners will gain exposure to how Excel is actually used in analytics, pricing, operations, and business decision-making.

What You Will Learn:

● Excel basics: interface, formatting, shortcuts, and productivity tips

● Data handling: sorting, filtering, data validation, and cleaning

● Core Excel formulas: IF, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS

● Advanced Excel techniques for analysis and reporting

● Pivot Tables & Pivot Charts for data summarization

● Dashboard creation using Excel

● Automation using formulas and Excel tools to reduce manual work

● Real-world use cases from finance, pricing, sales, and operations

● Best practices used in corporate reporting and decision support

Teaching Approach:

● Step-by-step explanation from basic to advanced level

● Practical exercises using real business datasets

● Focus on speed, accuracy, and efficiency

● Industry examples from global organizations.

● Personalized attention based on the learner’s background and goals

Who Should Join:

● Students and fresh graduates looking to build strong Excel skills

● Working professionals aiming to improve productivity and reporting

● Aspiring data analysts and business analysts

● Anyone who wants to use Excel confidently in real-world scenarios

By the end of the course, learners will be able to analyze data effectively, create professional reports and dashboards, automate repetitive tasks, and use Excel confidently in their academic or professional work.

John

4.88

(84)

Microsoft Excel is the most used tool in data analysis. having skills in Microsoft Excel gives you an upper hand in completing your work faster as well as landing a job faster than someone who doesn't have the needed skills.
Our online and in-person classes helps you acquire the skills as fast as possible for any industrial use