IT & Software > Other IT & Software
12 h
£34.99 Free for 3 days
Master Microsoft Excel: From Beginner to Expert (Arabic)
What you will learn:
- Learn Excel basics, including navigation, worksheet organization, and data entry.
- Master basic formulas and functions for calculations and data analysis.
- Create charts and graphs for visual data representation.
- Learn advanced sorting, filtering, and data analysis techniques.
- Discover advanced features such as pivot tables, conditional formatting, and data validation.
- Learn how to automate repetitive tasks using VBA macros.
- Use Power Query for data transformation and merging.
- Gain hands-on experience with practical applications of Excel skills.
- Explore additional features and functions.
Description
Unlock the power of Microsoft Excel with our comprehensive Arabic course. This course transforms you from a complete beginner to a confident Excel expert, equipping you with in-demand skills for any career. We’ll cover everything from the basics of data entry and spreadsheet navigation to advanced techniques like pivot tables, data analysis, and VBA macro automation.
Learn how to efficiently manage and analyze data, create dynamic charts and graphs, and automate your workflows for increased productivity. We'll focus on practical examples and real-world applications relevant to business, finance, and project management, ensuring you can immediately apply what you learn to your own projects.
Our step-by-step approach guides you through each concept, building a solid foundation before moving onto more advanced functions and features. You'll gain a deep understanding of essential and advanced formulas, functions, and statistical analysis techniques, enabling you to create powerful and insightful reports.
Whether you're a university student, a business professional, a financial analyst, or an entrepreneur, this Excel course will provide invaluable skills for data-driven decision-making and streamlined workflows. Learn to effectively organize data, generate impactful reports, and boost your efficiency. Master Excel and unlock new opportunities!
Enroll now and embark on your journey to Excel proficiency. Master crucial data management and analytical skills with confidence and efficiency. Your path to Excel mastery starts here!
Curriculum
General Introduction
This introductory section welcomes you to the course and sets the stage for your Excel learning journey. The "Welcome to the Excel Learning Course" lecture (2:55) provides an overview and sets expectations for the comprehensive training ahead.
Level 1 - Basic Skills
The first level focuses on fundamental Excel skills needed by every user. The introductory lecture ("Introduction to Level 1," 0:46) provides a concise overview of the basics before moving into the core concepts.
Excel Overview
This section covers the fundamental aspects of Excel, including defining Excel itself, opening and saving files, navigating the interface, and understanding file management. Lectures cover: "Defining Excel" (0:41), "Opening the Program" (0:39), "Back-end Interface Components" (2:21), "Opening Files" (0:40), "Saving Files" (1:39), and "Changing the Program Language" (1:31).
Excel Interface and Worksheet Properties
Explore the Excel interface in detail, learning about the quick access toolbar, creating and managing worksheets, transferring sheets between files, and understanding cell coordinates. Lectures include: "Program Interface Components" (3:05), "Quick Access Toolbar" (3:28), "Creating Worksheets and Their Properties" (3:24), "Transferring Worksheets Between Files" (5:11), and "Cell Coordinates" (0:46).
Typing and its Properties
This section delves into the specifics of typing in Excel, including autofill functionalities. Lectures cover: "Typing in Excel" (0:38), "Autofill and its Properties" (3:35), and "Automatic Autofill" (1:55).
Modifying Cell Appearance
Learn how to customize the appearance of your cells, including alignment, size adjustments, and formatting. Lectures cover: "Changing Cell Appearance" (2:55), "Alignment Properties" (2:03), "Changing Cell Height and Width" (3:53), and "Copying Cell Formatting" (2:36).
Creating and Managing Tables
Master the art of table creation, modification, and data manipulation within Excel. Lectures include: "Loading Resources" (0:01), "Creating Tables" (2:57), "Adding and Deleting Rows and Columns" (2:53), "Data Selection and Navigation Properties" (2:47), "Inserting Tables" (2:37), "Adding Rows and Columns" (1:00), and "Data Partitioning Properties" (2:56).
Importing External Data
This section teaches you how to integrate data from various sources into your spreadsheets. Lectures cover: "Loading Resources" (0:01), "Introduction to Importing External Data" (0:24), "Importing CSV Data" (2:31), "Importing Data from a Website" (2:41), and "Importing Data from an Image" (1:34).
Mathematical Operations
Learn to perform calculations in Excel, from basic arithmetic to more complex formulas. Lectures cover: "Loading Resources" (0:01), "Using the Calculator" (2:07), "Multiplication" (1:50), "Division" (0:38), "Addition" (0:46), "Subtraction" (0:58), "Combining Mathematical Operations" (2:37), and "Adding a Constant to a Calculation" (0:42).
Charts and Graphs
Visualize your data effectively using various chart types. Lectures cover chart creation, customization, and data representation using various chart types such as bar charts, pie charts, scatter plots, line charts, and more. A comprehensive exploration of various chart types and options is included.
Inserting Shapes and Images
Enhance your spreadsheets with shapes and images to improve visual communication. Lectures cover: "Inserting and Resizing Shapes" (3:40), "Formatting Text in Shapes" (2:17), "Shape Alignment - Part 1" (1:58), "Shape Alignment - Part 2" (3:21), "Arranging and Grouping Shapes" (3:06), and "Inserting and Resizing Images" (6:30).
Sum Functions
Master essential sum functions for data aggregation. Lectures cover: "Loading Resources" (0:01), "Defining Functions" (1:57), "SUM Function" (4:42), "SUMIF Function (Single Criterion)" (3:45), "SUMIFS Function (Multiple Criteria)" (3:35), and "SUMPRODUCT Function (Calculating Value)" (1:37).
Number Functions
A comprehensive look at various number functions to perform calculations and data manipulation on numerical data.
Lookup Functions
This section teaches you how to efficiently search for data within your spreadsheets. Lectures cover: "Loading Resources" (0:01), "VLOOKUP (Vertical Lookup)" (3:24), "HLOOKUP (Horizontal Lookup)" (1:57), "INDEX/MATCH Lookup Functions" (4:17), and "XLOOKUP Function" (1:43).
Text Functions
Learn to manipulate and analyze text data effectively using a wide range of text functions.
Conditional Functions
Master conditional functions to perform calculations based on specified conditions. Lectures cover: "Loading Resources" (0:01), "IF Function" (2:21), "Nested IF Function" (3:58), "IFS Function (Multiple Conditions)" (1:51), "IF+AND Function" (2:30), "IF+OR Function" (2:03), and "IF+NOT Function" (1:37).
Date Functions
This section covers the use of functions to work with dates and times within Excel.
Miscellaneous Functions
Explore a range of additional functions to enhance your Excel skills. Lectures cover: "Loading Resources" (0:01), "SEQUENCE Function" (2:36), "SORT Function" (2:27), "FILTER Function" (1:56), "UNIQUE Function" (2:10), "ISNUMBER, ISTEXT, ISBLANK Functions" (2:35), "TRANSPOSE Function" (0:55), and "HYPERLINK Function" (1:21).
Function Properties
Dive deeper into understanding function properties and troubleshooting techniques. Lectures cover: "Loading Resources" (0:01), "Nested Function Property" (2:35), "Methods for Modifying Functions" (1:21), "Showing Previous and Next Element" (2:04), "Function Evaluation" (1:50), "Spy Window" (2:01), "Main Types of Function Errors" (7:08), and "IFERROR Function" (2:43).
Freezing Cells, Rows, and Columns
Learn to freeze parts of your spreadsheet for easier navigation and viewing of large datasets. Lectures cover: "Loading Resources" (0:01), "Freezing Cells" (2:16), "Freezing Rows" (3:19), "Freezing Columns" (2:31), and "Unfreezing Cells" (1:18).
Modifying Cell Content Appearance
This section shows you how to format cell content as different data types, such as numbers, dates, times, and percentages. Lectures cover: "Introduction to Cell Content Appearance" (0:40), "Number Format" (2:41), "Date Format" (1:53), "Time Format" (1:30), and "Percentage Format" (0:55).
Level 2 - Advanced Skills
This level focuses on more advanced techniques for data organization and analysis.
Data Sorting
Learn different methods for efficiently sorting your data. Lectures cover: "Loading Resources" (0:01), "Sorting Data by Value" (2:23), "Sorting Data by Color" (2:18), and "Sorting Data by Priority" (3:17).
Data Filtering
Master the art of filtering data to isolate specific information. Lectures cover: "Loading Resources" (0:01), "Data Filtering - Part 1" (2:33), "Data Filtering - Part 2" (1:04), "Text Filtering Properties" (3:37), "Number Filtering Properties" (3:15), "Date Filtering Properties" (4:08), "Color Filtering Properties" (0:49), "Using the Search Bar" (1:33), "SUBTOTAL Function" (3:04), and "Sorting Data Using Filtering" (1:31).
Data Grouping
Learn how to group and summarize data for clearer insights. Lectures cover: "Loading Resources" (0:01), "Data Grouping Properties" (4:00), "Subtotals" (3:00), and "Subtotals Function (Reminder)" (3:37).
Search and Replace
Learn how to efficiently find and replace data within your spreadsheets. Lectures cover: "Loading Resources" (0:01), "Search Properties - Part 1" (1:56), "Search Properties - Part 2" (1:04), "Replace Properties - Part 1" (2:08), and "Replace Properties - Part 2" (2:03).
Paste Special
Master the 'Paste Special' function for advanced data manipulation. Lectures cover: "Loading Resources" (0:01), "Principle of Relative Values" (1:53), "Pasting Values" (1:56), "Pasting Cell Formatting" (1:28), "Pasting Summation and Subtraction" (2:26), "Pasting Multiplication and Division" (1:12), "Converting Rows to Columns and Vice Versa" (1:08), and "Keyboard Shortcuts" (1:01).
Data Validation
Learn techniques to ensure the accuracy of data entry. Lectures cover: "Loading Resources" (0:01), "Defining Data Validation" (0:26), "Validating Numbers" (3:53), "Data Validation Messages" (3:39), "Dropdown Lists" (2:02), "Validating Dates" (3:05), "Validating Times" (1:12), "Validating Values" (2:44), and "Showing Incorrect Data" (1:33).
Pivot Tables
Master pivot tables for powerful data summarization and analysis. Lectures cover: "Loading Resources" (0:01), "Defining Pivot Tables" (0:19), "Creating Pivot Tables" (1:09), "Pivot Table Components" (1:04), "Adding Data" (3:10), "Data Organization" (1:44), "Adding Rows, Columns, and Their Properties" (3:15), "Data Filtering" (1:46), "Sum and Count Properties" (1:38), "Grouping Numerical Data" (2:28), "Grouping Date Data" (3:34), "Grouping Text Data" (1:37), "Updating Pivot Tables" (1:16), "Adding New Items to the Database" (1:38), "Showing Details of a Specific Value" (0:54), "Changing the Appearance of Pivot Tables" (1:49), and "Pivot Charts" (4:31).
Duplicate Values
Learn techniques for identifying and managing duplicate values within your spreadsheets. Lectures cover: "Loading Resources" (0:01), "Showing Duplicate Values" (3:12), and "Deleting Duplicate Values" (3:34).
Conditional Formatting
Use conditional formatting to visually highlight specific data points based on defined conditions. Lectures cover: "Loading Resources" (0:01), "Introduction to Conditional Formatting" (0:26), "Conditional Formatting - Part 1" (5:43), "Conditional Formatting - Part 2" (2:25), "Conditional Formatting - Part 3" (3:00), "Custom Formats - Part 1" (3:26), "Custom Formats - Part 2" (5:04), "Custom Formats - Part 3" (1:49), "Custom Formats - Part 4" (2:36), and "Custom Formats - Part 5" (2:42).
Freezing Rows and Columns
This section covers the freezing of rows and columns to maintain visibility while working with large datasets. Lectures cover: "Loading Resources" (0:01), "Freezing Rows" (1:16), "Freezing Columns" (0:50), and "Freezing Rows and Columns" (2:18).
Level 3 - Professional Features
This level delves into advanced professional features for efficient Excel usage.
Text to Columns and Flash Fill
Learn to efficiently convert text data into columns and utilize the Flash Fill feature for quick data entry. Lectures cover: "Loading Resources" (0:01), "Converting Text to Columns" (2:37), and "Flash Fill Feature" (1:51).
What-If Analysis
Use what-if analysis techniques to explore different scenarios and data outcomes. Lectures cover: "Loading Resources" (0:01), "Introduction to What-If Analysis" (0:27), "Goal Seek" (4:35), "Scenario Manager - Part 1" (6:47), "Scenario Manager - Part 2" (4:20), "Introduction to Data Tables" (1:24), "Data Tables - Part 1" (2:38), "Data Tables - Part 2" (4:48), "Introduction to Solver" (1:55), "Using Solver - Part 1" (4:52), "Using Solver - Part 2" (2:10), and "Using Solver - Part 3" (5:25).
View Tab Properties
Explore various properties within the View tab for advanced customization options. Lectures cover: "View Tab - Part 1" (2:26), "View Tab - Part 2" (1:54), "View Tab - Part 3" (6:17), and "Showing and Hiding Tabs" (1:29).
Hyperlinks
Learn how to incorporate hyperlinks into your spreadsheets for seamless data connection. Lectures cover: "Loading Resources" (0:01) and "Hyperlinks" (4:52).
Notes and Comments
Learn how to add and manage notes and comments to enrich your spreadsheets. Lectures cover: "Loading Resources" (0:01), "Notes and Their Properties" (1:57), and "Comments and Their Properties" (3:18).
Grammar Checker
Use the built-in grammar checker to improve the quality of your text-based data. Lectures cover: "Loading Resources" (0:01) and "Grammar Checker" (3:00).
Printing and its Properties
Master printing techniques for effective output. Lectures cover: "Loading Resources" (0:01), "Page Layout Options for Printing" (2:56), "Adjusting Column Width" (2:21), "Printing the Page Horizontally" (0:52), "Modifying Page Margins" (1:38), "Changing Page Scale" (1:41), "Centering Margins" (1:33), "Printing All Columns on One Page" (1:36), "Printing Selected Cells" (1:07), "Printing Specific Pages" (1:13), "Repeating Header Row" (1:54), "Adding Headers" (3:00), "Adding Footers" (1:36), and "Starting the Print Job and its Properties" (1:37).
File and Cell Protection
Secure your spreadsheets using file and cell protection features. Lectures cover: "Loading Resources" (0:01), "Protecting Files" (2:16), "Protectibility Property" (1:13), "Protecting Worksheets" (1:44), "Protecting Workbooks" (1:34), and "Protecting Cells" (3:22).
Keyboard Shortcuts
Learn essential keyboard shortcuts to speed up your workflow. Lectures cover: "Keyboard Shortcuts - Part 1" (3:39) and "Keyboard Shortcuts - Part 2" (7:55).
Recovering Unsaved Files
Learn how to recover unsaved work to prevent data loss. Lectures cover: "Recovering Unsaved Files" (3:09).
VBA and Macros
This section introduces VBA and macro programming to automate tasks. Lectures cover: "Introduction to Macros and VBA" (1:44), "Developer Tab" (0:52), "Recording Macros" (3:58), "Relative Property" (3:22), "Recording Macros with Different Commands" (3:31), "Saving Macro Files" (0:59), "VBA Code Components - Part 1" (5:28), and "VBA Code Components - Part 2" (4:46).
Using Power Query
Learn to use Power Query for data transformation and integration. Lectures cover: "Loading Resources" (0:01), "Power Query Introduction" (0:27), "Getting Data" (2:37), "Power Query Interface" (2:17), "Data Transformation - Part 1" (4:31), "Data Transformation - Part 2" (5:37), "Saving and Transferring Data to Excel" (2:30), and "Updating Data" (2:39).
Exercises
Practice your skills with a series of exercises. This section contains 10 exercises, each with a corresponding solution video. The duration of each exercise video and solution video is given in the curriculum.
Conclusion
This final section congratulates you on completing the course.
Course Bonus
This bonus section introduces dashboard creation and includes lectures on background setup, adding numbers using text boxes, adding charts, adding maps, adding data filtering tools and data updating techniques.
Deal Source: real.discount