categories: Business & Professional Skills
Level: General
Course Language: Arabic
Understand how to insert data into cells and format and resize cells. You will also learn to use different tools such as drop-down menus and command buttons.
Use key functions such as SUM, AVERAGE, and IF, as well as statistical analysis tools such as graphs and charts.
Define the properties of Excel functions and adjusts them according to needs, use formatting tools to organize data and avoid common errors.
Save a lot of time by using Excel shortcuts for every action you need to take.
Free lessons
Workbook\Worksheet\Cells\Formula bar
Analysis Formatting
Period Functions
Excel Data Proofing
IF statements
Formula Tracing
1. Excel Layout
Excel Layout Overview
Workbook\Worksheet\Cells\Formula bar
Excel Ribbon
Insert\layout\formula
2. Excel Settings
Excel Settings
Excel General Settings
Excel Formulas Settings
Excel Data Proofing
Excel Advanced Settings
Excel Add-ins
3. Basic Analysis
Analysis Objectives
Analysis Formatting
Page Break - Freeze Panes
Duplicate Sheets
Grouping
Anchoring
Name Manager
Formula Tracing
Conditional Formatting
4. Functions & Formulas
Functions and Formulas
Period Functions
Sum\Average\Count
IF statements
Multiply\Round\Absolute
Min\Max\Small\Large
IF error
Find and Replace
This course offers a comprehensive understanding of Excel for effective data analysis. You'll learn how big companies leverage data for strategic decisions and gain access to advanced Excel tools. From mastering basic tasks like data insertion and formatting to utilizing functions, statistical analysis, and charts, you'll handle Excel with confidence. Dive into practical techniques such as freezing pages, copying information, naming data, and tracing functions. Discover how to control and format data for readability and gain insights into Excel's general and advanced features. Moreover, you'll learn to discover and replace data accurately, enhancing your analytical skills. Excel is your gateway to proficient data analysis – start learning now!
1- a computer or laptop with Microsoft Windows. 2- Microsoft Excel 2016, Excel 2019, or Microsoft 365. 3- No Prior Excel Knowledge Required.
Business Intelligence Consultant
6,732 Learners
3 Courses