Excel

When a macro won’t cut it, try a VBA script

This post written by Daniel Ferry, an Excel MVP, chronicles how he and Beth Melton, a fellow MVP, designed a Gradebook template in Excel that makes teachers’ lives a whole lot easier. Several teachers, however, wanted to make the template even more useful. They asked us whether the template could print all student progress reports at once. To tackle this task, Daniel knew recording a new macro wouldn’t cut it. He needed to write a…

OneNote

6 reasons why I used OneNote to plan a project

Earlier in the year, Jennifer Bost and Michael Oldenburg, two Office.com bloggers, took a road trip to Canada to video tape how a high school teacher was using OneNote in the classroom.  To plan for the adventure, they captured all of their research, trip details, and video storyboarding in a shared notebook. Jennifer Bost writes today’s blog post describing their process and how they used OneNote to help them collaborate…

Office 365

Free gradebook template for Excel 2010

Earlier in the year I worked with Beth Melton, an Excel MVP, to create a super easy and visual gradebook template in Excel 2010. It’s built for teachers with little to no Microsoft Excel experience. In fact, all of the grade calculation formulas are taken care of for you. We built the template in Excel 2010, because of all the new 2010 data visualization features. It even includes a printable…

Office 365

The secret to converting your presentation into a video

Did you know that you can save your PowerPoint 2010 presentations as Windows Media Player (.wmv) video files? Well, you can. And it only takes a few mouse clicks. You can then burn the video to a DVD, upload it to your blog or video-sharing web site, or email it to your professor to share the video file with people who don’t have PowerPoint installed on their computer. If you’re using…

Office 365

How to insert symbols and special characters into a Word document (video)

Do you need to use a Euro symbol in an economics paper? How about a Celsius degree in a lab report? Or, maybe you need to insert special characters into your math homework. I recently discovered the Math AutoCorrect feature in Word and realized that I could use it for more than just math stuff. Math AutoCorrect lets me insert symbols and special characters into my documents using keyboard shortcuts.…

Office 365

MLA, APA, Chicago — Microsoft Word formats bibliographies for you

Did you know that it’s easy to create a bibliography based on common citation formats in Microsoft Word? A few months ago, we were asking students about how they write a research paper. Jon, a freshman at a local community college, had just completed a huge term paper that counted for a large percentage of his overall grade in a class. While describing how he wrote this paper, he told…