كورس اوفيس 2010 - اكسل - 6 - جزء 1 - تنسيق الخلايا

Formatting and Naming Cells in Excel

Introduction to Formatting

• The discussion begins with an overview of formatting for writing, numbers, or cells in Excel. The speaker emphasizes the importance of proper formatting for data presentation.

Naming Ranges for Easy Reference

• To facilitate continuous reference to specific parts of a table, the speaker suggests naming groups of cells. This allows users to easily select named ranges without repeatedly highlighting them.

• When naming a range, it is crucial to press "Enter" after typing the desired name; otherwise, the name will not be saved correctly.

• Users can access all named ranges through a dropdown menu in the Name Box, making it easier to manage large datasets.

Deleting Named Ranges

• If there are unnecessary names created, they can be removed using the Name Manager found under the Formulas tab.

• The speaker demonstrates how to delete a named range by selecting it and confirming deletion.

Applying Currency Formatting

Changing Cell Format to Currency

• The speaker explains how to format cells containing monetary values as currency by changing their format from General to Currency.

• Selecting Accounting format adds thousand separators and decimal points automatically for better readability of financial figures.

Adjusting Decimal Places

• Users can increase or decrease decimal places using icons that adjust visibility based on preference. This feature is often tested in ICDL exams.

Percentage Formatting

Indicating Percentages Clearly

• For cells representing percentages (e.g., percentage of total), it's important to apply percentage formatting so that viewers understand these values at a glance.

• The speaker highlights that when applying percentage formatting, Excel automatically adjusts decimal places based on calculations performed on those numbers.

Finalizing Formats and Functions

Adding Currency Symbols

• Users can choose different currency symbols (e.g., Euro, Dollar, Egyptian Pound) while ensuring that numerical operations remain intact.

Utilizing Functions for Data Analysis

Functionality in Excel: Calculating Averages and Dates

Using Functions to Calculate Values

• The speaker discusses using functions to determine the average of selected numbers by highlighting a range and pressing Enter, which calculates the average based on the selected cells.

• The minimum function is introduced, allowing users to select a range of cells to find the smallest number. After pressing Enter, this can be dragged across other columns for consistent application.

• The importance of formatting dates within an Excel file is emphasized, with a requirement for three specific dates: creation date, today's date, and a variable print date.

Managing Date Formats

• The "Printed On" date should automatically update each time the file is opened or printed, reflecting the current date at that moment.

• Various methods are available for accessing cell formatting options; right-clicking on a cell allows users to open formatting settings where they can adjust how data appears.

Formatting Numbers and Dates

• The first tab in the formatting window focuses on number formats. Users can choose between general formats or specific currency formats that include decimal points and thousand separators.

• Users can set their preferred date format while ensuring it remains unchanged if they have already specified one.

Inserting Today's Date Dynamically

• To insert today’s date quickly from the keyboard, users can press Control + K (or another shortcut), which inputs the current date into a cell.

• For dynamic dates that change every time the file is opened, users are instructed to use functions like NOW(), which updates automatically based on when the document is accessed.

Understanding Dynamic vs. Static Dates

• When using functions like NOW(), Excel prompts that its format may differ from previously set formats but will display both current time and date upon execution.