The final two classes of the Microsoft Office Short courses--offered by the Sweetwater campus of TSTC (Texas State Technical College) West Texas this summer--will be held during the week of July 22 through 26.
Both courses will be taught on campus, located at 300 Homer K. Taylor Drive, in the Pevehouse Building in Room 210.
An intermediate/advanced course for Microsoft Excel 2010--which is an eight-hour course held in the mornings--will be taught Monday, July 22 and Wednesday, July 24.
The intermediate class on Microsoft Excel 2010 builds on the skills and concepts taught in Excel 2010: Basic, in which students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables.
Also, attendees will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates.
Students will learn to work with PivotTables and PivotCharts, data validation and database functions such as DSUM. They will learn how to import and export data. Finally, students will learn conditional formatting with graphics.
Finally, a day-long, six-hour, Microsoft Publisher Advanced 2010 course will be held toward the end of the week on Friday, July 26.
This course will show students how to set up a brochure and create a business information set, change color schemes, create tint swatches and gradients, use the graphics manager pane to link ad replace pictures, work with styles and change the font scheme, insert WordArt, create a type mask, modify text wrap based on image contours, snap text to baseline guides, and insert symbols and special characters.
Additionally, participants will create sections, format section page numbers, use bookmarks, create form letters, mail merge recipient list, sort and filter records, insert catalog pages, create a catalog merge, modify a web publication, insert and modify form elements, and set form properties and labels.
Each course costs $120. Interested participants can register by calling Cindy Brunett at (325) 672-9456 or by visiting http://www.tstc.edu/westtexasworkforcedevelopment/apply .