The Ultimate Microsoft Office 2010 Training Bundle 48 Hours

Learn to create and refine charts in Excel 2010 by using select data, switch rows and columns, edit series, choose chart types and layouts, and apply themes.

Learn to reveal complex trends in quarterly sales by using line charts, trend lines, and moving averages, and to refine chart titles and axes for clarity.

Create a live percent-change chart in Excel 2010 that tracks FTSE 100 and Dow Jones via Yahoo Finance. Enable one-minute refresh and keep the data hidden for a clean dashboard.

Unlock powerful data analysis with pivot tables and pivot charts in Excel 2010 by converting data to a table, selecting fields, applying filters, and adjusting value settings.

Explore Excel 2010 pivot tables and charts by using slicers to filter data, adjusting groupings, and creating calculated fields to enhance analysis.

Explore Excel 2010 graphics tools, from drawing shapes and smart art to formatting, resizing, and aligning graphics that float over worksheets, using keyboard constraints and customization.

Learn to present sales data in Excel 2010 using SmartArt graphics, convert to shapes for live progress indicators toward monthly targets, and prepare visuals for transfer to Word.

Start Word 2010 from the start menu or desktop shortcut, then explore the Word window, ribbons, Quick Access Toolbar, and Backstage view for recent documents and view modes.

Explore the word workspace basics, including dialog boxes, font options, and navigation shortcuts. Learn backstage view to manage files, printing, sharing, and word options in word 2010.

Master text editing in Word 2010 by selecting text, using copy and paste, performing cuts, undoing mistakes, and dragging and dropping paragraphs with keyboard shortcuts and the clipboard.

Master paragraph formatting in the home tab by adjusting alignment (left, right, center, justify), line spacing via the ruler, margins, indents, and tab stops for selected paragraphs.

Learn to insert and edit charts in Word with the insert chart tool and Excel data, switch chart types, apply styles, save templates, and delete charts.

Explore desktop publishing in Word to blend text, graphics and effects, mastering drop caps, watermarks, borders, shading, and page color for professional, publication-ready documents.

Learn to insert and resize shapes in Word, maintain proportions with corner handles, use the shift key for circles or squares, add text, rotate, and apply fills and effects.

Master mail merge in Word 2010 using the wizard, from preparing Excel data to selecting recipients, inserting address blocks, and previewing personalized letters.

Set up and run a manual mail merge in Word to create personalized letters and labels from CSV or Outlook data, preview results, and print or email.

Keep Word 2010 up to date by checking updates, use autosave and auto recover, compare versions, recover unsaved documents, start in safe mode, and repair Office installations.

Explore Outlook 2010 on Windows 7, including the ribbon, navigation pane, and reading pane, and learn to compose, send, and manage emails with inbox and sent items.

Navigate Outlook 2010's calendar, contacts, tasks, notes, and journal to manage appointments, invites, and reminders. Create and view entries, customize contact views, and log activities across modules.

Use the to-do bar in outlook 2010 to manage appointments, tasks, and flagged emails, customize categories, and adjust display options such as months shown and date navigator.

Explore Outlook 2010 journal feature, enabling automatic or manual entries for emails, meeting requests, and tasks; view timelines and lists, and learn to drag appointments into the journal.

Explore formatting email messages in Outlook 2010, comparing plain text, rich text, and HTML; apply themes and styles, attach files, add signatures, run spell check, and save drafts.

Explore Outlook 2010 general mail options, including composing messages, spell check, signatures, stationery and fonts, desktop alerts, conversations, replies and forwards, drafts, recipient checking, and high or low importance flags.

Learn how to create and assign tasks in Outlook, set start and due dates, priorities, and progress, and complete or forward tasks while tracking status and using task views.

discover how rss, or really simple syndication, provides a standard format to access content from podcasts, blogs, and social media, and how to set up rss feeds in outlook.

Explore PowerPoint 2010 basics by navigating the PowerPoint window, the ribbon, and the backstage, learning to start, open, save, close, and configure options, and review available views.

