Category Archives for "Excel Lessons"

3D Sum

In Excel, a 3D Reference refers to the same cell or range in multiple worksheets.  The 3D Sum allows you to sum the same cells in multiple worksheets. To demonstrate this,  we have 4 worksheets and in Cell B1 of each sheet, there is a sales value that we want to get the total of. […]

Continue reading

Paste Special

Paste Special is another time saving trick that may be going underused. You are probably already familiar with the cut, copy and paste functions in a lot of applications. Copy allows you to make a copy of selected or highlighted data to be pasted somewhere else Cut allows you to remove selected or highlighted data […]

Continue reading

Get every new post delivered to your Inbox

Join other followers: