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.
How to create and use a data entry form in Excel
How to customize the ribbon in Excel – add commands, create a new tab and group of commands in the ribbon
Short videos and step by step guide on how to get started with Power Query – connect to data and add an Index column.
How to use Excel’s TIME function to add time to time, with a worked example to create a series of appointments.
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.
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.
How to add a data label to just one data point on a chart in Excel.
How to calculate and plot custom error or confidence interval data on an Excel chart.
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.