Mainsail Suites Hotel
4902 Eisenhower Boulevard
Tampa, FL 33634
1:00 p.m. Wednesday, Dec. 5, 2012
Intermediate Excel Course Description:
This three hour class is a hands-on training session that will cover intermediate 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 2000/XP/Vista/7, Mouse Usage, and Typing (30 WPM)Beginning Excel Course
1. Normal vs. Page Layout view of data2. Create titles that span multiple columns by merging the contents of cells3. 3. Set the Rows and/or Columns to repeat on each page when printed 4. 4. Insert new rows or columns in a spreadsheet5. Insert Headers & Footers on each page4. 6. Insert (or Remove) Page Breaks to control where text breaks at the end of a page7. Preview Page Breaks8. Open multiple workbooks and copy data from one and paste into the other9. Inserting explanatory comments in cells (e.g. to explain what to put in a cell) and
editing these comments10. Insert Pictures, Clip Art, Shapes (Drawing Shapes), SmartArt, Charts,
Tables, Hyperlinks, Text Boxes, WordArt, Signature Line, Objects or Special
Symbols in a spreadsheet11. Use Conditional Formatting in a cell to set up visual alerts that are triggered when a
condition is met12. Sort data in your spreadsheet13. Filter data in your spreadsheet to filter out specific values14. Set up data validation criteria to prevent the end user from entering invalid data in a
cell15. Create nested Functions to perform more complex tasks16. Use the IF Function to perform conditional tasks17. Use VLOOKUP function to find a value in a lookup table18. Create and manipulate a Pivot Table (Multi-Dimensional Cube)19. Lock (default for all cells - prevent send user from changing a value or function –
has no effect until you Protect spreadsheet) or Unlock Cells20. Protect a Spreadsheet or Workbook 21. Creating Excel Macros (records all your keystrokes, saves them in a named
macro - you can play them back later by running the saved macro which saves you
time on repetitive tasks) 22. Other topics as determined by the class and the time available.
Visit EventBrite.com for pricing.