| How to add a data label to just one data point on a chart in Excel. Add a DATA LABEL to ONE POINT on a chart in Excel | To add a reference line such as an average or benchmark to a horizontal bar chart. step by step guide with videos and screenshots. Add a REFERENCE LINE to a HORIZONTAL BAR chart in Excel | Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel. Add a REFERENCE LINE to a VERTICAL BAR chart in Excel | How to use Excel's TIME function to add time to time, with a worked example to create a series of appointments. Add time using Excel’s TIME() function | How to add, move, group and copy worksheets within and between Excel workbooks, and how to navigate between sheets in large multi-worksheet file, and how to hide and unhide worksheets. Add, move, group, copy, hide and protect Excel worksheets | Sum the current value and all those that precede it in a column. This topic also shows how to fill cells down a column. Calculate a RUNNING TOTAL in Excel | Absolute and relative cell references, and ranges in Excel CELL references and ranges in Excel | Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation CHOOSE function with LINEST in Excel | To compare more than 2 cells to check if they are equal.
=(A1=B1)*AND(B1=C1) COMPARE more than two values in Excel | To apply conditional formatting in Excel to non-adjacent, non-sequential cells. CONDITIONAL FORMATTING of non-adjacent cells in Excel | How to copy and paste a formula in Excel COPY and PASTE a FORMULA in Excel | Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation Create a DROPDOWN LIST in Excel | How to create a chart with multi-level categories and sub-categories. Create a MULTI-LEVEL CATEGORY chart in Excel | How to customize the ribbon in Excel - add commands, create a new tab and group of commands in the ribbon Customize the ribbon in Excel | How to create and use a data entry form in Excel Data entry form in Excel | If you're new to Microsoft Excel, or to any function software for that matter, there are a few basic approaches to take Excel BEGINNER tips | To test IF a value matches a condition, and return one result if TRUE, and another if FALSE. Excel IF function | Excel's IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message. Excel IFERROR function — examples: return a blank; with VLOOKUP; perform a different function | How to use Excel's Sparklines -- mini column, line and win-loss charts. See how to create and customize sparklines to show data trends, and how to clear or delete sparklines from a worksheet. Excel Sparklines — create, resize, customize, and clear | How to return an array of non-adjacent cells in Excel. Excel’s CHOOSE function with array | To join text and/or numbers together using Excel's CONCATENATE / CONCAT function. An example is shown how to generate a a set of SUM(CASE WHEN) SQL statements. Excel’s CONCATENATE / CONCAT function — create a SUM(CASE WHEN) SQL statement | FILL DOWN cells in a column in Excel | It can be useful to inspect a cell's formula visually without having to click in it to display the formula in the formula bar. Excel's FORMULATEXT function enables you to see the formula in another cell. FORMULATEXT function in Excel – display formulas | How to use Excel's RANDBETWEEN function to generate random numbers between two values. A short video shows how to turn the values from dynamic to static. Generate RANDOM numbers with Excel’s RANDBETWEEN function | Short videos and step by step guide on how to get started with Power Query - connect to data and add an Index column. Get started with Power Query – connect to data and add an Index | How to use Excel's group and summarize data functions. GROUP and SUBTOTAL data in Excel | How to calculate and plot custom error or confidence interval data on an Excel chart. How to add custom ERROR BARS in Excel charts | How to import data into R from files stored in local directories. Includes how to copy file paths in Windows, how to use relative and absolute file paths, and working in R Projects. Importing data – absolute and relative file paths in R | How to display today's date and time in Microsoft Excel Insert current DATE and TIME in Excel | How to display today's date in Microsoft Excel Insert current DATE in Excel | How to add multiple rows or columns into an Excel spreadsheet Insert MULTIPLE ROWS or COLUMNS in Excel | Code to create a map in R Shiny using Leaflet. This example loads a base map, sets the centre and zoom, and has a reset button to return the map to the original view. LEAFLET map in R Shiny | Welcome to the new Excel Quick Help website giving free help for Microsoft Excel 2016! New website | Add, subtract, multiply or divide a set of values by another value, using 'Paste Special'. PASTE SPECIAL with formulas | How to protect your Microsoft Excel workbook so that users can only view the worksheets you want them to, and data and workbook structure can't be changed. PROTECT an Excel 2016 workbook | Remove blank cells in a list of values in Excel using Advanced Filter, retaining the original list. REMOVE BLANK cells in a list using Excel’s ADVANCED FILTER | How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by 'N/A' values using an IF statement. Remove BLANK CELLS in chart data table in Excel | To equalise column widths or row heights in Excel, by selecting a range of columns/rows, and dragging a column/row divider. Set EQUAL COLUMN widths or row heights in Excel | How to transform data between wide and long formats, and plot the data in R using the base plot() function. Steps show how to import data using read.csv, replace the header column, convert wide data to long data, and plot the data. Transform and plot data in R using plotly | How to use the VLOOKUP function in Excel VLOOKUP Excel function – explanation and examples | Look up values in a table, using Excel's VLOOKUP with the CONCATENATE function to combine values in multiple cells for the lookup. For example, convert a long format data table to a wide format data table. VLOOKUP with CONCATENATE in Excel | An introduction to the different scopes of the assignment operators '<-', '=' and '<<-' in R programming, with examples of using the operators in the global environment and in functions. What is the difference between =, <- and <<- in R