call us now on 020 8203 1774
or email on enquiries@theittrainingsurgery.com
Category: Excel Training, Microsoft Excel 2010, Tips for Windows Users
Find the Average Minimum or Maximum Excel When working we often have long lists of figures in a spreadsheet. If you have a list of shops that sold coffee you might want to find out which was the smallest sales figure in the list, or perhaps you want to find out what the average sales is […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
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 […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
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 […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
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 […]
Read MoreCategory: IT Quick Tips, Microsoft Excel, Microsoft Excel 2010, Tips for Windows Users
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 […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
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 […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
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 […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
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, […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
