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

Microsoft Excel - Pivot Tables
2024-10-15 11:45:00 2024-10-15 12:45:00 America/New_York Microsoft Excel - Pivot Tables Dread analyzing data? Simplify the process and create meaningful reports using the powerful PivotTable tools. Learn how to create and customize PivotTables and PivotCharts using Microsoft Excel. Alafaya Branch - Alafaya - Computer Lab

Tuesday, October 15
11:45am - 12:45pm

Add to Calendar 2024-10-15 11:45:00 2024-10-15 12:45:00 America/New_York Microsoft Excel - Pivot Tables Dread analyzing data? Simplify the process and create meaningful reports using the powerful PivotTable tools. Learn how to create and customize PivotTables and PivotCharts using Microsoft Excel. Alafaya Branch - Alafaya - Computer Lab

Alafaya Branch

Alafaya - Computer Lab

Dread analyzing data? Simplify the process and create meaningful reports using the powerful PivotTable tools. Learn how to create and customize PivotTables and PivotCharts using Microsoft Excel.

  • Class Duration: 1 hour 
  • Age Requirements: 13-Adult
  • Recommended Prerequisite: Microsoft Excel Level 4
  • Required Skills: None
  • Materials Fee: None
  • Out of District Fee: $10 (includes class and materials fees)

AGE GROUP: | Adults |

EVENT TYPE: | Business & Careers | Basic Tech Skills |

TAGS: | tech-productivity | tec101 |

Alafaya Branch
Phone: 407-835-7323
Hours
Mon, Oct 14 10:00AM to 7:00PM
Tue, Oct 15 10:00AM to 7:00PM
Wed, Oct 16 10:00AM to 7:00PM
Thu, Oct 17 10:00AM to 7:00PM
Fri, Oct 18 10:00AM to 6:00PM
Sat, Oct 19 10:00AM to 6:00PM
Sun, Oct 20 1:00PM to 6:00PM
previous
this week
next
About the branch

LYNX Bus Link 104 East Colonial

 

The Alafaya Branch has a long history of providing library services to the East Orange County community. The branch originally opened in 1965 as the Azalea Park branch, situated on Lake Barton Road. From the 1970s through the 1990s the branch provided library services from shopping center locations. Ground was broken in January 1999 for a new branch, designed to be the prototype branch for future Orange County Library System branches. Opened on February 1, 2000, the Alafaya branch was funded by a Florida Library Construction Grant.

Upcoming events

