Entries tagged with excel - Channel 10

AC/DC 's Rock n' Roll Train Music Video,.. in Excel!??

Nic — Fri, 24 Oct 2008 21:21:00 GMT

Yep - AC/DC's first new studio album in eight years - Black Ice - is now out and to celebrate some clever fan has converted the music video for Rock n' Roll Train into ASCII format and stuck it in an excel spreadsheet!

What the video here or download and run the XLS yourself!

Link: http://www.acdcrocks.com/excel/

Word and Excel Docs Can Now Be Added To Slideshare

sarahintampa — Thu, 16 Oct 2008 16:31:00 GMT

Slideshare is a popular website that made sharing PowerPoint presentations (and PDFs) easy. Recently, the site added a new feature: support for Microsoft Word and Excel files. The move was likely due to Slideshare’s competition from sites like Scribd, DocStoc, Zoho Share, and others. If you’re wondering what the difference is between all these sites and the services they offer, I have to point you over to the Digital Inspiration site, where the news broke. There, blogger Amit Agarwal has put together handy charts for your reference which compare the features, file size limits, viewer sizes, among other things. He even compares the traffic of the sites – a comparison which shows Slideshare has a lot of catching up to do if they want to compete with Scribd!

Save Your Spreadsheets With Autobackup

sarahintampa — Fri, 05 Sep 2008 15:26:00 GMT

I can’t tell you how many times I was asked this question when I worked in I.T.: “I accidentally just closed my spreadsheet and said NO to saving my changes…is it gone?” For whatever reason, some people’s fingers slip from time to time and the wrong button gets mashed. The shadow copies feature introduced in XP (aka “previous versions” in Vista) helped to some extent as does the AutoSave feature in Office. However, if you’re working with a spreadsheet undergoing a lot of revisions, what you might like even better is a tool that took periodic snapshots of the file at intervals you specify, allowing you to restore the spreadsheet to any particular moment in time.

As it turns out, there is a tool that does just that. I recently came across a review of it over on gHacks. The tool is an Excel plugin called Autobackup. With Autobackup installed, you can specify how often you want your spreadsheet backed up, how many copies it should save, and how long those copies should be saved (in days). Installation is simple – just got to Tools –> Add-ins and browse for the Autobackup file. Autobackup is available as a free download from here. An English and Portuguese version are available.

5 Microsoft Office Ribbon Tweaks You May Not Have Known

sarahintampa — Mon, 30 Jun 2008 13:19:00 GMT

Thanks to some internal emails that were going around recently, we’ve discovered some great Microsoft Office ribbon tweaks, tips, and customizations. I’ll confess, I hadn’t known about all of these, but they certainly are handy:

Hide the Ribbon: To hide the ribbon out of view leaving only the tab names showing, just double-click on any tab’s name.
Customize the Quick Access Toolbar: By default, the Quick Access Toolbar has the “Save,” “Undo,” and “Redo” buttons on it, but you can change that. To do so, go to any tab and right-click on the little pull-down menu symbol next to the window title on any Ribbon app. Here, you have the option to click on “Customize Quick Access Toolbar.” From the menu that displays, you can add and remove commands from the Quick Access Toolbar to suit your preferences. Add your most frequently used commands and you can hide the ribbon to get more screen real estate without losing access to the commands you use the most.
Find Hidden Commands: Because the Ribbon is meant to bring more simplicity to working with Office software, there are some infrequently used commands that are not available on the ribbon or are just harder to find. To bring these back into view, follow the steps above in #2 to customize the Quick Access Toolbar and you can get access to these commands once again. A couple examples of hidden commands include Excel’s pop-up calculator and PowerPoint’s Advanced Document Properties, which lets you see how big the file is.
Customize the Quick Access Toolbar on the Fly: No need to hunt down the little right-click menu, though, you can just right-click any command on the ribbon and choose “Add to Quick Access Toolbar.”
Scroll Through Tabs With a Mouse Wheel: If you have a mouse with a wheel, you can scroll through the tabs if the cursor is over the Ribbon – very useful for quick switching.

We would like to thank both Steven Levy and Alex Babanov for these great tips!

What can you do with Excel?

Larry — Fri, 02 Nov 2007 19:01:00 GMT

Jeff Sandquist has been sending me these links about the crazy things you can do with Excel besides... well, Excel stuff. This is certainly no replacement for an Xbox 360, but count me impressed.

Excel Music Synthesizer - EMS allows you to use Excel as a full music synthesizer. Just plot your notes on the staff in your spreadsheet, pick and instrument and hit play. The 92k Excel template comes with four songs; Amazing Grace, Pachabel's Canon, Twinkle Twinkle Little Star and the Star Spangled Banner.

Excel Pac-Man & Space Invaders - Also available for the Excel console system - Pac Man and a 192k version of Space Invaders.

ExcelGames.org - There is actually a domain that hosts a number of different Excel games including Battleship, Bejeweled, Berulex, Blackjack, Breakout, BubbleCell, Connect 4, Golf Stats, Mastermind, Maze, Minesweeper, Numbers Game, Reversi, Rubix, Square Poker, Stones of Power, Sudoku Solver, Tetris, TexTwisT, and Video Poker.

Export Facebook to Excel with FriendCSV

Larry — Wed, 24 Oct 2007 08:53:00 GMT

If you're a Facebook fan, don't miss this page on TechCrunch. FriendCSV is a way to export the information from your friends list in Facebook to a comma-separated values file that can then be opened in Excel. Once you log into Facebook and fill in your email address, FriendCSV will scrape the data you've selected and mail it to you (keep in mind it violates the Facebook TOS if it is stored for more than 24 hours.) Available fields; uid, name, sex, birthday, about me, current location, hometown, profile link, picture link, high school, education, work, and affiliations.

Another interesting Facebook app mentioned in the comments, called Fonebook, will export your Facebook friends list to Contacts in Outlook 2003 or 2007. Then when you sync your phone to your computer, it also syncs your Facebook friends to your mobile phone.

Office 2007 - Excel

Tina — Wed, 28 Feb 2007 00:59:00 GMT

Mor Hezi, the senior product manager for Microsoft Excel stops by to sum it all up for us. Ha, ha, okay that was so bad. But seriously people the new Excel is so much easier to use. With the Microsoft Office Excel 2007 Home Tab on the new user interface, you can immediately view the most important cell-editing, formatting, and navigation tools. You no longer have to hunt for the menu to quickly format the appearance of a cell or filter your data. Watch this video and then go get your pivot table on.