Crosoft Excel Guide

MICROSOFT EXCEL STUDY GUIDE
Manage Files
Create a new book
Click on Office button  Click New option  Select blank workbook Accept
Save as … a workbook
Click on Office button  Click Save as button  on the dialog box, select the folder destination  write the workbook name  select the file extension  click save button
Save a workbook
Click on Office button  Click Savebutton
Save a workbook with password
Click on Office button  Click Save as button  on the dialog box, select the folder destination  write the workbook name  select the file extension  click tool options  select general options  enter opening/writing password accept  click save button
Close a book
Click on Office button  click close option
Open an existing book
Click on Office button Click on the open option  on the dialog box, select the folder that contains the file select the file  click open button
Create a book using Templates
Click on Office button  Click Save as button  on the dialog box, select the folder destination  write the workbook name  select the file extension  click save button
Change user name and sheet number for a new book
Click on Officebutton  Click New option  on the left select installed templates or my templates  select the desired template  click on create button
Change auto-recovery information
Click on Office button  click on Excel options  on the left select the Saving option 
Change grid color
Click on office buttonclick on Excel optionsClick on advancedgo to show options for this sheet click where it sayschange grid color
Show formulas
Click on formulasin formula auditing click on show formulas

Manage worksheet environment
Select rows
Click on the heading
Select cells
Click on the cell they´re asking you
Insert columns
Click on homeclick in InsertInsert in insert column
Change row’s height
Click on homeclick in FormatClick on row´s heightinsert the measureclick ok
Eliminatecells
select the cell or cells you want to deletein home click de option Delete click delete cell
Eliminate rows
select the row or the rows in home click de option Deleteclick delete row
Hide columns
select the columns you wish to hideClick homeclick formatclick show and hideclick hide column
Hide rows
Select the row you wish to hideClick on homeClick show and hideclick hide row
Show, copy,and paste rows
Select the row you wish to showin your mouse click the right buttonclick show
Select the information you wish to copyin your mouse click the right button click copy
Select the place you wish to copy the info. in your mouse click the right buttonclick paste
Show rows
Select the row you wish to showclick homeclick formatclick show and hideclick show rows
Auto-adjust row’sheight
select the row you want to auto-adjustclick homein formatclick auto-adjust row
Copy columns 
SELECT THE COLUMNIN THE MOUSE CLICK THE RIGHT BUTTONCLICK COPY
Auto-adjust column’s width
SELECT THE COLUMNIN HOMECLICK FORMATCLICK AUTOU-ADJUST COLUMN’S WIDTH
Move columns
Select the columnmove the coursor to the heading of the columnmove it to where they ask you
Insert a newworksheet
at the bottom of the page select new worksheet



Page settings
Page size and orientation
click page designclick orientation
click page designclick page sizechoose the size they ask you
Set printing margins
click on page designin page configuration open the dialog boxclick margins make the change they´re asking you
Set printing area
select the area you want to printclick on pagedesignclick on adjust printing areaclick establish printing area
Center the page
click on page designin page configuration open the dialog boxclick marginsin center page click horizontally or vertically
Adjust worksheet scale

Insert header and footer
click insertclick header and footer
Insert Page breaks
click on page designclick page configurationclick page breakclick insert page...