Getting Up to Speed with Windows 7 and Office 2010 In this hands-on workshop you will work in the Windows 7 and Office 2010 environments to learn the tips and tricks and new features available in both Windows 7 and MS Office 2010. We will also talk about compatibility issues with earlier versions of Office, including the new and changed functions in Excel 2010.
1-19-2012 and 2-23-2012
Excel 2010 Basic/Review If you taught yourself Excel or learned it a while ago, you may have missed some of the key points that help you use Excel productively and without errors. We will focus on Excel 2010 including foundation skills for building well-designed and easy to use and update spreadsheets. We’ll also look at some of the newer features in Excel 2010 to help you lay a great groundwork for your Excel products.
Word 2010 Basic/Review If you taught yourself Word, or learned it a while ago, you may have missed some of the key points that make using Word easy and productive. In this class we will focus on Word 2010 including some of the new features such as the Navigation Pane, as well as the foundation skills (levels of formatting, controlling the environment, etc.) that have been with Word since the beginning. If you sometimes feel like Word is in control instead of you, this is the class for you!
Excel 2007 Formulas and Functions Take it to the next level, learn how to be creative with formulas and functions to design better spreadsheets. We will consider techniques for building spreadsheets, such as the use of absolute and relative cell references, evaluating formulas, and showing and printing formulas. We will then explore the many categories of functions and how to easily add functions to your design. We will use logical functions such as IF, SUMIF, and SUMIFS; LOOKUP & REFERENCE functions such as VLOOKUP, and other function categories such as DATE and TEXT functions. There are new and changed functions in Excel 2010, get the scoop in this workshop. Bring a USB device to take home the class exercise spreadsheet. Prerequisite: Basic knowledge of Excel (create and save spreadsheets, simple formulas, or Excel Basics/Review course).
3-1-2012 and 4-12-2012
MailMerging with Word 2010 Learn how to use the Mailings tab in Word 2010 to create envelopes, labels, letters, and even emails. We’ll also learn how to use some of the conditional statements in mail merging. These conditional statements allow you to select only certain recipients based on their address to send items to, or within the body of a merged document to vary the text based on a condition within the merged data file (for example, Anchorage residents get a different sentence than non-Anchorage residents).
PowerPoint 2010, Getting Started In this class we familiarize ourselves with the PowerPoint environment and learn how to create and edit a slideshow. We will learn when to use the various views available in PowerPoint, how to modify a slideshow including adding headers and footers, how to choose various layouts and designs, work with objects, add transitions between slides and animations within slide objects, and various methods for saving and presenting a slide show. This class will be a good preliminary class for the PowerPoint Next Steps class. Prerequisite: How to use a Windows computer.
Advanced Word 2010 Formatting If you work with Word documents longer than a couple of pages, you will really appreciate Styles, Themes, and Templates in Word. Learn how to create and use Styles and Themes to easily format and re-format documents.. We’ll also consider the many ways you can share formatting between documents and users. Learn to simplify and standardize your formatting and get control of Word’s formatting! Prerequisite: basic knowledge of Word formatting (Word Basics/Review or equivalent).
Excel 2010 Pivot Tables and Pivot Charts Pivot Tables and Pivot Charts allow you to create multidimensional data views by dragging and dropping column headings to move data around. Start with a simple list (such as accounting records or student enrollment data) and rearrange and summarize the data to answer questions such as how much was spent from each account in each quarter. You don’t need to reorganize, subtotal, and pretty-up the data yourself—Excel will do it for you starting from a basic list of information! You can also create charts from the pivoted data. This class will include examples and exercises using data drawn from the Banner system at UAA and will introduce new ways of working with Pivot tables and charts in 2010, including the great new Slicer feature.. If you work with lists of data, you need to know about pivot tables and charts! Prerequisite: Basic knowledge of Excel (create and save spreadsheets, simple formulas, or Excel Basics/Review course).
PowerPoint 2010, the Next Step In this fast-paced workshop you will learn about and use the features in PowerPoint 2010 such as Sections and new ways to save your files and access and customize video content. We will study Themes and the enhanced Layouts. We will also look at the enhanced features in WordArt, SmartArt, and Charts, and learn a variety of tips and tricks to make your slide show preparation easier and your shows more polished. Prerequisite: Basic knowledge to prepare a simple slideshow in PowerPoint 2007 or 2010 or PowerPoint 2010 Getting Started workshop.
OneNote 2010 Introduction OneNote is part of the Office 2010 software suite. OneNote is designed for note taking, brainstorming, research, searching, collaboration, collecting random bits of information — basically everything you've ever tried to do in notepads, sticky notes, to-do lists, and maybe even white boards. You'll find it all much easier to do with OneNote, and will be able to keep all your information in one easy-to-manage location. You can even integrate your notes with other Office programs, such as setting tasks in Outlook or sending notes from OneNote to Word. Come explore the possibilities of this powerful tool!
Outlook 2010 Email Management Learn proven techniques to get control of your Inbox and effectively organize and retrieve messages. We’ll cover ways to search for and find emails; creating and using personal and search folders; the use of flags, favorites, and categories; sorting, filtering, and arranging messages; creating and managing rules; and customizing email, junk, mail, notification and alert options. We’ll also discuss the mailbox cleanup and archiving tools and meet the new tools introduced in 2010 including QuickSteps. Prerequisite: Basic email skills (creating, sending, attaching files, receiving emails).
Excel 2010 Multiple Files and Sheets Learn how to link and embed data between worksheets and workbooks, create 3-dimensional formulas to link between worksheets, use the Consolidate command to combine worksheets with identical or similar layouts, summarizing multiple worksheets and workbooks with pivot tables, and more. Prerequisite: Basic knowledge of Excel (create and save spreadsheets, simple formulas, and/or Excel Basics/Review workshop).