Transcript Day 2:MICROSOFT EXCEL – CHAPTER 1

DAY 2:
MICROSOFT EXCEL – CHAPTER 1
Madhuri Siddula
[email protected]
January 14, 2014
ENTERING DATA
•
•
•
•
Text
Values
Date – Excel auto formats the date
Formulas
ENTERING DATA CTD…
• Edit the data – F2
• Clear the data – Delete
• Line break – Alt + Enter
ENTERING DATA CTD..
 Start Excel. Save the new workbook as
lastname_firstname.xlsx
 Type OK Office Systems Pricing Information in cell
A1, and press Enter.
 Enter the following values in the corresponding cells:
A4 Product
A5 Computer System
A6 Color Laser Printer
A7
Filling Cabinet
A8
Desk Chair
A9
Computer Desk
A10 28” Monitor
ENTERING DATA CTD..
C4
D4
E4
F4
G4
Markup Rate
Retail Price
Percent Off
Sale Price
Profit Margin
FORMULA
• Two ways – Manual and Selection
• Use auto fill
• Display cell formulas – Ctrl + `
FORMULA
 Click cell D5, the cell where you will enter the
formula to calculate the retail selling price of
the first item.
 Type =B5*(1+C5) and view the formula and
colored cell borders on the screen.
 Click Enter to the left of Formula Bar and
view the formula.
 Similarly click F5, enter formula =D5-D5*E5
and click G5, enter formula =(F5-B5)/F5.
ENTER THE FORMULA AND
RELATED CELLS HIGHLIGHTED
DRAG AND DROP TO AUTO FILL
OTHER CELLS IN THE COLUMN
ADD OTHER FORMULAS
WORKSHEETS
•
•
•
•
Create new – Shift +F11
Rename
Change color
move
ADDING NEW SHEET
RENAMING A SHEET
ADD COLOR
WORKSHEETS CTD..
•
•
•
•
•
Insert columns, rows
Delete
Hide / unhide rows/columns
Adjust row height
Adjust column width
INSERT
DELETE
HIDE /
UNHIDE
ROW HEIGHT / COLUMN WIDTH
DATA
•
•
•
•
•
Selection
Move
Copy
Paste
Paste special
SELECTION - COPY
PASTE
SPECIAL
FORMATTING DATA
•
•
•
•
•
•
•
Merge and center labels
Applying alignment and font options
Wrap text
Apply borders
Fill colors
Applying number formats
Increase/decrease decimal places
MERGE AND CENTER
ALIGNMENT AND FONT
WRAP DATA
APPLY BORDERS
APPLY BORDERS
FILL COLORS
NUMBER
FORMAT
NUMBER
FORMAT
PAGE OPTIONS
•
•
•
•
•
•
•
•
Margins
Orientation
Size
Print area
Breaks
Background
Print titles
Headers/footers
PAGE OPTIONS
SET PRINT AREA
HEADERS / FOOTERS