What's going on libsyn?
Here are the 99 most recent episodes published tagged technology.
^ return to full directory
Hamilton sends in a question about parsing data that has
leader......lines between the columns. This ends up being trickier than
you might think. Episode 782 shows you how I approached the problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video ...
Published on: 2008-06-17 09:00:00
Subscribe: 
| 
RSS
| RSSColumn I is sparsely filled in with product codes. You would like a
macro to copy only the non-blank cells to a new column. It turns out
that the macro recorder can actually reliably perform this task. Episode 779 will show you how.This blog is the video podcast companion to the book, ...
Published on: 2008-06-12 09:00:00
Subscribe: | RSS
| RSSOne of my favorite tricks is to fill a textbox with the result of a
formula in the worksheet. When you try this as the title in an embedded
chart, you need to change the formula to point back to the original
worksheet. Episode 778 shows you how.This blog is the video podcast ...
Published on: 2008-06-11 09:00:00
Subscribe: | RSS
| RSSTo enhance the chart from Episode 776, I'll use option buttons on the worksheet from the Forms toolbar. Episode 777 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of ...
Published on: 2008-06-10 09:00:00
Subscribe: | RSS
| RSSLucy asks how to make a chart interactively change from red to yellow to green based on an external selection. In today's Episode 776,
we take a look at the basics of setting up such a chart. Tomorrow's
episode will take a look at the Options button on the Form toolbar to
enhance ...
Published on: 2008-06-09 09:00:00
Subscribe: | RSS
| RSSIn Excel 2003, there is a cool button lurking in the Forms toolbar.
This button gives you one click access to show/hide gridlines. I am not
a big fan of hiding gridlines, but when it is only one click away, I
find myself actually doing so. Also, another tip about using PgDn and
PgUp ...
Published on: 2008-06-06 09:00:00
Subscribe: | RSS
| RSSYou are printing a multi-sheet workbook which is mostly portrait. In
the middle, one worksheet needs to be landscape. You would like the
page number to appear at the bottom of the portrait page like all of
the other page numbers in the document. Episode 772 will show you the steps required to ...
Published on: 2008-06-03 09:00:00
Subscribe: | RSS
| RSSTelling red cells from green cells in Excel is difficult for those suffering from color blindness. In Episode 771, I take a look at a macro that will show the text name of the color in the status bar for any selected cell.This blog is the video podcast companion to ...
Published on: 2008-06-02 09:00:00
Subscribe: | RSS
| RSSChart a moving average in Excel. Episode 770 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Published on: 2008-05-30 09:00:00
Subscribe: | RSS
| RSSEpisode 769
looks at the difficult variations on yesterday's podcast; how do you
set up an IF statement that will only be true if two conditions are
true? This episode will look at using OR, AND, NOT within the logical
test of the IF function.This blog is the video podcast companion to the book, ...
Published on: 2008-05-29 09:00:00
Subscribe: | RSS
| RSS
Questions for Consideration:How do you learn new skills? Are you a paper and pencil learner?Do you have the confidence to muck around in messy trial and error learning?Are you about following rules? or Are you about creating rules?Related Websites: Robotics LinksContact: Rodd Lucier via thecleversheep@gmail.comContinue the discussion: http://thecleversheep.com
Published on: 2008-05-29 07:50:00
Subscribe: | RSS
| RSSHow do you deal with many levels in an IF statement? Episode 768 discusses nesting IF statements.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Published on: 2008-05-28 09:00:00
Subscribe: | RSS
| RSSQuestions for Consideration:Have you witnessed educators struggling with computer basics?What simple things have thrown you for a loop in using your computer?Why after having computers in our lives for so long, are basic computer skills still such a barrier to educators?Is this more discouraging than it should be, or should ...
Published on: 2008-05-28 08:08:00
Subscribe: | RSS
| RSS
This week Greg, Chris, and Keith discuss spindles, disk imaging, Secunia PSI (Personal Software Inspector), Twitter, Teletwitter, Twhirl, the movies, and much much more...
Get the complete show notes at:
DGPodcast.com
Published on: 2008-05-27 23:24:00
Subscribe: | RSS
| RSSA question asks how to avoid #VALUE errors when a formula refers to a cell with a blank text value. In Episode 767,
I will take a look at how these blank cells come to be, how to work
around the #VALUE error and even a different approach to prevent the
root cause ...
Published on: 2008-05-27 09:00:00
Subscribe: | RSS
| RSS
A convenient function of iChat is the ability to send and receive files with the person that you are chatting with. Sharing a document, photo or other files is quick and easy with a simple drag 'n drop.
Published on: 2008-05-26 03:00:00
Subscribe: | RSS
| RSS
This week Lando and I are putting out a short show talking about technology in th workplace. Where does the responsibility lie in a company when it comes to adopting technology and making sure the workers are able to use it? Who makes the decisions on when something like a ...
Published on: 2008-05-25 10:00:00
Subscribe: | RSS
| RSSYou might already know these, but I recently was shown a few cool shortcuts for inserting rows, columns, or cells. Episode 765 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn ...
Published on: 2008-05-23 09:00:00
Subscribe: | RSS
| RSSThe Freeze Panes command allows you to always see certain rows at the top of your worksheet. In Episode 764, I will show you how to use Freeze Panes to always see certain columns as well.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. ...
Published on: 2008-05-22 09:00:00
Subscribe: | RSS
| RSSNow that you have iChat set up with an account (see segment #19) you need to add your buddies. Learn how to add your buddy who uses the AOL Instant Messenger service AIM, or a fellow .Mac member. In 720p High Definition.
Published on: 2008-05-22 03:00:00
Subscribe: | RSS
| RSS
Homepage
Shownotes
Facebook
Twitter
E-Mail
uStream.TV
SheetMusicPlus.com
If you need sheet music use the search button at http://edtechmusician.libsyn.com
to find all kinds of great stuff.
Too Little, Too Late In Columbus?
Honda Robot Makes Podium Debut
Jazz Educators' Association In BankruptcyDo Food And Music Live Together In The Brain? Ants
swarm over Houston area, fouling electronicsPhones
Faltering, Quake Survivors Rely on ...
Published on: 2008-05-21 21:37:00
Subscribe: | RSS
| RSSWhen you use Tools, Protect Worksheet, all of the cells become
protected. How can you protect only a portion of the worksheet? In Episode 763, we take a look at this problem and protect only the formulas in a worksheet. This blog is the video podcast companion to the book, Learn Excel ...
Published on: 2008-05-21 09:00:00
Subscribe: | RSS
| RSS
I have an aptitude or a nose for technology. So much so that I've
been slowly weaning myself off of older communication methods and
focusing on using only email, iChat, blogging and Twitter to contact
people.
OK, that list seems like it's pretty complete and would cover the majority of people. Not so.
If you're ...
Published on: 2008-05-20 18:05:00
Subscribe: | RSS
| RSSA combination of six cool tricks allows you to take detailed
transactional data and produce a chart of the top five customers in
about 12 clicks. Episode 762 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every ...
Published on: 2008-05-20 09:00:00
Subscribe: | RSS
| RSSIn Episode 761,
a look at three cool custom icons you can add to your toolbar in Excel
2007 or 2003. See how easy it is to use Select Current Region, Select
Visible Cells, and Set Print Area.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download ...
Published on: 2008-05-19 09:00:00
Subscribe: | RSS
| RSSichat is the handy little instant messaging application that Apple includes on your Mac. It is capable of so much more - video conferencing, file sharing, etc. However, the first step to taking advantage of iChat is getting it set up which is exactly what we will focus on in ...
Published on: 2008-05-19 03:00:00
Subscribe: | RSS
| RSSWhile it might seem minor, folks with a windows background need to remember to "Quit" out of Macintosh applications and not simply close the window. Leaving applications open that you intended to quit uses memory on your computer and can make things run slower. Yet another episode in stunning ...
Published on: 2008-05-18 03:00:00
Subscribe: | RSS
| RSSHow can you calculate the MIN or MAX value ignoring one outlier? Or,
how can you figure out the MIN or MAX throwing out 5% of the outliers? Episode 760 takes a look at SMALL, LARGE, and PERCENTILE functions.This blog is the video podcast companion to the book, Learn Excel 97-2007 ...
Published on: 2008-05-16 09:00:00
Subscribe: | RSS
| RSS
Edition #1The virgin edition production notesThe first one’s are always the hardest, aren’t they? On the 24th of April, we finally sat down to record the very first edition of the SACM Switched On Podcast, sponsored by Leaf…you know, the guys that do HTC in South Africa.In this edition, recorded ...
Published on: 2008-05-16 05:29:00
Subscribe: | RSS
| RSSThere is a way to set the default border color that is used when you use the Borders dropdown. Episode 759 shows you how. Also, a look at the new Podcast DVD.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two ...
Published on: 2008-05-15 09:00:00
Subscribe: | RSS
| RSSA special place called the "Dashboard" exists on your Macintosh, where you can use mini-applications designed for specific functions (weather, sports, calculator, movie show times). This segment explores several aspects of the Dashboard - how to activate it, adding new widgets, removing widgets, downloading widgets from the web.
Published on: 2008-05-15 03:00:00
Subscribe: | RSS
| RSSCan you use a pivot table to measure how many unique combinations of
customer and product appear in a data set? Well, you can't do it
natively, but in Episode 758,
we take a look at a formula such as
=IF(SUMPRODUCT(($B$2:$B2=B2)*($D$2:$D2=D2))>1,0,1) which will allow
the calculation to work. Also - a look at the Amazon ...
Published on: 2008-05-14 09:00:00
Subscribe: | RSS
| RSSThis week Chris, Greg, and Keith talk about the SNW conference, Going Green, Windows Vista, Remote control with TeamViewer, and more.
Get the complete show notes and all the links at:
http://www.DGPodcast.com
Published on: 2008-05-13 23:36:00
Subscribe: | RSS
| RSSMichael asks how to calculate a sliding commission rate. Episode 757 shows two approaches, both of which use the sorted version of VLOOKUP.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the ...
Published on: 2008-05-13 09:00:00
Subscribe: | RSS
| RSS
Interview with Herricks New York School District Superintendent
Dr. Jack Bierwirth
Urban Education and Difficult Decisions
Episode 14 Dr. Jack Bierwirth [26:31m]: Play Now | Play in Popup | Download (1)
<!--
podPressShowHidePlayer('1', 'http://www.districtleaderspodcast.org/wordpress/podpress_trac/play/53/0/DistrictLeadersPodcast-ep14-JB.mp3',300,30, 'nopreview', 'http://www.districtleaderspodcast.org/wordpress/wp-content/plugins/podpress//images/vpreview_center.png');
-->
Key Topics include: ...
Published on: 2008-05-12 12:02:00
Subscribe: | RSS
| RSSA question from a recent seminar involved calculating how many unused
meals occurred during a month. The person had to rewrite several
formulas every month depending on the total number of days in the
month. In Episode 756, we'll take a look at some changes to allow that formula to work for every ...
Published on: 2008-05-12 09:00:00
Subscribe: | RSS
| RSSIf you every needed a copyright symbol, an accent on a letter or some other special symbol in something that you were writing then this segment is for you. Use of a "Special Characters" menu can solve all your needs for special characters, symbols, and accents. This segment is in ...
Published on: 2008-05-12 03:00:00
Subscribe: | RSS
| RSSYou need to sort a detailed data set so that the records for the largest customer are at the top. Episode 755 will show you a quick way to accomplish this task. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two ...
Published on: 2008-05-09 09:00:00
Subscribe: | RSS
| RSSRene from Norway asks how to modify the code from podcast 730 in order to create a new workbook for every department. Episode 754 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to ...
Published on: 2008-05-08 09:00:00
Subscribe: | RSS
| RSSCustomizing your computing experience is a quick way to make the Mac feel more homey. This segment came from a viewer question about inserting different icons for files and folders. It is a simple process for anyone who wants to create their own unique look. This segment is in 1280x720 ...
Published on: 2008-05-08 03:00:00
Subscribe: | RSS
| RSS
Homepage
Shownotes
Facebook
Twitter
E-Mail
uStream.TV
SheetMusicPlus.com
Muti Named To Lead Chicago Symphony
Orchestras As A Danger To HearingWhat the
ASCAP music decision means for consumers
"Free" Music, Ad Supported
Debate: Where Should The Violins Sit? Metallica May Follow In Footsteps of Radiohead, NIN -
Slashdot
The
iMac Cometh
Adobe move makes Flash more mobile
Microsoft and Yahoo: Now What?
Microsoft Backpedals on Windows Updates
Study: Creativity ...
Published on: 2008-05-07 23:48:00
Subscribe: | RSS
| RSS
This week Byte Into It is hosted by resident Gaming Guru Mike Bantick who is joined by show favourite, Linux master Ed Borland, making his long awaited return to the show for 2008. They discuss the latest news and updates on all things IT and New Tech.
Check out the ...
Published on: 2008-05-07 19:00:00
Subscribe: | RSS
| RSSWhen Romas sent in the question for podcast 751, I couldn't tell from
the screenshot if his data actually was date/time or text that looked
like a date/time. In Episode 753,
I take a look at how to tell if the cell contains a date or something
that looks like a date. You will ...
Published on: 2008-05-07 09:00:00
Subscribe: | RSS
| RSSThis week Keith and Greg talk about Skyfire, HoverSnap, Virtualization, the 13th Apostle and much much more…
Get the complete show notes and all the links at:
http://www.DGPodcast.com
Published on: 2008-05-06 23:35:00
Subscribe: | RSS
| RSSIn today's podcast, we take a look at breaking Romas' date/time column into a date column using the INT function. Episode 752 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one ...
Published on: 2008-05-06 09:00:00
Subscribe: | RSS
| RSSRomas has data with both date and time in column A...but needs to summarize the data by date. In Episode 751, we take a look at using a pivot table to solve this problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a ...
Published on: 2008-05-05 09:00:00
Subscribe: | RSS
| RSSCreate your own collapsable folders in the Dock for quick access to favorite files/folders/applications. Not only are these folders are great short cuts, you can also customize the presentation in a fan, grid or list mode. This segment is in 1280x720 High Definition.
Published on: 2008-05-05 03:00:00
Subscribe: | RSS
| RSSDo you need to transfer custom lists and other settings from one Office
installation to another computer? The Save My Settings wizard will make
this a snap. Episode 750 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute ...
Published on: 2008-05-02 09:00:00
Subscribe: | RSS
| RSSRob has a spreadsheet showing install dates for several batteries. He
needs to sum all of the batteries that are overdue for being replaced.
This requires a tricky variation of the SUMIF formula. Episode 749 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. ...
Published on: 2008-05-01 09:00:00
Subscribe: | RSS
| RSSTerry called in with a question where she wanted to use a pivot table
to show text fields from a database. While this question initially
threw me for a loop, we did end up with a workable pivot table that
showed off text. Episode 748 shows you how.This blog is the video podcast ...
Published on: 2008-04-30 09:00:00
Subscribe: | RSS
| RSSLucy sends in a question. She has built a table of sales by rep by day.
She used the MAX and MIN function to find the largest and smallest
value. However, her boss then wants her to identify who had the largest
and smallest value. This requires the use of INDEX, MATCH, and ...
Published on: 2008-04-29 09:00:00
Subscribe: | RSS
| RSSJon has designed a worksheet in Excel that he wants others to use.
However, he does not want them to realize they are using Excel. How can
he obscure the fact that we are in Excel? Episode 746 will show you how.This blog is the video podcast companion to the book, Learn ...
Published on: 2008-04-28 09:00:00
Subscribe: | RSS
| RSS
In this weeks episode of the Tupelo Catholic we discuss old Macs and new, the Pope's recent trip to the US, the Atlanta Eucharistic Congress & the Catholic New Media Celebration, lots of audio feedback, and we discuss the no TV for 2 weeks challenge as mentioned by Greg & ...
Published on: 2008-04-27 20:36:00
Subscribe: | RSS
| RSS
Jamie Stratton, second year student, New York Medical College (NYMC), based in Westchester County, New York, discusses her path from high school in West Bloomfield, Michigan to studying biology at Johns Hopkins University in Baltimore, Maryland. Following graduation she talks about her transition to work at a Cornell Weil Medical ...
Published on: 2008-04-26 20:00:00
Subscribe: | RSS
| RSS If you want the macro from episode 744 to always be available, you can save it as an add-in and install the add-in. Episode 745 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every ...
Published on: 2008-04-25 09:00:00
Subscribe: | RSS
| RSS
Featured Guest: Josh Bernoff, coauthor of Groundswell: Winning in a World Transformed by Social Technologies.
Copyright 2008 Harvard Business School Publishing
Published on: 2008-04-24 11:38:00
Subscribe: | RSS
| RSS
Featured Guest: Josh Bernoff, coauthor of Groundswell: Winning in a World Transformed by Social Technologies.
Copyright 2008 Harvard Business School Publishing
Published on: 2008-04-24 11:30:00
Subscribe: | RSS
| RSSContinuing the information from podcasts 742 and 743, I record a simple
macro today to open the Invoice.xlt file and then add a couple lines of
code to update the invoice number and the date. Episode 744 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 ...
Published on: 2008-04-24 09:00:00
Subscribe: | RSS
| RSS
Get that old computer up and running and donate some electricity for a good cause.
Published on: 2008-04-24 03:13:00
Subscribe: | RSS
| RSS
HomepageFacebookTwitterE-MailuStream.TV
Apple becomes America's top music retailer
Tenor Peels Off 18 High C's To Standing Ovations At Met
Opera
Ohio Brass Arts
Festival
New York Philharmonic: School Days, School Days…
Now Starring: Technology
Purdue Made It! Its Burger Machine Wins Rube Goldberg
Contest
FCC greenlights text-message emergency alert system
Ballmer: Vista - A Work In Progress, But Bigger Than XP
Guitar ...
Published on: 2008-04-23 21:47:00
Subscribe: | RSS
| RSSContinuing the series from podcast 742, once you've downloaded and
customized the invoice from Office Online, learn how to save it as a
template and add it to the New Workbook task pane. Episode 743 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. ...
Published on: 2008-04-23 09:00:00
Subscribe: | RSS
| RSSRather than create an invoice worksheet from scratch, download a free one from Office Online. Episode 742 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips ...
Published on: 2008-04-22 09:00:00
Subscribe: | RSS
| RSS
Cory Doctorow joins us to discuss his new book, Little Brother. We also delve into Homeland Security's pitfalls, and how people can use technology to change the world. Then we introduce the Out of the Slush segment, featuring Greg Van Eekhout.
Published on: 2008-04-21 13:58:00
Subscribe: | RSS
| RSSDaniel from Quebec sends in a better way to compare columns using GoTo Special Column Differences. Episode 741 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips ...
Published on: 2008-04-21 09:00:00
Subscribe: | RSS
| RSSJerry from Georgia sends in a great alternate solution to podcast 730,
inserting one worksheet per customer. Gerry uses the Show Pages feature
of pivot tables. Episode 740 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every ...
Published on: 2008-04-18 09:00:00
Subscribe: | RSS
| RSS
What's in a name? When it comes to 'Ubuntu', a whole lot. Ubuntu means "humanity to others" in some African cultures, but it's also the name of an computer operating system that is bringing people together, as well as a larger movement to change the way people interact with technology.In ...
Published on: 2008-04-17 09:59:00
Subscribe: | RSS
| RSS