Skip to main content
close
Font size options
Increase or decrease the font size for this website by clicking on the 'A's.
Contrast options
Choose a color combination to give the most comfortable contrast.

Registration now closed

Microsoft Excel - Pivot Tables

2023-10-25 10:15:00 2023-10-25 11:15: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. Southwest Branch - Technology Classroom

Wednesday, October 25
10:15am - 11:15am

Add to Calendar 2023-10-25 10:15:00 2023-10-25 11:15: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. Southwest Branch - Technology Classroom

Southwest Branch

Technology Classroom

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 |

Southwest Branch

Phone: 407-835-7323

Hours
Mon, Dec 04 10:00AM to 7:00PM
Tue, Dec 05 10:00AM to 7:00PM
Wed, Dec 06 10:00AM to 7:00PM
Thu, Dec 07 10:00AM to 7:00PM
Fri, Dec 08 10:00AM to 6:00PM
Sat, Dec 09 10:00AM to 6:00PM
Sun, Dec 10 Closed

About the branch

The Southwest Branch opened on March 21, 1989 in a beautiful Mediterranean style building designed by Schweizer and Associates Architecture Firm, who also designed the Orlando Public Library. Serving the Dr. Phillips and Metrowest communities, Southwest is near International Drive and the attractions. Southwest is a popular place for local adults, children, students and tourists.

Read the Southwest blog often for more information on upcoming programs for children and adults, book news and book club discussions, technology classes, art exhibits, new library materials, and more. Email us your suggestions or questions; or post a comment. Let us hear from you!

Upcoming events

Mon, Dec 11, 10:00am - 12:00pm
Meet in Parking Lot 1
Join the Southwest Library for a walk outdoors at Bill Frederick Park followed by discussion of Life in Five Senses by Gretchen Rubin. Registration required. 18+

Mon, Dec 11, 11:00am - 11:30am
Using rhymes, songs, puppets, musical instruments and more, we will be interacting together to help develop important pre-literacy skills in our littlest ones! Recommended for ages 0-18 months.

Mon, Dec 11, 11:30am - 12:00pm
Connect with other caregivers to meet and mingle while your little one explores imaginary play with new and old friends. Recommended for ages 0-5.

Mon, Dec 11, 1:00pm - 2:00pm
Inviting all homeschoolers to play games, socialize, and share resources. Recommended for lower and upper elementary.

Tue, Dec 12, 10:15am - 12:15pm
Technology Classroom
Learn sashiko hand sewing techniques that form geometric patterns from simple running stitches. Create beautiful designs layer-by-layer while learning to mark and sew these geometric designs.
This event is full

Tue, Dec 12, 11:00am - 11:45am
Listen to stories and complete a STEAM challenge. Challenges will invite preschoolers to imagine, plan, create and improve upon a story-related project. Recommended for ages 3-5.

Tue, Dec 12, 1:15pm - 2:15pm
Technology Classroom
Discover how you can use Microsoft 365's Forms App to create forms, collect data and view and analyze data.

Wed, Dec 13, 10:15am - 11:15am
Technology Classroom
Turn scanned drawings into sleek vector graphics. Apply several design techniques and use common editing tools to trace and color artwork as well as manage objects and layers.

Wed, Dec 13, 11:00am - 11:45am
Brrr! Who is brrrave enough to live in the cold? Discover chilly animal friends and their snowy homes with fun stories, crafts and activities. Recommended for toddlers and preschoolers.

Wed, Dec 13, 11:30am - 12:30pm
Technology Classroom
Design professional-looking stationery using Adobe Illustrator. Create and arrange text and image assets and use masks, transparency, and blending modes to create eye-catching designs.

Wed, Dec 13, 1:30pm - 2:30pm
Technology Classroom
Calculate data with basic functions SUM and AVERAGE. Use auto features including auto and flash fill to streamline your workflow.

Wed, Dec 13, 4:00pm - 5:00pm
The LEGO® Club at the Southwest Library invites you to come use your imaginations to build! Bricks will be provided but cannot go home with you. Recommended for ages 6-12.

