Microsoft Excel
Learn to Create Tables and Charts
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
1Learning 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
26K students39 courses
This course is part of the diploma
