Plot Two Sets of Data on an X Y Scatter Chart

This video show how to plot two sets of data into an X Y Scatter chart. It also shows how to add additional axis to the chart for a total of four axes.

Combine Tables from Multiple Sheets in the Same Workbook with Power Query

If you work with data in many worksheets, sometimes it's better to combine this all into one worksheet. Especially if they all have the same header fields. You can usually do a copy and paste, but if there are a lot of worksheet or if this is a recurring task, you might want to semi automate it. Power Query makes this easier to do. This video shows how to combine tables from different tabs in the same file using the Append capability in the Excel with Power Query.

Lock Rows and Columns with Freeze Panes or Split

If you've got a table with lots of rows or columns, you usually end up doing a lot of scrolling either horizontally or vertically. When doing that it gets easy to lose site of what the cell values mean. That why header fields are usually good to have stay static when scrolling through rows or columns. There is a way to lock those in either by freezing those cell ranges or by splitting the views. See the video to learn to to lock rows or columns with Freeze Panes or Split in Excel.