MICROSOFT OFFICE APPLICATIONS & OFFICE TECHNOLOGY
Power Point 2013
With Microsoft Office 2013, learn to create and modify slides and presentations by using clip art, WordArt and charts, templates and presentation options. Learn how to add speaker notes, slide headers and footers. Insert multimedia content, including audio and video, and configure your presentation to run automatically. Discover how to use tables to aid in the placement of data and customize built-in document themes and color schemes.
Recommend prior experience in Windows and MS Word
Learn to use Microsoft’s powerful spreadsheet application that is an essential tool for today’s workplace. Learn the basic concepts of Excel. Discover how to build, edit and format spreadsheets and how to create basic and complex formulas and functions. Learn how to create and modify charts.
Recommend prior experience with Windows.
Using Microsoft Office 2013, take your spreadsheet skills to the next level. In this hands on course, learn to prepare workbooks and create custom views. Sort worksheet rows, freeze headings and split worksheet windows. Discover how to insert, draw, move, size, rotate and add styles; and create SmarArt. Use templates and create custom templates. Use Office templates and create custom templates. Copy and move worksheets, copy formatting between worksheets and use linked formulas. Discover how to work with tables, lists and outlines. Understand how to create hyperlinks to areas within the workbook and to other documents.
Excel 1 or equivalent experience is recommended.
Utilizing Microsoft Office 2013, learn basic database functions. Open, navigate and close database objects, view forms and reports, and look at queries. Add records to a table using the datasheet and a form and use a database to sort, delete, edit and filter records. Learn to create tables using Table Design View, append records to a table, work with queries and wizards, and learn about database management. Also discover how to modify table structures, set Lookup fields and field properties, and analyze and document a database.
Windows Basics and Word Basics or equivalent experience is recommended.