Microsoft Office 2010

New!10 Minute Video Tutorials are now available to enhance skills online without a workshop. See details below.

Microsoft Word - New Features

The biggest change in Word 2010 is the new user interface. Instead of Menu Bars, Office Button and the Ribbon of 2007, the elements have been combined into a Ribbon and File Menu based interface. Word 2010 also includes outstanding abilities such as image enhancement, New Word formatting tools, and much more. This workshop discusses how to use the Ribbon and File Menus in Word, as well as other new features designed to help you produce professional-looking documents.

_____________________________________________________

 

 WD 1

 

Upon successful completion of this course, you will be able to:

  • create a simple document using MS Word 2010, save a document, use some automatic text features for entering text, and access online help.
  • edit a document using a variety of techniques.
  • change the appearance of a document by applying various paragraph formats and effects.
  • create columns and organize your document into split views.
  • Use the ribbon interface to insert images and to access Backstage View.

 

 

FOR THE BEST POSSIBLE VIEWING EXPERENCE, PRESS THE FULL SCREEN BUTTON ON THE BOTTOM RIGHT OF THE PLAYER.

_________________________________________________

WD 2

Upon successful completion of this course, you will be able to:

  • create a generic fax using Word templates.
  • use Word's templates and wizards to efficiently do your work.
  • space a document into columns.
  • Setting up a document to print and setting the page orientation.
  • use the Mail Merge Wizard to mail merge form letters, converted from an external contact list.

FOR THE BEST POSSIBLE VIEWING EXPERIENCE, PRESS THE FULL SCREEN BUTTON ON THE BOTTOM RIGHT OF THE PLAYER.

__________________________________________________

 

ppt

Upon successful completion of this course, you will be able to:

  • use Word's templates and wizards to efficiently do your work.
  • space a document into columns.
  • Setting up a document to print and setting the page orientation.
  • use the Mail Merge Wizard to mail merge form letters, converted from an external contact list.

FOR THE BEST POSSIBLE VIEWING EXPERENCE, PRESS THE FULL SCREEN BUTTON ON THE BOTTOM RIGHT OF THE PLAYER.

This is a video series. To start watching, from start to finish, select the first play button.

 

_________________________________________

j

After completing this course, you will be able to:

  • add graphics and editing graphics in slides
  • add SmartArt and Photo Album
  • Use Master slides to provide a standard appearance
  • Add headers and footers to your presentation
  • Apply animation schemes
  • Add sound and video to presentations
  • Add hyperlinks

FOR THE BEST POSSIBLE VIEWING EXPERENCE, PRESS THE FULL SCREEN BUTTON ON THE BOTTOM RIGHT OF THE PLAYER.

This is a video series. To start watching, from start to finish, select the first play button.

______________________________________________

 

Microsoft Excel 2010 - New Features

The most noticeable change in Excel 2010 as in Word is the Ribbon interface alogn with the removal of the Office button, and the reinsertion of the File menu. The File Menu should be familiar toolbars and menus used in past versions prior to 2007. In this workshop, we'll discuss some of the new features and how easily you can transision from Excel 2007 to the new Excel 2010.

____________________________________________________

j

Upon successful completion of this course, you will be able to:

  • Excel 2010 File Environment
  • get start with Excel
  • format an Excel worksheet
  • enter and format cell contents
  • navigate within and between worksheets
  • use simple functions to do calculations

 

_________________________________________________

jj

Upon successful completion of this course, you will be able to:

  • use Excel Templates and create your own template.
  • customize Excel by exploring Excel Options
  • manipulate data
  • manipulate workbook
  • work with charts and graphics
  • customize Excel layout

 

_______________________________________________

j

Upon successful completion of this course, you will be able to perform calculation such as:

  • calculate Across Worksheets;
  • calculate with Date and Time Functions;
  • calculate with Financial Functions;
  • calculate with Lookup and Reference Functions;
  • calculate with Logical Functions;

 

Microsoft Access 2010 - New Features

If you’ve switched to Microsoft Access 2010 from an earlier version, you should immediately notice some major changes in the user interface, mainly the removal of the Office Button. In this workshop, we’ll walk you through some major new features of Microsoft Access 2010, such as:

 

  • Enhanced templates for getting started quickly
  • Easy spreadsheet-style data entry
  • Layout view for designing forms
  • User-oriented Office Ribbon interface

 

_________________________________________________

acc

Upon successful completion of this course, you will be able to:

  • create simple Access Database
  • understand the concepts of Access Table, Query, Form, and Report.
  • design an Access Table
  • create a simple Query, Form, and Report.

 

_______________________________________________

h

Upon successful completion of this course, you will be able to:

  • format an Access Table
  • format data property in design view
  • specify Query questions
  • create a Query, Form, and Report using design Wizard.

 

_______________________________________________

g

Upon successful completion of this course, you will be able to:

  • Update an Access Database
  • Create relationship between tables
  • Perform calculation and statistics
  • Integrate Excel tables into Access database

______________________________________________

Gradebook-Excel

This workshop will introduce the techniques of creating a gradebook using Excel. By presetting the formulas, during the whole semester, instructors will only have to enter students' raw score. Excel will calculate the total and convert numeral grades into letter grades automatically at the end of the semester. Using Excel Template will save instructor time entering formulas every semester.

 

Podcasting

This workshop will show you how to record your speech or lecture into a computer and post it onto a website or your Blackboard course, namely Podcasting.

__________________________________________________ 

h

ANGEL is our official Course Management System at Cobleskill. If you want to learn how to use the program, please go to this site for schedules:

 

 

 ANGEL Training Schedule

 

__________________________________________________

 Go back to the CELT homepage.

  • Center for Excellence
    in Learning and Teaching
  • Van Wagenen Library, Suite 209
  • Cobleskill, NY 12043
  • 518-255-5869
©