ملاحظات المحاضرة: إكسل 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.