Description:
Formatting data makes the data easier to see and work with. Discover how you can align data, use colors, and themes, resize rows and columns, and insert tables and borders in Excel to change the presentation of data in this 14-video course. Key concepts covered here include how to apply data formats to a data range; how to use font format options in a spreadsheet; and how to insert, customize, and delete borders. Next, you will learn how to add color to your spreadsheets and to apply font and background colors; how to use conditional formatting tools to highlight and apply the rules to different data; and how to transfer format styles from one worksheet to another. Learn how to insert and delete columns or rows, including multiple columns and rows in a single action; how to resize columns and rows in a spreadsheet; and how to convert a data range into a table and edit its contents. Finally, learn how to change the appearance of a table with formatting tools and table styles.
Target Audience:
Duration: 00:53
Description:
Explore how to use Excel for Office 365 to share documents via email, upload them to OneDrive, and use SharePoint to collaborate with your team, in this 8-video course. You will learn how to use the integrated e-mail function to choose recipients and document formats, including XLS and PDF. This course demonstrates how to share workbooks via links, how to choose editing permissions, and manage access to shared links. Learners will explore MS OneDrive to store files and access documents from any location with an Internet connection. Next, you will learn how to save a workbook to OneDrive, manage its version history, and verify that workbook's version history. This course demonstrates how to use the comment tool to leave notes or comments, when collaborating with multiple users working on the same spreadsheet. Learn how to use Excel to collaborate on a document in real time, and see when other users are viewing and editing the document. Finally, this course demonstrates how to use the Track Changes tool.
Target Audience:
Duration: 00:36
Description:
This 12-video course explores the support provided when using formulas on data in MS Excel for Office 365. In this course, you will learn to use the spreadsheet cells to perform simple and complex calculations. You will also learn how to use the Formula Library, and how to insert into a cell several built-in formulas included with Excel. Next, learners will observe how to create a calculation once, and then apply it automatically to the remaining data entries. You will learn how to insert subtotals for individual subgroups with a table, and how to use the COUNTA formula to count up the number of cells that contain values. This course demonstrates how to use RANK functions to determine where a value places on a list. You will learn several formulas to round up or down data values, then learn how to make changes in a spreadsheet using the SUBSTITUTE, TRIM, and REPLACE formulas. Next, observe how to use the QUOTIENT formula to perform divisions. Finally, you will learn how to create randomized numbers.
Target Audience:
Duration: 00:53
Description:
An Excel for Office 365 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature. Key concepts covered in this 7-video course include how to insert images and photographs to illustrate a table; how to insert a screenshot and to move, resize, or crop it; and how to edit an image by adjusting its brightness, contrast, and saturation levels and even adding a border. Next, you will learn how to create diagrams by using shapes and adding shape effects; learn how to insert and modify icons in a worksheet; and learn the best practices for inserting a hyperlink into your sheet. Finally, you will learn how to use the Smart Lookup tool to quickly access additional information about words used in your document and see images, definitions, and information appearing on the Web, related to the selected word, by using this tool.
Target Audience:
Duration: 00:34
Description:
Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel to change the presentation of your data.
Target Audience:
Duration: 00:54
Description:
Excel contains a number of features to aid in data insertion and manipulation. In this 17-video course, learners can explore numerous ways to insert, edit, and manipulate data, including undo and redo, Flash Fill, spellcheck, and transposing a data range. Key concepts covered in this course include the many different ways of inserting, editing, and replacing data in your spreadsheet; how to insert a text character or symbol if this is not located on your computer; and how to perform simultaneous edits of data cells with the same cell locations, but found on different worksheets. Next, you will learn how to use deletion tools to remove data from your spreadsheet; learn to organize your data into a list and avoid reentering the same categories repeatedly by creating automatic data series, including working with patterns and dates; and learn to use the Flash Fill feature which allows you to automatically and instantly complete data lists. Finally, you will learn how to insert dropdown menus, use spelling tools, and move data from one worksheet to another.
Target Audience:
Duration: 01:09
Description:
In Excel, it is easy to create and save new workbooks. Learn how to create, manage, and save documents, insert headers and footers, edit your document properties, and protect your Excel workbooks from unwanted edits or use. Key concepts covered in this 15-video course include how to create a new workbook directly from an existing workbook that you may have open, or create a new one from the application separate from a workbook; exploring the large library of predefined, preformatted spreadsheet templates that can be used to get started on a project quickly; and how to get more out of Excel by learning to navigate between your worksheets and how to modify their properties. Next, learn how to work with header and footer tools that are independent of cells and appear automatically at the top and bottom of every page; and learn how to check for compatibility issues that might be present in your workbook.
Target Audience:
Duration: 01:12
Description:
Excel for Office 365 is the spreadsheet application in the Microsoft Office 365 suite. This 5-video course explores the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Key concepts covered in this course include how to access the app from your Windows search bar and pin it to your Taskbar for quicker access; how to explore the interface, which features a ribbon with multiple tabs, a status bar, and a quick access toolbar with multiple tools for visualizing your spreadsheet data; and how to use the zoom function to adjust how you visualize your spreadsheet in Excel and how to quickly access the Zoom tools. Next, learn more about the view modes and the three different preset view modes of Normal, Page Layout, and Page Break, then learn how to create your own custom views; and learn to work on multiple workbooks simultaneously by using a number of tools to organize your workspace.
Target Audience:
Duration: 00:23