How To: Import external data in Excel
Learn how to Import External Data (i.e data from web pages) dynamically into Excel in Microsoft's Office 2007.
Learn how to Import External Data (i.e data from web pages) dynamically into Excel in Microsoft's Office 2007.
Since its release back in 1988, Microsoft Office has been the top client and server software suite for businesses around the world. Office's domination is thanks to both Microsoft's extraordinary foresight and their continual updates and innovations to ensure that companies always get what they need.
There are a number of ways to give your productivity a kicktstart, from taking a break from your distracting smartphone to just taking a break, plain and simple. Yet finding the motivation to start working doesn't require any effort at all—just a little bit of green.
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...
This video tutorial demonstrates tips for how to organize your home office when you are visually impaired. Here a rehabilitation specialist is helping a visually impaired person. The person who is visually impaired should know what is visually important to him/her. Mostly these people obviously need to know where every thing is because they don’t have their eyes to depend anymore. Here visually impaired person is 66 year old Deanne Jackson. She has wet macular degeneration. In order to set up...
After much speculating, denying, and waiting, Microsoft has finally released their suite of Offices apps dedicated to the iPad. With increased competition and flocks of users going to apps like Quickoffice (which was recently acquired by Google) and Kingsoft Office, it was getting close to do-or-die time for Microsoft.
Remember when the whoopee cushion was the epitome of a good office prank? Seriously, when was the last time you've actually seen a whoopee cushion? It's a shame when a classic prank fades into the shadows like a fart in a dungeon. These days, office pranks need to be a little more involved—and way louder—like this amazing air-horn chair prank.
If you've ever attended school or held a job, you're probably well familiar with Microsoft Office, whether you used it or not. It's the most popular office suite available, and has been for some time. Apple does have its own suite of productivity apps (iWork), but Microsoft Office has always been the industry leader for word documents, spreadsheets, and presentations.
Many seasoned users of Microsoft Excel, who have been using spreadsheets for years, still scroll through their spreadsheets, laboriously, with the horizontal and vertical scrollbars. In this software tutorial, you'll learn how to navigate around in Excel both quickly and efficiently. For more, take a look!
If you use Microsoft Word quite a bit and have never used the Format Painter tool, it's a technique you need to learn, and learn today, because it's a technique that will save you a lot of time and a lot of grief in the future. To learn how to use the Format Tool in Microsoft Office Word documents to streamline the formatting process, watch this how-to.
If you're buried in e-mail (and who isn't?), Instant Search in Microsoft Office Outlook 2007 can save the day for you. The new Instant Search helps you quickly find e-mail messages, appointments, contacts, or any Outlook item. You don't even need to know which folder the item is in. Watch the demo to see how to use this fast search feature in Outlook 2007, and start finding what you want instantly.
Learn how to manage contacts and business cards more effectively with this tips and tricks video on Microsoft Outlook 2007. This MS Office tutorial will show you how to create a contact from scratch, and give it a business card look in Outlook 2007.
This MS Office software tutorial shows you some tips and tricks for using Microsoft Outlook 2007 email software. If you are new to Outlook 2007 watch this video and learn about the changes to the reading pane and how to use different views like timeline view and more.
What a wonderful alternative use for a Powerpoint presentation. If you've got a lot of history and ancestry to share with your friends, then making a Powerpoint that each person can view from his/her computer is a nice way to organize and show off your stuff.
Oh how we love open source software. If it wasn't for Open Office, we never would have been able to write that seven-page English paper while on our friend's Microsoft Office-lacking laptop during an impromptu road trip to Mexico. And Ubuntu, an open source secure operating system, offers you similar convenience. A much more intuitive computer operating software than your standard Windows or Mac OS, Ubuntu is great if you know what you're doing.
Bored in your cubicle all day? It's time for helicopter wars! This video shows you how to make a fun and simple helicopter out of some basic office supplies. The materials you will need are: a big paper clip, a smaller paper clip, a large aluminum can (such as from Rockstar or Monster energy drinks), a ruler, Scotch tape, a rubber band, a pair of pliers (if you have a Leatherman multitool, those will work just fine), a pen you can take apart for the long tube, a pair of scissors, and some pla...
Bored at work or school? In the middle of waging a cubicle war, and need to up your arsenal? Just like making catapults? This video shows you how you can make a basic catapult out of an assortment of office supplies. To make your catapult, you will need a ball point pen, a large binder clip, a few rubber bands... and, of course the ammo! Crumpled up pieces of paper or Post It notes work very well as ammo.
In one way, this seem more like an artistic sculpture than a silly prank, but unless you're making food and drink art, this will always be a prank. Learn the spilled coffee prank, outlined in this how-to, which involves a little bit of Elmer's Glue. Place this over someone's secret and important documents, and they'll absolutely go apeshit!
In this clip, you'll learn how to use the "Paste in Plain Text" and "Paste from Microsoft Office" buttons in the WordPress editor. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
Does one of your coworkers at the office really make you mad? Do you want to mess with them at the office without having to destroy any property? This video can help. It will show you how to quickly create a fake wallpaper on someone's computer with Windows XP, which will infuriate them for a long time if they aren't very computer-saavy or familiar with this prank. Try it out and marvel at the hilarious results.
Creating tables inside Microsoft Word has always been a chore— but not anymore! With Word 2008 for Mac, you can easily create tables of all your information. And if you're not sure of the best way to select, resize, and move those tables, you'll know soon enough. The Microsoft Office for Mac team shows you just how to work with tables with these Word table tips in this how-to video.
Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.
Not every client or coworker likes to mine through a spreadsheet to find all the important data. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. To do this, all you need to do is to use the "copy as picture" option. The Microsoft Office for Mac team shows you just how to insert a spreadsheet snippet in this how-to video.
Are you a vigorous notetaker? But are your notes disorganized and cluttered? Drop the paper and pen and pick up Word 2008 for Mac. Word contains a new feature that allows you to take notes, not to mention add audio notes and video notes. The Microsoft Office for Mac team shows you just how to create a text and audio notebook in this how-to video.
Did you know that headers and footers are a great way to make your documents easier to read? Not to mention more professional— and if you have Word 2008 for Mac, creating those headers and footers is a cinch. The Microsoft Office for Mac team shows you just how to create headers and footers for documents in this how-to video.
Whether you've used Word before, on Windows or a Mac, the Word 2008 for Mac program has tons of new and yet undiscovered features (undiscovered by you!) that you still need to learn. So, if you're a beginner Word user or a seasoned pro, you still could learn a thing or two with this overview. The Microsoft Office for Mac team shows you how to get started in this how-to video.
Need to make a homemade business card for you new company. Maybe you're about to take freelancing to the next level, a more professional level. Well, Word 2008 for Mac allows you to make your very own, personal business cards, and they give you tons of pre-formatted templates to choose from. You just have to supply the ink and paper. The Microsoft Office for Mac team shows you just how to find and use business card templates in this how-to video.
There's a lot you can do in Word 2008 for Mac, and with all of the possibilities, it can be hard to figure out what you can and can't do. Well, you can add cover pages. You can add headers. And you can add bibliographies easy. The Microsoft Office for Mac team shows you just how to add cover pages, headers, and other document elements in this how-to video.
Sure, not everyone will want to create brochures, but for some of us, it's the best way to get around paying a design firm— making them yourself in Word 2008 for Mac. The tools and templates inside Word 2008 make it easy to create visually stunning brochures for any occasion. The Microsoft Office for Mac team shows you just how to design a professional brochure in this how-to video.
Have you always thought of Excel's grid system as kind of limited? Too small for what you need? Well, now in Excel 2008 for Mac, its grid might be too big for its own good! It's huge with plenty of room for all your data. The Microsoft Office for Mac team shows you just how to explore the bigger grid in this how-to video.
Great news! — Excel isn't just for Windows anymore. Okay, so it's been available on the Mac for awhile now, but if you haven't used it yet, why not start now? Getting started with Excel 2008 for Mac is easy, and this video overview will show beginners or even the most seasoned professional spreadsheet worker a thing or two. The Microsoft Office for Mac team shows you just how to get started in this how-to video.
Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.
You could be a PowerPoint power user or you could be a PowerPoint newbie— you've never created a slideshow in your life! Either way, this will show all of you brand new to PowerPoint 2008 for Mac (and all of your slideshow gurus) the basics of PowerPoint. The Microsoft Office for Mac team shows you just how to get started and get up to speed fast in this how-to video.
Managing your busy schedule just got easier in Entourage 2008 for Mac. Using the powerful Entourage Calendar feature lets you organize your time wisely. The Microsoft Office for Mac team shows you just how to organize your schedule with the calendar in this how-to video.
This how-to video is about how to use the Ribbon and Backstage view in Microsoft Office Excel 2010.
Want to learn how to apply makeup flawlessly? Watch this makeup instructional video to create this appropriate for office makeup look. May Paris gives helpful beauty tips on creating this beautiful look. Just another formal makeup look you can wear to work!
Do you have an extra room in your home? Watch this video tutorial from an interior designer to learn how to make that extra house space a home office by day and a guest room by night.
Learn how to install laminate flooring in your home or office.
Benny from askbenny.cn teaches you the names of some common pieces of stationary and office equipment in Mandarin Chinese and how to talk about them.
Just last month, Microsoft announced plans to take away a huge chunk of storage from the free tier of their OneDrive cloud service, and users are understandably quite upset. At the same time, they reneged on an offer to give Office365 users unlimited OneDrive storage, and instead, will only be offering 1 TB of storage.