Thu, Dec 14, 10:00am - 12:00pm
Drop-in before and after storytime to create a make-and-take craft. Recommended for toddlers and preschoolers.

Thu, Dec 14, 10:15am - 11:15am
Technology Classroom
Identify the basic features and tools to get you started. Learn how to create a presentation by using templates, text, and picture files.

Thu, Dec 14, 10:30am - 10:55am
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.

Thu, Dec 14, 11:00am - 11:20am
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.

Thu, Dec 14, 11:30am - 11:45am
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.

Thu, Dec 14, 11:30am - 12:30pm
Technology Classroom
Capture your audience attention with a visually compelling presentation. Learn how to insert and customize SmartArt graphics, tables, charts and video.

Sat, Dec 16, 10:30am - 11:30am
Learn beginner line dances to all types of music and discover a great way to exercise and have fun. Partners not needed. Bring water. Non-stick sole shoes recommended. 18+

Sat, Dec 16, 10:30am - 11:30am
Technology Classroom
Have a new tablet or smartphone, but not sure how to use it? Let us get you started with the basics, so you become more familiar with your personal device.

Sat, Dec 16, 1:30pm - 3:30pm
Conference Room
Experience the joy and camaraderie of reading aloud a book with others each week. Presented by the Dr. P. Phillips YMCA and the Southwest Library. 18+

Sat, Dec 16, 2:00pm - 5:00pm
Southwest - Ask at Desk
Let's play a single session of Dungeons and Dragons. Choose a premade hero for an adventure with fearsome foes, dire dungeons, and tons of treasure.

Mon, Dec 18, 11:00am - 11:30am
Discover the season of cold with your baby. Stories, songs, and rhymes will introduce baby to all things cold. Recommended for ages 0-18 months and their caregiver.

Mon, Dec 18, 11:30am - 12:00pm
Connect with other caregivers to meet and mingle while your little one explores imaginary play with new and old friends. Recommended for babies, toddlers and preschoolers.

Mon, Dec 18, 1:00pm - 2:00pm
Inviting all homeschoolers to play games, socialize, and share resources. Bring your favorite board games and card games to share. Recommended for lower and upper elementary.

Mon, Dec 18, 6:30pm - 8:00pm
Inside Dr. Phillips YMCA
Join us at Foxtail Coffee Co. to share with others your favorite podcasts you listen to and love. No pre-selected playlist this month. 18+

Tue, Dec 19, 10:15am - 12:00pm
Technology Classroom
Create mini gift toppers to decorate and gift. Learn and practice knitting techniques while creating a cute gift topper to accent your gifts.

Tue, Dec 19, 11:00am - 11:45am
Get cozy as we build a snowman with wintry sweets. Adult participation is required. Space is limited. Registration required. Recommended for ages 3-5.

Tue, Dec 19, 1:00pm - 3:00pm
Technology Classroom
Ever wanted to make your own custom clothes, home decor, costumes or accessories? Join us in this basic sewing class and learn about sewing safety, basic sewing machine skills and stitching seams.
This event is full

Wed, Dec 20, 10:15am - 11:15am
Technology Classroom
Build your business logo using graphic design theory for concepts, color, and font choices. Learn the basics of designing a business logo using vector graphics tools.

Wed, Dec 20, 11:00am - 11:45am
Southwest - Ask at Desk
Help your child with their motor development skills in this interactive bubble class. Recommended for ages 18-36 months.

Wed, Dec 20, 1:30pm - 2:30pm
Technology Classroom
Analyze data with COUNT functions and recommended charts. Use absolute and relative references to ensure your data is calculated accurately. Recommended Audience: Adult

Wed, Dec 20, 4:00pm - 5:00pm
The LEGO® Club at the Southwest Library invites you to come use your imaginations to build! Bricks will be provided but cannot go home with you. Recommended for ages 6-12.

Thu, Dec 21, 10:00am - 12:00pm
Drop-in before and after storytime to create a make-and-take craft. Recommended for toddlers and preschoolers.

