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.
Conditional formatting allows you to quickly highlight important information in a spreadsheet based on your particular criteria. This feature allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. It can also help you represent data in graphical form based on defined values you specify. You can create data bars and icon sets to depict values or divide them into categories. In addition, you can use data bars and icon sets to compare column values to one another. You can also use color scales to format cells differently depending on their values. To boost the performance of the Conditional Formats, you can create your own formula within the Conditional Formatting Rule feature.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.