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.

Microsoft Excel: Part 4

PivotTables, PivotCharts, and Lookup
2026-02-25 09:30:00 2026-02-25 11:30:00 America/Chicago Microsoft Excel: Part 4 Learn in Part 4 to get key insights from your information by learning to use PivotTables. Then, we’ll show you how to illustrate your PivotTable results using PivotCharts, capture information using VLOOKUP, and fix common formula problems. Main Library - 013 | The Hatcher Agency Computer Classroom

Wednesday, February 25
9:30am - 11:30am

Add to Calendar 2026-02-25 09:30:00 2026-02-25 11:30:00 America/Chicago Microsoft Excel: Part 4 Learn in Part 4 to get key insights from your information by learning to use PivotTables. Then, we’ll show you how to illustrate your PivotTable results using PivotCharts, capture information using VLOOKUP, and fix common formula problems. Main Library - 013 | The Hatcher Agency Computer Classroom

Main Library

013 | The Hatcher Agency Computer Classroom

Learn in Part 4 to get key insights from your information by learning to use PivotTables. Then, we’ll show you how to illustrate your PivotTable results using PivotCharts, capture information using VLOOKUP, and fix common formula problems.

Microsoft Excel offers a powerful feature that’s feared and misunderstood, even by some who use Excel regularly: PivotTables! But once you know a few of the basics, you’ll find PivotTables aren’t so scary; they’re an incredibly useful, flexible way to analyze your data! In the last session of our popular four-part Excel course, you’ll find out how to:

  • See your data from all angles (and impress your work friends) using PivotTables
  • Illustrate your PivotTable results with PivotCharts
  • Discover how VLOOKUP can capture information
  • And more!

This is Part 4 of a four-part weekly series, so don’t forget to register for the other sessions! Or, if you have intermediate Excel experience and just want to learn about these topics, feel free to skip Parts 1, 2, and 3 and just take this class!

Attendee Info

This is a hybrid technology class—it will be offered in-person in the Hatcher Agency Computer Classroom on the lower level of Main Library and online as a Zoom webinar. Registration is encouraged if attending in-person; it's required if attending online.

If you have questions, email digital@cals.org or call 501-918-3068.

AGE GROUP: | Teens ages 12-19 | Adults |

EVENT TYPE: | Virtual | Technology | Small Business & Entrepreneurship |

TAGS: | DigitalLiteracy |

Main Library
Phone: 501.918.3000
Branch manager
Joe Hudak
Hours
Skip Locations widget

Main Library

Today's hours

We're open 9:00AM to 6:00PM

Branch manager
Joe Hudak
Address
100 Rock Street
Little Rock, AR 72201
Tel: 501.918.3000

Upcoming Events

