Microsoft Excel

Learn to Create Tables and Charts

4.8(73)3h 31m11 lectures1 sections

What you'll learn

Understand Excel interface and settings
Master data entry and table creation
Use functions to handle data efficiently
Create charts for data analysis
Design pivot tables for data insights
Apply calculations using Excel

About this course

Excel is one of the most important programs available, specializing in designing tables, performing calculations, and preparing various types of reports. It is an essential tool for every computer user, despite being classified as accounting software. This course is your pathway to learning how to use its core features step by step without complications. You will explore the worksheet, learn how to create tables, write formulas, perform calculations, and discover how to extract reports and create charts.

Expected outcomes

Ability to create professional spreadsheets using Excel.
Format data and use functions and formulas efficiently.
Analyze data using charts and pivot tables.
Prepare documents for printing and format pages meticulously.

Course content

Learning Microsoft Excel

11 lectures

Getting to Know the Program Interface and Adjusting the Viewport33:17
Data Entry and Creating Your First Table15:17
Basics of Writing Equations14:47
Advanced Skills for Writing Equations11:18
Working with Functions31:39
Basic Formatting Skills19:49
Conditional Formatting and Automatic Formatting14:53
Sorting and Filtering Data21:35
Data Protection and Validation Rules16:44
Charts and Pivot Tables16:02
Printing and Page Formatting16:19

Instructor

Ahmed Hassan Khamis

He has developed computer science curricula for various Arab universities and taught at Alexandria University. He has authored over 120 educational books in computer science.

90.7K students39 courses

This course is part of the diploma

4.6(64)|5
Diploma in Computer Basics
5 courses
$59.99
Build your future now

Related courses

4.3(87)|864|7h 7m
Big Data
How to Analyze Big Data
Eng. Amr Abdel Fattah
$25.99
Start your journey now
4.9(62)|654|19h 31m
Geographic Information Systems with ArcMap
A Powerful Tool for Geographic Data Analysis
Imada Awda
$19.99
Start your journey now
4.8(99)|918|9h 52m
Statistical Analysis Using SPSS
Master All Types of Statistical Analyses
Dr. Samira Abu Radi
$25.99
Start your journey now
4.7(69)|966|4h 50m
Statistical Analysis with Power BI
Make Better Decisions Based on Data
Mohamed Khalaf
$19.99
Start your journey now