Explore the PowerPoint 2010 window, including the slide pane, outline pane, ribbon, quick access toolbar, and bottom controls, and learn to manage slides, outlines, views, themes, and zoom.

Explore the PowerPoint 2010 ribbon organization, including default and contextual tabs and tab groups, and the backstage file tab. Learn how selection activates font, paragraph, and design commands.

Learn how templates control PowerPoint themes, colors, fonts, and effects, and how to save, apply, and test custom themes across slides using the design tab and slide show view.

Explore beyond the basics by adding hyperlinks, clip art, screenshots, and multimedia in PowerPoint 2010, then apply animation, transitions, compare and merge presentations, and share with other Office 2010 apps.

Master animation in slides by applying entrance, emphasis, exit, and motion path effects with precise timing, sequencing, on-click triggers, and animation pane controls.

Explore PowerPoint transitions, including slide motions, direction, speed, and optional sounds. Apply transitions globally or per slide, manage hidden slides, and preview in slide sorter view.

Master PowerPoint basics by creating notes, handouts, and printing slides, and by building automated or self-running shows, while learning to annotate during presentations.

Create customized PowerPoint handouts that accompany presentations, offering one to nine slides per page or electronic pre-distribution, with flexible headers, footers, and print options.

Learn how effective presentations reduce misunderstanding and audience resistance, reinforce key ideas, and keep attention, while PowerPoint supports the verbal message with visual emphasis; avoiding death by PowerPoint through planning.

Discover ways to start Access 2010, access help and training, and work with four views—form view, datasheet view, layout view, and design view—while saving North Wind databases and templates.

Explore the basics of databases with the North Wind Traders example, defining databases as structured records and fields and reviewing core objects like tables, forms, queries, and reports.

Build a private tutor database by creating tables for students and invoices with primary keys and auto numbers. Establish a one-to-many relationship with referential integrity to link invoices to students.

Create a tasks table with Access 2010 application parts and QuickStart, link it to students, and import courses from Excel as a table with course code as primary key.

Improve the look, feel, and usability of forms by editing subforms in design and layout views, resizing and rearranging fields, removing layouts, and applying Office 2010 themes.

Learn how to add an existing field to a subform, manage a width of 19 centimeters, and align the new priority field with proper tab order in design view.

Develop an advanced report for the private duty database that lists each student and their tasks, with fields from the student and tasks tables, sorted by due date and priority.

Master select queries in Access 2010 to filter, sort, and summarize invoices, apply defined criteria, and join tables to display related student names with the invoice details.

Explore inner and outer joins in Access, create make table queries to generate overdue invoice tables, and perform a mail merge with Word for automated reminders.

Explore Access 2010 security features, including password protection, database encryption, exclusive access, and user restrictions via VBA and the ribbon. Learn how to enforce modal login and log user activity.

Explore how to work with Access 2010 tables, including field names, data types, and properties, and learn about primary keys, field sizes, validations, and input masks.

Discover how to set and use field properties in Access 2010, focusing on format and input mask to control data display, validation, and data entry across tables and forms.

Explore data normalization in Access 2010 by transforming a students courses table into first, second, and third normal forms, using primary and foreign keys to link student and course data.

Explore datasheet view to enter and manage student data and guardians, applying quick sorts, advanced filters, and column customization with alternate row colors and grid lines.

Explore creating and working with forms in Access 2010, including datasheet view and form interfaces, form wizard, blank form, form design, navigation and split forms, and form properties.

Learn to improve a student database using VBA by creating an about form with licensee, version, and copyright stored in table, adding a VBA close button, and introducing switchboard navigation.

Explore security techniques for access databases, including active format and runtime mode, encrypting with password, and protecting forms, tables, and VBA code for a secure student database.

Learn to import data from Excel, text, and XML into Access 2010 and to link to external sources, plus export data to XML.

Link data in Access 2010 by connecting to Excel workbooks and other databases, distinguishing linking from importing, and using the linked table manager to keep data synchronized and break links.

Examine advanced Access 2010 report features, focusing on grouping and sorting, including first-character alphabetical grouping, custom character options, and totals in address book and level-based reports.