How to convert factor data to numeric data whilst maintaining the decimal accuracy of the data.
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.
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.
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.