Catalog: LHRIC & SWBOCES

Search Options

Search Results (1 - 1 of 1)

Intermediate Excel Tips and Strategies

Program: LHRIC - Professional Development for Administrators and Support Staff

Audience: Administration and Support Staff

Dates: 3/12/2018

In a one-day course, students will create a running balance; custom sort data; wrap text; split data into separate columns; combine data into one column; create and use range names; work with multi-level spreadsheets; use conditional formatting; create a basic chart; and work with functions such as IF, COUNTIF and SUMIF. Participants will use DATEDIF to calculate current student age or employee years of service. Subtotals will also be covered. (Prerequisite: Introduction to Excel) *Special Introductory 2 for 1 Offer - Non-Members buy one seat get one additional registration free(based on availability)