Skip Upcoming Events widget
Cancelled
EVENT UPDATE: Carnival of the Animals
Sat, Jan 31, 10:30am - 2:00pm
Due to inclement weather, the Arkansas Symphony Orchestra and the Humane Society of Pulaski County will be unable to attend. Families are still welcome to visit the Main Library Children’s Center to enjoy animal-themed activities and crafts.
Fitness Bootcamp
Sat, Jan 31, 12:00pm - 2:00pm
504 | Adult Programming Room
The Fitness Bootcamp is an energizing group workout designed to help participants build strength, improve endurance, and boost overall physical well-being in a motivating and supportive environment.
Cancelled
Fitness Journals
Sat, Jan 31, 3:00pm - 6:00pm
After participating in the Fitness Bootcamp, you are invited to come to the Makerspace and create a fitness journal where you can track goals, mental wellbeing, exercises, meal plans and more.
Anti-Valentines Day Paintings
Mon, Feb 02, 4:00pm - 5:00pm
230 | Teen Center Program Room
Teens can paint an Anti-Valentines Day canvas to decorate our teen lounge for Valentines Day! No love allowed! Events in the Rice Teen Center are for ages 13-18 only.
The Great Paper Airplane Competition
Mon, Feb 02, 4:00pm - 5:00pm
131 | Martin Children's Center
Ready to put your engineering skills to the test? Join us for the library’s official Paper Airplane Competition! This isn't just about folding—it's about design, aerodynamics, and distance!
Drop-in Tech Help
Tue, Feb 03, 12:00pm - 4:00pm
013 | The Hatcher Agency Computer Classroom
Drop by and ask your burning technology questions, or get help with a specific problem from an expert. Feel free to bring your mobile device or laptop.
Paper Heart Spinners
Tue, Feb 03, 4:00pm - 5:00pm
131 | Martin Children's Center
Valentine's Day is approaching, let's get your hearts spinning! Using paper hearts, we'll decorate and assemble them into spinners you can use for decoration or give to someone you love.
In the Style of...
Tue, Feb 03, 4:00pm - 5:00pm
230 | Teen Center Program Room
Let's learn about Black artists and use their art to inspire our own works in their style! Events in the Rice Teen Center are for ages 13-18 only.
Microsoft Excel: Part 1 - The Basics
Wed, Feb 04, 9:30am - 11:30am
013 | The Hatcher Agency Computer Classroom
In Part 1 of our four-part series, get started using Microsoft Excel by learning how to enter information, format text and numbers, sort and filter, and use basic formulas.
Monthly Tour of the Main Library
Wed, Feb 04, 10:30am - 11:45am
Welcome to your new Main Library! On the first Wednesday of each month, join library staff on a tour of the newly renovated Main Library.
Storytime
Wed, Feb 04, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Preserving the Voices of Blackville, Arkansas - Legacies & Lunch February 2026
Wed, Feb 04, 12:00pm - 1:00pm
529 | Fred Darragh Center for Intellectual Freedom
Join co-editors Wally G. Vaughn and Carolyn Ann Butler Cooley in conversation with Arkansas Democrat-Gazette Sunday Style editor Helaine Williams for an illuminating conversation about their book Blackville, Arkansas, Fashioned by a Former Slave.
Valentine's Day Wreaths
Wed, Feb 04, 4:00pm - 5:00pm
131 | Martin Children's Center
Get ready to Color your Hearts out with this cute and eye-catching Valentine's Wreath!
Self-Love Sugar Scrub
Wed, Feb 04, 4:00pm - 5:00pm
230 | Teen Center Program Room
Self-love is the best love! Join us for a fun and pampering program where you'll learn how to create all-natural body scrub! Indulge in self-care and discover the benefits of exfoliation. Events in the Rice Teen Center are for ages 13-18 only.
Shaving Cream Hearts
Thu, Feb 05, 4:00pm - 5:00pm
131 | Martin Children's Center
Using shaving cream, we will create lovely, marbled paper hearts that can be used as decor, or as gifts for the ones you love.
Storytime
Fri, Feb 06, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Mending Workshop
Fri, Feb 06, 3:00pm - 6:00pm
235 | Makerspace
Start the new year off with a new skill! Bring in items to mend and learn different mending techniques.
This event is full
Artistic Accessories: Button Bracelets
Fri, Feb 06, 4:00pm - 5:00pm
230 | Teen Center Program Room
Upgrade your looks with your own handcrafted accessories! Events in the Rice Teen Center are for ages 13-18 only.
History and the Making: Stewed Okra
Fri, Feb 06, 4:00pm - 5:00pm
131 | Martin Children's Center
A snack and a history lesson! Join us as we explore the history of foods that have become staples in the black community.
2026 Black Family Expo
Sat, Feb 07, 11:00am - 2:00pm
Learn about families with strong ties to Central Arkansas’s Black history and explore CALS’s resources for preserving your own family history. Giveaways will be happening all day, so stop by and celebrate Black History Month with the CALS team!
Video for the Web
Mon, Feb 09, 9:30am - 11:30am
013 | The Hatcher Agency Computer Classroom
Find out how to make videos that break the internet--without breaking the bank. We'll focus on editing, but also touch on best practices for shooting and uploading your content.
DIY Love Potion
Mon, Feb 09, 4:00pm - 5:00pm
131 | Martin Children's Center
Step into our Potion Master's workshop! In this creative program, you'll learn to layer, mix, and bottle your own shimmering love potion to take home.
Drop-in Tech Help
Tue, Feb 10, 12:00pm - 4:00pm
013 | The Hatcher Agency Computer Classroom
Drop by and ask your burning technology questions, or get help with a specific problem from an expert. Feel free to bring your mobile device or laptop.
Papercraft Palooza: Victorian Heart Cards
Tue, Feb 10, 4:00pm - 5:00pm
230 | Teen Center Program Room
Let's make some artistic creations by playing with paper! Events in the Rice Teen Center are for ages 13-18 only.
DIY Conversation Hearts
Tue, Feb 10, 4:00pm - 5:00pm
131 | Martin Children's Center
What's Valentine's Day without conversation hearts? We'll create hearts using glue that you can then color and write a personalized sweet note for yourself or a loved one.
Microsoft Excel: Part 2 - Formulas and Charts
Wed, Feb 11, 9:30am - 11:30am
013 | The Hatcher Agency Computer Classroom
Build on your basic Excel skills to make your data easier to manage and understand. In Part 2, you’ll learn to let Excel do the math; use copy, paste, and AutoFill; avoid common formula problems; and create eye-catching charts with your data.
Storytime
Wed, Feb 11, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Love At First Dip
Wed, Feb 11, 12:00pm - 2:00pm
507 | Teaching Kitchen
Join us for a sweet and hands-on experience as we host a Chocolate-Covered Strawberries Class! Patrons will learn the basics of melting, dipping, and decorating strawberries while creating their own delicious treats to take home.
Crafting with Creativebug - Creating a Valentine's Zine
Wed, Feb 11, 2:00pm - 4:00pm
012 | Arvest Computer Classroom
Make your own Valentine themed Zine!
Taste of Tanghulu
Wed, Feb 11, 4:00pm - 5:00pm
230 | Teen Center Program Room
Join us for a sweet and cultural adventure! Learn about the delicious Chinese treat called Tanghulu, and enjoy a variety of fresh candied fruit. Events in the Rice Teen Center are for ages 13-18 only.
Hydro-Dipped Pencils
Wed, Feb 11, 4:00pm - 5:00pm
131 | Martin Children's Center
Add some color to your school days! Today we will be Using water and paint/nail polish, to create colorful pencils!
Anti–Valentine’s Day: “No Love Lost Party”
Thu, Feb 12, 9:00am - 10:00am
230 | Teen Center Program Room
A fun and humorous celebration of no love! Join us in some breakup karaoke, heartbreak cookie decorating, DIY Love stinks button crafting, and a shred your ex-stress relief session. Events in the Rice Center are for ages 13-18 only.
DIY Valentine's Day Cards and Boxes
Thu, Feb 12, 4:00pm - 5:00pm
131 | Martin Children's Center
Need last minute Valentine's Day cards for friends or family or boxes to hold your own goodies? Today we will be creating our own cards and/or Boxes!
Storytime
Fri, Feb 13, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Pom-pom Love Bugs
Fri, Feb 13, 4:00pm - 5:00pm
131 | Martin Children's Center
If you don't catch the love bug, you can make one! Using yarn made pom poms, we'll create cute little critters that you'll love forever.
Self-Love Zine
Fri, Feb 13, 4:00pm - 5:00pm
230 | Teen Center Program Room
Be your own valentine this year and celebrate yourself with a DIY zine all about you! Events in the Rice Teen Center are for ages 13-18 only.
Valentine's Day Cards
Sat, Feb 14, 3:00pm - 5:00pm
235 | Makerspace
Make your own Valentine in the Makerspace! We will be using elements cut out with the Cricut.
Drop-in Tech Help
Tue, Feb 17, 12:00pm - 4:00pm
013 | The Hatcher Agency Computer Classroom
Drop by and ask your burning technology questions, or get help with a specific problem from an expert. Feel free to bring your mobile device or laptop.
In the Style of...
Tue, Feb 17, 4:00pm - 5:00pm
230 | Teen Center Program Room
Let's learn about Black artists and use their art to inspire our own works in their style! Events in the Rice Teen Center are for ages 13-18 only.
Lunar New Year Paper Lanterns
Tue, Feb 17, 4:00pm - 5:00pm
131 | Martin Children's Center
It's the Lunar New Year! To celebrate, we're creating paper lanterns similar to the ones traditionally used during Lunar New Year celebrations.
Microsoft Excel: Part 3 - Color-Coding, Logic, and More
Wed, Feb 18, 9:30am - 11:30am
013 | The Hatcher Agency Computer Classroom
In Part 3, sharpen your Excel skills by learning to color-code your data automatically, protect your work from accidental changes, check your entries using Data Validation, remove duplicate information, write amazing formulas with logic, and more!
Storytime
Wed, Feb 18, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
DIY Paper Cup Mobiles
Wed, Feb 18, 4:00pm - 5:00pm
131 | Martin Children's Center
Using simple paper cups, we will create hanging mobiles that will add character to any space!
CALS Cypher
Wed, Feb 18, 4:00pm - 5:00pm
230 | Teen Center Program Room
Do you have lyrics floating around in your head or a tune you keep humming? This Teen Songwriting Workshop is your chance to turn your ideas, feelings, and stories into finished songs! Events in the Rice Teen Center are for ages 13-18 only.
Surf Secure
Thu, Feb 19, 12:00pm - 1:30pm
013 | The Hatcher Agency Computer Classroom
Protect your privacy in the digital world. You'll learn about tools like password managers and two-step verification, and best practices for online safety.
Paint Sample Bookmarks
Thu, Feb 19, 4:00pm - 5:00pm
131 | Martin Children's Center
Need a free art project to keep the kids entertained? Learn how to use free hardware store paint samples to create adorable bookmarks!
Storytime
Fri, Feb 20, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Lunchtime Craft: Weaving
Fri, Feb 20, 12:00pm - 2:00pm
235 | Makerspace
Join us in the Makerspace for a simple craft during lunchtime! This week we will be doing small cardboard weavings!
Artistic Accessories: Shrinky-Dink Earrings
Fri, Feb 20, 4:00pm - 5:00pm
230 | Teen Center Program Room
Upgrade your looks with your own handcrafted accessories! Events in the Rice Teen Center are for ages 13-18 only.
History and the Making: Cornbread
Fri, Feb 20, 4:00pm - 5:00pm
131 | Martin Children's Center
A snack and a history lesson! Join us as we explore the history of foods that have become staples in the black community.
Rhythm & Rhyme Adventure Time
Sat, Feb 21, 10:30am - 11:15am
131 | Martin Children's Center
Get ready to wiggle, jump, and sing! This high-energy class is designed for our youngest library visitors and their caregivers. We'll use music, scarves, shakers, and simple instruments to explore rhythm, gross motor skills, and creative movement.
The Culture In the Kitchen
Sat, Feb 21, 11:00am - 3:00pm
507 | Teaching Kitchen
Celebrate Black History Month through flavor and tradition with a special chef-prepared dining experience. This themed meal highlights the rich culinary contributions of Black culture, featuring dishes inspired by African and Southern roots.
PC Breakdown
Mon, Feb 23, 12:00pm - 1:30pm
502 | Arminta Berry Meeting Room
Ever wanted to know what's inside a computer? In this program, we'll take them apart together and talk about what makes them tick.
This event is full
Drop-in Tech Help
Tue, Feb 24, 12:00pm - 4:00pm
013 | The Hatcher Agency Computer Classroom
Drop by and ask your burning technology questions, or get help with a specific problem from an expert. Feel free to bring your mobile device or laptop.
Microsoft Excel: Part 4 - PivotTables, PivotCharts, and Lookup
Wed, Feb 25, 9:30am - 11:30am
013 | The Hatcher Agency Computer Classroom
Learn in Part 4 to get key insights from your information by learning to use PivotTables. Then, we’ll show you how to illustrate your PivotTable results using PivotCharts, capture information using VLOOKUP, and fix common formula problems.
Storytime
Wed, Feb 25, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Black History Month Bingo
Wed, Feb 25, 12:00pm - 2:00pm
504 | Adult Programming Room
Celebrate Black History Month with a fun and educational Black History Month Bingo event! Patrons will enjoy a classic game of bingo while learning about influential Black leaders, culture, achievements, and historical milestones.
Storytime
Fri, Feb 27, 10:30am - 11:15am
131 | Martin Children's Center
Join us for stories, songs, rhymes, and movement. Storytime is a great way to bond with your child. Storytime helps develop your child's brain, ability to focus, concentration, social skills and communication skills.
Sewn Rice Handwarmers
Sat, Feb 28, 10:00am - 1:00pm
235 | Makerspace
Make your own handwarmers through a simple sewing project using the sewing machines in the Makerspace!
See all events