REACH - University of Louisville

Computer Skills Seminars

[Skip to Navigation]

The Computer Skills Seminars for Fall 2009.

The Computer Skills seminars are aimed at students who would like supplemental information on computer-related topics for their course work...or for those who just want to brush up on their skills.

The Computer Skills seminars are hosted by the REACH Computer Resource Center each week and held in the Ekstrom Library. Each seminar is a 50-minute session that covers a chosen topic of interest. Please check the schedule below or call 852-7569 for more information.

Microsoft Office
PowerPoint 2007 Basics

Have you ever needed to create a PowerPoint presentation for class? Have you ever needed to create a presentation for a group project yet did not feel comfortable doing it? Then this seminar is for YOU! This seminar covers the basics of creating, saving, and sharing PowerPoint presentations, as well as some general presentation guidelines. Those brand new to PowerPoint 2007 are strongly encouraged to attend the “Office 2007: What’s New?” before attending this seminar.

Topics may include:

  1.  An introduction to the PowerPoint setup and different parts of the user interface
  2. Choosing simple layouts and themes for slides and entering text
  3. Learning how to create, edit, save, and print slideshows
  4. Viewing the slideshow
  5. Discovering the capabilities of Microsoft PowerPoint
Day Time Ekstrom Library Location
11/30/09 12:00 pm W102


Excel 2007 Basics

The Microsoft Excel Basics Seminar covers the basic use of Excel, including how to navigate the Excel setup and how to create impressive tables and basic graphs. Those brand new to Excel 2007 are strongly encouraged to attend the “Office 2007: What’s New?” seminar before attending this seminar. This seminar is intended for participants who have little to no experience with Excel.  It is NOT a substitute for the CIS100 course offered through the College of Business.

Topics may include:

  1. Getting introduced to the Excel setup and the different parts of the user interface
  2. Learning how to create, save, and print worksheets
  3. Entering data of different types: numbers, text, dates, currency, etc.
  4. Learning how to insert and adjust columns and rows
  5. Using simple formulas to add and subtract data: SUM, AVERAGE, MIN, MAX
  6. Finding out how to format cells for professional-looking spreadsheets using cell borders, wrapping, merging, and text orientation
  7. Using Excel Templates to make invoices, calendars, stationary etc.
Day Time Ekstrom Library Location
11/1/2009 1:00-2:00pm W102
11/5/2009 5:00-6:00pm 117A (CLC)


Report Writing in Word 2007

Have you ever wondered why your term papers look so drab and lack pizzazz? Learn how to use the features built into Word 2007 to help turn your “C” or “B” looking paper into an “A” paper that is sure to impress your professors and fellow students. If this is your first time using Word 2007, you are strongly encouraged to attend the “Office 2007: What’s New?” seminar prior to attending this seminar. This seminar will NOT teach you how to write better, but WILL help you use the tools to make your paper look polished.

Day Time Ekstrom Library Location
12/2/09 1:00 pm W102
12/6/09 3:00 pm W102


PowerPoint 2007 Intermediate

So you’ve made a PowerPoint presentation, and now you want to add a video clip, a sound file, or even have it do fancy transitions, but you just do not know how. This seminar covers how to do these tasks, as well as creating a stunning presentation that is sure to impress your professors and fellow students!

Topics may include:

  1. Thoroughly exploring themes and slide layouts using built-in and online features
  2. Creating charts and graphs in PowerPoint
  3. Linking charts and graphs from Excel to PowerPoint
  4. Inserting clipart, pictures, and sounds into your slides
  5. Adding animations to slides
  6. Appending speaker notes to slides
  7. Exploring Power Point viewing and printing options to make your job easier
Day Time Ekstrom Library Location
12/1/09 12:00 pm W102
12/6/09 1:00 pm W102

 

PowerPoint 2007 Advanced

Take your PowerPoint skills to the next level by incorporating content from external sources. Link your information to other data resources that are important to your viewers, and protect your presentation by using built-in security features.

Topics may include:

  1. Customizing animation schemes for slides
  2. Using Microsoft Smart Art in order to make data professional-looking in a few clicks
  3. Adding movies and YouTube videos to your presentation
  4. Learning how to insert objects such as Adobe Acrobat files and Word files into a slide
  5. Creating timed slideshows for professional presentations
  6. Finding out how to add hyperlinks and web pages in your slides
  7. Learning how to protect and secure presentations
Day Time Ekstrom Library Location
12/1/09 12:00 pm W102
12/6/09 1:00 pm W102


Excel 2007 Intermediate

The Microsoft Excel Intermediate Seminar covers how to create formulas to perform a variety of mathematical, statistical, text, and date/time operations on data you have created or that has been provided to you.  Topics may include importing data, financial functions, and conditional formatting. This seminar is intended for participants who have some experience with entering and formatting data in Excel and is NOT a substitute for the CIS100 course offered through the College of Business.

Topics may include:

  1. Discovering how to quickly manipulate data using pre-built Excel formulas
  2. Using Excel “lookup” functions to search and find specific data in large data sets: VLOOKUP, HLOOKUP, MATCH, etc.
  3. Learning how to quickly and easily create professional charts and graphs
  4. Discovering the power of the Excel Sort and Filter operations
  5. Discovering the utility of Excel Conditional Formatting operations to highlight or pick out certain data that meet your specifications
  6. Exploring Excel printing and viewing options to make your job easier such as Freeze Panes and Page Break Preview
Day Time Ekstrom Library Location
11/8/2009 1:00-2:00pm W102
11/11/2009 5:00-6:00pm W102


Excel 2007Advanced

The Microsoft Excel Advanced Seminar covers how to control the output of functions using custom, nested “If-Then” statements and “What-If Analysis” scenarios.  For example, one application may be using Solver to find the number of units that must be sold in order to reach a user-specified profit level.  Topics may include using Boolean Operators, Goal Seek, Solver, Pivot Tables, and Document Protection. This seminar is intended for participants who have some considerable experience using Excel formulas and organizing large data sets. It is NOT a substitute for the CIS300 course offered through the College of Business.

Topics may include:

  1. Utilizing “If-Then” statements to perform conditional operations on the table data
  2. Getting introduced to the “What-If Analysis” powerhouses Goal Seek and Solver
  3. Creating a simple Pivot Table to summarize and organize complex data
  4. Learning how to protect and secure your spreadsheets using Document Protection
Day Time Ekstrom Library Location
10/22/2009 5:00-6:00pm W102
10/25/2009 1:00-2:00pm W102
11/15/2009 1:00-2:00pm W102
12/3/2009 5:00-6:00pm W102

Computer Skills Seminars Flyer

If you have any suggestions for topics, contact the webmaster with your ideas or questions.

Top of Page


Navigation: