Social Media Marketing for Dummies

Office 2010 For Dummies, Basics and Advanced

36 Chapters         443 Videos
$99.99 $89.99
  • Table of Contents
  • Course Details
  • Introducing Office
    Starting and Exiting an Office 2010 Application
    Familiarizing Yourself with the Office Interface
    Creating Your First Documents
    Changing the Onscreen View
    Saving and Opening Documents
    Lesson Summary
  • Creating a Word Document
    Starting a New Word Document
    Setting Page Margins, Size, and Orientation
    Adding New Text
    Selecting Text
    Formatting Text
    Checking Spelling and Grammar
    Printing Your Work
    Lesson Summary
  • Applying Paragraph Formatting
    Formatting Paragraphs
    Creating Bulleted and Numbered Lists
    Lesson Summary
  • Inserting and Formatting Graphics
    Inserting Clip Art
    Inserting Photos from Files
    Managing Image Size and Placement
    Lesson Summary
  • Creating Basic Worksheets
    Seeing How Worksheets Work
    Typing and Editing Cell Content
    Changing the Worksheet Structure
    Working with Excel Workbooks
    Lesson Summary
  • Creating Formulas and Functions
    Using Formulas for Calculation
    Figuring Out Functions
    Moving and Copying Formulas
    Lesson Summary
  • Applying Worksheet Formatting
    Adjusting Rows and Columns
    Formatting Cells
    Formatting Cell Contents
    Formatting an Entire Worksheet
    Lesson Summary
  • Managing E-Mail and Outlook
    Introducing Microsoft Outlook
    Setting Up Outlook for E-Mail
    Receiving and Reading Your Mail
    Composing and Sending E-Mail
    Managing Incoming Mail
    Lesson Summary
  • Using Contacts and Tasks
    Storing Contact Information
    Putting Contact Information to Good Use
    Using Tasks and the To-Do List
    Lesson Summary
  • Managing Your Calendar
    Introducing the Calendar
    Creating and Editing Calendar Appointments and Events
    Lesson Summary
  • Getting Started with PowerPoint
    Exploring the PowerPoint Interface
    Starting a New Presentation
    Creating New Slides
    Adding Text to a Slide
    Manipulating Slide Content
    Lesson Summary
  • Formatting a Presentation
    Understanding and Applying Themes
    Formatting Text Boxes and Placeholders
    Lesson Summary
  • Adding Graphics and SmartArt to a Presentation
    Inserting Graphics
    Creating SmartArt
    Lesson Summary
  • Adding Movement and Sound to a Presentation
    Adding Slide Transition Effects
    Animating Objects
    Inserting Sounds and Videos
    Lesson Summary
  • Presenting a Slide Show
    Displaying a Slide Show Onscreen
    Working with Handouts
    Lesson Summary
  • Excel 2010 For Dummies, Advanced
    Excel 2010 For Dummies, Advanced
  • Creating and Formatting Charts
    Creating a Basic Chart
    Changing a Chart
    Adding and Positioning Chart Elements
    Formatting a Chart
  • Presenting Data Clearly
    Working with Advanced Number Formatting
    Taking Advantage of Conditional Formatting
    Customizing Themes and Table Styles
    Creating Advanced Charts
  • Exploring financial Functions
    Using Common Financial Functions
    Analyzing Financial Data
    Creating Scenarios
  • Working with Math, Statistical, and Text Functions
    Mastering Math and Trig Functions
    Mastering Statistical Functions
    Managing Data with Text Functions
  • Storing and Managing Databases
    Introducing Databases
    Working with Tables in Excel
    Merging and Splitting Data
  • Working with PivotTables and PivotCharts
    Creating a PivotTable
    Sorting and Filtering PivotTable Data
    Creating a PivotChart
  • Correcting, Protecting, and Sharing Data
    Finding and Fixing Errors in Formulas
    Validating Data
    Protecting Ranges
    Securing Workbooks
    Tracking Changes in a Shared Workbook
  • Word 2010 For Dummies, Advanced
    Word 2010 For Dummies, Advanced
  • Working with Styles and Templates
    Applying Styles
    Modifying and Creating Templates
  • Adjusting Advanced Typesetting Options
    Adjusting Text Scale and Spacing
    Enabling Kerning
    Creating Custom Superscript and Subscript Fonts
    Controlling OpenType Fonts Options
  • Creating and Formatting Tables
    Creating a Table
    Formatting a Table
  • Advanced Graphics
    Modifying a Picture You have Placed
    Drawing Lines and Shapes
  • Working with Pages, Sections, and Columns
    Applying Page Formatting
    Using Headers and Footers
    Working with Multi-Section Documents
    Preparing Professional Reports
    Captioning and Organizing Figures
    Organizing Legal Documents
    Creating Footnotes and Endnotes
    Creating a Table of Contents
  • Managing Correspondence
    Creating and Printing Envelopes
    Adding an envelope to a document file
    Changing the envelope size
    Printing an envelope
    Printing your own envelope
    Performing a Mail Merge
  • Sharing Your Work with Others
    Tracking Document Changes
    Working with Document Comments
  • Course Assessments
    Course Assessments
  • Starting, navigating, and exiting Office 2010 applications
  • Managing e-mail, contacts, tasks, and calendars with Outlook
  • Building and formatting a PowerPoint presentation with graphics, movement, and sound
  • Using Word styles and templates to enhance documents and save time
  • Tips for printing envelopes and performing a mail merge
  • Applying Excel's tools for sophisticated data analysis
  • Tackling common financial chores such as calculating loan payments and interest
  • . . . and much more!


In this course, you'll learn the basics of the Office 2010 interface, how to navigate it, and how to use the features common to all Office programs. After studying the basics of Word, Excel, PowerPoint, and Outlook, you'll move to more advanced Excel and Word skills, including how to apply page and section formatting and prepare professional reports in Word or work with PivotTables and PivotCharts in Excel.

In each lesson, you'll find clear, expert instruction, interactive questions or hands-on activities, summaries, and a way to review topics so you CAD ensure that you have mastered each skill.