Showing all 15 results

50532 Learn Microsoft Access 2010 Step-by-Step, Level 1

30,00 
After completing this course, students will be able to:
  • Work in Access 2010.
  • Understand database concepts.
  • Explore tables.
  • Explore forms.
  • Explore queries.
  • Explore reports.
  • Preview and print Access objects.
  • Create databases from templates.
  • Create databases and tables manually.
  • Manipulate table columns and rows.
  • Refine table structure.
  • Create relationships between tables.
  • Create forms by using the Form tool.
  • Change the look of forms.
  • Change the arrangement of forms.
  • Sort information in tables.
  • Filter information in tables.
  • Filter information by using forms.
  • Locate information that matches multiple criteria.
  • Create reports by using a wizard.
  • Modify report design.
  • Preview and print reports.

50533 Learn Microsoft Access 2010 Step-by-Step, Level 2

30,00 
After completing this course, students will be able to:
  • Restrict the type of data.
  • Restrict the amount of data.
  • Restrict the format of data.
  • Restrict data by using validation rules.
  • Restrict data to values in lists.
  • Restrict data to values in other tables.
  • Modify forms created by using a wizard.
  • Add controls.
  • Add subforms.
  • Use e-mail forms to collect data.
  • Create queries by using a wizard.
  • Create queries manually.
  • Use queries to summarize data.
  • Use queries to perform calculations.
  • Use queries to update records.
  • Use queries to delete records.
  • Create reports manually.
  • Modify report content.
  • Add subreports.

50534 Learn Microsoft Access 2010 Step-by-Step, Level 3

30,00 
After completing this course, students will be able to:
  • Import information.
  • Export information.
  • Copy to and from other Office programs.
  • Create navigation forms.
  • Create custom categories.
  • Control which features are available.
  • Assign passwords to databases
  • Split databases.
  • Secure databases for distribution.
  • Prevent database problems.
  • Change default program options.
  • Customize the ribbon.
  • Customize the Quick Access Toolbar.

50544 Learn Microsoft Excel 2010 Step-by-Step, Level 1

30,00 
After completing this course, students will be able to:
  • Create workbooks.
  • Modify workbook content.
  • Modify worksheet content.
  • Zoom in on a worksheet.
  • Arrange multiple workbook windows.
  • Add buttons to the Quick Access Toolbar.
  • Customize the ribbon.
  • Maximize usable space in the program window.
  • Enter and revise data.
  • Move data within a workbook.
  • Find and replace data.
  • Correct and expand upon worksheet data.
  • Define Excel tables.
  • Format cells.
  • Apply workbook themes and Excel table styles.
  • Add images to worksheets.
  • Add headers and footers to printed pages.
  • Prepare worksheets for printing.
  • Print worksheets.
  • Print parts of worksheets.
  • Print charts.

50545 Learn Microsoft Excel 2010 Step-by-Step, Level 2

30,00 
After completing this course, students will be able to:
  • Name groups of data.
  • Create formulas to calculate values.
  • Summarize data that meets specific conditions.
  • Find and correct errors in calculations.
  • Define styles.
  • Make numbers easier to read.
  • Change the appearance of data based on its value.
  • Limit data that appears on your screen.
  • Manipulate worksheet data.
  • Define valid sets of values for ranges of cells.
  • Sort worksheet data.
  • Organize data into levels.
  • Look up information in a worksheet.
  • Use workbooks as templates for other workbooks.
  • Link to data in other worksheets and workbooks.
  • Consolidate multiple sets of data into a single workbook.
  • Group multiple sets of data.

50546 Learn Microsoft Excel 2010 Step-by-Step, Level 3

