Skip to main content
close
font 1 font 2 font 3
Reset to standard size
Font size options
Increase or decrease the font size for this website by clicking on the 'A's.
Yellow on Black White on Black Soft Greys Black on Linen Black on White
Reset to default contrast
Contrast options
Choose a color combination to give the most comfortable contrast.
Image for event: Excel: Drop-down lists & Conditional Formatting

Registration now closed

Excel: Drop-down lists & Conditional Formatting

In-person Computer Instruction
2023-10-10 18:30:00 2023-10-10 20:00:00 America/Chicago Excel: Drop-down lists & Conditional Formatting Excel is a spreadsheet program that allows you to analyze data, create tables, charts, and use formulas. St. Charles Public Library - Computer Lab

Tuesday, October 10
6:30pm - 8:00pm

Add to Calendar 2023-10-10 18:30:00 2023-10-10 20:00:00 America/Chicago Excel: Drop-down lists & Conditional Formatting Excel is a spreadsheet program that allows you to analyze data, create tables, charts, and use formulas. St. Charles Public Library - Computer Lab

Excel is a spreadsheet program that allows you to analyze data, create tables, charts, and use formulas.

Drop-down lists allow you to make a selection from a list of items you've created. It's a useful feature for calendars and spreadsheets shared with others. 

Conditional formatting applies your choice of formatting to a cell based on the data entered in the cell and the criteria you set for the conditional formatting.  

AGE GROUP: | Adults |

EVENT TYPE: | Tech Class |

TAGS: | Microsoft | Excel |

St. Charles Public Library
Phone: 630-584-0076 x1
Fax: 630-584-9262
Hours

St. Charles Public Library
scpld.org

MON-THU 9 A.M.-9 P.M.
FRI 9 A.M.-8 P.M.
SAT 9 A.M. - 5 P.M.
SUN 12 P.M.-5 P.M.
 

 
Address
One South 6th Avenue
St. Charles, IL 60174
Tel: 630-584-0076 x1
About the branch

The award-winning St. Charles Public Library District is located in the scenic Fox River Valley, 35 miles west of Chicago. The Library serves a district population of 55,092 residents and has a staff of 101. The St. Charles Public Library is an equal opportunity employer.

Upcoming Events

