Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula E ...more
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula ...more
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicat ...more
In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, clic ...more
With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple ...more
Hi again, Just wanted to share a neat little code that I found way back, when I was presented with a spreadsheet which was locked and asked to ''unlock'' it or do whatever it takes to enable the user to edit it's contents. Well, I'm not one to say nay to a challenge, however ...more
The Costsheet demonstrates how to enable macros in Excel 2007 to run correct spreadsheets. First, open up the spreadsheet. Make sure that the macros are enabled. If they have not, enable the macros by placing them in a trusted source by saving them in a particular folder. You ...more
Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl ...more
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 F ...more
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 ...more
Check out this video tutorial on how to generate an Excel worksheet using XML. There's a free library from CarlosAG.net, and you need to get the free dll file from there. This video will show you how to use it. You need to use CreateExcelFile in Microsoft Visual Studio to use ...more
File collaboration is one of the best integration features between Office 2003/Office 2007 and SharePoint. These task panes allow you to access and modify content in a SharePoint site from within Office without having to navigate to the site using your browser. The feature is ...more
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summari ...more
In this Excel basics video, the instructor talks about the basics of charts. There is an enormous difference in how you make charts between Microsoft Excel 2003 and 2007. In both the versions, to make charts the first thing you do is highlight the data cells in your workspace. ...more
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
This tutorial shows you how to use the color categories feature in Outlook 2007 to manage email.
This video shows you how to change the background color and watermark in your Word 2007 document. Both settings are found on the Page Layout tab. The background color can be chosen from a wide palette. The most frequently used colors are immediately applied to the current page ...more
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 co ...more
Watch this software tutorial video to learn how to uncover Outlook 2007's best features: drag-and-drop calendaring and color-coding. This how-to video will allow you to use drag-and-drop calendaring in Outlook to make your calendars better.
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. Part 1 of 2 - How to Use the formula functions in MS Office 2007. Part 2 of 2 - How to Use the formula functions in MS Office 2007.
A PivotDiagram is similar to an Excel PivotTable report: It arranges data in a visual way. Check out this tutorial and learn how to look at the same data from different angles to establish and analyze relationships that you might miss in a table or a worksheet.
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 237th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MROUND, CEIL ...more
Take a look at this instructional video and learn how to use a Microsoft Office Excel worksheet that contains employee data to create shapes, connect them according to your organization's structure, and add data to each shape in your drawing automatically.
Take a look at this instructional video and learn how to customize progress meters, icons, color coding, and other graphical elements to emphasize sales trends, product performance, critical deadlines, or whatever information is contained in the data behind your diagram.
We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, ...more
A video from Helpvids.com that shows how to Insert and edit text in Microsoft Word 2007. There are many ways to do document editing tasks in any of today's advanced word processing programs and MS Word 2007 is no exception to it. There are many ways to do the same task in wor ...more
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart te ...more
STake a look at this instructional video and learn how to organize and gather information with OneNote 2007 from Microsoft. Microsoft Office OneNote 2007 is an easy-to-use note-taking and information-management program where you can capture ideas and information in electronic ...more
This video will guide you how to disable or delete recent document list in MS Word 2007. The same procedure is also applicable for MS excel also. Follow the steps and employ the technique in your PC. Video: .
Apple is set to release its latest operating system for iPad, iPhone, and iPod touch this fall, and if you haven't noticed yet from our iOS 7 softModder guides, it's going to be pretty slick. Gone are the boring old icons that have remained basically unchanged since the very ...more
Microsoft Office files can be password-protected in order to prevent tampering and ensure data integrity. But password-protected documents from earlier versions of Office are susceptible to having their hashes extracted with a simple program called office2john. Those extracted ...more
If we were to assign a theme for the 2019 edition of the Next Reality 30 (NR30), it might be something along the lines of, "What have you done for me lately?" Many of the top names in the industry from the 2018 edition remain the same, but their positions have shuffled. The p ...more
First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more
Parental involvement is a crucial ingredient in the success of many children. Teachers know the saying all too well that it takes more than a village to raise a child, for one - it takes parental involvement. Thus, it is important for teachers to reach out to parents in that f ...more
Microsoft PowerPoint is a powerful software to make presentations. It can also be used to make a Jeopardy board. To do this open a new PowerPoint presentation. Start with a title layout. Now add a gradient to its background. To do it right click on it and select the fill optio ...more
To use borders in Microsoft Word 2007, you begin by clicking on the Page Layout tab. Next, click on Page Borders. This will open a window. Page borders will border the entire page. You are able to custom choose the width of the lines, the style of the border, or the color of t ...more
We always have so many file formats in our computer, we use MS Word to view .doc files, MS Excel to view .xls files, Adobe Reader to view PDF files, image viewers to view all kinds of image formats, and browser to view html files. It seems we need to install many programs to v ...more
For that, first, click insert, select any shape from the given options. Take drawing tools from format option. In that, we can choose from the most used colors , like, black, blue and red. Also we have options like, fill color. In that, theme color can be used for different ty ...more
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add con ...more
Did you know the views in your Microsoft Office Outlook calendar are fully customizable? View days and weeks in increments of 5 minutes, 60 minutes, or periods in between. Take a look into instructional video and learn how to adjust the view according to your work week and wor ...more
If you're new to Microsoft Office PowerPoint 2007 and just want to pick up the basics, watch this tutorial and learn how to get started fast. You'll see how to create your own slides for a show and add headings, bulleted lists, and pictures. Use built-in layouts to organize yo ...more
This video will go over how to insert a check box in Microsoft Word for printing or for electronic distribution. With just a few clicks you can get a check box. You can even add different symbols or styles for your check box. Step 1 Open Word on your computer. This will give ...more
Hey has anybody tried Microsoft Office 2010 yet? It looks like they had their major Keynote today (2010-05-12). Being an IT guy I am looking forward to rolling this out in my company. I liked the ribbon when it was introduced in Office 2007 & with Office 2010 it looks like the ...more
Microsoft office 2010 is the successor version of office 2007 and is code named as office 14. It is the first 64 bit version of office which is only compatible with Microsoft service pack 3, Windows vista and windows 7. It was released on April 15, 2010. It is the first Micros ...more
To be honest, I haven't played an Assassin's Creed game since the first one way back in 2007. So, the fact that there is a character named Duccio kind of makes me want to play the new one, Assassin's Creed: Revelations. Add to that, the fact you can get 20G if you're playing o ...more
In this video, we learn how to create a brochure with Microsoft Publisher 2007. A brochure says a lot about your business, and you can make them yourself easily! Find the brochure templates first in the program. Choose a design and a color scheme along with the page size, font ...more
In order to insert Word Art, into your document, using Microsoft Word 2007, you will need to begin by opening your document. Next, find "Insert", at the top of your screen. Click on it. This will take you to the Insert Tool Bar. Find Word Art. Choose the style that you would l ...more
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Cla ...more
This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines ...more
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart ...more
This video will show you how to create a flow chart in MS Word 2007. First click on the Insert tab. You can see the smart art option, click on it. A "Smart Art Graphic" window will appear. Now click "Hierarchy" option in that window. You can choose any chart you want then cli ...more
If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more
MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. Moti ...more
This video demonstrates how to choose a theme for your Word 2007 document. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to choose a theme for your Word 2 ...more
This video demonstrates how to make multiple changes at once with Word 2007 themes. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to make multiple changes ...more
You don't have to be a professional designer to create a professional-looking slide show. Check out this tutorial and learn how to grab the audience's attention by adding a background to your slides. Microsoft Office PowerPoint 2007 design themes include an array of coordinate ...more
How to use trendlines in Excell 2007 In this tutorial I will show you how to use trendlines in microsoft excell 2007. Trendlines can only be used for certain types of charts. Charts that cannot be used for a trendline: Stacked-chart, 3D, Radar, Pie-chart, surface-chart, don ...more
In recent years, Russian marine biologist Alexander Semenov has built a stunningly beautiful collection of deep sea photography, capturing alien creatures only locatable in the hostile, icy depths of the far northern sea off the coast of Russia. A brave art world denizen migh ...more
In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizon ...more
This video is a Microsoft Word 2007 tutorial on working with pictures. To insert a picture in your document, click on Insert and select Picture, then find the picture, select and insert it. To resize the picture without distorting it, click and hold on the corner circles. You ...more