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 - Formulas and Functions

2023-12-14 10:15:00 2023-12-14 11:15:00 America/New_York Microsoft Excel - Formulas and Functions 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. South Creek Branch - South Creek - Computer Lab

Thursday, December 14
10:15am - 11:15am

Add to Calendar 2023-12-14 10:15:00 2023-12-14 11:15:00 America/New_York Microsoft Excel - Formulas and Functions 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. South Creek Branch - South Creek - Computer Lab

South Creek Branch

South Creek - 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.

  • Class Duration: 1 hour 
  • Age Requirements: 13-Adult
  • Recommended Prerequisite: Microsoft Excel 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 |

South Creek Branch


Hours
We're closed Friday November 08 due to Closed in observance of Staff Development Day.
Mon, Nov 04 10:00AM to 7:00PM
Tue, Nov 05 10:00AM to 7:00PM
Wed, Nov 06 10:00AM to 7:00PM
Thu, Nov 07 10:00AM to 7:00PM
Fri, Nov 08 Closed
(Closed in observance of Staff Development Day.)
Sat, Nov 09 10:00AM to 6:00PM
Sun, Nov 10 1:00PM to 6:00PM

About the branch

LYNX Bus Link 108 U.S. 441 / Kissimmee

The South Creek Branch is located at the intersection of Deerfield Boulevard and Balcombe Road east of South Orange Blossom Trail. Serving communities including Deerfield, Ginger Mill, Hunters Creek, Pepper Mill, South Chase and Whisper Lakes, South Creek is the southernmost branch in Orange County.

In October of 2002, the South Creek branch replaced the South Orange Branch which had been located in the Waterbridge Down Shopping Center since 1992. With the completion of South Creek, south Orange County now has a light and bright facility with state-of-the-art technology and services including, 35 public computers, self-checkout, and technology classes in English and Spanish. This facility was funded by the Orange County Library District and a Florida Library Construction Grant.

A special feature at South Creek is the sculpture "Bonsai Study IV" by local artist Larry Jones. The piece won "Best in Show" at the 2001 Fiesta in the Park. The Fiesta Committee purchased the sculpture and donated it to the Library.

Upcoming events

Mon, Nov 11, 10:15am - 10:40am
South Creek - Meeting Room 1
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
Mon, Nov 11, 10:15am - 11:15am
Aprenda conceptos y terminología de hojas de cálculo. Aprenda a crear una hoja de cálculo simple y a cómo aplicar diferentes fórmulas sencillas.

Mon, Nov 11, 10:45am - 11:10am
South Creek - Meeting Room 1
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.

Mon, Nov 11, 11:15am - 11:30am
South Creek - Meeting Room 1
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.

Mon, Nov 11, 11:30am - 12:00pm
South Creek - Meeting Room 1
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.

Cancelled
Mon, Nov 11, 11:45am - 12:45pm
Aprenda a utilizar herramientas avanzadas de formato y a aplicar formulas y funciones sencillas.

Mon, Nov 11, 4:15pm - 5:15pm
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Mon, Nov 11, 4:30pm - 5:30pm
South Creek - Ask at Desk
Create your own sunflower earrings using crochet techniques. For ages 13 and up.

Mon, Nov 11, 5:30pm - 6:30pm
South Creek - 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.

Tue, Nov 12, 10:15am - 11:15am
South Creek - Computer Lab
Aprenda cómo enlazar hojas de cálculo y a trabajar con las opciones avanzadas de hoja de cálculo.

Tue, Nov 12, 11:45am - 12:45pm
South Creek - Computer Lab
Aprenda a insertar imgenes, ordenar data y a proteger con contraseña las hojas de cálculo.

Tue, Nov 12, 5:30pm - 6:30pm
South Creek - Meeting Room 1
The South Creek Book Club meets on the second Tuesday of each month to discuss a new book!

Wed, Nov 13, 10:00am - 5:00pm
South Creek - Ask at Desk
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.

Wed, Nov 13, 10:15am - 11:15am
South Creek - 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.

Wed, Nov 13, 11:45am - 12:45pm
South Creek - Computer Lab
This session is to continue/practice what remains of the Formulas and Functions class.