Microsoft Excel - Formulas & Functions
Tue, Oct 15, 10:30am - 11:30am
Alafaya - Computer Lab
Calculate your data with formulas and functions. Use the Function Library to find the best fit for your project. Insert financial, logical, lookup, math and text functions.
Registration is now closed
Microsoft Excel - Pivot Tables
Tue, Oct 15, 11:45am - 12:45pm
Alafaya - Computer Lab
Dread analyzing data? Simplify the process and create meaningful reports using the powerful PivotTable tools. Learn how to create and customize PivotTables and PivotCharts using Microsoft Excel.
Registration is now closed
Build LEGO Robots: Halloween Scene (Ages 5-6)
Tue, Oct 15, 4:00pm - 5:00pm
Alafaya - Computer Lab
Explore the world of LEGO WeDo as we build and program LEGO robotics. Build a fun Halloween scene with witches and ghosts, and use code to fly them around!
This event is full
Adobe Illustrator Level 3
Wed, Oct 16, 12:00pm - 1:00pm
Alafaya - Computer Lab
Explore the benefits of having a defined and consistent visual design style. Use a variety of tools and techniques to apply styles such as watercolor, flat, outline and more.
Open Lab - Ask A Tech
Wed, Oct 16, 2:00pm - 3:00pm
Alafaya - Computer Lab
Are you stuck on a software-related project or simply need constructive ideas to get you started? Let us help! A technology trainer will be available to assist you in this open lab.
Adobe Photoshop Level 3 - Retouching & Restoration
Wed, Oct 16, 5:00pm - 6:30pm
Alafaya - Computer Lab
Learn how to add Photoshop filters. Apply powerful retouching and restoration techniques to revitalize your images. Become familiar with Photoshop's Artificial Intelligence capabilities.
This event is full
Web Design - CSS Level 3
Thu, Oct 17, 12:00pm - 1:30pm
Alafaya - Computer Lab
Do you want to draw more attention to your site? A full-screen video background is a solution.
Stop Motion Monster Movies (Ages 10-12)
Thu, Oct 17, 4:00pm - 5:00pm
Alafaya - Computer Lab
Combine stop motion animation and LEGOs to make your own monster movie! Explore the basics of animation while creating your own stop motion movie.
Storybook Fun
Fri, Oct 18, 10:15am - 10:40am
Alafaya - Ask at Desk
The use of picture books, songs and told stories will encourage your child to read, talk, sing, write and play. Recommended for children ages 3 to 5.
Toddler Time
Fri, Oct 18, 10:45am - 11:05am
Alafaya - Ask at Desk
The use of picture books, finger plays, songs and flannel board stories will encourage the development of verbal and listening skills for this active age group. Recommended for ages 18 to 36 months.
Tiny Tales
Fri, Oct 18, 11:15am - 11:30am
Alafaya - Ask at Desk
The rhythm and repetition of nursery rhymes are used to introduce young children to literature. Hold your child in your lap and enjoy this special time together. Recommended for babies 0-18 months.
Internet Level 1 - Fundamentals
Fri, Oct 18, 1:00pm - 2:00pm
Alafaya - Computer Lab
Learn Internet concepts and terminology. Become familiar with Web browsers while surfing the Web.
Internet Level 2 - Search Techniques
Fri, Oct 18, 2:15pm - 3:15pm
Alafaya - Computer Lab
Learn about search engines and search techniques to help you find exactly what you are looking for on the Web.
Stop Motion Monster Movies (Ages 7-9)
Fri, Oct 18, 4:00pm - 5:00pm
Alafaya - Computer Lab
Combine stop motion animation and LEGOs to make your own monster movie! Explore the basics of animation while creating your own stop motion movie.
This event is full
Cancelled
Social Worker @ the Library
Sat, Oct 19, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services.
Digital Monster Sculpting (Ages 7-9)
Sat, Oct 19, 11:00am - 12:00pm
Alafaya - Computer Lab
Use the digital sculpting program ZbrushCoreMini to create and decorate your monster sculptures!
Digital Monster Sculpting (Ages 10-12)
Sat, Oct 19, 2:00pm - 3:00pm
Alafaya - Computer Lab
Use the digital sculpting program ZbrushCoreMini to create and decorate your monster sculptures!
Cancelled
Social Worker @ the Library - By Appointment Only
Mon, Oct 21, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services by appointment only. To make an appointment visit ocls.info/socialworker.
Social Worker @ the Library - By Appointment Only
Mon, Oct 21, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services by appointment only. To make an appointment visit ocls.info/socialworker.
Cancelled
Social Worker @ the Library
Fri, Oct 25, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services.
Cancelled
Social Worker @ the Library
Fri, Oct 25, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services.
Cancelled
Storybook Fun
Fri, Oct 25, 10:15am - 10:40am
The use of picture books, songs and told stories will encourage your child to read, talk, sing, write and play. Recommended for children ages 3 to 5.
Cancelled
Toddler Time
Fri, Oct 25, 10:45am - 11:05am
The use of picture books, finger plays, songs and flannel board stories will encourage the development of verbal and listening skills for this active age group. Recommended for ages 18 to 36 months.
Cancelled
Tiny Tales
Fri, Oct 25, 11:15am - 11:30am
The rhythm and repetition of nursery rhymes are used to introduce young children to literature. Hold your child in your lap and enjoy this special time together. Recommended for babies 0-18 months.
Cancelled
Social Worker @ the Library - By Appointment Only
Mon, Oct 28, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services by appointment only. To make an appointment visit ocls.info/socialworker.
Social Worker @ the Library - By Appointment Only
Mon, Oct 28, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services by appointment only. To make an appointment visit ocls.info/socialworker.
Cancelled
Storybook Fun
Fri, Nov 01, 10:15am - 10:40am
The use of picture books, songs and told stories will encourage your child to read, talk, sing, write and play. Recommended for children ages 3 to 5.
Cancelled
Toddler Time
Fri, Nov 01, 10:45am - 11:05am
The use of picture books, finger plays, songs and flannel board stories will encourage the development of verbal and listening skills for this active age group. Recommended for ages 18 to 36 months.
Cancelled
Tiny Tales
Fri, Nov 01, 11:15am - 11:30am
The rhythm and repetition of nursery rhymes are used to introduce young children to literature. Hold your child in your lap and enjoy this special time together. Recommended for babies 0-18 months.
Cancelled
Social Worker @ the Library
Sat, Nov 02, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services.
Social Worker @ the Library
Sat, Nov 02, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services.
Social Worker @ the Library - By Appointment Only
Mon, Nov 04, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services by appointment only. To make an appointment visit ocls.info/socialworker.
Kid's Crochet - Learn How to Crochet
Mon, Nov 04, 4:00pm - 5:30pm
Alafaya - Meeting Room 1
Learn how to crochet a new project each month. Ages 8 -12. Beginners welcome. Materials will be provided.
This event is full
Microsoft Excel Level 1 - Creating Spreadsheets
Tue, Nov 05, 10:30am - 11:30am
Alafaya - Computer Lab
Start using Excel today. Input, format and save data in spreadsheets. Calculate data with basic formulas. Save your data and learn how to share workbooks with collaborators.
Microsoft Excel Level 2 - Finalizing & Securing Spreadsheets
Tue, Nov 05, 11:45am - 12:45pm
Alafaya - Computer Lab
Customize and organize worksheets with sheet names, color coding, headers, themes, and more. Protect your worksheets with a password and learn how to print your data.
Build LEGO Robots: Acrobat (Ages 5-6)
Tue, Nov 05, 4:00pm - 5:00pm
Alafaya - Computer Lab
Explore the world of LEGO WeDo as we build and program LEGO robotics. Build a flipping acrobat and discover how code can bring machines to life!
This event is full
Bubble Playtime
Wed, Nov 06, 10:30am - 11:30am
Alafaya - Meeting Room 1
Help your child develop gross-motor skills in this interactive bubble party. Recommended for toddlers and preschoolers.
Microsoft PowerPoint Level 1
Wed, Nov 06, 12:00pm - 1:00pm
Alafaya - Computer Lab
Identify the basic features and tools to get you started. Learn how to create a presentation by using templates, text, and picture files.
Open Lab - Ask A Tech
Wed, Nov 06, 2:00pm - 3:00pm
Alafaya - Computer Lab
Are you stuck on a software-related project or simply need constructive ideas to get you started? Let us help! A technology trainer will be available to assist you in this open lab.
Teen Volunteering: Tech Demos (Ages 13-17)
Wed, Nov 06, 4:00pm - 6:00pm
Alafaya - Computer Lab
High school students will earn two hours of community service by helping test out technology classes. Recommended for ages 13-17.
This event is full
Over the Garden Wall Fridge Magnet - Polymer Clay
Wed, Nov 06, 5:00pm - 6:00pm
Alafaya - Meeting Room 1
Pop in for a fall craft. Create fridge magnets inspired by Over the Garden Wall. Recommended for ages 16+
This event is full
Adobe Photoshop Level 1 - Editing Tools
Thu, Nov 07, 12:00pm - 1:30pm
Alafaya - Computer Lab
Learn about the functionality of Photoshop and explore the environment. Become familiar with using the Brush, Eraser, Selection, Move, and Crop tools.
Photoshop Practice Lab
Thu, Nov 07, 1:45pm - 2:45pm
Alafaya - Computer Lab
Polish your graphic design skills while practicing what you've learned in class. Get more hands on time with Photoshop and practice with others.
Homeschool Snack Around the World - Native Americans!
Thu, Nov 07, 2:00pm - 3:00pm
Alafaya - Meeting Room 1
Learn about a different country each month and try some local snacks! Food will be served at this event, please see staff about specific needs concerning food allergies.
This event is full
Build LEGO Animals: Gorillas (Ages 10-12)
Thu, Nov 07, 4:30pm - 5:30pm
Alafaya - Computer Lab
Discover how different animals move as you build and program robotic LEGO animals. Create dynamic arms and code your gorilla to walk.
Alafaya Book Club
Thu, Nov 07, 5:00pm - 6:00pm
Alafaya - Meeting Room 1
The Alafaya Book Club's November selection is "Colton Gentry's Third Act" by Jeff Zentner.
Cancelled
Storybook Fun
Fri, Nov 08, 10:15am - 10:40am
The use of picture books, songs and told stories will encourage your child to read, talk, sing, write and play. Recommended for children ages 3 to 5.
Cancelled
Toddler Time
Fri, Nov 08, 10:45am - 11:05am
The use of picture books, finger plays, songs and flannel board stories will encourage the development of verbal and listening skills for this active age group. Recommended for ages 18 to 36 months.
Cancelled
Tiny Tales
Fri, Nov 08, 11:15am - 11:30am
The rhythm and repetition of nursery rhymes are used to introduce young children to literature. Hold your child in your lap and enjoy this special time together. Recommended for babies 0-18 months.
Basic English 2
Sat, Nov 09, 10:30am - 11:30am
Alafaya - Meeting Room 1
This class is designed for students with a high-beginner to intermediate level of English. Continue to practice basic vocabulary and grammar.
Google Earth (Ages 7-9)
Sat, Nov 09, 11:00am - 12:00pm
Alafaya - Computer Lab
Fly around the globe and view famous world landmarks using Google Earth. Also, go beyond the Earth with Google Sky!
English Conversation Hour 2
Sat, Nov 09, 12:00pm - 1:00pm
Alafaya - Meeting Room 1
Come practice your English conversation skills! This class is intended for intermediate and advanced English Language Learners.
Digital Art with Wacom (Ages 10-12) - Tech Exploration
Sat, Nov 09, 2:00pm - 3:00pm
Alafaya - Computer Lab
Take your digital art to the next level with a Wacom drawing tablet! Discover digital art fundamentals and explore different uses for a drawing tablet while learning helpful tips.
Teen Volunteering: Orange Slice November
Sat, Nov 09, 3:00pm - 5:00pm
Alafaya - Meeting Room 1
Earn community service hours by becoming involved in Alafaya's teen literary and creative arts magazine. Registration required. Ages 13-18.
Build LEGO Animals: Frogs (Ages 7-9)
Sun, Nov 10, 1:30pm - 2:30pm
Alafaya - Computer Lab
Discover how different animals move as you build and program robotic LEGO animals. Build powerful legs to help your frog hop around!
Family Storytime
Sun, Nov 10, 2:00pm - 2:25pm
Alafaya - Meeting Room 1
Storytime is the right time for family time. Reading together is a wonderful way to bond and learn from one another. Bring your families together for fun stories that are designed for all ages.
Teen Volunteering: Tech Demos (Ages 13-17)
Sun, Nov 10, 3:30pm - 5:30pm
Alafaya - Computer Lab
High school students will earn two hours of community service by helping test out technology classes. Recommended for ages 13-17.
This event is full
Cozy Meet and Play - Part of Cozy Gaming Week
Sun, Nov 10, 4:00pm - 5:00pm
Alafaya - Meeting Room 1
Show off your farm from Stardew Valley or visit each other’s islands from Animal Crossing in this video game meet and greet! Recommended for ages 13+
Social Worker @ the Library - By Appointment Only
Mon, Nov 11, 10:00am - 5:00pm
Our social worker is on-site to meet with library customers and assist with social and government services by appointment only. To make an appointment visit ocls.info/socialworker.
Computer Basics Level 1 - Getting Started with Windows
Mon, Nov 11, 11:00am - 12:00pm
Alafaya - Computer Lab
Get up and running with computers. Learn how to navigate the computer desktop and how to perform various techniques in manipulating windows using basic mouse and keyboard techniques.
Homeschool Tech: Learn American Sign Language (Ages 7-12)
Mon, Nov 11, 2:30pm - 3:30pm
Alafaya - Computer Lab
Discover American Sign Language in a fun and interactive way! Learn to count from 1 to 10 and the basics of finger spelling while practicing together.
Animal Crossing Perler Beads - Part of Cozy Gaming Week
Mon, Nov 11, 4:00pm - 4:45pm
Alafaya - Meeting Room 1
Create your own perler bead magnets of your favorite Animal Crossing villager! Recommended for ages 6 and up. Registration required.
This event is full
Stardew Valley Perler Beads - Part of Cozy Gaming Week
Mon, Nov 11, 5:00pm - 6:00pm
Alafaya - Meeting Room 1
Create your own Stardew Valley-inspired perler bead magnets! For teens and adults. Registration required.
Design with Canva - Flyers, Social Media, Presentations & more
Mon, Nov 11, 5:30pm - 6:30pm
Alafaya - Computer Lab
Bring your design ideas to life with Canva, a free graphic design application. Save time by building on thousands of professional templates to create logos, flyers, social media content and more.
Microsoft Excel Level 3 - Functions & Automated Features
Tue, Nov 12, 10:30am - 11:30am
Alafaya - Computer Lab
Calculate data with basic functions SUM and AVERAGE. Use auto features including auto and flash fill to streamline your workflow. Transfer data with ease using Excel's copy and paste features.
Cozy Animal Storytime - Party of Cozy Gaming Week
Tue, Nov 12, 11:00am - 11:45am
Alafaya - Back of Branch
Celebrate all sorts of animals with fun stories, activities, and a scavenger hunt adventure! Recommended for ages 3-5.
Microsoft Excel Level 4 - More Functions & Visual Tools
Tue, Nov 12, 11:45am - 12:45pm
Alafaya - Computer Lab
Use absolute and relative references to ensure your data is calculated accurately. Analyze data by using functions like COUNT. Visually represent your data with tools like recommended charts.
Animal Crossing Diy Stamps - Part of Cozy Gaming Week
Tue, Nov 12, 5:30pm - 6:30pm
Alafaya - Meeting Room 1
Bring your favorite villager to life with this DIY stamp making program from the video game Animal Crossing. Ages 18+
Artsy Toddler - Part of Cozy Gaming Week
Wed, Nov 13, 10:30am - 11:00am
Alafaya - Back of Branch
Paint, paste, glue, stamp and create! Young children will enjoy stories, songs and exploring age-appropriate art experiences. Registration is recommended. Recommended for ages 18 to 36 months.
Microsoft PowerPoint Level 2
Wed, Nov 13, 12:00pm - 1:00pm
Alafaya - Computer Lab
Capture your audience attention with a visually compelling presentation. Learn how to insert and customize SmartArt graphics, tables, charts and video.
Open Lab - Ask A Tech
Wed, Nov 13, 2:00pm - 3:00pm
Alafaya - Computer Lab
Are you stuck on a software-related project or simply need constructive ideas to get you started? Let us help! A technology trainer will be available to assist you in this open lab.
Animal Crossing Shrinky Dinks - Part of Cozy Gaming Week
Wed, Nov 13, 3:00pm - 4:00pm
Alafaya - Back of Branch
Make your own Animal Crossing shrinky dink magnet! Recommended for ages 6 and up. Registration required.
This event is full
Cuisine Corner Junior: Zelda Snacks - Part of Cozy Gaming Week
Wed, Nov 13, 4:00pm - 5:00pm
Alafaya - Meeting Room 1
Make some of Link's classic cuisine from Zelda: Breath of the Wild and Tears of the Kingdom! Recommended for ages 6-12. Registration for each child required.
This event is full
Teen Volunteering: Tech Demos (Ages 13-17)
Wed, Nov 13, 4:00pm - 6:00pm
Alafaya - Computer Lab
High school students will earn two hours of community service by helping test out technology classes. Recommended for ages 13-17.
This event is full
Stardew Valley Shrinky Dinks - Part of Cozy Gaming Week
Wed, Nov 13, 5:00pm - 6:00pm
Alafaya - Back of Branch
Make your own Stardew Valley shrinky dink magnet! For teens and adults. Registration required.
Adobe Photoshop Level 2 - Working with Layers
Thu, Nov 14, 12:00pm - 1:30pm
Alafaya - Computer Lab
Learn how to use layers, layer masks, and layer styles. Become familiar with additional Photoshop tools like Paint Bucket, Type, and Free Transform. Explore Photoshop's myriad of adjustment layers.
Photoshop Practice Lab
Thu, Nov 14, 1:45pm - 2:45pm
Alafaya - Computer Lab
Polish your graphic design skills while practicing what you've learned in class. Get more hands on time with Photoshop and practice with others.
Learn American Sign Language (Ages 10-12)
Thu, Nov 14, 4:30pm - 5:30pm
Alafaya - Computer Lab
Discover American Sign Language in a fun and interactive way! Learn to count from 1 to 10 and the basics of finger spelling while practicing together.
Animal Crossing Mugs - Part of Cozy Gaming Week
Thu, Nov 14, 5:00pm - 6:00pm
Alafaya - Meeting Room 1
Paint your own Animal Crossing inspired mug! Ages 18 and up.
See all events