Quick Links

Microsoft® Office 2010

Microsoft® Office 2010

The updated Microsoft® Office 2010 Catalog has arrived!
Price
$75 NYBA or ABA Members/$99 Non-members per course
License Option
Courses are also available at discounted prices under an annual license.
Required Software
Internet Explorer 6.0 or higher
Required Hardware
Computer with sound capability
Available courses in the Microsoft Office 2010 catalog follow. Click on the appropriate link above – Returning Learner/ ABA Member Registration /Non-Member Registration – to access full course descriptions and online registration. If you would prefer to have NYBA process your registration, click Registration Form.
 
MICROSOFT® OFFICE 2010: BEGINNING ACCESS
  • Getting Started with Access 2010 
  • Creating Basic Tables in Access 2010
  • Data Manipulation and Simple Relationships in Access 2010
  • Introduction to Forms in Access 2010
  • Introduction to Queries in Access 2010 
  • Introduction to Reports in Access 2010 
  • Modifying Basic Forms in Access 2010
MICROSOFT® OFFICE 2010: ADVANCED ACCESS
  • Access 2010 Macros and VBA
  • Advanced Importing and Exporting with Access 2010
  • Joins, SQL, and Action Queries in Access 2010
  • Optimizing, Securing, and Sharing Access 2010 Databases
  • PivotTables and PivotCharts in Access 2010
  • Retrieving, Validating, and Attaching Data in Access 2010
  • Subforms, Subreports, and Conditional Formatting in Access 2010
  • Using Access 2010 with SharePoint and Access Services
MICROSOFT® OFFICE 2010: BEGINNING EXCEL
  • Getting Started with Excel 2010
  • Adding Visuals, Themes, and Styles to Excel 2010 Workbooks
  • Applying Basic Data Formatting in Excel 2010
  • Inserting Basic Charts in Excel 2010
  • Moving and Getting Around in Excel 2010
  • Moving Data and Modifying Worksheets in Excel 2010
  • Reviewing and Protecting Content in Excel 2010
  • Saving, Sending, and Printing Excel 2010 Workbooks
  • Using Basic Formulas in Excel 2010
  • Using Basic Functions with Excel 2010
  • Using Conditional Formatting, Tables, and Sparklines in Excel 2010
MICROSOFT® OFFICE 2010: ADVANCED EXCEL
  • Analyzing Data with What-if Analysis in Excel 2010
  • Automating Excel 2010 Tasks Using Macros
  • Customizing Visual Elements in Excel 2010
  • Organizing Data and Objects in Excel 2010
  • PivotTable Filters, Calculations, and PowerPivot
  • PivotTables and PivotCharts in Excel 2010
  • Verifying Excel 2010 Data and Formulas
  • Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010
MICROSOFT® OFFICE 2010: POWER USER EXCEL
  • Manipulating Formulas and Using Forms in Excel 2010
  • Sharing Excel 2010 Workbooks Online and on a Network
  • Using Excel 2010 Data Connections: Web Queries, XML, and Databases
  • Using Excel 2010 to Collaborate Online and with Other Office Applications
  • Using Lookup, Reference, Math, and Text Functions in Excel 2010
MICROSOFT® OFFICE 2010: BEGINNING OUTLOOK
  • Getting Started with Outlook 2010
  • Managing Attachments, Graphics, Signatures, and Autoreplies in Outlook 2010
  • Managing Conversations and Organizing E-mail in Outlook 2010
  • Managing Meetings and Customizing the Calendar in Outlook 2010
  • Outlook 2010 Social Connector and Messaging
  • Using the Calendar for Appointments, Events, and Meetings in Outlook 2010
  • Using the Tasks, Notes, and Journal Features in Outlook 2010
  • Working with Contacts in Outlook 2010
MICROSOFT® OFFICE 2010: ADVANCED OUTLOOK
  • Accessing Exchange Remotely and Using Forms in Outlook 2010
  • Customizing Outlook 2010 and Managing Accounts
  • Data Files, Archiving, and Send/Receive Groups in Outlook 2010
  • Formatting E-mail and Configuring Message Options in Outlook 2010
  • Implementing Security with Outlook 2010
  • Managing E-mail with Rules, Automatic Replies, and Alerts in Outlook 2010
  • Working with Files and Folders and Using Search and RSS Feeds in Outlook 2010
MICROSOFT® OFFICE 2010: BEGINNING POWERPOINT
  • Getting Started with PowerPoint 2010
  • Adding Images to Presentations in PowerPoint 2010
  • Using Multimedia and Animations in PowerPoint 2010
  • Visually Enhancing PowerPoint 2010 Presentations
MICROSOFT® OFFICE 2010: ADVANCED POWERPOINT
  • Collaborating and Sharing Presentations in PowerPoint 2010
  • Using Advanced Slide Show Tools in PowerPoint 2010
MICROSOFT® OFFICE 2010: BEGINNING WORD
  • Getting Started with Word 2010
  • Customizing the Behavior and Appearance of Word 2010
  • Drawing and Inserting Graphics in Word 2010
  • Formatting and Working with Text in Word 2010
  • Moving Around in Word 2010
  • Organizing and Arranging Text in Word 2010
  • Reviewing Documents in Word 2010
  • Saving, Sharing, and Printing in Word 2010
  • Structuring Word 2010 Documents
MICROSOFT® OFFICE 2010: ADVANCED WORD
  • Adding Tables of Contents, Footnotes, Hyperlinks, and Bookmarks in Word 2010
  • Creating and Formatting Tables in Word 2010
  • Embedding Charts and Tables into Word 2010
  • Forms, Fields, and Mail Merge in Word 2010
  • Managing, Inspecting, and Recovering Word 2010 Documents
  • Manipulating Tables in Word 2010
  • Using Themes, Backgrounds, Watermarks, and Quick Parts in Word 2010
    The Nebraska Bankers Association is a Local ABA Training Provider.
    For More Information Contact:

    Joanne Smith
    Education and Member Information Coordinator

Nebraska Bankers Association / 233 South 13th Street, Suite 700 / PO Box 80008 / Lincoln, NE 68501-0008