Wed, Nov 13, 4:30pm - 5:15pm
South Creek - Meeting Room 1
It’s time to get fancy with our favorite girl, Nancy! Wear your fanciest clothes and join us for stories, activities, and crafts that will be wonderful. Recommended for ages 3-5.

Thu, Nov 14, 10:15am - 11:15am
South Creek - Computer Lab
Learn how to use advanced sort and filter options; apply data validation and other data tools to organize your data.

Thu, Nov 14, 10:30am - 11:15am
South Creek - Meeting Room 1
Celebrate Autumn with preschool friendly science activities. Adult participation is required for this event. Recommended for ages 3-5.

Thu, Nov 14, 11:45am - 12:45pm
South Creek - Computer Lab
Learn how to apply data subtotals, outlines, data consolidation and conditional formatting to organize your data.

Thu, Nov 14, 4:30pm - 5:30pm
South Creek - Meeting Room 1
Join us for an afternoon of cork crafting just in time for fall. We will create a craft with corks, hot glue and paint. Registration is recommended. For ages 18 and up.

Fri, Nov 15, 10:15am - 12:15pm
South Creek - Ask at Desk
Bring your plants and ask questions! Master Gardener Volunteers from the UF/IFAS Orange County Extension Office will be available to answer your gardening questions.

Fri, Nov 15, 10:30am - 11:30am
South Creek - Computer Lab
How do you organize your important documents and appointments? From doctor appointments, budgets, to final arrangements discuss best practices for organizing your important plans and documents.

Fri, Nov 15, 10:30am - 11:30am
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Fri, Nov 15, 12:00pm - 1:00pm
South Creek - 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.

Fri, Nov 15, 1:30pm - 2:30pm
South Creek - Meeting Room 1
A series of workshops in which students can practice their English speaking and listening skills. Recommended for those with a basic understanding of English.

Sat, Nov 16, 10:15am - 11:15am
South Creek - 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.

Sat, Nov 16, 10:30am - 11:30am
South Creek - 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, Nov 16, 11:00am - 11:45am
South Creek - Meeting Room 1
Enjoy Moana-inspired activities and crafts. Recommended for families with children 3-12.

Sat, Nov 16, 11:45am - 12:45pm
South Creek - 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.

Sat, Nov 16, 4:00pm - 5:00pm
South Creek - Meeting Room 1
Dive into Egyptology and explore hieroglyphics, pyramids, amulets and ancient Egyptian art & history. Recommended for lower and upper elementary.

Sun, Nov 17, 2:00pm - 2:25pm
South Creek - Children's Area
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.

Mon, Nov 18, 10:15am - 10:40am
South Creek - Meeting Room 1
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.

Mon, Nov 18, 10:15am - 11:15am
South Creek - Computer Lab
Aprenda a crear formulas y a insertar funciones avanzadas. Familiarícese con la Librera de Funciones la cual le ayudara a encontrar e insertar argumentos de funciones.

Mon, Nov 18, 10:45am - 11:10am
South Creek - Meeting Room 1
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.

Mon, Nov 18, 11:15am - 11:30am
South Creek - Meeting Room 1
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.

Mon, Nov 18, 11:30am - 12:00pm
South Creek - Meeting Room 1
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, Nov 18, 11:45am - 12:45pm
South Creek - Computer Lab
Continuación de Fórmulas y Funciones

Mon, Nov 18, 4:15pm - 5:15pm
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Mon, Nov 18, 4:30pm - 5:30pm
South Creek - Children's Area
Explore the art and literature of Beatrix Potter and discover why she wrote simple stories about animals. Recommended for ages 6-12.

Mon, Nov 18, 5:30pm - 6:30pm
South Creek - 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.

Tue, Nov 19, 4:00pm - 5:30pm
South Creek - Meeting Room 1
Leave Monopoly at home! Come learn this fast-paced miniature battle game set in the world of Dungeons & Dragons! Other classics and popular board games will also be available. Registration Required. 

Wed, Nov 20, 10:00am - 5:00pm
South Creek - Ask at Desk
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.

Wed, Nov 20, 10:15am - 11:15am
South Creek - 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.

