99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Microsoft Excel's Best Kept Secret
Wed 10th January 2007
Even after one day of Microsoft Excel training you're likely to walk away with countless ideas for streamlining your daily activities and enhancing the usefulness of your data. In this article, we'll scratch the surface of one of Excel's most ingenious capabilities that has the potential to revolutionize the way you conduct your tasks - the Excel web query.
If the term "web query" makes you feel like you're treading dangerously close to complicated programming, rest assured that this is big name for something incredibly simple and unusually useful that you'll learn in Microsoft Excel training. An Excel web query simply means that you're telling Excel to go out and retrieve the most current information from a particular web page.
Believe it or not, there's no complicated formula that will take you hours to digest in Microsoft Excel training. It's as simple and navigating to a web page and making one mouse click. Really. Simply click "data" on your Excel dropdown menu, then mouse over "import external data," and then select "new web query." This will open a browser window where you can navigate to the page where you want the information.
For a test run, type in "stock prices" and choose a page. You'll notice lots of yellow arrows to the left of blocks of data that aren't normally visible. Simply click on the arrow of the block of data that you want to import and the entire table is instantly imported into your Excel sheet. Not only is the data in your sheet, each time the data on the webpage is updated, you can instantly update the data by clicking the red exclamation mark icon on the new 'import data' menu located in your toolbar. This one little gem of information taught in Microsoft Excel training could completely change the way you do business and boost your productivity to new levels.
Think of the possibilities of creating smart spreadsheets with Excel web queries. You could track up to the minute airfare and hotel rates, produce always-accurate reports on web statistics, and even keep an eye on your competitors. You can create a spreadsheet that compares your competitor's current advertised prices next to your own. Using formulas in Excel, you can track the percentage difference between daily advertised prices and adjust accordingly - lets' hope your competitors haven't already been through Microsoft Excel training!
Many companies would consider paying a steep price for a piece of software with this capability. However, having taken Microsoft Excel training, you'll know how to create your own data powerhouses with just a few clicks. Most people are surprised at how much power Excel has to offer after taking a Microsoft Excel training course. Try one for yourself and see how Microsoft Excel training can completely change the way you do business.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Really good - wold have been cool to have some test's at the end to recap on everything.
other than that was really good and useful.
The course was delivered at a comfortable pace and the trainer was happy to deviate onto subjects not listed in the handbook when we requested more information on other subjects.
Overall a great course, thank you!
Maps Medical Reporting
Building Confidence and Assertiveness at Work: Level 1
I found the training fun, engaging, comfortable. We were able to express views in total confidentiality and trust. A course that all employees should do in MAPS.