May 22
May 17
Learn the basic operations of the Microsoft Access 2010 database program. This course is designed to teach the features and functionality of Access 2010. In this class, you will learn to create and populate tables, create forms and queries as well as designing reports. A training manual is included. Self-supporting.
Learn to import/export from spreadsheets, text files and other non-database file formats. Expand your understanding of table relationships and how these relationships are used in forms, queries and reports. Customize your reports using Group and Totals, add calculations and running totals. An introduction to macros is also presented. A training manual is included. Self-supporting.
In this 1-day course, you will learn the fundamentals of Excel for creating and formatting spreadsheets. Following an overview of the program environment and a glimpse of the power of Excel, you will learn how to enter and format data (both text and values), how to move and copy data, how to create formulas and functions to calculate data, and how to specify a formula reference as relative or absolute depending on how you need to use the formula in the worksheet. You will also learn how to format and print spreadsheets. A training manual is provided. Self-supporting.
Building on the skills learned in the Excel 2010 Basics workshop, this workshop teaches advanced formulas, sorting, filtering, applying conditional formatting as well as charting and graphing. Learn to create PivotTables and PivotCharts. A workshop guide is furnished. Self-supporting.
Learn to create dynamic presentations using PowerPoint 2010! Whether you are new to PowerPoint or upgrading from a previous version, you will learn what PowerPoint can do for you. Learn to create presentations from start to finish. Learn to use templates, insert graphics and create tables and charts. Enhance your presentation with transitions and animations. Watch your presentations come to life by running the slideshow on your own computer. A training manual is provided. Self-supporting.
Learn to import Word outlines, Excel charts and slides from other PowerPoint presentations. In addition, you will gain an understanding of headers and footers, Master Slides and templates. Learn new, exciting features added to PowerPoint 2010 (advanced animation techniques, SmartArt graphics and more). A training manual is provided. Self-supporting.
In this 1-day course, you will learn the essentials of document processing in Microsoft Office Word 2010. You will learn how to create and format basic documents as well as multiple page reports. You will learn how to create and format text using a variety of features. You will learn how create columnar text using tabs and how to emphasize text blocks by adding borders and shading. You will also learn how to work with the page layout features of margins, page breaks, and page numbers. You will learn how to use the various document views, how to print, move and copy text, and copy text formats. You will also learn how to create bulleted and numbered lists, and how to spell check documents. A training manual is provided. Self-supporting.
Microsoft Word 2010 Intermediate extends the learner's basic skills and knowledge of Microsoft Word 2010 and helps them create more intricate and varied documents. Existing skills and knowledge are enhanced by covering more advanced aspects of key topics such as formatting, tables, and lists, and new features such as merging, envelopes. Quick Parts, AutoCorrect, clip art and graphics are also introduced. A training manual is provided. Self-supporting.