Scribd
Upload
108 views2 pages

Basic Excel Word PowerPoint Notes

This document provides a quick reference for basic functions and shortcuts in Microsoft Excel, Word, and PowerPoint. It includes essential Excel formulas like SUM, AVERAGE, and VLOOKUP, as well as Word shortcuts for formatting and editing text. Additionally, it lists PowerPoint shortcuts for slide management and presentation tools.

Uploaded by

Rama kumar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
108 views2 pages

Basic Excel Word PowerPoint Notes

This document provides a quick reference for basic functions and shortcuts in Microsoft Excel, Word, and PowerPoint. It includes essential Excel formulas like SUM, AVERAGE, and VLOOKUP, as well as Word shortcuts for formatting and editing text. Additionally, it lists PowerPoint shortcuts for slide management and presentation tools.

Uploaded by

Rama kumar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Basic MS Excel, Word, and PowerPoint – Quick Reference

Microsoft Excel – Basic Formulas


SUM: =SUM(A1:A10) – Adds numbers

AVERAGE: =AVERAGE(A1:A10) – Finds average

COUNT: =COUNT(A1:A10) – Counts numeric cells

COUNTA: =COUNTA(A1:A10) – Counts non-empty cells

MAX: =MAX(A1:A10) – Highest value

MIN: =MIN(A1:A10) – Lowest value

IF: =IF(A1>50,"Pass","Fail") – Logical test

VLOOKUP: =VLOOKUP(A1,A2:B10,2,FALSE) – Search vertically

HLOOKUP: =HLOOKUP(A1,A1:D5,2,FALSE) – Search horizontally

CONCAT: =CONCAT(A1,B1) – Join text

Microsoft Word – Basic Tools & Shortcuts


Bold – Ctrl + B

Italic – Ctrl + I

Underline – Ctrl + U

Copy – Ctrl + C

Paste – Ctrl + V

Cut – Ctrl + X

Find – Ctrl + F

Replace – Ctrl + H

Align Left – Ctrl + L

Justify – Ctrl + J

Microsoft PowerPoint – Basic Tools & Shortcuts


New Slide – Ctrl + M

Duplicate Slide – Ctrl + D


Start Slide Show – F5

From Current Slide – Shift + F5

Insert Text Box – Insert → Text Box

Apply Theme – Design → Themes

Insert Image – Insert → Pictures

Change Layout – Home → Layout

Add Animations – Animations tab

Save Presentation – Ctrl + S

You might also like