Mainsail Suites Hotel
4902 Eisenhower Boulevard
Tampa, FL 33634
1:00 p.m. Wednesday, Sept. 11, 2013
Beginning Excel Course Description:
This three hour class is a hands-on training session that will cover basic features of Microsoft Excel. The class will use real world business problems as the focus for teaching all the concepts and students will do an exercise after each topic to practice what they have learned.
NOTE: You must cancel at least 72 hours before the workshop begins to get a refund!
Prerequisites:Microsoft Windows XP/7, Mouse Usage, and Typing (30 WPM)Course Topics:1. How to run Microsoft Excel2. Display or hide toolbars3. Define distinction between spreadsheet and workbook4. Cell as the core element where data is entered in a spreadsheet5. Identifying cells via row and column designators (e.g. A1)6. Moving from cell to cell (Mouse Click into any cell, Tab to move to cell
to right, Enter to move to cell below)7. Enter data into an empty cell8. Edit data currently in a cell9. Create basic spreadsheet structure and enter data§ Spreadsheet title (if embedded in spreadsheet)§ Row and column titles§ Data10. Name a spreadsheet11. Save and name a new workbook for the first time12. Save additions/changes to a workbook13. Set autosave option to automatically save your file every X minutes14. Exit Microsoft Excel15. Open an existing worksheet to edit it16. Format spreadsheet§ Create titles that span multiple columns by merging the contents of cells§ Change the font and point size of data in a cell§ Format the data in a cell (bold, italicize, underline, color)§ Position the data in a cell (align left , center, or align, right, or justify/block)§ Change the data type/display format of data in a cell (e.g. displaying a
number like 14.4 as currency like $14.40)§ Resize column width or row height§ Autowrap text within a cell (to avoid making an extra wide text cell)
§ Align data within a cell either vertically or horizontally§ Add printable borders around a cell or group of cells§ Shade the background of a cell or group of cells§ Insert new rows or columns in a spreadsheet17. Inserting explanatory comments in cells (e.g. to explain what to put in
a cell) and
editing these comments18. Cut and paste data within a spreadsheet19. Create formulas§ Row and column references (relative, absolute, and mixed)§ Sum up data in non-contiguous cells in a row or column§ Sum up data in contiguous cells in a row or column using SUM formula§ Use an existing row/column total formula to automatically create
equiivalent formulas for other columns§ Add today’s date to spreadsheet20. Create additional spreadsheets in the workbook21. Create cross-spreadsheet formulas22. Change spreadsheet setup for display and printing (changes only
impact currently open spreadsheet)§ Scaling the data so it fits horizontally on page without spilling over to another page§ Set the paper orientation (portrait or landscape)§ Change the size of the margins (top and bottom and/or left and right)§ Change the size of the page header and footer§ Create custom headers and footers to appear on each page§ Force column titles to print on each page of a multiple page
spreadsheet23. Preview what the printed result of a spreadsheet will look like§ Zoom in to full spreadsheet full size§ Access Page Setup to make changes§ View and alter margins24. Print out a copy of a spreadsheet or the entire workbook§ Set global print options Number of pages to print from each spreadsheet Portion of spreadsheet or workbook to print Number of copies to print§ Use Properties button Set page orientation (portrait or landscape) for all spreadsheet in
workbook (overrides spreadsheet specific setting done with via
File|Page Setup) Set page order for printing (front to back or back to front) Set the number of spreadsheet pages to print on a physical page25. Open multiple workbooks and copy data from one and paste into the
Visit EventBrite.com for pricing.