Data Analysis using Excel " Analysis and Visualization"

Àpd 29.82 C$ /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

Lieu

En ligne depuis Égypte

Présentation

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

Expérience / 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

Adolescents (13-17 ans)

Adultes (18-64 ans)

Niveau du Cours

Débutant

Intermédiaire

Avancé

Durée

60 minutes

90 minutes

Enseigné en

anglais

arabe

Compétences

Microsoft excel

Disponibilité semaine type

(GMT -05:00)

New York

Cours par webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

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

29.82 C$ /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

29.82 C$ /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

Anas

4.75

(12)

>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.

>>> What about pedagogy?
I favor the learning by doing method

>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.

>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)

>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.

**** Excel Training (Beginner and Intermediate) ****

Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.

Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.

Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination

Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously

Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.

Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.

Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.

**** Excel Training (Advanced) ****

Part I: Configure Excel Options
Set up Excel options.
Customize the interface.

Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.

Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.

Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.

Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.

Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.

Matías

4.75

(12)

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.

Hajar

4.75

(12)

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

(12)

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

(12)

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

(12)

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.

Zahr

4.75

(12)

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

(12)

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

(12)

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

(12)

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

(12)

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!

Hélène

4.75

(12)

Bienvenue,

Vous débutez sur Excel et souhaitez apprendre simplement et efficacement ? 💻

Je vous guide pas à pas pour créer vos tableaux, utiliser les formules de base et gagner du temps dans votre travail.

Formatrice expérimentée en bureautique, je m’adapte à votre niveau et à vos besoins (pro, perso ou scolaire).

Cours en visio, clairs et concrets, avec exercices pratiques.

👩‍💻 Hélène

Laeticia

4.75

(12)

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!

Armstrong

4.75

(12)

Ce cours de bureautique de niveau débutant est conçu pour toute personne souhaitant acquérir les compétences de base nécessaires à l’utilisation d’un ordinateur et des logiciels bureautiques les plus courants. Il s’adresse aux débutants ou aux utilisateurs ayant peu d’expérience en informatique. À l’issue de la formation, les apprenants seront capables d’utiliser efficacement un ordinateur dans un contexte personnel, scolaire ou professionnel

Dona

4.75

(12)

Découvrez les fondamentaux de l’IoT, les architectures typiques (capteurs, passerelles, cloud), les protocoles de communication et les enjeux de sécurité. Ce cours couvre des cas pratiques pour concevoir et déployer des solutions IoT simples et sécurisées.
Ce cours introduit l’Internet des Objets (IoT) et ses fondements. Vous explorerez les composants typiques d’un système IoT (capteurs, actuateurs, passerelles, cloud), les flux de données et les méthodes de communication. À travers des projets pratiques, vous apprendrez à concevoir des solutions IoT simples et sécurisées, à collecter et analyser des données, et à déployer des prototypes fonctionnels