from15.21EUR/ 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
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 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.
الإحصاء الوصفي
انواع المتغيرات
الجداول التكرارية
مقاييس المركز
مقاييس الانتشار
مقاييس الالتواء
عرض اليبانات متغير واحد
عرض اليبانات متغيرين
فترات الثقة لمعلمة سكانية واحدة ومعلمتين سكانيتين
فرضية الاختبار لمعلمة مجتمعية واحدة ومعلمتين سكانيتين
تحليل التباين 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?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | Friday at 3:00 | Saturday at 3:00 | |||||
4 | Friday at 4:00 | Saturday at 4:00 | |||||
5 | Friday at 5:00 | Saturday at 5:00 | |||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
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 | Monday at 16:00 | Tuesday at 16:00 | Wednesday at 16:00 | Thursday at 16:00 | Sunday at 16:00 | ||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 15.21€Online 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 -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | Friday at 3:00 | Saturday at 3:00 | |||||
4 | Friday at 4:00 | Saturday at 4:00 | |||||
5 | Friday at 5:00 | Saturday at 5:00 | |||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
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 | Monday at 16:00 | Tuesday at 16:00 | Wednesday at 16:00 | Thursday at 16:00 | Sunday at 16:00 | ||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 15.21€Online 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.
Muhammed
Mastering Engineering Software: Revit, SAP2000, ETABS, and AutoCAD"A Civil Engineer from Zagazig University, I have hands-on experience in using advanced engineering software such as Revit and Navisworks for Building Information Modeling (BIM), structural analysis and design tools like SAP2000, ETABS, and Robot, as well as AutoCAD for drafting and design. I am also proficient in Excel for data analysis and project management. With the ability to apply these tools in real-world projects, I can provide practical examples to help students better understand engineering applications. I aim to deliver an exceptional learning experience in engineering software to help students develop their technical skills."
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.
Anass
Computer and office training Word Excel and PowerPointHello,
You want to learn the basics of computers or how to use software such as Word, Excel or Powerpoint.
I will give you the skills you need to better understand the features of this software to write, for example, a document.
I will also give you advice on how to make the most of the internet, protect and back up your data, or on the day-to-day use of your computer.
Contact me.
Carlos Alberto
Clases de Excel básico e Intermedio Online para principiantesMicrosoft Excel es una herramienta poderosa que facilita la gestión y análisis de datos, optimizando nuestras tareas diarias de manera más eficiente. Dominar sus funciones no solo mejora la productividad, sino que también abre nuevas oportunidades laborales y profesionales.
En este curso, aprenderás desde los conceptos básicos, como abrir la aplicación y familiarizarte con su interfaz, hasta el uso de fórmulas esenciales y herramientas intermedias para la gestión de datos. Al finalizar, serás capaz de manejar Excel con mayor confianza y aplicar sus funciones para optimizar tu trabajo diario.
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.
Amine
Computer course for all levels , EXCEL, WORD, POWER-POINT, Coaching in Computer Science, Office AutomationI offer courses in computer science for different languages and frameworks also intended for students in classes preparatory and license in computer science. Tailor-made training adapted to the profile of each student whatever his difficulties, with a pleasure of teaching; academic orientation sessions, and then the addition of other subjects that I master is surely possible.
Josè
Master Learning&Training Innovation in the Italian language and mathematics disciplinesImprove 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.
Adil
Excel pour les débutants / Microsoft Excel pour les débutantsJe vous offre des séances pour apprendre l'excel.
Vous allez pouvoir apprendre des différents outils qui vont vous permettre de mettre des tableaux sur Excel.
Par ce cours, vous allez pouvoir calculer par des formules de calcul.
Qu'est ce que vous attendez?
Allez, réservez votre cours.
Salah
Learn MS (Word, Excel and PowerPoint) Microsoft Office / Expand your knowledge of Microsoft office!I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions
Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations...
Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc.
Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows...
I am waiting for your message.
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.
Azzedine
Use Excel, Word and PowerPoint for optimal performances and unlimited creativity!Boost your product and edit your creativity with Microsoft Office: Liberate all your capabilities to create this file!
Do I find a solution to improve your effectiveness, stimulate your creativity and increase your productivity at home? Don't share anything else with Microsoft Office.
Why choose Microsoft Office?
Explore your creativity: with Word, Excel, PowerPoint and other applications, you can find out which files you want to donate to your IDs, which is suitable for creating professional documents, creating calculus complexes or performing percutantes.
Turn on the high-temperature automation: Excel simplifies complex touches with intelligent formats, dynamic table rotations and intelligent functions.
Available part: If you travel to your office, place it or your home, access Microsoft Office to all your devices, you will be able to use it anywhere else.
Benefit from the Microsoft Office revolution!
Do not allow any obstacles to enter your progression. Invest in the Microsoft Office box to edit all your photos.
Transform your travel façon and lancez-vous facilement in new records with Microsoft Office. Inscribe your main content to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint to all of your children, which you can do now, in the future or later.
Said
Microsoft office : Excel / Word for everyone, Online sessionYes, 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.
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.