Wed, Nov 20, 11:45am - 12:45pm
South Creek - Computer Lab
Display your data in stunning charts and graphs. Insert recommended and custom charts. Edit chart data, elements and styles.

Wed, Nov 20, 4:30pm - 5:15pm
South Creek - Meeting Room 1
From a suspicious photograph of the Loch Ness monster to the Cottingley Fairies, history is full of fakers. Learn about some of the world's greatest hoaxes through crafts and activities. Ages 6-12.

Thu, Nov 21, 10:15am - 11:15am
South Creek - Computer Lab
Automate everyday tasks with macros. Record data entry and formatting. Insert and modify objects to run macros without coding.

Thu, Nov 21, 10:30am - 11:15am
South Creek - Meeting Room 1
Read stories of thankfulness and family, then create holiday-themed crafts to delight someone special. Recommended for ages 3-5.

Thu, Nov 21, 4:30pm - 5:30pm
South Creek - Meeting Room 1
Make your own no-sew fleece pet blanket for your furry friend! Recommended for Adults. Registration required.

Fri, Nov 22, 10:30am - 11:30am
South Creek - Children's Area
Learn about Thanksgiving and being thankful through stories, songs and rhymes. Recommended for ages 3-5.

Fri, Nov 22, 10:30am - 11:30am
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Fri, Nov 22, 12:00pm - 1:00pm
South Creek - 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.

Fri, Nov 22, 1:30pm - 2:30pm
South Creek - Meeting Room 1
A series of workshops in which students can practice their English speaking and listening skills. Recommended for those with a basic understanding of English.

Sat, Nov 23, 10:15am - 11:15am
South Creek - 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.

Sat, Nov 23, 10:30am - 11:30am
South Creek - Meeting Room 1
Grow your own beanstalk in a glass jar and observe the growth process. Recommended for ages 5 and up.

Sat, Nov 23, 11:45am - 12:45pm
South Creek - 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.

Mon, Nov 25, 10:15am - 10:40am
South Creek - Meeting Room 1
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.

Mon, Nov 25, 10:15am - 11:15am
South Creek - Computer Lab
Aprenda a crear tablas dinamicas para el análisis de grandes cantidades de datos sin el uso de formulas complicadas.

Mon, Nov 25, 10:45am - 11:10am
South Creek - Meeting Room 1
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.

Mon, Nov 25, 11:15am - 11:30am
South Creek - Meeting Room 1
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.

Mon, Nov 25, 11:30am - 12:00pm
South Creek - Meeting Room 1
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, Nov 25, 11:45am - 12:45pm
South Creek - Computer Lab
Aprenda a crear gráficos y tablas de apariencia profesional.

Mon, Nov 25, 4:15pm - 5:15pm
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Mon, Nov 25, 5:30pm - 6:30pm
South Creek - 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.

Tue, Nov 26, 4:30pm - 5:30pm
South Creek - Meeting Room 1
Expand your creativity and imagination with LEGO! Bricks will be provided but cannot go home with you. Recommended for families with children ages 6-12.

Wed, Nov 27, 10:00am - 5:00pm
South Creek - Ask at Desk
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.

Sat, Nov 30, 10:30am - 12:00pm
South Creek - Meeting Room 1
Join us for a showing of Disney Pixar’s Inside Out 2 as you create your own fuse bead masterpiece. Recommended for families with children ages 6-12.

Sat, Nov 30, 4:00pm - 5:00pm
South Creek - Meeting Room 1
Grab your sketchbook and join us for a laid-back hour of drawing! South Creek Sketchbook Club is a monthly gathering where artists can work on pieces and share them with others.

Mon, Dec 02, 10:15am - 10:40am
South Creek - Meeting Room 1
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.

Mon, Dec 02, 10:45am - 11:10am
South Creek - Meeting Room 1
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.

Mon, Dec 02, 11:15am - 11:30am
South Creek - Meeting Room 1
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.

Mon, Dec 02, 11:30am - 12:00pm
South Creek - Meeting Room 1
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 02, 4:15pm - 5:15pm
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Mon, Dec 02, 4:30pm - 5:30pm
South Creek - Ask at Desk
Learn to make cool paper decorations to add pizzazz to your own room or to give as a gift. Recommended for tweens and teens.

