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:
October 4, 2022
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 2, Mini Session 1

Tuesday, October 4, 2022


Microsoft Excel Level 2, Mini Session 1


Practice formula exercise and practice absolute and relative

 Change tables to Databases and opposite

 Create cell styles within a workbook

 Fill Series: dates, numbers, quick tool

 String Values for combining words or groups of words and CONCATENATE

 Text to column

IF / ELSE function to check formulas

 IF / ELSE for condition

 Functions: UPPER, LOWER, PROPER, MIN, MAX, AVERAGE

 Formulas copied to another page

 Evaluate Formulas to view step by step evaluation

 Auditing Formula to point to cells in a formula: dependent and precedents

 Circular References

Mirror Image

 Transpose formulas to values

 Paste Values

 Range Names and Range Names with functions and formulas with F3


Click here to enroll in this Zoom session.

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