Craft of the Month - Woven Hanging Wall Art
Thu, May 08, 10:00am - 11:30am
Computer Lab,STC Creative
Create a woven piece of art to decorate your home.
Registration is now closed
Family Storytime (All Ages with Caregiver)
Thu, May 08, 10:00am - 10:30am
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
Mac Barnett Book Bash (Grades K-2)
Thu, May 08, 5:30pm - 6:15pm
Helen Gale Story Room
Join us for a Mac Barnett Book Bash! We will read and talk about some of his best books while we have a snack, do puzzles, make a craft, and leave with some great book recommendations.
Registration is now closed
Upcycled Storybook Birdhouse
Thu, May 08, 6:30pm - 7:30pm
Huntley Community Room
Remember your favorite golden book?
Registration is now closed
Friday Fun (Grades K-5) - Dominoes
Fri, May 09, 4:00pm - 6:00pm
Helen Gale Story Room
Challenge yourself to master new building techniques and test your skills in domino toppling!
St. Charles Writers Group
Sat, May 10, 9:15am - 12:15pm
Huntley Community Room
The St. Charles Writers Group is a workshop for novice or experienced writers that meets twice a month.
Cryptid Creep & Crawl (Families)
Sat, May 10, 9:30am - 4:30pm
Youth Services
Bigfoot, Mothman, and Nessie, oh my! Join us for this special cryptid-themed scavenger hunt! Scavenger hunt sheets will be available at the youth desk.
Cryptid Creep & Crawl (Families)
Sun, May 11, 12:30pm - 4:30pm
Youth Services
Bigfoot, Mothman, and Nessie, oh my! Join us for this special cryptid-themed scavenger hunt! Scavenger hunt sheets will be available at the youth desk.
5-Minute Makes - Leatherette Flower Keychain
Sun, May 11, 1:00pm - 2:30pm
Computer Lab,STC Creative
Roll our precut Leatherette roses and make a keychain to take home.
Family Storytime (All Ages with Caregiver)
Mon, May 12, 10:00am - 10:30am
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
We Love Cardinals (Grades K-5)
Mon, May 12, 4:00pm - 4:45pm
Helen Gale Story Room
Next in our We Love…Series are Cardinals! There’s more to these bright red backyard birds than just being the Illinois state bird. Come learn, explore, and research these crested creatures with us.
One-to-One Resume Review - with a Career Coach from workNet Batavia
Mon, May 12, 4:00pm - 4:30pm
Study Room 5
Meet with a workNet Batavia Career Coach for a one-to-one review of your resume.
This event is full
One-to-One Resume Review - with a Career Coach from workNet Batavia
Mon, May 12, 4:30pm - 5:00pm
Study Room 5
Meet with a workNet Batavia Career Coach for a one-to-one review of your resume.
This event is full
One-to-One Resume Review - with a Career Coach from workNet Batavia
Mon, May 12, 5:00pm - 5:30pm
Study Room 5
Meet with a workNet Batavia Career Coach for a one-to-one review of your resume.
My First Storytime (0-23 Months with Caregiver)
Mon, May 12, 6:00pm - 6:30pm
Miller Haase Community Room
Connect with your baby for an interactive and engaging storytime session full of songs, rhymes and stories! Please register baby only. 
My First Storytime (0-23 Months with Caregiver)
Tue, May 13, 9:30am - 10:00am
Miller Haase Community Room
Connect with your baby for an interactive and engaging storytime session full of songs, rhymes and stories! Please register baby only. 
Introduction to Microsoft Word - In-person Computer Instruction
Tue, May 13, 10:00am - 11:30am
Computer Lab
Learn the basics of word processing.
Second Tuesday Book Discussion - Wandering Stars by Tommy Orange
Tue, May 13, 10:00am - 11:30am
Carnegie Community Room
The Library offers two book discussion sessions on the second Tuesday of each month: Mornings at 10:00 a.m. and Evenings at 7:00 p.m.
2 & 3 Year Old Storytime (with Caregiver)
Tue, May 13, 10:30am - 11:00am
Miller Haase Community Room
Interactive storytime for children and their parents/caregivers! Please only register your child.
This event is full
Family Storytime (All Ages with Caregiver)
Tue, May 13, 6:00pm - 6:30pm
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
Medicare Basics - Everything You Need to Know
Tue, May 13, 6:30pm - 8:00pm
Huntley Community Room
Medicare is complicated! Learn about Parts A and B, Supplement Plans, Part D, Advantage Plans, when (and how) to enroll.
Coming to America: The Immigrant Experience - Genealogy Presentation
Tue, May 13, 7:00pm - 8:00pm
Carnegie Community Room
Starting with a fascinating historical perspective on what the experience was like for our immigrant ancestors, learn the types of immigration or emigration records kept and where to find them.
Poverty: A Discussion with Matthew Desmond - Illinois Libraries Present
Tue, May 13, 7:00pm - 8:00pm
Join us to close out our fourth season with bestselling author Matthew Desmond in conversation with award-winning journalist, Natalie Moore. Register
Second Tuesday Book Discussion - Wandering Stars by Tommy Orange
Tue, May 13, 7:00pm - 8:30pm
Bisbee Conference Room
The Library offers two book discussion sessions on the second Tuesday of each month: Mornings at 10:00 a.m. and Evenings at 7:00 p.m.
My First Storytime (0-23 Months with Caregiver)
Wed, May 14, 9:30am - 10:00am
Miller Haase Community Room
Connect with your baby for an interactive and engaging storytime session full of songs, rhymes and stories! Please register baby only. 
2 & 3 Year Old Storytime (with Caregiver)
Wed, May 14, 10:30am - 11:00am
Miller Haase Community Room
Interactive storytime for children and their parents/caregivers! Please only register your child.
This event is full
Stories at the Nature Center (Families)
Wed, May 14, 10:30am - 11:00am
Children are invited to hear stories at the Creek Bend Nature Center at LeRoy Oakes Forest Preserve.
Ukulele Strum & Sing - No Experience Needed
Wed, May 14, 1:00pm - 2:30pm
Carnegie Community Room
Join the St. Charles Ukulele Strummers! Come play and sing along with us! Bring your own ukulele (soprano, concert, or tenor)
1:17 at The Loft (Grades 9-12)
Wed, May 14, 1:17pm - 3:00pm
The Loft
Craft, game, or hang in The Loft after an Early Release Wednesday.
LEGO Club (Grades K-8)
Wed, May 14, 4:00pm - 7:00pm
Helen Gale Story Room
Drop by the library and build with LEGO. Each Wednesday we will have a different LEGO challenge you can try, or build whatever you want!
BookTalk: A Good Girl's Guide to Murder (Grades 6-8)
Wed, May 14, 6:30pm - 7:30pm
Miller Haase Community Room
More fun with books!
Library Board Meeting
Wed, May 14, 7:00pm - 9:00pm
Huntley Community Room
Library Board Meeting
Family Storytime (All Ages with Caregiver)
Thu, May 15, 10:00am - 10:30am
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
Genealogy Research at the Library - Afternoons
Thu, May 15, 1:00pm - 4:00pm
Computer Lab
Do you need a few quiet hours to work on your family tree? Are you looking for help breaking down a brick wall?
Forever Young Adult Book Club - Yolk by Mary H.K. Choi
Thu, May 15, 7:00pm - 8:00pm
Study Room 5
A club for adults to read and discuss popular YA titles.
Great Decisions - India: Between China, The West, And The Global South
Thu, May 15, 7:00pm - 8:30pm
Bisbee Conference Room
Great Decisions is America’s largest discussion program on world affairs. May's topic is "India: Between China, the West, and the Global South."
5-Minute Makes - Leatherette Flower Keychain
Fri, May 16, 10:00am - 11:30am
Computer Lab,STC Creative
Roll our precut Leatherette roses and make a keychain to take home.
Baby Prom (Ages 0-5 with Caregiver)
Fri, May 16, 5:00pm - 7:00pm
Helen Gale Story Room,Youth Services
Let's Glow- It's Prom! Join us for dancing and activities on this special evening. Fancy attire welcome.
Loose Parts Play (Ages 0-5 with Caregiver)
Sun, May 18, 12:30pm - 4:00pm
Helen Gale Story Room
Join us for some open ended play for children under aged five. Little ones will explore activities while grown ups get ideas for simple screen free fun!
Introduction to Microsoft Word - In-person Computer Instruction
Sun, May 18, 1:00pm - 2:30pm
Computer Lab
Learn the basics of word processing.
Genealogy Research at the Library - Mornings
Mon, May 19, 10:00am - 1:00pm
Computer Lab
Do you need a few quiet hours to work on your family tree? Are you looking for help breaking down a brick wall?
Family Storytime (All Ages with Caregiver)
Mon, May 19, 10:00am - 10:30am
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
My First Storytime (0-23 Months with Caregiver)
Mon, May 19, 6:00pm - 6:30pm
Miller Haase Community Room
Connect with your baby for an interactive and engaging storytime session full of songs, rhymes and stories! Please register baby only. 
My First Storytime (0-23 Months with Caregiver)
Tue, May 20, 9:30am - 10:00am
Miller Haase Community Room
Connect with your baby for an interactive and engaging storytime session full of songs, rhymes and stories! Please register baby only. 
2 & 3 Year Old Storytime (with Caregiver)
Tue, May 20, 10:30am - 11:00am
Miller Haase Community Room
Interactive storytime for children and their parents/caregivers! Please only register your child.
This event is full
Art Club: Crayon Transfer Drawing (Grades K-5)
Tue, May 20, 4:00pm - 4:45pm
Helen Gale Story Room
Using the crayon transfer technique, reveal colorful designs on paper. Learn how to create crayon transfer drawings and take beautiful artwork home!
Family Storytime (All Ages with Caregiver)
Tue, May 20, 6:00pm - 6:30pm
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
My First Storytime (0-23 Months with Caregiver)
Wed, May 21, 9:30am - 10:00am
Miller Haase Community Room
Connect with your baby for an interactive and engaging storytime session full of songs, rhymes and stories! Please register baby only. 
2 & 3 Year Old Storytime (with Caregiver)
Wed, May 21, 10:30am - 11:00am
Miller Haase Community Room
Interactive storytime for children and their parents/caregivers! Please only register your child.
This event is full
Ukulele Strum & Sing - No Experience Needed
Wed, May 21, 1:00pm - 2:30pm
Huntley Community Room
Join the St. Charles Ukulele Strummers! Come play and sing along with us! Bring your own ukulele (soprano, concert, or tenor)
LEGO Club (Grades K-8)
Wed, May 21, 4:00pm - 7:00pm
Helen Gale Story Room
Drop by the library and build with LEGO. Each Wednesday we will have a different LEGO challenge you can try, or build whatever you want!
5-Minute Makes - Leatherette Flower Keychain
Wed, May 21, 6:00pm - 7:30pm
Computer Lab,STC Creative
Roll our precut Leatherette roses and make a keychain to take home.
Board Game Night
Wed, May 21, 6:00pm - 8:30pm
Huntley Community Room
Join us to play games like Settlers of Catan, Ticket to Ride, and other modern games.
Mediterranean Feast: Flavors of the Sun - Classroom Kitchen Seasonal Series via Zoom
Wed, May 21, 6:30pm - 7:30pm
Take a culinary journey to the Mediterranean and discover vibrant, healthy dishes inspired by the sun-soaked flavors of the region.
Family Storytime (All Ages with Caregiver)
Thu, May 22, 10:00am - 10:30am
Miller Haase Community Room
This program is filled with stories, music and movement! Each week focuses on a new theme. Space is limited.
Laura Ingalls Wilder - All That I Have Told is True
Thu, May 22, 1:00pm - 2:00pm
Carnegie Community Room
In the summer of 1937, Laura Ingalls Wilder and her husband Almanzo moved from the Rock House on their property in Mansfield Mo., back into the farmhouse they loved.
See all events