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 concatenation using LEFT and RIGHT functions. For more information, watch this Microsoft 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 concatenation using cell references only. For more on textless concatenation, 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 conditional formatting in Excel to change background color. To get started learning about conditional formatting, 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 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!
If you're lucky enough to have snow outside your front door right now, then you know how beautiful it can be to just take a walk around the neighborhood, watching as the soft snow glistens quietly. Mimic that same surreal magic by creating a makeup look inspired by snow.
When rap sensation Soulja Boy came out with his namesake hit "Crank That (Soulja Boy)" in 2007 you could walk past a single neighborhood block without witnesses at least one kid out in his driveway practicing the arm swishes and leg pops.
Losing weight can be simple if you follow one rule: Cut calories! In this Ask Amy tutorial, your neighborhood nutritionist shows you how to cut back on the calories and lose the weight easily without feeling like you are sacrificing your favorites. Follow Amy's advice and you will be fitting into your jeans easier sooner than you think!
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...
In this tutorial, we learn how to draw a neighborhood using an imaginary box. First, draw a straight line and then the boxes should go around it. Continue to draw additional boxes around the line, then fill them in with the outline and further details. Draw in the roof, walls, windows, and doors. When you finish with the details, start to shade them in and then add in the street details. Make sure to give the ground some rough edges and also add in lights on the street. Add as many details as...
Watch this video to learn how to make an urban neighborhood drawing. Start by sketching the road splitting into two direction. Remember that as things are farther a way they are smaller in appearance. Put in some vegetation where you are not going to put building. Next sketch in the buildings. At first just put the outline of the buildings. Then add detail on the building such as windows and doors. Think at what point in the sky the sun is at and add shadows on the sides of the buildings acco...
Is there something strange in your neighborhood? Don't bother with a phone call, just watch this video and learn how to build your own EM pump. An EM pump improves EVps and attract paranormal entities. If you are going ghost hunting, you need an EM pump.
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.