MS Office Cheat Sheet Overview

Introduction

• Speaker: Aditya from Prime Coding
• Purpose: To provide a comprehensive cheat sheet for MS Office questions, covering Excel, Word, and Outlook.
• Importance: Useful for sharpening skills and preparing for essential OA exams.

MS Word Shortcuts

• Basic Shortcuts:
  • Ctrl + C: Copy selected text/item
  • Ctrl + V: Paste copied item
  • Ctrl + X: Cut selected text/item
  • Ctrl + Z: Undo last action
  • Ctrl + Y: Redo last action
  • Ctrl + B: Bold selected text
  • Ctrl + I: Italicize selected text
  • Ctrl + U: Underline selected text
  • Ctrl + S: Save document
  • Ctrl + P: Open print dialog
  • Ctrl + F: Find text in document
  • Ctrl + H: Replace text in document
  • Ctrl + Enter: Insert page break
  • Ctrl + Shift + L: Apply bullet point to selected text

MS Word Features

• Stylus Pane: Ensures consistent formatting using predefined styles.
• Track Changes: Allows document editing while tracking modifications.
• Mail Merge: Combines templates with data sources for personalized documents.
• Smart Art: Inserts visual elements to represent information.
• References Tab: Manages citations, footnotes, and bibliographies.

MS Excel Shortcuts

• Basic Shortcuts:
  • Ctrl + N: Create new workbook
  • Ctrl + O: Open existing workbook
  • Ctrl + W: Close current workbook
  • Ctrl + S: Save workbook
  • Ctrl + P: Open print dialog
  • Ctrl + F: Find text or numbers
  • Ctrl + H: Replace text or numbers
  • Ctrl + Arrow Key: Move edge of data region
  • Ctrl + Shift + Space: Select entire row
  • Alt + Enter: Start new line within a cell
  • Ctrl + Shift + $: Apply currency format

Common Excel Functions

• SUM Function: Adds numbers in a specified range.
• VLOOKUP: Searches for a value in the first column and returns data from a specified column.
• COUNTIF: Counts cells meeting a specified criterion.
• AVERAGE: Calculates the mean of a specified range.

MS PowerPoint Shortcuts

• Basic Shortcuts:
  • Ctrl + L: Create new presentation
  • Ctrl + M: Insert new slide
  • Ctrl + D: Duplicate selected slide
  • Ctrl + S: Save presentation
  • Ctrl + P: Open print dialog
  • Shift + F5: Start slideshow from current slide

MS Outlook Shortcuts

• Basic Shortcuts:
  • Ctrl + N: Create a new email/appointment
  • Ctrl + R: Reply to selected email
  • Ctrl + F: Forward selected email
  • Ctrl + Shift + M: Create new email message
  • Ctrl + Shift + A: Create a new appointment

Conclusion

• Resources: Cheat sheet and additional materials available via a Telegram link provided in the video description.
• Encouragement to like and subscribe for more content.
• Next topics will include cloud and networking cheat sheets based on viewer engagement.