Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
Freezing Column Headings on spreadsheet
$31.50
You can use the Freeze Panes command to “freeze” (lock) rows and/or columns in place so that headings remain visible at the top of your report as you scroll down your spreadsheet.
You can link multiple worksheets within a workbook and you can link multiple workbooks. You can do this by writing a formula in one workbook that refers to a cell, range, or name in another worksheet tab or workbook file. The benefit of this is if the data changes in one location, all linked cells will automatically update accordingly.
The Autofilter allows you to find, show or hide specific data faster within a database. You can filter data based on two or more criteria by using Excel’s advanced filtering features. Excel provides the Custom AutoFilter and Advanced Filter tools for specifying multiple filtering criteria. Filtering refers to displaying only the information that meets specific criteria.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.