The Ultimate Microsoft Office 2010 Training Bundle 48 Hours

Create and customize charts in Excel 2010, selecting contiguous or non-contiguous data and choosing 3D cylinder or pie chart types. Move charts, set defaults, and use F1 shortcuts to insert.

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.

Analyze how to format axes and grid lines in Excel 2010 charts, covering primary horizontal and vertical axes, tick marks, labels, display units, and major and minor grid lines.

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.

Learn to use bar charts to compare values and reveal differences between entities, including single and double bars, sorting data, reversing axis, and 2d and 3d bar charts.

Explore relationships using scatter charts and trend lines in Excel 2010, linking inquiries to season and to policies sold, and forecast outcomes with the trend line equation and R-squared.

Learn to present relationships with charts in Excel, using stacked bar charts with negative values, bubble charts for three variables, and radar charts to compare targets and scores.

Learn to chart financial data in Excel 2010 by plotting adjusted closing prices, adding a secondary volume axis, and combining line and column charts for clear visual analysis.

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.

Explore sparklines in Excel 2010 to visualize trends with line, column, and win/loss sparklines, manage grouped data, customize axes, and embed labels in cells.

Discover how to use data bars, color scales, and icon sets in Excel 2010 to visualize numbers, manage conditional formatting rules, and compare data across rivers, sales, and months.

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.

Explore exporting charts from Excel to Word or PowerPoint, weighing linking versus embedding, and using web publishing and formats like PNG, PDF, and XPS.

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.

Learn to customize the word workspace using the status bar and quick access toolbar, explore split views and zoom, and access online help.

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.

Create and customize Word 2010 documents using backstage view, templates, and new from existing options, then tailor page setup, including size, orientation, margins, and columns, and manage document properties.

Learn to manage formats across versions, open and save in backstage view, convert older documents to the format with save as, and use the document inspector to check for issues.

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.

Edit with ease in Word 2010 by deleting characters, using Ctrl shortcuts to remove words, toggling insert versus overtype mode, and using the navigation pane to find and replace.

Learn practical text formatting by selecting fonts, adjusting sizes, and applying bold, italic, underline, and color, plus using the font dialog and mini toolbar for quick edits.

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.

Explore using bullets, numbering, and multilevel lists to structure information. Apply borders and shading through the borders and shading dialog to enhance Word 2010 documents.

Learn how to create new paragraph styles, apply them across a document, modify and delete styles, use quick styles and the style inspector to reveal formatting.

Insert graphics and format pictures in Word 2010, using clipart or your own photos, resize, wrap text, and adjust layout for precise positioning.

Utilize picture tools in Word 2010 to apply styles, effects, and layouts to images. Adjust corrections, color, and artistic effects, and crop, crop to shape, remove background, and rotate options.

Master inserting screenshots and screen clipping in Word 2010 to capture full or partial screen images, then create stylized text with WordArt and its effects.

Create clear diagrams with smart art in Word 2007+, selecting categories, entering text, and formatting with smart art styles. Build an organization chart and adjust layouts using smart art tools.

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.

Expand and collapse sections in a master document using outline view and section breaks, then insert subdocuments and manage document properties and cover pages.

Learn to insert and customize a table of contents in Word 2010, apply levels and tab leaders, and use header and footer tools with quick parts and document properties.

Learn to insert symbols and equations in Word 2010, using auto correct, shortcuts, and building blocks to add auto text, quick parts, and dynamic content like text boxes.

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.

Learn how to perform spelling and grammar checks in Word 2010, manage proofing options, use the custom dictionary, and apply ignore and auto correct rules for accurate documents.

Publish Word documents to the web by saving as html or single-file web pages, preview in a browser, and access or edit pages within Word.

Discover how to collaborate in Word 2010 by creating and navigating comments, changing user identity, and tracking edits with accept/reject changes and show mark-up controls.

Explore how to customize Word 2010 settings to suit your workflow, including live preview, toolbars, display of formatting marks, auto recover, language options, and ribbon customization.

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.

Invite learners to leave a five-star review if they gain value, share feedback to improve training material, and feel free to update the review later.

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.

Create, edit, and forward notes in Outlook 2010. Explore notes in the notes module with icon view, list view, and last seven days view, and use search and categorization.

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.

Learn to customize Outlook 2010 workspace views, including list and table views, by adding and resizing columns, sorting by multiple fields, and removing grouping for clearer contact and calendar layouts.

Navigate Outlook data files and folders in backstage view, learn locations for inbox, sent items, deleted items, and junk mail, and create custom folders for centralized storage.

Explore how the Outlook Connector synchronizes a Windows Live Hotmail account with Outlook, merging email and contacts across local data files, while organizing with folders and the reading pane.

Learn to automate Outlook 2010 emails by creating rules for sent and received messages, moving items to folders, flagging with alerts, and configuring send and receive schedules.

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.

Learn to forward and share contact details as business cards or vcards, customize business cards, create and manage contact groups, and print individual or full contact lists in various layouts.

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.

