Udemybeginnerar

إكسيل 2019 للمبتدئين - المستوى الأول - Excel 2019 level 1

Learn Excel essentials! Master spreadsheets, formulas, and data analysis. Perfect for beginners to boost productivity. Start your Excel journey today!

4.7(330)
4,358students
1h 34m
Abdelrahman hashem
Abdelrahman hashemOrganizational skills trainer

Course Content

إكسيل 2019 للمبتدئين - المستوى الأول - Excel 2019 level 1 is a beginner-level Udemy course taught by Abdelrahman hashem. It runs 1h 34m and is taught in Arabic. Learners rate it 4.7 out of 5 from 330 reviews, with 4,358 students enrolled. It is free to enroll, first published March 2021.

Excel Fundamentals: Master the Basics & Beyond

Excel for Beginners: Level 1 - Essential Skills

This comprehensive course is designed for absolute beginners looking to learn Microsoft Excel from the ground up. Whether you've never used Excel before or are a complete novice, this course provides a step-by-step introduction to the core concepts and functionalities. You'll gain a solid foundation for using Excel effectively in your personal or professional life.

What You'll Learn in Level 1:

  • Understanding Excel Basics:

    • What is Microsoft Excel?
    • Navigating the Excel interface: screen components, hiding/showing elements, and understanding the workspace.
    • Key Excel terminology: Workbook, Column, Row, Cell, and the Active Cell.
    • Cell References: Understanding and using cell references (e.g., A1).
    • Saving, Opening, and Closing Workbooks.
    • Exiting Excel.
  • Working with Rows & Columns:

    • Selecting rows and columns using the mouse and keyboard.
    • Using cell references (names) for selection.
    • Selecting multiple contiguous and non-contiguous rows/columns.
    • Adding and deleting rows and columns.
    • Hiding and showing rows and columns.
    • Adjusting row height and column width.
  • Cell Manipulation:

    • Selecting single and multiple cells (Ranges).
    • Selecting cells in different locations.
    • Using mouse and keyboard to select cell ranges.
    • Using cell references to select cell ranges.
    • Inserting and deleting cells.
    • Distinguishing between deleting cells and clearing content.
    • Merging and unmerging cells.
    • Freezing panes for easy navigation.
  • Managing Worksheets:

    • Selecting worksheets.
    • Multiple worksheet selection methods.
    • Adding, deleting, and renaming worksheets.
    • Changing the default number of worksheets.
    • Hiding and showing worksheets.
    • Moving and copying worksheets within the same workbook.
    • Moving or copying worksheets to different workbooks.
    • Controlling the zoom level for optimal viewing.

Excel for Beginners: Level 2 - Data Entry & Formulas

Build upon your foundational knowledge with Level 2, focusing on data entry, formatting, and basic formulas. This level empowers you to organize, analyze, and manipulate data within Excel.

What You'll Learn in Level 2:

  • Text Data Entry:

    • Entering text data.
    • Entering multi-line text within a cell.
    • Modifying existing data.
    • Utilizing AutoComplete for efficient data entry.
    • Selecting data from Drop-down Lists.
    • Text alignment and wrapping.
    • Formatting text: adding borders and filling cells with color.
  • Numeric Data Entry:

    • Creating number scales (tells).
    • Applying various number formats: General, Number, Currency, Accounting, and Date.
    • Treating numbers as text.
  • Formulas & Calculations:

    • Understanding the structure of a formula.
    • Entering formulas within cells.
    • Automatic reference insertion.
    • Editing and modifying formulas.

This course provides a practical and accessible pathway to mastering Excel, equipping you with valuable skills for data management, analysis, and reporting.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.