Thu, Dec 21, 10:15am - 11:15am
Technology Classroom
Get more precise control over your presentation. Learn how to insert slide transitions, add animations and hyperlinks. Create a customized photo album with simple to use tools.

Thu, Dec 21, 10:30am - 10:55am
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.

Thu, Dec 21, 11:00am - 11:20am
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.

Thu, Dec 21, 11:30am - 11:45am
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.

Thu, Dec 21, 11:30am - 12:30pm
Technology Classroom
Make universal style changes to all slides in your presentation. Learn how to customize a theme and to format slides through the slide master.

Fri, Dec 22, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Fri, Dec 22, 2:00pm - 3:30pm
Enjoy an afternoon of sharing a favorite book or author with other readers. Give a toast to a new year of shared reading adventures! No preselected title. For ages 18+.

Sat, Dec 23, 10:15am - 11:15am
Technology Classroom
Display your data in stunning charts and graphs. Insert recommended and custom charts. Edit chart data, elements and styles.

Sat, Dec 23, 10:30am - 11:30am
Children's Area
Children can improve their reading skills by reading to a therapy dog with Golden retriever Rescue of Mid-Florida. Practice with a furry friend and build your confidence. Recommended for children.
This event is full

Sat, Dec 23, 11:30am - 12:30pm
Technology Classroom
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.

Sat, Dec 23, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Sat, Dec 23, 1:30pm - 3:30pm
Conference Room
Experience the joy and camaraderie of reading aloud a book with others each week. Presented by the Dr. P. Phillips YMCA and the Southwest Library. 18+

Tue, Dec 26, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Wed, Dec 27, 11:00am - 11:45am
Toddlers use unstructured play to advance their physical and cognitive development and to have FUN! Recommended for ages 18-36 months.

Wed, Dec 27, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Wed, Dec 27, 4:00pm - 5:00pm
The LEGO® Club at the Southwest Library invites you to come use your imaginations to build! Bricks will be provided but cannot go home with you. Recommended for ages 6-12.

Thu, Dec 28, 10:00am - 12:00pm
Drop-in before and after storytime to create a make-and-take craft. Recommended for toddlers and preschoolers.

Thu, Dec 28, 10:30am - 10:55am
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.

Thu, Dec 28, 11:00am - 11:20am
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.

Thu, Dec 28, 11:30am - 11:45am
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.

Thu, Dec 28, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Fri, Dec 29, 10:30am - 11:30am
Southwest - Ask at Desk
Learn ancient Qigong practice with modern day instructor Jasmine Win. Using the 5 elements of life, students will undergo an empowering & uplifting shift to take control of their health & lives.

Fri, Dec 29, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Sat, Dec 30, All day
Stop by to write a postcard to our character of the month and drop it in our mailbox! The character mailbox helps encourage reading, writing, and creativity.

Sat, Dec 30, 10:30am - 11:30am
Technology Classroom
Join Alex and Steve on a Minecraft Adventure! Solve code challenges to explore, gather resources, and defeat mobs. Create algorithms, use loops, and debug your code.

Sat, Dec 30, 11:30am - 12:15pm
Southwest - Ask at Desk
Make some noise and ring in the noon year with your little ones! Join us for fun and games with an exciting countdown at noon. Recommended for ages 3-5.

Sat, Dec 30, 12:00pm - 1:00pm
Technology Classroom
Make your own Minecraft world! Program the environment, animals and mobs. Use algorithms, functions, loops, and conditions to complete code challenges.

Sat, Dec 30, 1:30pm - 3:30pm
Conference Room
Experience the joy and camaraderie of reading aloud a book with others each week. Presented by the Dr. P. Phillips YMCA and the Southwest Library. 18+

Tue, Jan 02, 10:30am - 12:15pm
Technology Classroom
Start learning how to knit together ! Knitting for families focuses on basic techniques while and muscle memory. Techniques include casting on, the knit stitch and binding off.

Tue, Jan 02, 11:00am - 11:45am
Preschoolers will discover how arctic animals survive in the cold while practicing early literacy skills through stories, songs and a craft. Recommended for ages 3-5.

