Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about adding, resizing and placing graphics as either standalone images, or as backgrounds. For detailed instructions on incorporating images into your Access projects, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using calculated field to work out the tax payable on an item, then adjusting item value. For more, and to get started using calculated queries yourself, watch this MS Access how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about protecting your VBA code from snoopy little trolls. For more information on keeping your VBA code secure, watch this MS Access how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using Access to create a search engine type query that can adapt to fragments of data. For more on using Google-style queries in MS Access, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating subforms (assuming relationships have already been created). For more on subforms, watch this MS Access how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using an append and delete query sequentially using a macro. For more on archiving data in Microsoft office, take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using queries to selectively delete records. For more information on using delete queries in Access, take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a simple four-button switchboard in Microsoft Access. For more information, watch this Access how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about passing parameters to queries in Microsoft Office Access. For more information, and to get started running your own parameter queries, take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using simple select queries on one or more fields. For more information, or to get started using simple queries in your own Microsoft Access databases, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about what queries are, and scratches the surface on what they can do, For more information, and to get started running your own database queries in Access, take a look.
Microsoft Office Live Meeting is a conferencing solution that you can use to engage audiences in online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting by using new features such as audio, video conferencing, uploading handouts for distribution, and using Microsoft RoundTable.
Even if you don't have Microsoft Office Word 2007, you can open Word documents with Word Viewer. In this instructional video, a Microsoft employee shows how you and your coworkers can download Word Viewer and the Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. With these 2 downloads, you can open, print, or copy and paste from Word documents without having to install Word on your computer.
Not sure what to do when you get a security warning about a macro? What are macro security settings, the Trust Center, and Trusted Locations anyway? Watch this instructional video to learn how to enable macros and make informed security decisions that can help you keep your computer safer while you work in Microsoft Office Excel, Outlook, Word, Publisher, PowerPoint, and Visio 2007.
This tutorial shows you how to share your calendar three ways in Microsoft Office Outlook 2007. If your company uses Microsoft Exchange Server, you can share your calendar within the organization by using that feature. You can also send a snapshot of your calendar in e-mail to people outside your company. And you can publish your calendar on the Microsoft Office Online Web site and restrict how much detail is shown and who can access it.
Many businesses rely on standardized forms for gathering information, and often those forms are created in Microsoft Office Word. But Word isn't really intended for creating, maintaining, and filling out forms — that's what Microsoft Office InfoPath is for! Take a look at this instructional video and learn how to convert a Word coument to a form template.
Take a look at this instructional video and learn how to use themes in Microsoft Office Visio Professional 2007 to add color and style to your diagram with just a few clicks. Choose from a gallery of predefined themes, or customize themes with your own background colors, fonts, effects, and more. Your diagram will jump off the page, plus you can make it visually consistent with documents you create in other Microsoft Office programs.
Now you can enable users to fill out Microsoft Office InfoPath 2007 forms by using a Web browser, which makes your forms more accessible to a wider audience. This instructional video shows you how to go through the process an IT Administrator can use to verify, upload, and activate an administrator-approved form template on a Microsoft Office SharePoint Server 2007 site.
Learn about the New SmartArt Feature in Microsoft's Office 2007 which allows you to create interactive graphics in your documents.
Learn how to create PDF and XPS files directly from Microsoft's Office 2007.
This is an amazingly creative idea. Watch this video hosted by Graffiti Research Lab in NYC and learn how to create a portable chair for free out of post office boxes. These guys provide a resting place for the city lunch roamer, but these chairs would be great for a kids playroom or even the office!
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...
Make sure you use the facilities before you put this office bathroom trick into hilarious effect. You will need several pairs of shoes and slacks, as well as newspapers. Make everyone in the office think all the bathroom stalls are occupied. Check out this video practical joke tutorial and learn how to prank the office bathroom.
This video from TechFusionVids presents how to install Microsoft Office 2008 on Macbook Pro.All installation process takes about 5 minutes. Insert Microsoft Office 2008 installation disk, double click on the installer icon when Office installation window opens.Click Continue two times, agree to software license agreement, type your name and name of your computer, click Continue again.Window opens saying you should close all running applications before starting further installation.Once it's d...
Do you work in an office? Learn Korean words pertaining an office in Korea! Check out this Korean language tutorial that shows you how to pronounce office related vocabulary words. This video provides another great way to learn Korean, and continues with the Picture/Video Vocab series to go over some Korean vocabulary in the office place! Offices in Korea are very similar to those found elsewhere in the world. So listen in to today's Picture Video Vocab Lesson, and learn some Korean words tha...
Learn about the New Formula Features in Microsoft's Office 2007 and how to use them to do calculations in MS Office and Excel documents.
This video helps you to Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007. When you click the office button on the left corner, your recent documents will appear by default. If you open a new document, it will push the other documents down and it will appear on the top. So, if you want a particular document to open whenever you open the excel, you have to click that particular document by clicking the pin that appears in the right side of it. This will turn t...
Learn about the New Contextual Spelling Feature in Microsoft's new Office 2007 and how to use it to better proofread your documents.
Word 2008 for Mac is jam-packed with tons of cool and useful features and tools that you can use to make a great looking document. Starting with the pre-made templates is the best way to go, and from there, customize it the best you can, anyway you can. The Microsoft Office for Mac team shows you all the great features in this how-to video.
In the era of smartphones and cloud-based computing, it almost seems irresponsible to keep a stash of paper documents. Not only is a physical paper printout environmentally impractical, it's also a lot harder to organize and keep track of than a digital file stored on a hard drive.
The massive offices that represent so much of the American economy are an ecological disaster. They aren't heavy manufacturing, but they use incredible amounts of paper, electricity, and other resources. This video will give you some tips for making you office more green, saving electricity and paper and making the Earth a better place.
Barely able to lift your head off your bed to do exercise? No problem, the exercise can come to you!
See the demo to learn how to take advantage of some of the advanced features of Office Communicator 2007, including rich-text formatting, transferring files, and escalating to a Live Meeting. If you use Office Communicator at your office for video conference calls or chatting, then this tutorial will explain some very useful advanced features.
Do you ever wish you had a way to jot down an idea, and then illustrate it with a page from a document, a photo and a sound clip, all without opening multiple applications? Microsoft Office OneNote 2007 note-taking program is that advanced notepad, and is better than ever with new additions to the interface that make it even easier to organize yourself. For more on using MS Office OneNote, watch this video tutorial.
Feng Shui is the art of interior design that arranges energy to create a feeling of comfort in a house. Our Feng Shui expert will give you several great tips in this free video clip series.
Yoga is a meditative practice that can be utilized at home or even in the work place. Learn a few healthy stretches you can perform while at the office from a yoga instructor in this free video series.
