MS Word – Study Notes
1. Shapes in MS Word
Shapes are built-in drawing tools that help make your document more visually appealing and creative.
🔹 Examples:
Line
Arrow
Rectangle
Circle
Text box
Flowchart symbols
2. SmartArt
SmartArt is a feature used to create diagrams to show information like processes, relationships, or hierarchies.
🔹 Common Types:
List
Process
Cycle
Hierarchy
Pyramid
3. Charts
Charts are visual tools to represent data (like numbers) using graphs.
🔹 Types of Charts:
Column Chart
Pie Chart
Line Chart
Bar Chart
4. Table of Contents (TOC)
A Table of Contents lists all the headings and subheadings of your document along with their page numbers. It
helps in easy navigation.
🧭 Steps to Create TOC:
1. Use Heading Styles (like Heading 1, Heading 2) on your titles.
2. Click the References tab.
3. Click on Table of Contents.
4. Choose an automatic format.
5. It will insert TOC based on the styled headings.
5. Hyperlink
A hyperlink allows you to link to a webpage, file, email, or a place within the same document.
🧭 Steps to Insert a Hyperlink:
1. Select the text or image.
2. Right-click and select Hyperlink (or press Ctrl + K).
3. Enter a URL, email, or choose "Place in this Document".
4. Click OK.
6. Mail Merge
Mail Merge is used to send personalized letters, emails, or labels to many people using one main document and
a data list.
🧭 Steps to Use Mail Merge:
1. Click on the Mailings tab.
2. Click Start Mail Merge → Choose Letters/Emails.
3. Click Select Recipients → Use Excel or create a list.
4. Click Insert Merge Field (like Name, Address).
5. Click Preview Results.
6. Click Finish & Merge → Print or Send Emails.
MS Excel – Study Notes
✅ What is Excel?
Microsoft Excel is a spreadsheet program used to record, organize, and analyze numerical and text data using
rows and columns.
Basic Elements in Excel
🔸 Workbook: The entire Excel file (.xlsx)
🔸 Worksheet: A single sheet inside a workbook
🔸 Cell: The intersection of a row and column (e.g., A1)
🔸 Formula Bar: Displays the formula used in a selected cell
Basic Formulas and Functions
Function Description Example
=SUM() Adds numbers =SUM(A1:A5)
=AVERAGE() Finds average =AVERAGE(B1:B5)
=IF() Checks a condition =IF(A1>50, "Pass", "Fail")
=VLOOKUP() Finds value in a table =VLOOKUP(101, A2:C10, 2, FALSE)
=CONCATENATE() or =CONCAT() Joins text =CONCAT(A1, " ", B1)
Excel Features
🔹 Sorting: Organize data A–Z or Z–A
🔹 Filtering: View specific data based on conditions
🔹 Charts: Create visual representation (Pie, Column, Line)
🔹 Data Validation: Control what can be entered in a cell
🔹 Conditional Formatting: Highlight cells with rules
Common Shortcuts
Task Shortcut Key
New Workbook Ctrl + N
Save Workbook Ctrl + S
Cut / Copy / Paste Ctrl + X / C / V
Undo / Redo Ctrl + Z / Y
Select all cells Ctrl + A
Go to last cell Ctrl + End
MS PowerPoint – Study Notes
✅ What is PowerPoint?
Microsoft PowerPoint is used to create presentations in the form of slideshows with text, images, animations,
videos, and charts.
Basic Components
🔸 Slide: One page in a presentation
🔸 Slide Layout: Predefined format with placeholders
🔸 Theme: A set of colors, fonts, and effects
🔸 Transition: Animation between slides
🔸 Animation: Movement within a slide (text, image)
Designing a Slide
1. Click Home > New Slide to add a new slide.
2. Choose a Layout like Title Slide, Content Slide, etc.
3. Add Text, Images, Shapes, SmartArt, Charts as needed.
4. Use Design tab to apply a theme.
5. Use Transitions tab to add slide changes.
6. Use Animations tab for object animations.
Slideshow Controls
Task Shortcut
Start slideshow (from start) F5
Start slideshow (current) Shift + F5
Next slide Right arrow / Enter
Previous slide Left arrow
Exit slideshow Esc