Overview/Description Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft...

Overview/Description Microsoft Office Word 2007 provides new features called Quick Styles and building blocks which make it easy to create great looking documents quickly. You can select Quick Styles using the new Live Preview feature to view the different styles before committing the changes. This course demonstrates the use of Quick Styles, building blocks, templates and AutoCorrect features in detail. Previewing and printing options, as well as Word 2007's Help and Research options, are also explored and demonstrated. Target Audience Personnel at all levels of the enterprise; end-users...

Overview/Description Project managers often share Project 2007 data with other applications, such as Microsoft Excel and Microsoft Outlook. When importing and exporting information in this way, the information must first be sorted, filtered, and grouped to customize the information's appearance. Information also needs to be timely – actual work performed, actual start and finish dates, and actual costs must all be updated. This course outlines the basics of importing and exporting, sorting, filtering, and grouping information to meet a project's needs. It also discusses creating and sharing...

Overview/Description Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and demonstrates how to create or modify a query in Design view in order to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying...