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 […]
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 […]
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 […]
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 […]
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 […]
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 – […]