call us now on 020 8203 1774
or email on enquiries@theittrainingsurgery.com
Category: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Headers and Footers In Microsoft Excel 2010 you can add extra text to the headers and footers in spreadsheets. The type of information you can add can include page numbers, current date, file path and sheet name. You can type on the left, right and centre of a header or […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here are some steps to follow when you want to use The Name a Box in Microsoft Excel 2010. The Name Box The name box (1) sits beside the Formula bar and tells you the cell you are currently in. Naming the cell It can sometimes make more sense to […]
Read MoreCategory: IT Training Blog
Quick Tip for Microsoft Excel 2010 Microsoft Excel 2010 normally copies all the information in the range of cells you select when you paste the data. Use Excel’s Paste Special command to specify other options, such as pasting only the cell contents (without the formatting) or only the formatting (without the cell contents). To use Paste […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Here are some steps on how to set the workbook properties for every Workbook you create in Microsoft Excel 2010. Workbook Properties in Microsoft Excel can help you to find your workbook more easily and to see who the author was. You can also see when the workbook was last saved and how long it […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here are some quick steps on using the Alt key in Microsoft Excel 2010 The Alt key can be used to access functions in Excel without having to go to the mouse. When you press the Alt key, letters and numbers appear next to the ribbon tabs and the […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 The Quick Access Toolbar is where you can store and use shortcuts to Excel functions you use most often. Here are some steps to follow for customising your Quick Access Toolbar: Customising the Quick Access Toolbar (QAT) To add a function you use often to the Quick Access Toolbar: Click […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Save in Different Formats in Excel 2010 If you work with people who are still using an older version of Excel you may want to save your spreadsheets in a compatible format. Here are some steps to follow when you want to use Save As Type to Save in a different format when using Microsoft […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel 2010, Tips for Windows Users
Here is an introduction to Workbook Views in Microsoft Excel 2010. The Excel View options allow you to view or see the spreadsheet differently. You can adjust the Excel window to suit what you are currently working on by changing the view to match your current task. Excel offers three different views: Page Layout – […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
