IF Function (IF Statement) in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 Here I talk about IF Function (IF Statement) in Microsoft Excel 2010 An If function asks Excel to consider if something is true or false.  If it is true it will return one answer, if it false it will return a different answer. For example:  Can my company afford to […]

Hide and Unhide a Worksheet in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 Here is how to Hide and Unhide a Worksheet in Microsoft Excel 2010. To Hide a Worksheet 1. Right click on the Sheet tab you want to hide 2. Click on Hide 3. The Sheet tab disappears To Unhide a Worksheet 1. Right click on any Sheet tab in the Workbook […]

Delete Copy and Move a Worksheet in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 Here is how to Delete Copy and Move a Worksheet in Microsoft Excel 2010. To Delete a Worksheet 1. Right-click on the sheet you wish to delete 2. Click on Delete 3. Click OK on the confirmation dialog box Copy a Worksheet To copy a worksheet via right-click 1. Right-click on […]

Insert Worksheets in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 You need to add a worksheet to your Excel Workbook. It might be for a different product category, or perhaps you need one worksheet per month? Here is how to insert Worksheets in Microsoft Excel 2010. To insert a worksheet using the icon. 1. Click on the New Worksheet icon […]

How to Input an Absolute Cell Reference in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 Here is How to Input an Absolute Cell Reference in Microsoft Excel 2010. To input an absolute cell reference while creating a formula Select the cell where you require the first formula Enter the formula as normal Press F4 after the cell reference you wish to be absolute (Dollar signs will […]

Absolute Cell References in Excel 2010

Quick Tip for Microsoft Excel 2010 How to use Absolute Cell References in Excel 2010 Using AutoFill to copy formulas is a great way to save time, but the cell references in the original formula do not always need to be adjusted. There are some situations where a cell reference needs to remain constant. For example: Look […]

Intro to Formulas in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 Here is an introduction to Formulas in Microsoft Excel 2010. A Formula is the term used for a calculation in your spreadsheet. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, […]

Copy Formatting using Autofill in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010 Here I show you how to copy Formatting using Autofill in Microsoft Excel 2010. AutoFill also allows you to copy formats from one cell to another. To copy formatting using Autofill 1. Format the content in your first cell. 2. Position your cursor so it hovers over the bottom right […]

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.