-
Calculate the Current Date
Microsoft Excel 2013 allows you to easily display the current date on a worksheet; saving you the trouble of having to know it and update it manually. In this video; Erin Olsen uses the TODAY function in Excel 2013 to return the system date to a cell in a worksheet.
-
Calculate the Payments on a Loan
Microsoft Excel 2013 financial functions include the PMT function that you can use to calculate the payment amounts on a loan that will help you determine the affordability before committing to a long-term transaction. In this video; Erin Olsen uses the PMT function in Excel 2013 to calculate the monthly repayment amounts on a loan.
-
Change a Cell Entry to Proper Case
In Microsoft Excel 2013; you can use the proper function to reformat text that has been entered in all caps so that it displays in title; or proper; case without you having to completely retype everything. In this video; Erin Olsen demonstrates how to create a formula using the proper function to automatically change case.
-
Change How Zero Values Display
Depending on how you want the data to appear; you can change how zero values are presented in Microsoft Excel 2013. In this video; Erin Olsen demonstrates how to hide and show zeroes in cells containing a zero value before applying a custom format that determines how zero values are displayed in a specified range of cells.
-
Concatenate Text
The CONCATENATE function in Microsoft Excel 2013 allows you to create elegant-looking results by joining text data from several cells together in a single destination cell to form easily read phrases and sentences. In this video; Erin Olsen highlights the CONCATENATE function syntax while combining text in a worksheet.
-
Configure a Workbook for Multiple Users
Microsoft Excel 2013 gives users a variety of ways to share a workbook with multiple users. This includes sharing a workbook so that users cannot overwrite each other's changes. In this video; Erin Olsen demonstrates how to allow editing by multiple users; track changes; configure AutoSave options; and configure conflict management.
-
Control Recalculate
Microsoft Excel 2013 allows you to control automatic recalculations when entering or changing worksheet data. In this video; Erin Olsen sets the calculation options to manual and demonstrates manual recalculation and update options.
-
Convert a Table Back to a Normal Range
Microsoft Excel 2013 allows you to easily convert tables back to a normal data range without losing any of the table style formatting. In this video; Erin Olsen demonstrates how to convert an Excel table to a regular range of data in a worksheet.
-
Copy Word Text to Excel
By identifying certain data in Word documents and copying it into Microsoft Excel 2013; you'll be able to take advantage of the many features and the functionality that Excel provides when structuring and analyzing data. In this video; Erin Olsen demonstrates how to clean up text in a Word document before copying it into an Excel worksheet.
-
Create a Workbook from a Template
Microsoft Excel 2013's featured worksheet templates offer easy-to-use alternatives to designing fresh worksheet templates. In this video; Erin Olsen introduces Excel 2013's default templates; and demonstrates how to search for; download; and edit a worksheet template.
-
Create an Advanced Filter
In Microsoft Excel 2013; you can limit the amount of data that you see at one time by using an advanced filter. In this video; Erin Olsen demonstrates how to do an advance filter using criteria you have specified for the data that you wish to view.
-
Customizing Display Options for Workbooks and Worksheets
Excel 2013 contains the option to adjust various settings such as; hide the formula bar; the function screen tips; show all comments; hide the scrollbars; the row; and column headers. In this video; Lynn Tao discusses how to customize display options for workbooks and worksheets.
-
Customizing the List of Recently Opened Workbooks and Folders
Excel 2013; allows you to adjust the display settings for the list of recently opened workbooks or folders. In this video; Lynn Tao discusses how to customize the recently opened workbooks and folders.
-
Edit Cell Content
Microsoft Excel 2013 enables you to edit cell data by overtyping; adding; and appending data; or by editing data in the Formula bar. In this video; Erin Olsen demonstrates each method and describes its advantages or disadvantages.
-
Add a Calculation Using the Paste Function
The paste function feature in Microsoft Excel 2013 simplifies the task of adding calculations to your workbook; guiding you through the process of creating functions while providing you with information about the arguments that the functions take. In this video; Erin Olsen uses the Function Arguments dialog box in Excel 2013 to build and add a function to a cell.
-
Add Comments to Cells
Microsoft Excel 2013 gives users the ability to comment individual cells or a range of cells in a worksheet. These comments can contain explanatory notes or reminders; and can be useful for communication in a shared workbook. In this video; Erin Olsen demonstrates how to identify a cell that contains a comment and how to insert or delete a comment.
-
Add Text to Calculated Values
By understanding the syntax and using custom formatting in Microsoft Excel 2013; you will be able to add labels to the calculated values in cells that will help clarify the data for users. In this video; Erin Olsen demonstrates how to add text to a cell containing a calculated value.
-
Adjust Row Height and Column Width
You can adjust the default row height and column width in Microsoft Excel 2013 to accommodate the content onscreen or when printed out; as well as add visual appeal to certain elements by creating extra whitespace. In this video; Erin Olsen demonstrates the various methods used to adjust the row height and column width in an Excel worksheet.
-
Allow Editing of Select Cells
Microsoft Excel 2013 provides users with the ability to allow editing of selected cells by authorized users; leaving the rest of the worksheet unavailable for editing. In this video; Erin Olsen demonstrates how to protect sections of a worksheet while allowing editing of other sections.
-
Calculate Due Dates Based on Work Days
Microsoft Excel 2013's WORKDAY date and time function differs from the DAYS and DAYS360 functions by allowing you to easily exclude weekends and holidays from your calculations. In this video; Erin Olsen demonstrates how to use the Excel 2013 WORKDAY date and time function in a worksheet; and explains how it differs from the DAYS and DAYS360 functions.
-
Export a SharePoint List to Excel
You can manipulate the data stored in a SharePoint list by exporting the list to Microsoft Excel 2013; which allows you to take advantage of the excellent formatting options and features in Excel without affecting the original SharePoint list. In this video; Erin Olsen demonstrates how to export a SharePoint list to Excel using the list tools in SharePoint.
-
Fast Convenient Chart Format Tools
In Microsoft Excel 2013; the new chart formatting tools are much easier and convenient to use. In this video; Erin Olsen; demonstrates to use the chart formatting tools to create; format; and modify charts.
-
Format a Cell Based on Its Value
In Microsoft Excel 2013; you can use conditional formatting to make data stand out; based on its value. In this video; Erin Olsen demonstrates how to format the data in the cells based on the conditions you have stipulated.
-
Format Data as a Table
Microsoft Excel 2013 provides a useful feature that allows you to format a selected area of data as a table in a couple of easy steps using one of the many predefined table styles. In this video; Erin Olsen demonstrates how to create an Excel table in a worksheet.
-
Format Tables Using Quick Styles
Microsoft Excel 2013 Quick Styles provide options that let you quickly format your tables with the flexibility of changing the style at any time while retaining your custom formatting. In this video; Erin Olsen demonstrates how to apply Quick Style formatting to tables.
-
Identify and Select Chart Formatting Tools
Microsoft Excel 2013 gives users a range of formatting tools to customize their charts. In this video; Erin Olsen discusses the difficulties many users have identifying chart elements; such as the X axis; and demonstrates how to use the Current Selection options to do this.
-
Insert and Delete Rows and Columns
Using spreadsheets in Microsoft Excel 2013 will more than likely require that the worksheet structure be modified from time to time by inserting and deleting rows and columns. In this video; Erin Olsen demonstrates the different techniques that can be used in Excel 2013 to efficiently add rows and columns into a worksheet.
-
Keep Labels Visible by Freezing Panes
Microsoft Excel 2013's Freeze Panes feature allows you to frame data by selecting which columns or rows remain visible while the rest of your worksheet scrolls. In this video; Erin Olsen demonstrates how to freeze a single column; as well as a column and a row simultaneously.
-
Let Excel Recommend a Pivot Table
Microsoft Excel 2013 simplifies the creation of pivot tables by analyzing selected data and proposing several pivot tables. Known as the Recommended PivotTables feature; this option saves steps and time; especially when analyzing complex data. In this video; Erin Olsen demonstrates how to select data and use the Recommended PivotTables option to create a suitable pivot table.
-
Look Up Additional Information from a Known Value
In Microsoft Excel 2013; you can use lookups to find information using a known value. In this video; Erin Olsen uses the VLookup function to find related data from a data source.
-
Mark a Workbook as Final
Microsoft Excel 2013's Mark as Final feature enables you to mark collaborative documents as final and disable their editing features; thereby rendering them read-only – a status that can be reversed by users with write permissions. In this video; Erin Olsen uses the Mark as Final feature to mark and save a document as final; before re-opening it for editing.
-
Merge and Center Content Across Columns
The Merge and Center feature in Microsoft Excel 2013 allows you to easily create perfectly centered headings in your worksheets that dynamically change to accommodate any adjustments you might make to the column widths. In this video; Erin Olsen uses the Merge & Center option to create a centered label that spans multiple columns in a worksheet.
-
Modify a Macro Using VBA
Microsoft Excel 2013 enables you to quickly and easily correct or amend your recorded macros by editing their VBA code in the Microsoft Visual Basic for Applications Editor. In this video; Erin Olsen shows you how to read and edit a macro's VBA code; save it as a Macro-Enabled Workbook; and run it from the DEVELOPER tab on the ribbon.
-
Modify How Worksheets Print with Page Break Preview
Microsoft Excel 2013 provides users with the ability to modify how worksheets print using the Page Break Preview option. Users can insert their own page breaks; change page break placement; and remove page breaks. In this video; Erin Olsen demonstrates how to work with page breaks so that worksheets print in a way that is clearly readable.
-
Modify Tables Using Style Options
Microsoft Excel 2013 provides you with the ability to optimally display tabular data by easily modifying an Excel table's appearance. In this video; Erin Olsen demonstrates how to modify the style of an Excel table.
-
Navigate Through Worksheets and Workbooks
Microsoft Excel 2013 enables you to swiftly and easily navigate increasingly large worksheets by way of shortcut keys. Moreover; should you know the position of a cell; you can use Excel 2013's Go To feature to take you directly there. In this video; Erin Olsen demonstrates how to use shortcut keys and the Go To feature to navigate a worksheet.
-
Organize Worksheets and Workbooks
Microsoft Excel 2013 allows you to organize your workbook's worksheets quickly and easily by simply dragging and dropping their tabs; before naming and color-coding them. In this video; Erin Olsen demonstrates how to move a worksheet from one workbook to another; format worksheet tabs; and delete worksheets.
-
Perform Different Calculations Depending on Cell Values
The IF function is one of the most versatile and useful functions in Microsoft Excel 2013 allowing you to test the value of a cell and perform different calculations depending on whether or not a certain criteria is met. In this video; Erin Olsen describes the formula syntax of the IF function and uses to create a conditional formula.
-
Presenting Online
In Microsoft Excel 2013; you can present your Workbook online by using the Lync Meeting. In this video; Lynn Tao demonstrates how to present an Excel Workbook online through the Lync Meeting.
-
Printing Tips
Microsoft Excel 2013 provides users with a range of printing options that allow you to print the active worksheet or an entire workbook. There are also several ways to optimize printing. In this video; Erin Olsen gives various printing tips to optimize printing and demonstrates how to print a worksheet; a workbook; and a data selection.
-
Protect a Workbook
Microsoft Excel 2013 facilitates secure sharing across organizations by enabling you to disable functionalities; partly or completely protecting the structure or screens of your workbooks and their worksheets from change by others. In this video; Erin Olsen demonstrates how to use Excel 2013’s Protect Workbook feature to protect your workbooks from accidental overwriting or unintended change.
-
Record a Simple Macro
Microsoft Excel 2013's macro recorder enables you to record macros; negating the need to perform repetitive actions and allowing you to accomplish complex tasks with the click of a self-designated shortcut button. In this video; Erin Olsen demonstrates how to set up; record; and save a spreadsheet macro formatted for use in a single or multiple workbooks.
-
Remove Duplicates
In Microsoft Excel 2013; you can now remove duplicate data easily and effortlessly. In this video; Erin Olsen demonstrates how to use the Remove Duplicates feature to specify the criteria for removing duplicate data.
-
Remove Metadata and Personal Information
Microsoft Excel 2013's Document Inspector enables you to selectively edit a shared document's metadata and allows you to remove personal information from it. In this video; Erin Olsen gives an overview of multiple categories of metadata and uses the Document Inspector to remove personal information from a document.
-
Resize a Table
Microsoft Excel 2013 provides different methods that you can use to accurately identify a range of table data by manually modifying the size of tables. In this video; Erin Olsen demonstrates how to resize a table and specify a new table data range.
-
Save Data to a SharePoint Library
Microsoft Excel 2013 allows you to easily save your Excel data directly to a library on a SharePoint site; providing colleagues within your organization with the ability to access the data. In this video; Erin Olsen demonstrates how to save a workbook to a SharePoint library from the Backstage in Excel 2013.
-
Select Data in Excel
Microsoft Excel 2013 allows you to select worksheet data using navigation shortcut keys in conjunction with the Shift key; as well as with your mouse. In this video; Erin Olsen demonstrates various methods of selecting entire rows and columns; contiguous and discontiguous data selections; and your entire worksheet.
-
Send a Workbook Using Lync
Microsoft Excel 2013 enables users to send workbooks to other user via Lync. This is the integrated messaging service provided by various Microsoft Office 2013 applications; such as SharePoint. This feature enables workbooks to be shared quickly and in context. In this video; Erin Olsen demonstrates how to send a workbook using instant messaging rather than e-mail.
-
Simplify Data with an Outline
Microsoft Excel 2013's Auto Outline feature enables you to expand and collapse specific areas of your spreadsheets; containing calculations; for selective data presentation to different audiences – negating any need to maintain multiple versions. In this video; Erin Olsen demonstrates how to best set up; organize; and present multiple collapsible and expandable data levels using Microsoft Excel 2013's Auto Outline feature.
-
Sort Worksheet Columns
In Microsoft Excel 2013; you can organize data in a number of ways. In this video; Erin Olsen uses the in-column filters in a defined table; as well as the Sort & Filter tool to sort data in worksheet columns.
-
Split Single Text Entries into Multiple Columns
In Microsoft Excel 2013; you sometimes have to split single text entries into multiple columns. Excel provides a wizard that makes this easy to do. In this video; Erin Olsen demonstrates how to use the Text to Columns wizard to split single columns into multiple columns using a delimiter.
-
Splitting a Worksheet into Windows
In Excel 2013; splitting a Worksheet into Windows allows you to compare different sections of the worksheet. In this video; Lynn Tao discusses how to Split a worksheet into Windows in Excel 2013.
-
Summarize Data with Sparklines
Microsoft Excel 2013's Sparklines feature dispenses with elaborate graphs to give your data trends visual clout by enabling you to render custom; multi-cellular spreadsheet data in multiple graphic styles. In this video; Erin Olsen uses the Sparklines feature to show you how to select; define; and format spreadsheet data selections as mini-charts capable of communicating trends with immediate graphic impact.
-
Summarize Data with Subtotals
Microsoft Excel 2013 gives users the ability to summarize data using subtotals. This method can be used only if there are at least three columns of data; which have been sorted by category. In this video; Erin Olsen demonstrates how to choose a valid Subtotal field; summarize the data; and troubleshoot the process if it doesn't work.
-
Understand and Use Excel Views
Microsoft Excel 2013's views offer you three different views of your worksheet; each of which offers you different options and lets you format your worksheet according to your needs. In this video; Erin Olsen details the options available in the Normal; Page Layout; and Page Break Preview views.
-
Understand How Table Calculations Differ
Table calculations in Microsoft Excel 2013 differ from conventional worksheet calculations and with an understanding of how the table calculations work you'll be able to take advantage of the numerous advantages they offer. In this video; Erin Olsen demonstrates how to perform a simple table calculation and describes the benefits of using table calculations.
-
Use a Timeline to Filter Pivot Tables
Microsoft Excel 2013 enables the user to slice data in various ways using the timeline in a pivot table; if the data contains dates. In this video; Erin Olsen demonstrates how to select data and use the Recommended PivotTables option to create a suitable pivot table.
-
Use Flash Fill
In Microsoft Excel 2013; you can use Flash Fill to auto-complete data in a column. In this video; Erin Olsen uses Flash Fill to auto-complete a column by comparing text entered into a cell with the data in adjacent columns.
-
Use Goalseek to Find an Input
In Microsoft Excel 2013; you can calculate what-if type questions quickly; efficiently; and accurately using the Goal Seek feature. In this video; Erin Olsen; demonstrates how to use Goal Seek to calculate the answers you need; without knowing all the inputs required getting to the answer.
-
Use Quick Analysis Tools
In Microsoft Excel 2013; you can analyse your data even faster and easier using the Quick Analysis tool. In this video; Erin Olsen demonstrates how to use the Quick Analysis tool to analyse your data and create meaningful information.
-
Use Recommended Charts
Microsoft Excel 2013 gives users the ability to select a chart that suits their data from a list of recommended charts. The Recommended Charts feature presents previews of various charts based on the user's actual data. In this video; Erin Olsen demonstrates how to select a data range and choose a chart that best illustrates that data.
-
Use the Namebox to Select Cells
In Microsoft Excel 2013; you can easily navigate to cells and worksheets using the Name box. In this video; Erin Olsen; demonstrates how to use the Name box to select cell names and move to the desired location in your worksheets.
-
Use the Watch Window to Inspect Formulas
In Microsoft Excel 2013; you can use the Watch Window feature to monitor calculations across multiple worksheets while working with data in another worksheet. In this video; Erin Olsen uses the Watch Window to keep track of a calculation on one worksheet while entering data into a different worksheet.
-
Validate Data
Microsoft Excel 2013 includes a data validation feature that you can use to define restrictions and control the data that users enter into a worksheet; thereby eliminating data entry errors. In this video; Erin Olsen demonstrates how to define a validation rule and provide messages to guide users; ensuring worksheet data integrity.
-
View Calculation Flow
Microsoft Excel 2013 includes commands that allow you to visually represent the relationship between cells and formulas that can be very useful when contextualizing the flow of calculations as well as providing assistance when checking formulas for reference errors. In this video; Erin Olsen demonstrates how to use the Trace Precedents and Trace Dependents options in Excel.