Calendar module icon

Calendar

View All Calendars is the default. Choose Select a Calendar to view a specific calendar. Subscribe to calendar notifications by clicking on the Notify Me® button, and you will automatically be alerted about the latest events in our community.

Return to Previous

Event Details


Date:
December 10, 2021
Time:
8:30 AM - 12:00 PM
Time Details:
Virtual event. Facilitated by Jody Christopherson-Degan of Dallas College .
Location:

Virtual Class

Facebook Twitter Email

Microsoft Excel Level 3, Mini Session 2

Friday, December 10, 2021


Microsoft Excel Level 3, Mini Session 2


SUMIF: to sum data based on a particular piece of data

SUMIFS: to sum data base on two particular pieces of data

DSUM: to sum a column based on a certain identifier

COUNT: to count numbers; COUNTIF: to count items; COUNTIFS; COUNTA; 

COUNTBLANK

Database Subtotals within a sorted database

            Sum, average, count, minimum or maximum 

FUNCTIONS: DAY, MONTH, YEAR, FIND, LEFT, RIGHT, RANK

Linking Worksheets

Text functions: for dates to appear a certain way

Advanced VLOOKUP


Click here to enroll in this Zoom session.

Map
Facility Submit Event Print Email Event Subscription RSS Feed Select on Calendar Expand Collapse Previous Next Down Up Map Share Show more