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.

Registration now closed

Excel: Advanced Topics
2024-10-29 13:00:00 2024-10-29 14:30:00 America/Chicago Excel: Advanced Topics Learn how to quickly highlight important numbers using conditional formatting, work with multiple sheets in an Excel file, calculate percentages, and use the PMT and VLOOKUP functions in this class. Ela Area Public Library - Adult Computer Lab (R202)

Tuesday, October 29
1:00pm - 2:30pm

Add to Calendar 2024-10-29 13:00:00 2024-10-29 14:30:00 America/Chicago Excel: Advanced Topics Learn how to quickly highlight important numbers using conditional formatting, work with multiple sheets in an Excel file, calculate percentages, and use the PMT and VLOOKUP functions in this class. Ela Area Public Library - Adult Computer Lab (R202)

Ela Area Public Library

Adult Computer Lab (R202)

Learn how to quickly highlight important numbers using conditional formatting, work with multiple sheets in an Excel file, calculate percentages, and use the PMT and VLOOKUP functions in this class.

Prerequisite: Excel Basics, Charts & Graphs, Formulas & Functions, Working with Tables or related experience

Learn how to quickly highlight important numbers using conditional formatting, work with multiple sheets in an Excel file, calculate percentages, and use the PMT and VLOOKUP functions in this class.

AGE GROUP: | Adults |

EVENT TYPE: | Computers and Technology |

TAGS: | |

Ela Area Public Library
Phone: 847-438-3433
Fax: 847-438-9290
Hours
Mon, May 19 9:00AM to 9:00PM
Tue, May 20 9:00AM to 9:00PM
Wed, May 21 9:00AM to 9:00PM
Thu, May 22 9:00AM to 9:00PM
Fri, May 23 9:00AM to 6:00PM
Sat, May 24 9:00AM to 5:00PM
Sun, May 25 12:00PM to 5:00PM
previous
this week
next

Upcoming Events

