Microsoft Excel
Learn to Create Tables and Charts
What you'll learn
- Get to know the program interface
- Enter data and create tables
- Write basic and advanced formulas
- Work with functions
- Format data with conditional and automatic formatting
- Sort and filter data
- Protect data and validate it
- Create charts and pivot tables
- Print and set up pages
About this course
This course explains how to build tables, run calculations and create charts with Microsoft Excel from scratch. It starts with getting to know the interface and adjusting the view, then entering data and creating your first table. After that come the basics of writing formulas and advanced formula skills, and working with functions. Next are basic formatting skills, conditional and automatic formatting, sorting and filtering data, protection and data validation rules, then charts and pivot tables. It ends with printing and page setup. The course suits anyone who needs to work with data and calculations at work, such as employees, accountants, business owners and people who prepare reports. You need no previous experience with the program, because the course starts from the interface and explains each skill with direct practice on the worksheet. By the end, you will be able to create spreadsheets, write formulas, use functions, analyze data with charts and pivot tables, and print your files in an organized way, ready to hand in.
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.
Learner reviews
- ★★★★★mohamed e.·منذ 1 شهرشاهد 100٪
هايل جدا ما شاء الله
- ★★★★★Mohammed E.·منذ 1 شهرشاهد 67٪
- ★★★★★mohammed a.·منذ 1 شهرشاهد 100٪
شرح ممتاز يغطي الاساسيات و الوظائف لاستخدام البرنامج بشكل محترف
- ★★★★★Mahmoud N.·منذ 1 شهرشاهد 55٪
- ★★★★★Hesham s.·منذ 2 شهرشاهد 100٪
رائع جدا وبسيط فى الشرح وبيوصل المعلومه بسلاسه
Course content
1Learning Microsoft Excel
11 lectures
- Getting to Know the Program Interface and Adjusting the ViewportIntroduces the Microsoft Excel interface: rows, columns and sheet limits, navigating with the End key, adding and deleting sheets, the status bar, and switching sheet direction to Arabic.33:17
- Data Entry and Creating Your First TableExplains entering data and building a first table in Excel, a salary table with tax and net pay, writing formulas that start with an equals sign, copying them, summing salaries, and replacing a word throughout the sheet.15:17
- Basics of Writing EquationsExplains formula basics in Excel: placing the tax rate in its own cell, using the dollar sign for absolute references so they do not change when copying, and referring to a cell in another sheet.14:47
- Advanced Skills for Writing EquationsCovers advanced formula skills in Excel: giving a cell a fixed name such as Tax, tracing cells related to a formula, controlling automatic calculation, showing formula text, and evaluating parts of a formula.11:18
- Working with FunctionsExplains using Excel functions and the rules for writing them, such as SUM to add cells, the average function, the IF function to choose a tax rate, counting functions for the number of students, and switching command language to English.31:39
- Basic Formatting SkillsExplains basic formatting in Excel: selecting the table header, aligning text horizontally and vertically, changing row height, adding borders and colors to the table, merging cells, and choosing Arabic or Hindi digit shapes.19:49
- Conditional Formatting and Automatic FormattingExplains Conditional Formatting in Excel to color cells by rules such as failing students or the top three, automatic table styles, and number formatting with decimals, thousands separators and currency symbols.14:53
- Sorting and Filtering DataExplains sorting and filtering data in Excel on a table treated as a database, the Filter tool, descending sort by total, advanced filtering with a criteria range, and the difference between conditions on one row or on separate rows.21:35
- Data Protection and Validation RulesExplains protecting an Excel file and Data Validation rules: setting a number range with input and error messages, a drop-down list, excluding cells from protection, and setting a password to open the file.16:44
- Charts and Pivot TablesExplains charts and Pivot Tables in Excel: sorting students by total, creating a Pivot Chart to show average subject scores per stage, editing the pivot table and formatting the chart.16:02
- Printing and Page FormattingExplains printing and page setup in Excel: freezing rows and columns so they stay visible, narrowing margins, adding a Header and Footer, choosing which pages to print, and print settings before sending the table to the printer.16:19
Instructor
Ahmed Hassan Khamis
This course is part of the diploma
