Ardito Computer Training

Course Description

In this course, you will work with the new and improved features in Office 2010.

Prerequisites
Basic knowledge of earlier versions of Microsoft Office suite of products (Excel, PowerPoint, Word, Access, and Outlook).

Who Should Take This Course
Users with prior experience of previous versions of Microsoft Office suite who want to know the new features of Office 2010.

Course Objectives

Upon completing this course, you will have learned how to:

1. Explore the various features across all the Microsoft® Office suite applications.
2. Create professional looking documents using Microsoft® Office Word® 2010.
3. Enhance your spreadsheets using Microsoft® Office Excel® 2010.
4. Create dynamic presentations using Microsoft® Office PowerPoint® 2010.
5. Familiarize yourself with the new features in Microsoft® Office Outlook® 2010.
6. Finalize files in Microsoft® Office 2010. 

Course Outline

I.    What’s new in Office 2010

• Customise the Ribbon
• Tabs - Groups - Commands
• Reset the Ribbon
• Export a customised ribbon
• Import a customised ribbon
• Using and Customising the Quick Access Toolbar
• Microsoft Office Backstage view

II.  What’s new in EXCEL 2010

• Make fast, effective comparisons from lists of data
• Sparklines
• Use slicers to filter PivotTable data
• Improved conditional formatting
• Create workbooks with more visual impact
• Excel 2010 Extras

III.  What’s new in WORD 2010

• Compare An Earlier Version Of Your File With The Current Version
• Work more effectively and get more done
• Document Navigation pane and Search
• Add artistic effects to your images
• New SmartArt graphic picture layouts
• Work with others with confidence
• Go beyond documents
• Avoid losing work

IV. What’s new in POWERPOINT 2010

• Organize your slides into sections
• Enrich your presentations with video, picture, and animations
• Trim an Audio or Video clip
• Apply artistic textures and effects to your pictures
• Remove the background and other unwanted portions of a picture
• Crop your pictures with more precision
• Use transitions with 3-D motion graphic effects
• Add a screenshot to a slide
• Deliver and share your presentations more effectively
• Identify and resolve accessibility issues

V. What’s New in OUTLOOK 2010

• Outlook now has the ribbon
• See more of your messages
• Process and file your messages faster
• Respond to an e-mail message with a meeting request
• Instant Search
• Clean Up Quicker
• Work smarter and more efficiently with messages
• Get the calendar big picture
• Stay on top of your tasks
• Additional improvements

VI.  What’s New in Access 2010

• New user interface
• Enhanced security

Course Description

The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™. This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Course Objectives

Upon completing this course, you will have learned how to:

1. Open an existing database and define database objects.
2. Describe the uses of and ways to execute the Transact-SQL language.
3. Use querying tools.
4. Write SELECT queries to retrieve data.
5. Group and summarise data by using Transact-SQL.
6. Join data from multiple tables.
7. Write queries that retrieve and modify data by using subqueries.
8. Modify data in tables.
9. Query text fields with full-text search.
10. Describe how to create programming objects.
11. Use various techniques when working with complex queries.

Course Outline

1. Getting Started with Databases and Transact-SQL
2. Querying and Filtering Data
3. Grouping and Summarising Data
4. Joining Data from Multiple Tables
5. Working with Subqueries
6. Modifying Data in Tables
7. Querying Metadata, XML, and Full-Text Indexes
8. Using Programming Objects for Data Retrieval
9. Using Advanced Querying Techniques

Course Description

In today's fast-paced world, many people often feel as though they cannot find time to get everything done. In a work-related environment, the ongoing pressure to achieve business goals, as well as the responsibility to meet deadlines, respond to customer demands, and stay ahead of the competition, are common problems. Feeling overwhelmed because of the workload can result in stress and a sense of helplessness. The right time management skills, however, can help you avoid these problems.

Time Management Using Outlook teaches participants to set priorities, which is the first step in learning how to manage time effectively. In addition, participants learn techniques to create a more efficient workplace, including developing strategies for skill improvement with respect to scheduling, analysing, planning, avoiding procrastination, and handling interruptions. Participants will also be exposed to a variety of time management tools, including planners and calendars. In addition, the participants learn the fundamentals of using a computer-based e-mail application (Microsoft Outlook), including managing folders.

Prerequisites
Familiarity with the Windows operating system is essential.

Course Outline

Examining How You Currently Allocate YourTime
Your Week at a Glance

Identifying Individual Time Wasters

• Common Time Wasters
• Time Wasters or Long-Term Investments? Some
• Useful Techniques for Managing Interaction

Prioritising Your Time

• Deciding What Your Priorities Should Be - And
• Why
• Begin with Your Job Description
• Open the Time Window
• Putting Your Money Where Your Time Is
• Making the Match

Analysing, Planning, and Scheduling Your
Time

• Common Analysis and Planning Techniques
• Avoiding Procrastination
• Recognizing the Results of Procrastination

Common Strategies to Avoid Procrastinating

• Managing Interruptions and "Time Wasters"
• Organizing Your Environment

Handling Mail and Memos

• Handling E-Mail
• Handling Interruptions
• Putting Your Phone on Voice Mail

Setting Expectations

• Closing the Door
• Stating the Consequences of Interruptions
• Handling Meetings
• Handling Your Work Environment

Using Time Management Tools

• Introduction to Time Management Tools
• "Sensing" Time
• Planning and Scheduling Strategy
• Monthly Planning and Scheduling
• Weekly Planning and Scheduling
• Daily Planning and Scheduling

Managing Folders and Messages

• Inbox Management
• Views
• Working with Folders

Scheduling Appointments

• Viewing the Calendar
• Changing the Calendar View
• Selecting a Specific Date
• Scheduling an Appointment
• Adding an Appointment
• Creating an Appointment from a Message
• Manipulating Appointments
• Managing Recurring Appointments
• Scheduling Recurring Appointments
• Editing Recurring Appointments
• Scheduling a Meeting and Responding to a
• Meeting Request
• Scheduling Meetings and Events
• Converting an Appointment to a Meeting
• Scheduling a Meeting
• Responding to a Meeting Request
• Checking Responses
• Scheduling Events
• Scheduling an Event
• Printing Your Calendar

Managing Tasks

• Creating and Manipulating Tasks
• Viewing Tasks
• Creating a Task
• Viewing or Changing Existing Tasks
• Copying Tasks
• Creating a Task from a Message
• Tracking the Details of a Task
• Creating a Recurring Task
• Printing Tasks

Managing Contacts

• Creating Contacts
• Viewing Contacts
• Creating a Contact
• Creating a Contact from the Same Company
• Creating a Contact from a Message
• Opening a Contact
• Editing a Contact
• Deleting a Contact
• Tracking Contact Activity
• Viewing Contact Activity