Barns of Southwestern Lake County
Sat, May 24, 10:00am - 11:30am
Ela Area Public Library - Meeting Room A (R117A)
Join photographer John Rouse on a visual... more
Join photographer John Rouse on a visual tour of the barns of Southwest Lake County including Ela, Wauconda and Fremont townships.
Registration is now closed
Holiday Closing
Mon, May 26, All day
Ela Area Public Library - Meeting Room A and B (R117)
The library will be closed all day.
Lisa Frank Party
Tue, May 27, 6:00pm - 7:30pm
Ela Area Public Library - Meeting Room A and B (R117)
Step into a world of vibrant colors and... more
Step into a world of vibrant colors and nostalgia! At this Lisa Frank-themed craft party, you’ll color fun designs and decorate your very own Lisa Frank-inspired mug.
This event is full
Office Hours with Rep Syed - Meet your Representative
Wed, May 28, 5:00pm - 6:00pm
Ela Area Public Library - 2nd Floor Conference Room
Stop by to discuss issues of concern with... more
Stop by to discuss issues of concern with Illinois House Rep. Syed
Fishing 101
Wed, May 28, 7:00pm - 8:00pm
Ela Area Public Library - Meeting Room A and B (R117)
Fishing enthusiast Eugene Kim talks about... more
Fishing enthusiast Eugene Kim talks about what you need to get started. Come for tips and informative information or to expand your existing fishing knowledge.
Libraries Rock! (ages 0-12) - Summer Reading Program
Thu, May 29, All day
Ela Area Public Library
Get in the reading groove this summer!... more
Get in the reading groove this summer! Visit the Children's Desk to learn how you can earn prizes by completing reading and activity challenges.
Migration Bird Walk With Red Hill Birding
Thu, May 29, 10:00am - 11:30am
Picnic Shelter B at Heron Creek Forest Preserve
Join an expert birder for a spring... more
Join an expert birder for a spring migration bird walk at Heron Creek Forest Preserve, Long Grove, IL.
This event is full
Queer Book Club - How You Get the Girl by Anita Kelly
Thu, May 29, 7:00pm - 8:00pm
Ela Area Public Library - Meeting Room B (R117B)
A welcoming and safe space to explore,... more
A welcoming and safe space to explore, read and discuss LGBTQIA+ themed books, while making a themed craft. Let’s celebrate diversity, creativity and the power of storytelling together!
Libraries Rock! (ages 0-12) - Summer Reading Program
Sun, Jun 01, All day
Ela Area Public Library
Get in the reading groove this summer!... more
Get in the reading groove this summer! Visit the Children's Desk to learn how you can earn prizes by completing reading and activity challenges.
German Storytime
Mon, Jun 02, 9:30am - 10:15am
Ela Area Public Library - Children's Program Room B (R186)
Join Wochenendschule der Donauschwaben... more
Join Wochenendschule der Donauschwaben for movement, music, and fun! Enjoy a felt board story to learn German words for shapes, colors, and animals, then get moving with dynamic parachute activities.
Senior Scrabble Club
Mon, Jun 02, 10:00am - 12:30pm
Ela Area Public Library - Meeting Room A (R117A)
Senior adults of all skill levels are... more
Senior adults of all skill levels are welcome. Refreshments and supplies will be provided.
Puzzle Race
Mon, Jun 02, 6:00pm - 8:00pm
Ela Area Public Library - Meeting Room A and B (R117)
We are looking for 10 teams of 2-5... more
We are looking for 10 teams of 2-5 players who will compete to build the same 500-piece puzzle.
This event is full
Kids Karaoke (ages 5 and up)
Tue, Jun 03, 3:30pm - 5:30pm
Ela Area Public Library - Meeting Room A and B (R117)
Make some noise and put on a star-worthy... more
Make some noise and put on a star-worthy performance with our karaoke machine! Sing your favorite songs solo or plan a group number with family or friends.
Board of Trustees Orientation Training - Board of Trustees Orientation Training
Tue, Jun 03, 6:00pm - 8:30pm
Ela Area Public Library - 2nd Floor Conference Room
Board of Trustees Trustee Orientation... more
Board of Trustees Trustee Orientation Training
Alzheimer's Support Group
Tue, Jun 03, 7:00pm - 8:00pm
Ela Area Public Library - Children's Conference Room
This monthly drop-in event provides... more
This monthly drop-in event provides information and support to those in a caregiving role. For further information please contact Lisa Gaggiano at Ela Township 55+ (847) 438-9160.
All I Wanna Do Is Rock (Paper, Scissors)
Wed, Jun 04, 10:30am - 11:30am
Ela Area Public Library - Meeting Room A and B (R117)
Grammy-nominated children's entertainer... more
Grammy-nominated children's entertainer Justin Roberts will get you on your feet! This show is for everyone who loves to sing, dance, and laugh.
Registration opens Sunday, June 1 2025 at 12:00pm
Cook's Ice Cream Scoop Bus
Wed, Jun 04, 4:00pm - 6:00pm
Ela Area Public Library - Front Lawn
Celebrate the start of summer with a FREE... more
Celebrate the start of summer with a FREE scoop of ice cream.
Volunteer Fair
Wed, Jun 04, 4:00pm - 6:00pm
Ela Area Public Library - Meeting Room A and B (R117)
Looking for opportunities to give back to... more
Looking for opportunities to give back to the community. Talk with representatives from a variety of non profits and find out what's available in the area.
Blood Drive
Thu, Jun 05, 12:00pm - 5:00pm
Ela Area Public Library - Front Lawn
Give the gift of blood this summer and... more
Give the gift of blood this summer and make a real difference for someone in need.
Register
Crafternoon (ages 6-11) - mosaic lantern
Thu, Jun 05, 4:00pm - 4:45pm
Ela Area Public Library - Children's Program Room A (R187)
Enjoy an afternoon of crafting with... more
Enjoy an afternoon of crafting with friends and create your own one-of-a-kind project! We'll have everything you need to create a mosaic lantern.
Registration opens Sunday, June 1 2025 at 12:00pm
Annual Shred and Recyling Event - Cosponsored with Ela Township
Sat, Jun 07, 8:30am - 11:30am
Ela Area Public Library - Front Lawn
Shredding is limited to 3 boxes per... more
Shredding is limited to 3 boxes per household with a nonperishable food donation.
Ela Library Quilt Talks - FABRIC WORKSHOP DAY - ELQT FABRIC WORKSHOP DAY
Sat, Jun 07, 11:00am - 4:00pm
Ela Area Public Library - Meeting Room A (R117A)
Join us in our Fabric Workshop Day. Use... more
Join us in our Fabric Workshop Day. Use our spacious meeting room to work on your quilting projects! Sewing machines, cutting mats, iron and sewing notions will be available for use.
Libraries Rock! (ages 0-12) - Summer Reading Program
Sun, Jun 08, All day
Ela Area Public Library
Get in the reading groove this summer!... more
Get in the reading groove this summer! Visit the Children's Desk to learn how you can earn prizes by completing reading and activity challenges.
Senior Book Discussion (Zoom and In-Person) - "The Fraud" by Zadie Smith
Mon, Jun 09, 10:00am - 11:00am
Ela Area Public Library - 2nd Floor Conference Room
Books are available in large print,... more
Books are available in large print, audio, and regular print formats.
Science Explorers (ages 6-8)
Mon, Jun 09, 10:00am - 10:45am
Ela Area Public Library - Children's Program Room A and B (R186-187)
Explore the wide world of science! Dress... more
Explore the wide world of science! Dress for a mess as we share fun, hands-on activities and experiments. Register for only one June date.
Registration opens Sunday, June 1 2025 at 12:00pm
Drop-In Craft - 3D ice cream cone
Mon, Jun 09, 1:00pm - 7:00pm
Ela Area Public Library - Children's Program Room A (R187)
Stop by the Children's Department to... more
Stop by the Children's Department to design a unique craft project with the materials provided.
Drop-In Craft - 3D ice cream cone
Tue, Jun 10, 9:00am - 1:00pm
Ela Area Public Library - Children's Program Room A (R187)
Stop by the Children's Department to... more
Stop by the Children's Department to design a unique craft project with the materials provided.
Genealogy Interest Group - Open Research Session
Tue, Jun 10, 2:00pm - 4:00pm
Ela Area Public Library - Adult Computer Lab (R202)
Enjoy personal research time using the... more
Enjoy personal research time using the library's many online resources alongside others who enjoy this popular hobby. Bring your questions and share research strategies. Newcomers welcome!
Teen Gamer Meetup
Tue, Jun 10, 3:00pm - 4:30pm
Ela Area Public Library - Meeting Room A (R117A)
Kick back, chat, and chill with fellow... more
Kick back, chat, and chill with fellow teen gamers! Talk favorite titles, swap strategies, and vibe in a laid-back space just for you.
Registration opens Sunday, June 1 2025 at 12:00pm
Board of Trustees Orientation Training - Board of Trustees Orientation Training
Tue, Jun 10, 6:00pm - 8:30pm
Ela Area Public Library - 2nd Floor Conference Room
Board of Trustees Orientation Training
Intro to Edibile Landscaping
Tue, Jun 10, 7:00pm - 8:00pm
Ela Area Public Library - Meeting Room A (R117A)
Learn how to turn your yard into a... more
Learn how to turn your yard into a veritable food forest.
Registration opens Sunday, June 1 2025 at 12:00pm
Cancelled
Books & Brews
Tue, Jun 10, 7:00pm - 8:30pm
Buffalo Creek Brewing
Join us for Books & Brews. We will meet... more
Join us for Books & Brews. We will meet in-person at Buffalo Creek Brewing in Long Grove. Contact readers@eapl.org with questions.
Mini Makers (ages 3-5) - CD snails
Wed, Jun 11, 10:00am - 10:45am
Ela Area Public Library - Children's Program Room A (R187)
Preschoolers can practice art and fine... more
Preschoolers can practice art and fine motor skills in a crafting class made just for them! Dress for a mess.
Registration opens Sunday, June 1 2025 at 12:00pm
Neurodiverse Meetup Group
Wed, Jun 11, 5:00pm - 6:30pm
Ela Area Public Library - Meeting Room A and B (R117)
Do you identify as neurodiverse? Amy, a... more
Do you identify as neurodiverse? Amy, a librarian who identifies as AuDHD runs a neurodiverse meetup group at the library. Open to adults 18+ to those who otherwise identify as neurodiverse.
Registration opens Sunday, June 1 2025 at 12:00pm
Rockin' Summer Storytime
Thu, Jun 12, 9:30am - 10:15am
Ela Area Public Library - Children's Program Room B (R186)
Stop by with your kiddo for a casual... more
Stop by with your kiddo for a casual storytime experience. There will be great music for singing and dancing plus stories that rock!
Windows 11 Basics
Thu, Jun 12, 1:00pm - 2:30pm
Ela Area Public Library - Adult Computer Lab (R202)
This in-person workshop is for those who... more
This in-person workshop is for those who are new to using a PC or want to build more confidence using the Windows 11 operating system.
Registration opens Sunday, June 1 2025 at 12:00pm
2nd Annual Duck Boat Challenge - Family Edition
Thu, Jun 12, 4:00pm - 6:00pm
Ela Area Public Library - Back Lawn
Your family (with at least one child age... more
Your family (with at least one child age 3-11) must attend a building workshop in order to compete in this event. All spectators are welcome.
Registration opens Sunday, June 1 2025 at 12:00pm
2nd Annual Duck Boat Challenge - Teen Edition
Thu, Jun 12, 4:00pm - 6:00pm
Back Lawn
Do you have what it takes to design the... more
Do you have what it takes to design the winning duck boat at our second annual Duck Boat Challenge? Teens must attend a building workshop in order to compete in this event. All spectators are welcome.
Warm Up Lake Zurich Yarn Group (In-Person)
Thu, Jun 12, 4:00pm - 6:00pm
Ela Area Public Library - Forge Makerspace Room (R168)
Join us for our monthly Yarn crafting... more
Join us for our monthly Yarn crafting meetings, have fun & socialize as we knit & crochet & discuss everything yarn. All levels welcome. (R)
Lawyer in the Library
Thu, Jun 12, 5:00pm - 5:15pm
Ela Area Public Library - 2nd Floor Conference Room
Attorney Bonnie Weis from Buckley Fine... more
Attorney Bonnie Weis from Buckley Fine Law returns to answer questions about estate planning.
Registration opens Sunday, June 1 2025 at 12:00pm
Lawyer in the Library
Thu, Jun 12, 5:20pm - 5:35pm
Ela Area Public Library - 2nd Floor Conference Room
Attorney Bonnie Weis from Buckley Fine... more
Attorney Bonnie Weis from Buckley Fine Law returns to answer questions about estate planning.
Registration opens Sunday, June 1 2025 at 12:00pm
Lawyer in the Library
Thu, Jun 12, 5:40pm - 5:55pm
Ela Area Public Library - 2nd Floor Conference Room
Attorney Bonnie Weis from Buckley Fine... more
Attorney Bonnie Weis from Buckley Fine Law returns to answer questions about estate planning.
Registration opens Sunday, June 1 2025 at 12:00pm
Lawyer in the Library
Thu, Jun 12, 6:00pm - 6:15pm
Ela Area Public Library - 2nd Floor Conference Room
Attorney Bonnie Weis from Buckley Fine... more
Attorney Bonnie Weis from Buckley Fine Law returns to answer questions about estate planning.
Registration opens Sunday, June 1 2025 at 12:00pm
Lawyer in the Library
Thu, Jun 12, 6:20pm - 6:35pm
Ela Area Public Library - 2nd Floor Conference Room
Attorney Bonnie Weis from Buckley Fine... more
Attorney Bonnie Weis from Buckley Fine Law returns to answer questions about estate planning.
Registration opens Sunday, June 1 2025 at 12:00pm
Ela Library Quilt Talks (In Person)
Thu, Jun 12, 6:30pm - 8:30pm
Ela Area Public Library - Forge Makerspace Room (R168)
Join us in our Quilt talks meeting to... more
Join us in our Quilt talks meeting to discuss and learn about fabrics and quilt making. All skill levels are welcome, "Show and tell" is always a fun feature! (R)
Lawyer in the Library
Thu, Jun 12, 6:40pm - 6:55pm
Ela Area Public Library - 2nd Floor Conference Room
Attorney Bonnie Weis from Buckley Fine... more
Attorney Bonnie Weis from Buckley Fine Law returns to answer questions about estate planning.
Registration opens Sunday, June 1 2025 at 12:00pm
Summer Festivals in Chicago
Thu, Jun 12, 7:00pm - 8:00pm
Ela Area Public Library - Meeting Room A and B (R117)
Summer in Chicago is magical, and a big... more
Summer in Chicago is magical, and a big reason is the number of festivals that take place throughout the season.
Registration opens Sunday, June 1 2025 at 12:00pm
Baby Storytime (0-18 months)
Fri, Jun 13, 10:00am - 11:00am
Ela Area Public Library - Children's Program Room B (R186)
So much more than stories! Drop in for... more
So much more than stories! Drop in for lots of movement and smiles as we share songs and rhymes chosen specifically for little ones.
Quest: Kids RPG Club (ages 8-11)
Fri, Jun 13, 1:00pm - 3:00pm
Ela Area Public Library - Children's Conference Room
Tell your own stories, create fun... more
Tell your own stories, create fun characters, and embark on fantastical quests in this Dungeons & Dragons style event!
Registration opens Sunday, June 1 2025 at 12:00pm
Libraries Rock! (ages 0-12) - Summer Reading Program
Sun, Jun 15, All day
Ela Area Public Library
Get in the reading groove this summer!... more
Get in the reading groove this summer! Visit the Children's Desk to learn how you can earn prizes by completing reading and activity challenges.
Pajama Family Storytime
Mon, Jun 16, 6:00pm - 6:45pm
Ela Area Public Library - Children's Program Room B (R186)
Gather the whole family for fun and cozy... more
Gather the whole family for fun and cozy stories, songs, and a collaborative craft. Pajamas are encouraged!
Antique Road Show - Coins and Jewelry
Mon, Jun 16, 6:30pm - 7:30pm
Ela Area Public Library - Meeting Room A and B (R117)
Dave Ekstrom, a coin collector, member of... more
Dave Ekstrom, a coin collector, member of the American Numismatic Association and retired school teacher, offers a presentation on coin and currency values as well as gold jewelry and silver values.
Registration opens Sunday, June 1 2025 at 12:00pm
Baby Obstacle Course (ages 6-24 months)
Tue, Jun 17, 9:30am - 11:30am
Ela Area Public Library - Children's Program Room A and B (R186-187)
Calling on-the-go babies and toddlers!... more
Calling on-the-go babies and toddlers! Whether your little one is crawling, walking, running, or something in between, stop in for a fun challenge to help them develop motor and sensory skills.
Memory Cafe
Tue, Jun 17, 10:00am - 11:30am
Ela Area Public Library - Meeting Room A (R117A)
People experiencing memory loss due to... more
People experiencing memory loss due to Alzheimer's disease or other cognitive issues are invited to attend with care partners. For questions call BACOA at 847 381-5030.
Great Decisions
Tue, Jun 17, 1:00pm - 2:30pm
Ela Area Public Library - Meeting Room A (R117A)
Great Decisions is a discussion program... more
Great Decisions is a discussion program on world affairs.
Registration opens Sunday, June 1 2025 at 12:00pm
Crochet and Cookies
Tue, Jun 17, 2:00pm - 4:00pm
Ela Area Public Library - Meeting Room B (R117B)
Beat the heat with some cookies and learn... more
Beat the heat with some cookies and learn the basics of crochet at this cozy gathering. Whether you're a beginner looking to start or a seasoned crocheter, all are welcome.
Registration opens Sunday, June 1 2025 at 12:00pm
Board of Trustees Regular Monthly meeting - Board of Trustees meeting
Tue, Jun 17, 6:00pm - 8:30pm
Ela Area Public Library - 2nd Floor Conference Room
Board of Trustees monthly meeting
Quest: Kids RPG Club (ages 8-11)
Wed, Jun 18, 1:00pm - 3:00pm
Ela Area Public Library - Children's Conference Room
Tell your own stories, create fun... more
Tell your own stories, create fun characters, and embark on fantastical quests in this Dungeons & Dragons style event!
Registration opens Sunday, June 1 2025 at 12:00pm
Quest: Kids RPG Club (ages 8-11)
Wed, Jun 18, 3:30pm - 5:30pm
Ela Area Public Library - Children's Conference Room
Tell your own stories, create fun... more
Tell your own stories, create fun characters, and embark on fantastical quests in this Dungeons & Dragons style event!
Registration opens Sunday, June 1 2025 at 12:00pm
8-Bit Art Night
Wed, Jun 18, 6:00pm - 7:30pm
Ela Area Public Library - Meeting Room A (R117A)
It’s hip to be square! Tap into your... more
It’s hip to be square! Tap into your retro side and paint pixel-style art inspired by your favorite video games, characters, and more.
Registration opens Sunday, June 1 2025 at 12:00pm
Your Best Resume Yet! w/ Amy Rath
Wed, Jun 18, 7:00pm - 8:00pm
Ela Area Public Library - Meeting Room B (R117B)
Everyone regardless of job level, or work... more
Everyone regardless of job level, or work history, deserves a well-crafted resume. Resume specialist Amy Rath walks you through the process, and provides guidelines for creating your best resume yet!
Registration opens Sunday, June 1 2025 at 9:00am
Rockin' Summer Storytime
Thu, Jun 19, 9:30am - 10:15am
Ela Area Public Library - Children's Program Room B (R186)
Stop by with your kiddo for a casual... more
Stop by with your kiddo for a casual storytime experience. There will be great music for singing and dancing plus stories that rock!
Cybersecurity Basics
Thu, Jun 19, 1:00pm - 3:00pm
Ela Area Public Library - Adult Computer Lab (R202)
This in-person workshop is for those who... more
This in-person workshop is for those who are interested in safety online and want to protect themselves from fraudsters and scams.
Registration opens Sunday, June 1 2025 at 12:00pm
Queer Book Club - On A Sunbeam by Tillie Walden
Thu, Jun 19, 7:00pm - 8:00pm
Ela Area Public Library
A welcoming and safe space to explore,... more
A welcoming and safe space to explore, read and discuss LGBTQIA+ themed books, while making a themed craft. Let’s celebrate diversity, creativity and the power of storytelling together!
Registration opens Sunday, June 1 2025 at 12:00pm
Lego Club (ages 6-11)
Fri, Jun 20, 11:00am - 12:00pm
Ela Area Public Library - Children's Program Room A and B (R186-187)
If you enjoy building with Lego bricks,... more
If you enjoy building with Lego bricks, this program is for you! Create and construct using your own ideas or try one of our challenges.
Libraries Rock! (ages 0-12) - Summer Reading Program
Sun, Jun 22, All day
Ela Area Public Library
Get in the reading groove this summer!... more
Get in the reading groove this summer! Visit the Children's Desk to learn how you can earn prizes by completing reading and activity challenges.
Science Explorers (ages 6-8)
Mon, Jun 23, 10:00am - 10:45am
Ela Area Public Library - Children's Program Room A and B (R186-187)
Explore the wide world of science! Dress... more
Explore the wide world of science! Dress for a mess as we share fun, hands-on activities and experiments. Register for only one June date.
Registration opens Sunday, June 1 2025 at 12:00pm
Cartooning with Mark Anderson (ages 5-11) - Out of Toon
Mon, Jun 23, 2:00pm - 3:00pm
Ela Area Public Library - Children's Program Room A and B (R186-187)
Join Mark for a lively, interactive... more
Join Mark for a lively, interactive cartooning class. The library will provide your supplies.
Registration opens Sunday, June 1 2025 at 12:00pm
Rotary Club of Lake Zurich - Rotary Club Meeting
Mon, Jun 23, 6:00pm - 8:00pm
Ela Area Public Library - 2nd Floor Conference Room
Thinking about joining the Rotary Club of... more
Thinking about joining the Rotary Club of Lake Zurich? Come to the meeting and get acquainted. Public is welcome.
See all events