Create a basic presentation in PowerPoint 2007.Use formulas, create charts and graphs in Excel 2007.Manipulate data using data names and ranges, filters and sort, and validation lists in Excel 2007.Insert headers and footers in Excel 2007.Save, page setup, and print worksheets in Excel 2007.Create/Use templates, enter, edit, copy, cut, paste, and format data in Excel 2007.Use the help function and customize the Quick Access Toolbar in Excel 2007.Review Excel 2007 navigation, features, and create a worksheet.Insert graphics, pictures, and table of contents in Word 2007.Format paragraphs, insert tables, create lists, and format pages in Word 2007.Start MS Word, perform basic editing functions, format text, copy and move objects and text.It is strongly recommended you have MS Office 2007 or have access to this version.
#USE OF MICROSOFT EXCEL 2007 HOW TO#
After completing this section, learners will be able to demonstrate an understanding of the fundamental features of Outlook 2007,set up new email accounts along with understanding how to convert their previous Outlook information to 2007, utilize the toolbars and navigation panes in Outlook 2007, understand how to operate the email tools in Outlook 2007, demonstrate an understanding of how to customize email options and tools, perform personal information management tasks, manage and utilize Outlook 2007's contact management tools, understand and utilize Outlook 2007's calendar, tasks, notes and journal entry tools, and demonstrate an understanding of the collaboration and remote access tools in Outlook 2007. This section has been developed to be of benefit to new users of Outlook, individuals migrating from previous versions of Outlook and individuals wanting to learn to use the advanced functionality of Outlook 2007.
#USE OF MICROSOFT EXCEL 2007 PROFESSIONAL#
The purpose of this section of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. One of the most noticeable changes is the new user interface called the Microsoft Office Fluent which allows for the creation of dynamic, professional presentations in a much shorter period of time than earlier versions of PowerPoint. The Fluent interface has all commands, toolbars and task panes categorized into tabs and related groups.Īmong the many new options offered by PowerPoint 2007 are new themes and quick styles, custom slide layouts, Smart Art graphics, more advanced graphic effects for text, pictures, objects, charts, graphs and tables, more effective proofing tools, user-friendly collaboration and permission features, and much more. This course will walk you through PowerPoint 2007, beginning with the basics and lead you through to some of the most advanced features available, offering additional helpful tips and hints along the way. New Pivot Table User Interface to help the user more effectively use pivot tables.And, Excel now supports up to 16 million colors!
New options for applying themes and styles which enhance the look of your spreadsheets and graphics.
This Excel 2007 Online Training Course does just that and more! It assumes users have no prior experience with Excel or other spreadsheet programs. With the right training and understanding of Excel 2007, businesses and individual users can unlock the world of opportunities that this powerful business application offers. Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data. You'll learn your way around the toolbars and menus, basic editing features,how to insert items into a document, how to create and edit tables,Macros,And much, much more! Additionally, this course introduces new features exclusive to MS Word 2007, as well as includes detailed instructions on how to use them. It doesn't matter if you're new to MS Word or an experienced user, this comprehensive course teaches the most basic features as well as focuses on the more advanced tools that all students will find useful. MS Office 2007 will provide a comprehensive tutorial of these programs- Word, Excel, PowerPoint, and Outlook.