ملاحظات المحاضرة: إكسل 2016

Lecture Notes: Microsoft Excel 2016

• Excel 2016 is a spreadsheet program part of the Microsoft Office suite.
• It's used to input and process numerical and textual data.
• It has extensive built-in functions, including mathematical, trigonometric, text-based, time/date, and logical functions.

Starting Excel

• Launch from the taskbar or a shortcut.
• The interface displays recently opened files ("Recent").
• There's an option to "Open other workbooks" to open pre-existing Excel files.
• The right side features a search bar for finding online templates.
• "Blank workbook" creates a new, empty Excel document called "Book1".

Main Excel Interface

• The interface is similar to Microsoft word .
• Title bar includes zoom, minimize, and close buttons plus the current file and application names.
• Quick Access Toolbar (QAT) can be shown below the tabs.

Ribbon Display Options

• Auto hide ribbons: Hides all ribbon content, leaving only the blank document page.
• Show tabs: Displays tab names only, not the contained commands.
• Show tabs and commands: Displays both tab names and their commands.

Formula Bar and Name Box

• Formula bar below the tabs; accepts formulas, functions, and data input.
• Name box to the left, shows the current active cell.

Working with Sheets

• An Excel file contains multiple worksheets (called "sheets") by default.
• Add new sheets using the plus button near the sheet tab.
• Each sheet has rows and columns.
• Active cell is highlighted and its name appears in the name box.
• Active sheet is where work is currently done.

File Tab Features

• Info: Provides complete file information (size, name, creation date, etc.).
• New (CTRL + N): Creates a new file.
• Open (CTRL + O): Opens an existing file.
• Save (CTRL + S): Saves an existing file; prompts for location and name if it's a new file.
• Save As (F12): Creates a copy of a file (either at the same location with a new name, or in a different location).

Print and Export

• Print (CTRL + P): Prints the document with options for copies and printer type.
• Export: Exports the file to other formats (e.g., PDF).
• Close (CTRL + W): Closes the current file.

Data Entry

• Method 1: Double-click the cell and enter data; press Enter to save the input.
• Method 2: Double-click on the Formula bar; enter data and press the input button next to the formula bar to save.

Data Formatting

• Font Formatting: Modify using the Home tab (e.g., font type, size, color, style).

Hiding and Unhiding Rows, Columns, and Sheets

• Hide rows/columns: Right-click row/column header, select Hide.
• Unhide rows/columns: Select the row/column(s) before and after the hidden section and select Unhide from the context menu. Also, you can select visibility, then format.
• Hide Sheet: Right-click sheet tab, select Hide.
• Unhide Sheet: Select File > Info, then click the ellipsis and select the hidden sheet.

Deleting Rows, Columns, and Sheets

• Delete Rows/Columns: Right-click row/column header and select Delete; or, select the row/column(s) and select Delete from the Home tab.
• Delete Sheet: Right-click on the sheet tab and select Delete .

Clearing Data and Formatting

• Clear Content: Removes cell contents.
• Clear Formats: Removes formats but not contents.
• Clear Comments: Removes any comments added to the specific cell.
• Clear All: Removes all contents, formats, and comments.

Controlling Row Height and Column Width

• Row Height : Right-click on the top of the row, and select row height in the context menu.
• Column Width: Right-click on the top of the column.

Conditional Formatting

• Applies formatting based on a condition (e.g., values greater than, less than, between, or equal to a certain number).

Functions

• Functions are predefined formulas that perform specific tasks on data.
• They are categorized by type (mathematical, logical, statistical, text, etc.).
• Use the "Insert Function" feature in the "Formulas" tab.
• Common functions include MAX, MIN, SUM, AVERAGE, COUNT, COUNTA, and IF functions.

Microsoft Word Lecture Notes

• Word is a word-processing application in the Microsoft suite.
• Used to create, edit, and print documents.
• Can also include tables, diagrams, images, and decorative text.
• User-friendly interface, making document creation simple.

Microsoft Word Features

• Multi-language support (Arabic and other languages).
• Spell and grammar check functionality.
• Page setup options (margins, orientation, paper size, printing, creating multiple pages and reversed margins).
• Applying formatting to text such as font type, size, color, alignment, and background.
• Adding images, shapes, charts, diagrams.
• Creating and formatting tables and applying sorting.
• Searching and replacing text in the document.
• Security features to protect documents (password protection).
• Saving as a web page or a template for reuse.
• Document preview before printing.
• Managing references and citations.

