How to create a macro in Excel in 3 easy steps. The macro sums a column of values which can be set dynamically by referring to range using the INDIRECT() function. This method also shows how to use a dynamic formula which reads a value from the cell above the current cell.
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 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.
Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation
How to use Excel’s group and summarize data functions.
How to create a chart with multi-level categories and sub-categories.
