categories: Technology, Science & Productivity
Level: General
Course Language: Arabic
Use formulas, and functions, and perform calculations, in addition to mastering the most important Google Sheet commands.
Design tables, graphs, and pivot tables in Google Sheets and various data formats.
Share the spreadsheet with the team and track changes as well as learn all the keyboard shortcuts associated with the program.
Free lessons
Google Sheets Overview
Google Sheets Interface
Data Selecting
Data Entry
1. Google Sheets Basics
Google Sheets Overview
Google Sheets Interface
Data Selecting
Data Entry
View options
Fill handle
Copy, Cut & paste
2. Calculations
Basic Formulas
Functions
Absolute cell references
3. Formatting
Font and format print
Alignment and styles
Insert objects
4. Sorting Data
Organizing the Spreadsheets
Filtering
Sorting
Conditional formatting
5. Charts & Sharing
Add a chart
Share with your team
Comments
Download and print
6. Text Functions
Concatenate function
Functions : Left , Right & Find
Case Functions (Upper , Lower , & Proper )
7. More Functions & Charts
Name Ranges
Count Functions
Countifs Function
Sumifs Function
More Charts
8. Pivot Tables
Creating a Pivot Table
Pivot Charts and Slicers
9. Data Valiation & Protection
Data Validation
Data protection
10. Conditional Functions
IF function
Logical Functions (AND , OR)
AND & OR with IF
Nested IF Functions
Spreadsheets are important programs in our lives that help us a lot in performing our daily tasks. Google Sheets is one of the best programs for this task, as it is one of the best alternatives to Excel. What distinguishes Google Sheet is that it is completely free and also online. You do not need to download anything to your device except that it is linked to Google Drive and saves everything automatically. In this course, you will be able to understand the most important tools of the program with ease, step by step. You will also learn techniques and methods that will help you save time and effort through a simplified and practical explanation. In addition, you will learn how to better display and easily modify your data with tables and graphs.
There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Engineer
1,263 Learners
4 Courses