Відео

How to add custom error bars to an Excel chart. Add the positive and negative error values to your data table first, then use the 'Custom | Specify Value' option in the Format Error bars dialog. For more details visit our webpage excelquick.com/excel-charts/excel-chart-error-bars/

Step by step explanation of how to add a reference line, such as an average or benchmark value, to a horizontal bar chart in Excel. For more details visit our webpage excelquick.com/excel-charts/add-a-reference-line-to-a-horizontal-bar-chart-in-excel/

Excel's VLOOKUP with CONCATENATE to look up values in a table. Combine values in multiple cells for the lookup. For more details see our web page excelquick.com/excel-function/vlookup-with-concatenate-in-excel/

Create a data entry form in Excel to make it easy to add records to your data table. The video starts with a data table with a few rows already created. The data is formatted as an Excel table, and then a form view can be opened. For more details visit our help web page at excelquick.com/excel-general/data-entry-form-in-excel

How to customize the ribbon in Excel. Add your own tab and group to the ribbon, and select commands. From the dropdown arrow at the end of the Quick Access Toolbar, choose 'Customize ribbon'. For more details go to our webpage excelquick.com/excel-general/customize-the-ribbon-in-excel

How to create an array of values using Excel's CHOOSE function, and how to delete an array. For more details see our web page excelquick.com/excel-function/choose-function-array/. With an array formula, you need to use Ctrl-Shift-Enter to run the formula. If you have a current version of Excel with Office 365, you can enter the formula into the first cell in the range (you don't need to select ...

How to create a conditional formatting rule to highlight cells with values less than a target value, and then copy that formatting rule to other ranges of cells which are not adjacent. For more details visit our web page at excelquick.com/excel-general/conditional-formatting-of-non-adjacent-cells/, which also shows a second simple method to copy conditional formatting.

How to add an Index column to a Power Query data table in Excel. Shows how to reference (build on) another data query, add an Index column, move the column to the first column in the table, rename the data query, and save as a data connection. See more details on our webpage here, plus how to create a data connection to another Excel workbook using Power Query excelquick.com/excel-power-query/p...

How to connect to data in another Excel workbook using Power Query in Excel 2019 or 2016. From the data tab in the ribbon, select Get data. This example shows how to create a connection only rather than loading the data, which is useful when working with large datasets. More details on our webpage here excelquick.com/excel-power-query/power-query-connect-to-data/.

A group of sparklines can be created in Excel, as well as single sparklines. The main benefit is to customize all the charts together. The video above starts with a table of data, and with the first sparkline already created, spanning two columns (using the ‘Merge & Center’ command). To add additional sparklines, drag the right-hand corner of the sparkline down to fill the cells below. Each spa...

Excel’s Sparklines were introduced in Excel 2010, and are a super neat way to add mini data visualizations, which sit within a cell or range of cells. Excel will only allow a sparkline to be first created in a single cell. You can then merge and center cells, and increase row height, to resize the sparkline chart to the desired size. See our web post on sparklines here excelquick.com/excel-char...

An Excel workbook contains one or more worksheets. This short video shows you how to add, move, group and copy worksheets within and between Excel workbooks. We also show you how to navigate between sheets in large multi-worksheet file, how to hide and unhide worksheets, and how to protect and unprotect them. For more details view our webpage excelquick.com/excel-quick-help-videos/add-move-grou...

You'll need your data set out so that main categories are in the left hand column of your data table, sub-categories are in the next column, and then your value column(s) are to the right of that. By merging the categories, Excel will create a multi-level category chart when you plot the data. See more details here excelquick.com/excel-charts/create-a-multi-level-category-chart-in-excel/

Excel includes features on the Data tab | Outline section of the ribbon to group and subtotal data. Grouping the data allows parts of the the data table to be hidden, to make it easier to navigate large data tables, and to be summarized by various functions such as Sum, Average, and Count. See here for more details excelquick.com/excel-general/group-and-subtotal-data-in-excel/

How to name a range of cells in Excel

Create a dropdown list in Excel using Data Validation

Add custom error bars to Excel bar chart