Fill Blank Cells in Excel With Value from Above
https://youtube.com/watch?v=iIKqeaFvltQSome Excel sheets have blank cells, so headings are easier to read. If you want to sort or filter the list, you need to fill blank cells in Excel with…
Create a Pivot Table in Excel 2013
https://youtube.com/watch?v=1NaimbSyo0EA pivot table is a quick and easy way to summarize data in Excel. In Excel use the Recommended PivotTables tool, to see how easy it is to get started.…
Autocomplete Entries With Excel Drop Down List
https://youtube.com/watch?v=vOOuSe_s6pQTo make data entry easier, create a drop down list in an Excel cell, using data validation. This saves you time, and prevents errors, but has some limitations. -The font…
7 Ways to Sum in Excel
https://youtube.com/watch?v=t8Kbi_D5vjUhttp://www.contextures.com/xlFunctions01.html Visit this page to download the sample file for this video. You can Sum numbers with a single click, to create grand totals. Use the SUM function to avoid…
Auditing Excel Formulas – Quick Tips
https://youtube.com/watch?v=CpXWslv-e8chttp://www.contextures.com/excelformulasaudit.html Visit this page to download the sample file. When troubleshooting formulas in Excel, you can use keyboard shortcuts and Ribbon commands to help with auditing the formulas. For example,…
Excel Worksheet Navigation Tips
https://youtube.com/watch?v=3QioIhMkDEchttp://www.contextures.com/excelworkbooktips.html Visit this page to get more Excel workbook tips. It can be difficult to find a specific sheet, if an Excel file has many worksheets. This video shows how…
Excel VLOOKUP From Another Workbook
https://youtube.com/watch?v=6pSYP2plbdIIn a VLOOKUP formula, you can refer to a lookup table that is in a different Excel workbook. In this example, the price list is in one workbook, and the…