98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
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.
Author is a freelance copywriter. For more information on Microsoft Excel Training please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-115-microsoft-excel-best-kept-secret.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsNational Physical Laboratory
Quality Auditor Jascindra Ravi Microsoft 365 Ambassadors Very useful, picked up quite a few useful tips and tricks Citrix Systems International GmbH
Reveneue Accountant Kushan Wellage Excel Advanced It was a really good training to learn and refresh everything. Papa Johns
Manager Asif Michael Excel Intermediate Very useful. l will come back for the advanced one as well. |
PUBLICATION GUIDELINES