If you’re looking for help with Microsoft Excel, look no further. TechRepublic’s Excel TechMail is what you’ve been searching for. This useful message, sent straight to your inbox each weekday, is packed with valuable information that can save you time and effort. To give you a taste of what the Excel TechMail has to offer, we’ve complied a list of 50 great Excel tips, which you can download by clicking here. Below, you’ll find two examples of what the Excel TechMail and our 50 essential Excel tips download have to offer.
Get valuable tips on creating tables, formatting pages, links to Word resources, and much more, all delivered straight to your inbox every weekday. Best of all, it’s absolutely free. Sign up for the Excel TechMail today!
Easy data-posting to the Web
If your organization is using an intranet to share public data—and whose organization isn't these days—your users will want an easy way to post this information. Excel 97 offers an easy, wizard-driven system to walk even the most apprehensive users through this process:
- Select the cell range that contains the data to be published.
- Select Save As HTML from the File menu.
- Answer the questions posed by the Internet Assistant Wizard.
The wizard walks users through four steps that define how information will be converted for Web display. Various options include:
- Inserting the resulting HTML tables into an existing HTML page, or creating an entirely new page.
- Specifying format options, such as rules between data.
- Saving your new HTML page as a freestanding file or inserting it directly into a FrontPage Web.
Faster access to worksheets
When working with large workbooks in which all of the worksheet tabs are not visible, your users probably get frustrated with scrolling to find the sheet they need. Here's a really quick tip to pass on. Right-click on any of the tab-scrolling buttons (to the left of the sheet tabs), and a shortcut menu will pop up. You can then select the tab you want.
Download our 50 essential Excel tips
You can download our essential Excel tips by following this link or by clicking on the Downloads link in the navigation bar on the top of this page. TechRepublic has many useful documents, templates, and applications available for download, so be sure to check out our other offerings.
Our 50 essential Excel tips download is available both as a Microsoft Word document and an Adobe PDF file. To increase download speed, we have zipped these two files together into one file named excel_tips.zip. You will need an unzip utility such as WinZip or PKZIP to expand the zipped file. You will also need either Microsoft Word or the Adobe Acrobat Reader to view each respective document. You can download the Adobe Acrobat Reader here.
Tell us what you think about this download. We'd like to hear your comments and suggestions, so send us an e-mail.
Bill Detwiler has nothing to disclose. He doesn't hold investments in the technology companies he covers.
Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop support specialist in the social research and energy industries. He has bachelor's and master's degrees from the University of Louisville, where he has also lectured on computer crime and crime prevention.