Intermediate Excel

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… Show more (30 WPM)
Beginning Excel Course Course Topics:
1. Â Â Â Normal vs. Page Layout view of data
2. Â Â Â Create titles that span multiple columns by merging the contents of cells
3.      3.  Set the Rows and/or Columns to repeat on each page when printed
4.      4.  Insert new rows or columns in a spreadsheet
5. Â Â Â Insert Headers & Footers on each page
4.      6.  Insert (or Remove) Page Breaks to control where text breaks at the end of a page
7.  Preview Page Breaks
8. Â Â Â Open multiple workbooks and copy data from one and paste into the other
9.    Inserting explanatory comments in cells (e.g. to explain what to put in a cell) and      editing these comments
10.  Insert Pictures, Clip Art, Shapes (Drawing Shapes), SmartArt, Charts,      Tables, Hyperlinks, Text Boxes, WordArt, Signature Line, Objects or Special      Symbols in a spreadsheet
11.  Use Conditional Formatting in a cell to set up visual alerts that are triggered when a      condition is met
12. Â Sort data in your spreadsheet
13. Â Filter data in your spreadsheet to filter out specific values
14. Set up data validation criteria to prevent the end user from entering invalid data in a      cell
15. Â Create nested Functions to perform more complex tasks
16. Â Use the IF Function to perform conditional tasks
17. Â Use VLOOKUP function to find a value in a lookup table
18. Â 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 Cells
20. Â 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.

Show less