Category Archives: Basics

Basics

How to Make Excel 2010 formulas invisible or visible

There can be many reasons why you might want to make the formulas visible on your Excel sheet. Here you will learn how to make excel formulas invisible/visible.


read more »

Basics

How to Make Excel 2010 formulas absolute

The default setting for formulas in excel is for them to be relative to the other data on the spreadsheet, this tutorial will show you how to make excel formulas absolute instead.


read more »

Basics

How to Make Excel 2010 formulas for columns

If you have a great deal of data and need to apply many formulas, learning how to make excel formulas for columns is a valuable time saving skill.


read more »

Basics

How to Make Excel 2010 formulas calculate automatically

The default setting is for formulas to automatically calculate in Excel. This tutorial will show you how to make excel formulas calculate automatically if this setting has become deactivated.


read more »

Basics

How to Link Excel 2010 columns between worksheets

Multiple worksheets in a single workbook is a useful feature of Excel, sometimes you need to link an entire column between worksheets. This tutorial will show you how to link excel columns between worksheets.


read more »

Basics

How to Link Excel 2010 formulas between worksheets

Each Excel workbook has the option to create several worksheets, this tutorial will show you how to link excel formulas between worksheets.


read more »

Basics

How to Link Excel 2010 worksheet to another workbook

If you are managing a lot of data, linking a sheet from one workbook to another can be a valuable skill, this tutorial will show you how to link excel worksheet to another workbook.


read more »

Basics

How to start Excel 2010 in safe mode 2010

If you have been having some problems with excel then learning how to start excel in safe mode 2010 version is a useful skill.


read more »

Basics

How to Update Excel 2010 drop down list

If you have a drop down list in Excel you might find yourself wanting to enter data not available in the list. This tutorial will show you how to update excel drop down list so you can enter your own data.


read more »

Basics

How to Update Excel 2010 pivot table

The pivot table is certainly one of the most powerful features in Excel. Learning how to update excel pivot table is essential as it will keep your table up to date when you change the source data.


read more »