Tue, Jan 02, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Wed, Jan 03, 10:00am - 10:45am
Join us for an outdoor nature Storytime hosted near the playground at Bill Frederick Park. Small fee required to enter the park. Recommended for ages 0-12.

Wed, Jan 03, 11:00am - 11:45am
Join us with your toddlers for a special parachute playtime. Enjoy rhymes, songs and tons of parachute fun. Recommended for ages 18-36 months.

Wed, Jan 03, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Wed, Jan 03, 12:45pm - 2:45pm
Technology Classroom
Start crocheting today! Learn basic techniques while creating your first project, a bookmark for your favorite read. Techniques include creating a slip knot, chaining, and single crochet stitches.

Wed, Jan 03, 4:00pm - 5:00pm
The LEGO® Club at the Southwest Library invites you to come use your imaginations to build! Bricks will be provided but cannot go home with you. Recommended for ages 6-12.

Thu, Jan 04, 10:00am - 12:00pm
Drop-in before and after storytime to create a make-and-take craft. Recommended for toddlers and preschoolers.

Thu, Jan 04, 10:15am - 11:00am
Technology Classroom
Go on a coding adventure. Help Awbie, the loveable monster, find his animal friends with the use of tangible Osmo coding blocks in this fun game.

Thu, Jan 04, 10:30am - 10:55am
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.

Thu, Jan 04, 11:00am - 11:20am
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.

Thu, Jan 04, 11:15am - 12:00pm
Technology Classroom
Run your own pizza shop with Osmo. Make customers happy with fresh made-to-order pizzas and good service. Learn how to help customers and make change with Osmo Pizza Co.

Thu, Jan 04, 11:30am - 11:45am
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.

Thu, Jan 04, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Fri, Jan 05, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Sat, Jan 06, 10:00am - 10:45am
Join us for an outdoor nature Storytime hosted near the playground at Bill Frederick Park. Small fee required to enter the park. Recommended for ages 0-12.

Sat, Jan 06, 10:15am - 11:15am
Technology Classroom
Go on a coding adventure. Help Awbie, the loveable monster, find his animal friends with the use of tangible Osmo coding blocks in this fun game.

Sat, Jan 06, 11:30am - 12:30pm
Technology Classroom
Run your own pizza shop with Osmo. Make customers happy with fresh made-to-order pizzas and good service. Learn how to help customers and make change with Osmo Pizza Co.

Sat, Jan 06, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Sat, Jan 06, 1:30pm - 3:30pm
Conference Room
Experience the joy and camaraderie of reading aloud a book with others each week. Facilitator-led in partnership with the Dr. P. Phillips YMCA and Southwest Library. 18+

Mon, Jan 08, 10:00am - 12:00pm
Join the Southwest Library for a walk outdoors at Nehrling Gardens followed by discussion of Go As A River by Shelly Read. Registration required. 18+

Mon, Jan 08, 11:00am - 11:30am
Introduce your baby to important early literacy skills through movement, music, rhymes and stories. Recommended for ages 0-18 months.

Mon, Jan 08, 11:30am - 12:00pm
Connect with other caregivers to meet and mingle while your little one explores imaginary play with new and old friends. Recommended for ages 0-18 months.

Mon, Jan 08, 12:00pm - 12:15pm
Gather with us in the children’s area daily at noon for a story about winter. We will open a different wrapped book each day for shared reading. Recommended for families.

Mon, Jan 08, 1:00pm - 2:00pm
Come participate in math, science, history, art and literature-based learning to support your child's homeschool curriculum. Recommended for ages 6-12.

Tue, Jan 09, 10:15am - 11:30am
Technology Classroom
Basic hand sewing skills are essential skills needed in everyday life. Learn the basic techniques to get started, including how to make a quilter's knot, thread a needle and sew a running stitch.

Tue, Jan 09, 11:00am - 11:45am
Have a berry good time celebrating fruits with stories and activities! Recommended for ages 3-5.

Tue, Jan 09, 1:15pm - 2:15pm
Technology Classroom
Start using Excel today. Input, format and save data in spreadsheets. Calculate data with basic formulas.