Overview/Description Excel 2013 provides tools to allow you to share workbooks, connect to external data, and add Office Apps. You can log into Office using an Office 365 Organizational ID or Microsoft account, allowing you to carry your personalized Office settings with you. You can add online services including SkyDrive and SharePoint storage, as well as Microsoft accounts to access and share your images and videos with social media sites. This course will show you how to link to external data including Access databases and other Excel workbooks. Finally, it will show you how to add Office...

Overview/Description Within Word 2013, there are numerous options that allow you to customize how the contents of your documents appear. Items like page margins, paper sizes, and spacing are fully customizable. You can also add headers and footers to easily include important information on some or all of the pages in your document and add page numbers to make it easier to navigate longer documents This course demonstrates how to adjust page margins and paper size, as well as how to add, edit, and remove headers and footers. Adding page numbers, configuring indentation, and adjusting paragraph...

Overview/Description Excel 2013 provides powerful financial functions and data-analysis tools that enable you to explore data and to make educated business decisions based on that data. Using financial functions, iterative calculations, and the Watch Window can help you make the make better financial decisions and ensure the calculations are accurate. This course will cover What-if Analysis which enables you to retrieve required results from formulas by determining the data the formula requires, forecast worksheet outcome models, and to see how changing values in formulas affect the formula...

Overview/Description Tables are a great way of sorting and organizing data to make it easier to read and analyze. In Word 2013, you can create tables in a variety of ways, either using the ribbon to specify the number of columns and rows required, drawing a table and customizing it as needed, or converting existing text to a table. Once you've created a table, there are many options available to customize its overall appearance. You can add and remove cells, columns, and rows as needed, as well as merge cells, split them apart, or even split a table into more than one table. You can use row...