30,00 
After completing this course, students will be able to:
  • Define an alternative data set.
  • Define multiple alternative data sets.
  • Vary your data to get a desired result by using Goal Seek.
  • Find optimal solutions by using Solver.
  • Analyze data by using descriptive statistics.
  • Analyze data dynamically by using PivotTables.
  • Filter, show, and hide PivotTable data.
  • Edit PivotTables.
  • Format PivotTables.
  • Create PivotTables from external data.
  • Create charts.
  • Customize the appearance of charts.
  • Find trends in your data.
  • Summarize your data by using sparklines.
  • Create dynamic charts by using PivotCharts.
  • Create diagrams by using SmartArt.
  • Create shapes and mathematical equations.
  • Enable and examine macros.
  • Create and modify macros.
  • Run macros when a button is clicked.
  • Run macros when a workbook is opened.
  • Include Office documents in workbooks.
  • Store workbooks as parts of other Office documents.
  • Create hyperlinks.
  • Paste charts into other documents.
  • Share workbooks.
  • Manage comments.
  • Track and manage colleagues’ changes.
  • Protect workbooks and worksheets.
  • Authenticate workbooks.
  • Save workbooks for the Web.

50535 Learn Microsoft Outlook 2010 Step by Step, Level 1

30,00 
After completing this course, students will be able to:
  • Connect to e-mail accounts.
  • Troubleshoot connection problems.
  • Work in the Outlook program window.
  • Work with the ribbon and the Backstage view.
  • Work in the Mail module.
  • Work in the Calendar module.
  • Work in the Contacts module.
  • Work in the Tasks module.
  • Create and send messages.
  • Attach files to messages.
  • View messages and message attachments.
  • Configure Reading Pane behavior.
  • View message participant information.
  • Respond to messages.
  • Save and update contact information.
  • Communicate with contacts.
  • Display different views of contact records.
  • Print contact records.
  • Schedule and change appointments.
  • Schedule and change events.
  • Schedule meetings.
  • Respond to meeting requests.
  • Display different views of a calendar.
  • Create tasks.
  • Update tasks.
  • Remove tasks and items from task lists.
  • Manage task assignments.
  • Display different views of tasks.

50536 Learn Microsoft Outlook 2010 Step by Step, Level 2

30,00 
After completing this course, students will be able to:
  • Work with Conversation view.
  • Arrange messages in different ways.
  • Organize Outlook items by using color categories.
  • Organize messages in folders.
  • Manage messages by using Quick Steps.
  • Quickly locate messages.
  • Print messages.
  • Delete messages.
  • Define your available time.
  • Configure time zones.
  • Work with multiple calendars.
  • Share calendar information.
  • Print a calendar.
  • Create additional address books.
  • Import and export contact records.
  • Create contact groups.
  • Quickly locate contact information.
  • Personalize electronic business cards.
  • Personalize the appearance of message text.
  • Embed and modify images.
  • Create and format business graphics.
  • Change message settings and delivery options.

50537 Learn Microsoft Outlook 2010 Step by Step, Level 3

30,00 
After completing this course, students will be able to:
  • Work with new mail notifications.
  • Create rules to process messages.
  • Block unwanted messages.
  • Secure your e-mail.
  • Work with Outlook items while offline.
  • Manage download options for slow connections.
  • Automatically reply to messages.
  • Work with SharePoint site content.
  • Personalize the Outlook program window.
  • Create and manage Quick Steps.
  • Customize the ribbon.
  • Customize the Quick Access Toolbar.
  • Personalize your Office and Outlook settings.

50538 Learn Microsoft PowerPoint 2010 Step by Step, Level 1

30,00 
After completing this course, students will be able to:
  • Work in the user interface.
  • Create and save presentations.
  • Open, move around in, and close presentations.
  • View presentations in different ways.
  • Add and delete slides.
  • Add slides with ready-made content.
  • Divide presentations into sections.
  • Rearrange slides and sections.
  • Enter text in placeholders.
  • Add text boxes.
  • Edit text.
  • Correct and size text while typing.
  • Check spelling and choose the best words.
  • Find and replace text and fonts.
  • Apply themes.
  • Use different color and font schemes.
  • Change the slide background.
  • Change the look of placeholders.
  • Change the alignments, spacing, size, and look of text.
  • Insert pictures and clip art images..
  • Insert diagrams.
  • Insert charts.
  • Draw shapes.
  • Add transitions.
  • Set up presentations for delivery.
  • Preview and print presentations.
  • Prepare speaker notes and handouts.
  • Finalize presentations.
  • Deliver presentations.