Mon, Dec 02, 5:30pm - 6:30pm
South Creek - 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.

Tue, Dec 03, 4:30pm - 5:15pm
South Creek - Meeting Room 1
Use a variety of art supplies to create unique cards for your loved ones this holiday season. Recommended for all ages.

Wed, Dec 04, 10:00am - 5:00pm
South Creek - Ask at Desk
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.

Wed, Dec 04, 10:15am - 11:15am
South Creek - 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.

Wed, Dec 04, 11:45am - 12:45pm
South Creek - Computer Lab
Get your computer skills racing. Learn how to create, rename, delete, and organize files and folders on your computer.

Wed, Dec 04, 5:00pm - 6:30pm
South Creek - Meeting Room 1
During this 4-session program, students will meet to prepare for the U.S. Naturalization (Citizenship) Test and Interview.

Thu, Dec 05, 10:15am - 11:15am
South Creek - Computer Lab
Create polished documents in Microsoft Word. Navigate the user interface and apply basic word processing techniques to create a formatted letter. Learn important actions like copy, cut, and paste.

Thu, Dec 05, 10:30am - 11:15am
South Creek - Meeting Room 1
Introduce some beginner Spanish words and phrases to your little one through stories, songs, and interactive play. Recommended for children ages 3 to 5.

Thu, Dec 05, 11:45am - 12:45pm
South Creek - Computer Lab
Explore Microsoft Word's proofing features like the spelling and grammar check. Use and modify Word templates with ease. Enhance your document by inserting and formatting pictures.

Thu, Dec 05, 5:00pm - 6:30pm
South Creek - Meeting Room 1
During this 4-session program, students will meet to prepare for the U.S. Naturalization (Citizenship) Test and Interview.

Fri, Dec 06, 10:30am - 11:30am
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Fri, Dec 06, 12:00pm - 1:00pm
South Creek - 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.

Fri, Dec 06, 1:30pm - 2:30pm
South Creek - Meeting Room 1
A series of workshops in which students can practice their English speaking and listening skills. Recommended for those with a basic understanding of English.

Fri, Dec 06, 4:30pm - 5:30pm
South Creek - Meeting Room 1
Teens meet each month to discuss a new book and enjoy activities inspired by the reading. Ages 13-18. This month's book is Demon in the Wood by Leigh Bardugo & Dani Pendergast.

Sat, Dec 07, 10:15am - 11:15am
South Creek - 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.

Sat, Dec 07, 10:30am - 11:30am
South Creek - Meeting Room 1
Unleash your inner artist and discover your creative side in this all-ages art exploration. Inspiration is a must! Recommended for families with a child 6 years or older.

Sat, Dec 07, 11:45am - 12:45pm
South Creek - Computer Lab
Display your data in stunning charts and graphs. Insert recommended and custom charts. Edit chart data, elements and styles.

Sat, Dec 07, 2:30pm - 4:00pm
South Creek - Meeting Room 1
Make a one-of-a-kind keychain! Learn the basics of resin and create a personalized design of your choice. For adults. All supplies provided. Registration required. Ages 18+

Mon, Dec 09, 10:15am - 10:40am
South Creek - Meeting Room 1
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.

Mon, Dec 09, 10:45am - 11:10am
South Creek - Meeting Room 1
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.

Mon, Dec 09, 11:15am - 11:30am
South Creek - Meeting Room 1
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.

Mon, Dec 09, 11:30am - 12:00pm
South Creek - Meeting Room 1
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 09, 4:15pm - 5:15pm
South Creek - Meeting Room 1
This class is designed for students with a beginner level knowledge of English. Practice basic vocabulary and grammar.

Mon, Dec 09, 5:30pm - 6:30pm
South Creek - 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.

Tue, Dec 10, 4:30pm - 5:15pm
South Creek - Meeting Room 1
Compete against the best in the branch in challenging minute-to-win it mini games. Recommended for ages 6-12.

Tue, Dec 10, 5:30pm - 6:30pm
South Creek - Ask at Desk
The South Creek Book Club meets on the second Tuesday of each month to discuss a new book!