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
Creating A Clearer Picture With Excel
Mon 25th July 2011
By publishing your workbook as a webpage, staff will be able to view the results on the Internet, or even your local network, with a web browser. When you save an Excel document as a webpage, it is converted it to Hypertext Markup Language (HTML) format. To do this, click on the 'File' tab. Now click 'Save As'. When the 'Save As' dialog box appears, select the location you want to save your file to. Type a file name and then select 'Web Page' from the 'Save as type' on the drop-down list. Click the 'Change title' button to add a title to your webpage. The title is different from a file name and it appears in the bar at the top of a web browser when you open a webpage.
You can also link to the Internet via your workbook by creating hyperlinks in your document. These links are an ideal way to jump to resources that are related to the data within your worksheet. To create a hyperlink, select the cell, object or text you want to convert to a hyperlink, click on the 'Insert' tab, and then select the 'Hyperlink' button. In the 'Link to' section (this appears in the left pane), click on one of the buttons to select the type of link you want to create. Now select or type the web page you need to connect to. Once you have created a hyperlink, it will be formatted as blue text in a cell.
And you can also format a hyperlink so that anyone viewing your data knows where and when they can link to the web. To format a hyperlink, click on the 'Home' tab. Now select the 'Cell Styles' button, right-click the 'Linked Cell' option and select 'Modify'. You can alter alignment, borders and fills if preferred. Select 'Format' to alter the styles and colour you want to apply to your hyperlink. You can even copy or move your hyperlink by right-clicking on the link and selecting 'Copy' or 'Cut'. Right-click the cell you want to contain the link and paste it in.
Obviously Excel isn't a web browser, but it can open a worksheet that has previously been saved as a webpage. You can switch from HTML to Excel format without losing any commands or functions. To do this, click on the file tab to get to the open command. Now select 'All Web Pages' from the drop-down list. Or if you want to open the file in your web browser, then select 'Open in Browser' instead.
Previewing your worksheet as a webpage is a good chance to correct any errors before committing your file to its online version. With your workbook open in Excel 2010, click on the 'Web Page Preview' button (the icon has the e-Internet symbol on a blank sheet) located in the quick access toolbar - or add in the 'Web Page Preview' button by selecting 'More Commands' on the quick access toolbar. Your default web browser will now open, displaying your document as a web page.
With the flexibility of reproducing charts, tables, and even images in your Excel worksheet, data definitely becomes more accessible and understandable to staff viewing the Internet. It's true that with employee engagement comes better performance; and as stakeholders demand more high-level corporate information, Excel 2010 is the ideal driver to deliver this type of data.
Author is a freelance copywriter. For more information on excel+training, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1836-creating-clearer-picture-with-excel.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsFastNet Ltd
Finance Director Chris Lamb Advanced Excel Dashboards This course was spot on, a great follow up to the previous BI/Dashboards one I did a few weeks ago. Its definitely worth booking these close to one another and puttin thiings into practice back at work in the meantime to get the best of the courses. Jens was great and this time was perfectly timed in terms of pace, however the final part I thought was too much copying what was being typed from his instructions so we weren't really learning as such, and we weren't looking at how the background of the design of the dashboard was done. I think what would be good would be an excersise using some base data for us to try and design our own dashboard or perhaps formulate a choice of 2-3 things - then have some time to do so, then all look at each others' work. T. Rowe Price
Senior Admin And Office Coordinator Maria Rojas Presentation Skills Very useful and Andrew was marvelous. Ofgem
Energy Efficiency And Social Programs Assistant Manager Anthony Dean Excel VBA Introduction I think the course was good, with an enthusiastic, knowledgeable and helpful person delivering the course. However, I think each task of creating macros would have benefited from more explanation of what the macro is trying to do and why we are doing it, to better help us understand what we are trying to achieve. I also think more time to make macros yourself from scratch would have been good. Pace slightly too fast perhaps and course could be made longer than one day. Overall course was useful though. |
PUBLICATION GUIDELINES