Microsoft Excel Training. September 16, 2006 CHART Hinche, Haiti. Agenda. Introduction to excel functions Formatting Useful tips Formulas Charts Importing data Printing excel worksheets Practicing with reports . Intro to Excel.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
September 16, 2006
Excel is used for budgeting, reporting, and data analysis
Each workbook is made up of worksheets
Each worksheet is made up of a grid with cells
Click on start, programs Microsoft Excel
Click on open new document
A new workbook will appear
Within each workbook is a worksheet or worksheets
Align text right
Align text Left
Align text center
Entering cell references lets Excel automatically update formula results if cell values are changed. For example:
Drag the black cross from the cell containing the formula to the cell where the formula will be copied, then release the fill handle.
Auto Fill Options button appears but requires no actions.
Relative references change as they are copied.
Absolute references stay the same as they are copied.
Create a link between cells in the same worksheet or workbook
Create a link between cells in different worksheets
What print preview gives you
The Fit to option is another way to print your data on one page.
Leave 1 in the page(s) wide by box.
Leave 1 in the tall box.
In page break preview, a big number identifies the page.
An automatic page break appears as a dotted line.
A manual page break appears as a solid blue line.
convenient to define and save it as a print area.
You can print the column titles (months) and the row titles (company names) on every page. You can also print the alphabetical column headings and numerical row headings on every page.