Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Guides to Excel, Word, Etc.

  1. Nov 6, 2010 #1


    User Avatar
    Gold Member

    Does anyone know of any good guides on getting the most out of the programs that typically come with Microsoft Office? And not things like "How do I make a chart?", but something a little more advanced like a sort of "mail merge" between data on a spreadsheet and a word document "template". For example last week I wanted to create current grade printouts for my students which involved having a word document where I could put their name and a little guide to calculating their grade. However I had to manually copy and paste the row of grades from the excel spreadsheet I have and print them 1 by 1. What a pain.

    Are there any guides to really getting the most out of programs like these? Hmm, a guide to powerpoint would be nice too... putting videos on a power point reliably.. I like that idea too! I notice so many options in all these programs yet I have no idea how to use them...

    Microsofts help isn't of much use...
  2. jcsd
  3. Nov 8, 2010 #2
    google is normally the best thing for problems like mail merge

    This is probably not what you want, but I have found that its just best to mess around on each program and google each point that you need help with. Either that or use the help & tutorials that come with office.
  4. Nov 28, 2010 #3


    User Avatar
    Gold Member

    Last edited by a moderator: Apr 25, 2017
  5. Nov 28, 2010 #4
    Should be not that difficult to generate a function for that, as I did here in the d-column. This calculates the area exactly, when assuming that there is a straight line in between the datapoints

    Attached Files:

    Last edited by a moderator: Apr 25, 2017
  6. Dec 13, 2010 #5


    User Avatar
    Gold Member

Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Discussions: Guides to Excel, Word, Etc.
  1. Word > Excel help (Replies: 9)

  2. Excel summing (Replies: 3)

  3. Excel + Calculations (Replies: 9)