Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Typing the same, long word over and over in a report? Use autocorrect to enable a shortcut. Episode 135 will show you how.
posted by Bill at 9:00 AM
Stop Excel from autocorrecting certain words. Episode 134 will show you how.
posted by Bill at 9:00 AM
Quickly copy a formula to all cells in a row. Then learn how to switch data entered horizontally to vertically by turning it on is side. Episode 133 will show you how.
posted by Bill at 9:00 AM
Quickly copy a formula to all rows of data. Have you ever tried to copy a formula to 5,817 rows of data, only to have a scroll utility go flying past row 6,000? There is a better way! Today, you will visit Dr. Phil...(I mean Dr. Fill Handle) to learn the amazing trick for solving this problem. When I do any seminar, I can guarantee that this is the one trick which most people don't know and everyone absolutely loves. Episode 132 will show you how.
posted by Bill at 9:00 AM
Learn how to use the customize dialog box to reset your toolbar to original settings. Episode 131
posted by Bill at 9:00 AM
Create a totally new toolbar customized with the icons you use regularly. Episode 130 will show you how.
posted by Bill at 9:00 AM
There is a lot of power in the various PasteSpecial options. Learn how to utilize this feature without ever touching the PasteSpecial dialog. Episode 129 will show you how.
posted by Bill at 9:00 AM
Create an easy to use menu by inserting hyperlinks to sheets within your workbook to help others navigate thru data. Episode 128 will show you how.
posted by Bill at 9:00 AM
Spell check only specified region or text instead of the whole worksheet. Episode 127 will show you how.
posted by Bill at 9:00 AM
Use Excel as a word processor to properly format text added to reports. Episode 126 will show you how.
posted by Bill at 9:00 AM
Have Excel calculate Excel macros faster by installing an internet download of a laser jet printer driver. Episode 125 will show you how.
posted by Bill at 9:00 AM
Export Excel Data for Other Applications - Do you need to transfer your budget figures from Excel back to your company's accounting records. Episode 124 will walk you through the various methods of saving Excel data as a text file for use with other applications.
posted by Bill at 9:00 AM
Send Excel file via e-mail as an attachment directly from Excel. Episode 123 will show you how.
posted by Bill at 9:00 AM
Suppress the update links message alert box when sending a linked file to co-workers.
posted by Bill at 9:00 AM
Can't find a file? Use the file open command to sort by name, size, type, or date. Episode 121 will show you how.
posted by Bill at 9:00 AM
Open a copy of a workbook to make sure you don't accidentally overwrite the original file.
posted by Bill at 9:00 AM
Do you ALWAYS turn on "Page 1 of n" as your footer? Do you always set the print setup to fit to 1 page wide by (blank) pages tall? You can now customize these settings for every new workbook that you create. Episode 119 will show you how.
posted by Bill at 9:00 AM
Use a simple macro to further customize startup when opening a particular workbook. Episode 118 will show you how.
posted by Bill at 9:00 AM
Set up Excel icons to open a specific file on startup. Episode 117 will show you how.
posted by Bill at 9:00 AM
Have Excel always open certain workbooks. Episode 116 will show you how.
posted by Bill at 9:00 AM
Arrange windows to view two worksheets in an open workbook at the same time. Episode 115 will show you how.
posted by Bill at 9:00 AM
Arrange windows to see data from two or more open workbooks. Episode 114 will show you how.
posted by Bill at 9:00 AM
