Looking for ways to better leverage Microsoft Office — including Excel, Word, and Powerpoint — for school or work? You’re not alone! While many of us use Microsoft Office daily, ITS frequently hears that staff, faculty, and even students would like to learn more about this powerful software program.
Microsoft has an Office training site that features a large number of video tutorials for performing tasks in Word, Excel, Powerpoint, Access, and eight other Office applications. The site features tutorials for the latest version of Office — 2013 — as well as for Office 2011 for Mac, Office 2010, Office 2007, and Office for iPad. Tutorials range from beginning tasks like creating your first Word document or PowerPoint presentation, to advanced tasks like working with pivot tables in Excel.
Some of the more popular topics include:
- Table of Contents: Intro to TOC and Advanced TOC
- Mail Merge: Beginning and advanced, plus “taking mail merge to the next level“
- Special Formatting: Creating an MLA paper, or a resume
- Creating a chart
- Averages: averaging a group of numbers or creating weighted averages
- Conditional Formatting: Beginning and advanced
- Advanced Functions: Pivot tables, VLOOKUP, advanced IF functions, and using macros
- Charts: Inserting a bar, line, or pie chart
- Special Effects: Animations, motion paths, and sound effects
The next time you’re looking for training on specific tasks within Microsoft Office applications, check out the Office training site to see if there is a video tutorial to meet your needs!
Category: Tech Tips