Quotes

After completing the first course in this series, Microsoft® Office Word 2010: Part 1, you are now able to perform the basic tasks to create a variety of documents. You probably noticed as you continued working in Word that there are some tasks that you repeat quite often. This course will show you how you can work more efficiently by automating some tasks and providing methods to maintain consistency between documents. You will create more complex documents that include lists, tables, charts, graphics, and newsletter layouts. You will also merge data into documents to personalize correspondence and address envelopes and labels with the data as well.*Word can be used to create complex documents that are nearly as complicated as those created using a desktop publishing application. Using Word, you can control how the text flows between paragraphs and pages, you can link a story on page one to the rest of the story later in the document, and you can add graphics and specify how the text and graphic appear together on the page.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Word 2010.

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. In order to gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do.*This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2010: Part 1 (Second Edition) course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your organizational intelligence. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.*This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2010 Exam and the Excel 2010 Expert Exam.

Whether you need to crunch numbers for sales, inventory, IT, human resources, or another business unit, the ability to get the right information to the right people at the right time can create a powerful competitive advantage in a complex market environment.*This course builds upon the foundational Microsoft® Office Excel® 2010 knowledge and skills you’ve already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your firm’s business intelligence.*You’ll learn a lot of things about Excel 2010, including how to create advanced formulas and organize your data into tables. You’ll discover the power of PivotTables and PivotCharts and how Slicers can make data filtering as easy as clicking a few buttons.*At its heart, this course is about one simple idea: asking your data questions and using Excel 2010 to find the answers.

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ball park, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.*Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility such as time reporting or recording a sale. But virtually everyone is affected in some way by the need to manage data.*A relational database application such as Microsoft® Office Access® 2010 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2010 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.*You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2010.