Running Word

• Locating Word on the Windows start menu (either by direct selection or search).
• Specific features are in different parts of the interface.
• Default file extension for word documents is DOCX.

Word Interface Elements

• Title Bar: Displays the document title and application name.
• Ribbon: A toolbar containing different tabs (e.g. Home, Insert, Design, Layout..)
• Quick Access Toolbar (QAT): Contains frequently used commands.
• Insertion Point: The blinking cursor where text is entered or other items are added.
• Work Area: The main document area.
• Status Bar: Provides information about the document, such as page count, word count, and language.

Ctrl + Z and Ctrl + Y

• Ctrl + Z: Undoes the last action.
• Ctrl + Y: Redoes the last action.

Word Ribbon

• A collection of menus, each containing groups with multiple tools.

Insertion Point

• The location where text is inserted.

Work Area

• The main space for working on the document.

Scroll Bars

• Used to navigate through the document if it's too large for the screen.

Using Delete and Backspace

• Deleting text: Delete removes from the right of the pointer. Backspace removes from the left of the pointer.

Microsoft PowerPoint 2016

• A presentation software in Microsoft Office.
• Used for creating presentations (lectures, discussions, meetings etc)

Starting PowerPoint

• The program can be opened through the Start Menu by searching for it or from a shortcut
• Using Start and searching for PowerPoint
• Method 2 : Opening it from a shortcut on the Desktop

Main PowerPoint Interface

• Ribbon: It plays an important role in utilizing the features offered by PowerPoint such as
• File Tab: Contains general settings for the presentation. It has important options such as
• Home Tab: for text formatting and inserting images, shapes, tables, charts, and other items.

Insert Tab

• Used to insert different elements into the presentation.

Design Tab

• Used to format, customize, and apply themes to the slides.

Transitions Tab

• Used to add animations and transitions for a smooth transition effect between different slides

Animations Tab

• Used to add animations to individual items within slides like texts or images.

Presentation View Tab

• Used to make specific settings for displaying, viewing, and presenting slides with details on the display and timing.

Review Tab

• Contains options for spellchecking, language translations, and checking for errors.

View Tab

• Displays options for viewing the presentation in different modes.

Add-ins Tab

• Used to add and manage add-ins to extend PowerPoint's functionality.

Help Tab

• Contains helpful instructions and information on how to use the program.

General Information

• Files have a specific extension (.pptx).
• Presentations can be saved as different formats (e.g., PDF, video)
• Features for adding multimedia, tables, charts, animations, and other elements.

Microsoft PowerPoint 2016 - Shortcuts

• New Presentation (Ctrl+N)
• Insert new slide (Ctrl+M)
• Copy current slide (Ctrl+D)
• Create hyperlink (Ctrl+K)
• Start presentation (F5)
• Stop presentation (Esc)
• Using Windows + Numbers (1-9): Open the desktop and start running applications.

Internet

• Internet is a large computer network made up of smaller networks.
• Enables users to surf the web and gain information.
• Primary services include e-mail and browsing.
• Key terms include LAN, WAN, MAN.
• Protocols consist of TCP/IP, FTP.
• Protocol HTTP is essential for transferring Web pages and other forms of documents.
• A web browser is a software application, such as Chrome, Firefox, or Edge that allows users to connect to and view web pages.
• The language used to create these pages is HTML.
• Web servers are computer systems that hold Web pages.
• A web address or URL has specific formats.

Network devices

• Modem.
• Router.
• Switch.
• Hub.

Internet Services

• Browsing.
• E-mail.
• Chatting.
• Newsgroup.
• File Transfer.
• Remote Connection (Telnet).
• Online Shopping.

Search Engine

• A search engine is software that lets users search the internet for information by using search terms or keywords, saving time.

E-Mail

• Sending and receiving electronic messages.
• Requires an e-mail address.
• Essential items in creating a new email include sender's address, receiver's address, subject, and message body.

يتناول هذا الاختبار أساسيات استخدام برنامج إكسل 2016. ستتعرف على كيفية بدء البرنامج، واجهته، وكيفية التنقل بين ميزاته المختلفة. يهدف هذا الاختبار إلى تعزيز فهمك لوظائف إكسل المتنوعة.