Organize RSS feeds with folders and mark items as read, then subscribe to YouTube feeds and connect contacts through Outlook 2010's social connector for LinkedIn and Facebook.

Back up Outlook data files regularly by copying them when Outlook is closed, and protect with antivirus, optional password, and encrypted email using digital IDs along with Exchange offline features.

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.

Learn how to start PowerPoint 2010 using desktop icons, start menu, or double-clicking files, and how to exit with save prompts and cancel options.

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.

Explore PowerPoint 2010 options in the backstage, learn how nine general categories influence current and future presentations, and review key settings like color scheme, proofing, and embedded fonts.

Learn to navigate, insert, move, duplicate, and reuse slides from other presentations using the slide sorter and normal view, while managing source formatting and the slide master.

Learn to insert and draw shapes in PowerPoint, combine simple shapes into complex forms, and place text and word art inside them for dynamic slides.

Learn to create, insert, and manage tables in PowerPoint slides. Configure rows and columns, merge cells, and apply borders, shading, and table styles for a professional look.

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.

Learn to use predefined and custom templates in PowerPoint 2010, apply them to new or existing presentations, and edit slide masters and layout masters.

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.

Learn to create and manage PowerPoint hyperlinks to websites, files, emails, and other presentations, with security prompts, text links, and hidden-slide navigation via action buttons.

Learn to insert and control audio and video in PowerPoint presentations, including clip art audio, file audio, full-screen video, playback options, trimming, fading, looping, and slide-triggered playback.

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.

compare two versions of the same presentation, designate a final version, and merge changes using outline mode, comments, and review features to streamline editing.

Discover how to share content across Office 2010 apps using a shared clipboard, embed Excel objects in PowerPoint, and convert Word outlines into slides.

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

Use PowerPoint 2010 notes to add slide scripts beneath slides; print them as handouts. Format notes with the notes master, add headers and footers, use presenter view with dual monitors.

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.

Print your PowerPoint with flexible options, including hidden slides, outline view, notes or handouts, headers and footers, and color, grayscale, or black and white printing.

Annotate slides in PowerPoint 2010 during presentation using pen and highlighter, adjust ink colors and laser pointer, and decide to keep or discard annotations after the slideshow.

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.

Explore how to design and build a database using the North Wind Traders example, identifying tables, primary keys, and foreign keys to establish relational structure.

Learn to create a blank Access 2010 database, build a private tutor database from scratch, and explore templates like North Wind to manage students, courses, exams, and billing.

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.

Explore how to design and manage fields in Microsoft Access tables, including adding, renaming, deleting, and rearranging fields, selecting data types, and using datasheet views with captions and descriptions.

Explore table and field properties in Access 2010, including text and date/time data types, field size, captions, validation, indexing, input masks, and the lookup wizard with examples.

Learn to create and customize forms in Access using the form wizard, blank form, datasheet form, multiple items form, and split form, plus subforms and design and layout view.

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.

Explore the expression builder in Access 2010 to perform calculations, comparisons, and data validation with built-in date and time functions like now, and set a 30-day default for invoice dates.

Apply conditional formatting on Access 2010 forms and reports to flag upcoming due dates. Build calculated controls to implement a 10 percent prepaid discount with currency formatting.

Learn how to sort and filter data in form view and use multi-field filters in the North Wind database. Master find and replace in forms for safe, targeted updates.

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.

Add existing fields in design view, adjust borders, and use print preview; group by instrument and sort by course code, then export or email reports in PDF or Excel.

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.

Discover how the auto exec macro runs on opening an Access 2010 database, opening forms like student list or guardian list, and controlling startup options via a settings table.

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.

Master advanced access 2010 queries by nesting if statements, using inner, left, and right joins, and creating sub-queries that combine student and attendance data for reporting.

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.

Master the student list form in a Microsoft Access 2010 database, using open and new actions, a macro-driven workflow, and requery to view or add student details.

Explore the NZ function for view or add modes and duplicate checks, and review key Access 2010 commands like close, save and new, Outlook contact, and attachments on the form.

Discover how to enhance Access 2010 forms with VBA and macros, including guardian details and guardian list forms, plus search and filter features and a splash screen.

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.

Learn how to structure VBA code, organize into modules, and build a switchboard by wiring exit and open form commands, using string variables, dim, and option explicit.

Master VBA basics: manage variable scope with public and private declarations, implement runtime error handling with on error goto and message boxes, and control flow with if statements.

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.

Explore how to configure multiuser access in Access 2010, balancing data safety and usability by choosing shared open mode, locking strategies, and performance settings like refresh intervals and update retries.

Explore advanced report features in Access 2010, including grouping and sorting with group sort and total, handling emergency contact information and guardian details for each student.

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.

Explore Copilot in Excel, Word, and PowerPoint, compare Copilot for Bing, Copilot Pro, and Copilot for Microsoft 365, and learn licensing, OneDrive, autosave, and hands-on demos.