Please note that we will not offer computer classes to the public from Thanksgiving Week until the end of December 2013. Classes will resume the beginning of the following year. Registration and the class schedule for January, 2014, will be available Monday, December 16, 2013. For more information, contact (205) 226-3680 or email email@example.com.
Be safe and have fun!
Please remember that the Digital Bookmobile is making a stop at the Central Library Wednesday, October 16, 2013, 10:00 am – 4:00 pm. We will not hold classes due to this event.
The Regional Library Computer Center November computer classes schedule is now available, and registration is open to staff and the public. This month, we will offer multiple basics classes and Microsoft Excel 2010. To register for the classes, you may do so online, drop by the Computer Commons, or call (205) 226-3681.
Microsoft Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows you to store, manipulate and analyze data in organized workbooks for home and business tasks. You can use Excel to keep up with inventory, budgets, bookkeeping, contact lists, etc. To understand the basics of Excel, you might want to become familiarized with some of its features.
Components of the Excel Window
The tabbed Ribbon system was introduced in Excel 2007 to replace traditional menus. It contains all of the commands you’ll need in order to do common tasks. There are multiple tabs, each with several groups of commands. Some groups have an arrow in the bottom-right corner that you can click to see even more commands.
- File Tab: Opens Backstage view, which displays a menu of commonly used file-management commands, such as Open, Save, Save As, and Print.
- Quick Access Toolbar: Contains buttons for frequently used commands. By default, Save, Undo, and Repeat/Redo are available. You can customize the toolbar to include additional commands.
- Ribbon Tabs: Contain Excel’s primary tools and commands, which are organized in logical groups and divided among the tabs. The main tabs are File, Home, Insert, Page Layout, References, Mailings, Review, and View.
- Ribbon Groups: Further organize related tools and commands. For example, tools and menus for changing text formats are arranged together in the Font group.
- Title Bar: Displays the name of the current document.
- Document area: Displays the text graphics that you type, edit, or insert. The flashing vertical line in the document area is called the insertion point, and it indicates where text will appear as you type.
- Status Bar: Contains the page number, word count, View commands, and document Zoom.
- Scrollbars: Used to view parts of the document that doesn’t currently fit in the window. You can scroll vertically and horizontally.
- Help: Pressing your F1 key will bring up the Help function for Window-based programs. Excel 2010 offers relevant results with articles from different sources online.
Becoming familiar with the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. The Ribbon contains multiple tabs, each with several groups of commands. You can add your own tabs that contain your favorite commands.
- Home Tab-This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style.
- Insert Tab-This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers.
- Page Layout Tab-This tab has commands to adjust page such as margins, orientation and themes
- Formulas Tab-This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function in your spreadsheet.
- Data Tab-This tab allows you to modifying worksheets with large amounts of data by sorting and filtering as well as analyzing and grouping data.
- Review Tab-This tab allows you to correct spelling and grammar issues as well as set up security protections. It also provides the track changes and notes feature providing the ability to make notes and change someone’s document.
- View Tab-This tab allows you to change the view of your document including freezing or splitting panes, viewing gridlines and hide cells.
Would you like to be the among the first to know what new books, DVDs, and CDs have been added to the collections of the Public Libraries In Jefferson County (PLJC)? Well, you now have the opportunity to do just that. Birmingham Public Library has teamed up with Wowbrary to put together a weekly list of all the new materials added to the PLJC catalog. The list is available as a weekly email as well as online. You can sign up to have weekly email alerts automatically sent to you or read the weekly alert online.
The weekly alerts will spotlight the many new bestsellers, DVDs, CDs, cookbooks, mysteries, science books, travel guides, histories, children’s titles, health books, science fiction, and more. With this information you can place a hold on any library book, DVD, or CD, and any hold can be picked up at the library location of your choice. It’s easy, it’s free, and it is a fun way to find something new and unexpected at your local library.To sign up, learn more, or view the latest list of new arrivals, check out our Wowbrary page.