Udemybeginnerar

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

Learn Excel basics! Master essential skills for data management, analysis, and productivity. Perfect for beginners.

4.8(178)
2,681students
1h
Abdelrahman hashem
Abdelrahman hashemOrganizational skills trainer

Course Content

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

Excel Data Entry Essentials: Level 2 Course

This course builds upon foundational Excel skills, focusing on efficient and accurate data entry techniques. You'll learn to master the core functions for organizing and manipulating information within Microsoft Excel.

Level 1 Recap (Prerequisites):

  • Understanding Excel: Get acquainted with the Excel program interface and key components.
  • Navigating the Interface: Learn to show/hide window elements and worksheets.
  • Basic Terminology: Understand fundamental terms like workbook, column, row, and cell.
  • Cell References: Master cell references (A1, B2, etc.) and the concept of the active cell.
  • File Management: Learn to save, open, close, and exit Excel files.
  • Row & Column Management: Efficiently select, add, delete, hide/show, and resize rows and columns using the mouse, keyboard, and cell references.
  • Cell Manipulation: Select, insert, delete, merge, and unmerge cells. Understand the difference between deleting cell contents and emptying cells.
  • Worksheet Management: Select, add, delete, rename, hide/show, move, and copy worksheets. Control the zoom level.

Level 2: Advanced Data Entry Techniques

  • Text Data Entry:

    • Entering text data accurately.
    • Entering multi-line text within a cell.
    • Data editing and correction.
    • Utilizing AutoComplete for faster data entry.
    • Selecting data from drop-down lists.
    • Text alignment and wrapping.
    • Cell formatting: Applying borders and background colors.
  • Numeric Data Entry:

    • Creating number scales for data organization.
    • Applying various number formats:
      • General formatting.
      • Number formatting.
      • Currency formatting.
      • Accounting formatting.
      • Date formatting.
    • Treating numbers as text.
  • Formulas & Calculations:

    • Understanding the structure of formulas.
    • Entering formulas directly into cells.
    • Automatic reference insertion in formulas.
    • Editing and modifying formulas.
$ 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.