50539 Learn Microsoft PowerPoint 2010 Step by Step, Level 2

30,00 
After completing this course, students will be able to:
  • Insert tables.
  • Format tables.
  • Insert and update Excel worksheets.
  • Edit pictures.
  • Customize diagrams.
  • Format charts.
  • Arrange graphics.
  • Add WordArt text.
  • Insert symbols and equations.
  • Insert screen clippings.
  • Create hyperlinks.
  • Attach actions to text or objects.
  • Use ready-made animations.
  • Customize animation effects.
  • Insert and play sounds.
  • Insert and play videos.

50540 Learn Microsoft PowerPoint 2010 Step by Step, Level 3

30,00 
After completing this course, students will be able to:
  • Collaborate with other people.
  • Save presentations in other formats.
  • Send presentations directly from PowerPoint.
  • Password-protect presentations.
  • Add and review comments.
  • Merge presentation versions.
  • Create theme colors and fonts.
  • View and change slide masters.
  • Create slide layouts.
  • Save custom design templates.
  • Adapt presentations for different audiences.
  • Rehearse presentations.
  • Prepare presentations for travel.
  • Save presentations as videos.
  • Change default program options.
  • Customize the ribbon.
  • Customize the Quick Access Toolbar.

50541 Learn Microsoft Word 2010 Step by Step, Level 1

30,00 
After completing this course, students will be able to:
  • Work in the user interface.
  • Create, enter text in, and save documents.
  • Open, move around in, and close documents.
  • View documents in different ways.
  • Make text changes.
  • Find and replace text.
  • Fine-tune text.
  • Correct spelling and grammatical errors.
  • Insert saved text.
  • Quickly format text.
  • Change a document’s theme.
  • Manually change the look of characters.
  • Manually change the look of paragraphs.
  • Create and modify lists.
  • Present information in columns.
  • Create tabbed lists.
  • Present information in tables.
  • Format tables.
  • Insert and modify pictures.
  • Change a document’s background.
  • Insert building blocks.
  • Add WordArt text.
  • Preview and adjust page layout.
  • Control what appears on each page.
  • Print documents.
  • Prepare documents for electronic distribution.

50542 Learn Microsoft Word 2010 Step by Step, Level 2

30,00 
After completing this course, students will be able to:
  • Create diagrams.
  • Modify diagrams.
  • Create picture diagrams.
  • Insert charts.
  • Modify charts.
  • Use existing data in charts.
  • Add watermarks.
  • Insert symbols and equations.
  • Draw and modify shapes.
  • Insert screen clippings.
  • Reorganize document outlines.
  • Arrange objects on the page.
  • Use tables to control page layout.
  • Save files in different formats.
  • Create and modify Web documents.
  • Create and publish blog posts.

50543 Learn Microsoft Word 2010 Step by Step, Level 3

30,00 
After completing this course, students will be able to:
  • Add hyperlinks.
  • Insert fields.
  • Add bookmarks and cross-references.
  • Create and modify tables of contents.
  • Create and modify indexes.
  • Add sources and compile bibliographies.
  • Understand mail merge.
  • Prepare data sources.
  • Prepare main documents.
  • Merge main documents and data sources.
  • Send personalized e-mail messages to multiple recipients.
  • Create and print labels.
  • Co-author documents.
  • Send documents directly from Word.
  • Add and review comments.
  • Track and manage document changes.
  • Compare and merge documents.
  • Password-protect documents.
  • Control changes.
  • Work with styles and templates.
  • Change default program options.
  • Customize the ribbon.
  • Customize the Quick Access Toolbar.