This course covers those features of Microsoft Office 2010 that are new to the Office system, with dedicated units for the new features of each application.
Microsoft Office holds a solid 80% of the productivity software market. That means virtually everyone at one point or another comes into contact with Office files. There were significant changes to the interface in Office 2007 and that paved the way for Office 2010 to focus on features that will bring your work to a whole new level of professionalism and mobility. Because 2010 is not about interface or new applications, many of the features are subtle or hard to recognize at first glance. This course will show you what you need to know to get up to speed and quickly take full advantage of the Shared Features.
This course is designed to take you to the next level with Word 2010. The training will focus on advanced navigation techniques using the Browse Buttons and the Navigation Pane, using web components, inserting and working with graphics and images, and working with multilevel lists. You will also learn how to add references in a document, such as footnotes, endnotes, cross references and bookmarks. Time will be spent covering creating simple macros, customizing Word, sharing documents and creating a Table of Figures.
This course is designed to expand on the skills learned in the Introduction to Word 2010 training. Specifically this class will focus on advanced table techniques, using mail merge, creating envelopes and labels. You will learn to work with long document functions such as building a table of contents, building an index, using paragraph styles, working with section breaks, using Quick Parts, creating columns, and creating complex headers and footers.
This course covers the basic functions and features of Word 2010. After an introduction to Word's window components, students will learn how to use the Help system and navigate documents. Then they will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics.
The Microsoft Press(R) Step by Step video series teaches Microsoft software and technologies visually, in an easy-to-follow visual format. Each video in the series is based on a specific book in the highly successful Step by Step print book series, and adds best practices, tips, tricks, and enhanced explanations and commentary. You'll learn just what you need, just when you need it.
In this course students will work with advanced formulas and functions, as well as lookup functions. In addition, students will apply conditional formats and learn to manage them. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver).
In this course you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to create and format charts. You will work with templates, collaborate in workbooks and use the drawing tools to enhance and annotate spreadsheets.
This class teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Next, you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. Additionally, you will move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, managing large worksheets and printing