FastTrack Essentials: MS Office 2007
$7.99
Minimum price
$7.99
Suggested price

FastTrack Essentials: MS Office 2007

Hands-on exercises to quickly learn MS PowerPoint 2007, MS Word 2007, and MS Excel 2007

About the Book

About the Author

Table of Contents

  • Front Matter
    • Acknowledgements
  • Creating a Basic MS PowerPoint 2007 Presentation
    • Overview
    • Step 1 – See if there is an appropriate template on your local computer
    • Step 2 – See if there is an appropriate template on Microsoft Online
    • Step 3 – Create a new presentation from scratch and save
    • Step 4 – Import content from Word outline document
    • Step 5 – Insert some slides from another related presentation
    • Step 6 – Try applying the design theme from existing presentation
    • Step 7 – Apply your own theme to the presentation
    • Step 8 – Modifying design
    • Step 9 – Use the slide sorter to change order of presentation
    • Step 10 – Change the layout for some slides
    • Step 11 – Resize a text box window
    • Step 12 – Autofit
    • Step 13 – Add Slide Numbers and Date to footer area
    • Step 14 – Research Creative Commons
    • Step 15 – Start the presentation to see how it looks
    • Step 16 – Inserting a SmartArt diagram that shows evolution of PPT
    • Step 17 – Adding simple animation to Smart Art flowchart showing evolution of MS PPT
    • Step 18 – Insert a contacts slide at the end of the presentation
    • Step 19 – Find the “death by PowerPoint” video on YouTube and watch
    • Step 20 – Insert videos into MS PowerPoint 2007 presentation
    • Step 21 – Insert Pictures
    • Step 22 – Modify the picture on your title slide
    • Step 23 – Modify picture style
    • Step 24 – Insert audio file about MS PowerPoint history to a slide
    • Step 25 – Add new slide with chart showing market penetration of MS PowerPoint
    • Step 26 – Edit text on a slide
    • Step 27 – Add a MS PPT 2003 vs. 2007 slide (use a table for this)
    • Step 28 – Delete a slide
    • Step 29 – Add a comment to one of the slides to remind yourself to tell a joke
    • Step 30 – Insert a footer
    • Step 31 – Insert audio
    • Step 32 – Presenting to two monitors
    • Step 33 – Print preview of MS PowerPoint 2007 presentation
    • Step 34 – Preparing speaker notes for MS PowerPoint 2007 presentation
    • Step 35 – Printing handouts for MS PowerPoint 2007 presentation
    • Step 36 – Save to PDF format
    • Step 37 – Pack MS PowerPoint 2007 presentation to CD
    • Step 38 – Congratulate yourself
    • Step 39 – Using Pointer Pen in MS PowerPoint 2007
    • Step 40 – Prepare MS PowerPoint 2007 presentation for another computer
    • Step 41 – Print MS PowerPoint 2007 presentation as MS Word 2007 outline
    • Step 42 – Add box shape around contact info on contacts slide
    • Step 43 – Add clipart of mailbox to contacts slide
    • Step 44 – Check presentation for spelling mistakes
    • Step 45 – Save final presentation
  • Creating a Self-Running Presentation with Excel
    • Step 1 – Set up folder for your presentation and related files
    • Step 2 – Get music file and screen shot from Jamendo.com
    • Step 3 – Create new presentation
    • Step 4 – Modify the title page slide
    • Step 5 – Delete Slides
    • Step 6 – Save your presentation
    • Step 7 – Modify presentation properties
    • Step 8 – Add slides
    • Step 9 – Add slide masters
    • Step 10 – Insert music file into presentation
    • Step 11 – Set your sound up so that it runs continuously through your presentation
    • Step 12 – Try running your presentation
    • Step 13 – Add animations to presentation general content
    • Step 14 – Add in “color typewriter” animations on selected slides
    • Step 15 – Turn Wikipedia text on slide 3 into hyperlink and add the hyperlink in the notes area
    • Step 16 – Add transitions to presentation
    • Step 17 – Add a new slide at the end with credits
    • Step 18 – Add new slide at the end to attribute the music source for the presentation (Creative Commons License)
    • Step 19 – Adding narration
    • Step 20 – Change background colour on slide
    • Step 21 – Add Questions slide and then hide it
    • Step 22 – rehearse timings
    • Step 23 – Download Camtasia 30-day trial
    • Step 24 – Convert presentation to YouTube format using Camtasia
    • Step 25 – Upload to YouTube
  • Creating a Business Style Report with Word
    • Step 1 – Create a new MS Word 2007 document
    • Step 2 – Set up Page Margins
    • Step 3 – Modify Properties
    • Step 4 – Add Cover Page
    • Step 5 – Add Content from Wikipedia
    • Step 6 – Add Attribution Page
    • Step 7 – Structure Content
    • Step 8 – Add Header
    • Step 9 – Add Page Numbers to Footer
    • Step 10 – Add Table of Contents
    • Step 11 – Insert Table on Resources Page
    • Step 12 – Insert Index
    • Step 13 – Use Replace All
    • Step 14 – Spell Check your Report
    • Step 15 – Save your File
    • Step 16 – Make Screenshot of the Cover Page
    • Step 17 – Create New Version of your File
    • Step 18 – Save your Report to PDF Format
    • Step 19 – Upload Report to LuLu.com
    • Step 20 – Track Results and Donate Earnings
    • Samples
  • Introduction to Word
    • Step 1 – Register for the GCFLearnFree.org site
    • Step 2 – Pre-assessment test
    • Step 3 – Complete GCF LearnFree MS Word 2007 Tutorials
    • Step 4 – Create a Personal Newsletter
  • Creating a Simple Business Model with Microsoft Excel 2007
    • Step 1 – Create an Excel 2007 file and save
    • Step 2 – Create business model
    • Revision History
    • Frequently Asked Questions
  • Creating a Multiplication Table with Microsoft Excel
    • Step 1 – Open MS Excel and Save a File
    • Step 2 – Create Multiplication Table
  • Create a Business Model for a Car Dealership with Microsoft Excel 2007
    • Step 1 – Open Excel and Save File
    • Step 2 – Read Scenario & Design Model on Paper
    • Step 3 – Develop Excel Model
    • Protected: Answer Key for Instructors
  • Create a Mortgage Calculator with Excel 2007
    • Step 1 - Open Excel and Save File
    • Step 2 – Build Your Own Spreadsheet Model for Loan Amortization and Business Deductions
  • Creating a Cluster Column Chart with Excel 2007
    • Step 1 – Open and save data file
    • Step 2 – Enter your name and date in documentation worksheet
    • Step 3 – Insert 2D Clustered Column Chart
    • Step 4 – Change Chart Style
    • Step 5 – Insert Titles
    • Step 6 – Add Axis Titles
    • Step 7 – Change the line styles of the horizontal gridlines
    • Step 8 – Add Vertical Gridlines
    • Step 9 – Change chart type
    • Step 10 – Insert cloud and lightning bolt shapes
    • Step 11 – Fill in plot area with custom picture
    • Step 12 – Conditional Formatting
    • Protected: Instructor Answer Key

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $13 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub