evergreen-reports:meetings:2022-09-28
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
evergreen-reports:meetings:2022-09-28 [2022/10/04 14:20] – jventuro | evergreen-reports:meetings:2022-09-28 [2022/10/11 09:11] (current) – jventuro | ||
---|---|---|---|
Line 13: | Line 13: | ||
* Crossover with Cataloger Interest Group | * Crossover with Cataloger Interest Group | ||
* Guest speaker - Tiffany Little of PINES to talk about tips and tricks for manipulating report output in Excel! | * Guest speaker - Tiffany Little of PINES to talk about tips and tricks for manipulating report output in Excel! | ||
- | * Formulas at the top for ease of the spreadsheet for ease | + | * Formulas at the top of the spreadsheet for ease |
* To freeze header row - View tab - Freeze pane (select row underneath header row) | * To freeze header row - View tab - Freeze pane (select row underneath header row) | ||
* Filters and subtotal function | * Filters and subtotal function | ||
Line 40: | Line 40: | ||
* (B2=C2) will show true of false | * (B2=C2) will show true of false | ||
* Pivot table to show authors that patrons are requesting that you may not own | * Pivot table to show authors that patrons are requesting that you may not own | ||
- | | + | |
- | * To refer back to formulas later, keep formulas in a separate sheet to work in. Then paste report data into another sheet. | + | * To refer back to formulas later, keep formulas in a separate sheet to work in. Then paste report data into another sheet. |
* Scheduling for the end of the year - October and November meetings will be held as scheduled. December meeting will be canceled. | * Scheduling for the end of the year - October and November meetings will be held as scheduled. December meeting will be canceled. | ||
evergreen-reports/meetings/2022-09-28.1664907643.txt.gz · Last modified: 2022/10/04 14:20 by jventuro