Excel at Sipping Coffee with the Spreadsheet Shortcut Mug

I like to think I’m pretty adept at Microsoft Excel.  Whenever I show some neophyte how to use a Pivot Table, I feel like a spreadsheet god. Despite my skills at manipulating rows, columns, formulas, and macros, I don’t have all the Excel keyboard shortcuts memorized. I mean sure, I’m a master of Copy, Paste, and Undo, but after those, I don’t remember most of them. Now, every time I go to take a sip of hot coffee, I can brush up on my spreadsheet shortcut knowledge.

Firebox sells this Excel Shortcut Mug which lists a number of the available keyboard shortcut sequences for Excel, including classics like “Ctrl Shift +” and “Alt F1.” I had no idea that you could copy a value from the cell above with “Ctrl Shift Quote.” Heck, I’m already smarter and I haven’t even bought this thing yet. Next stop, creating complicated and abstruse financial models that make venture capitalists throw fat stacks of cash at me.

Like all ceramic computer reference materials, the Excel Shortcut Mug holds 12 oz. of your favorite hot or cold beverage and is dishwasher and microwave safe. You can grab one for your desk today over at Firebox for just $11.

 

An Excel error may have led England to under-report COVID-19 cases

A day after the UK government announced its highest number of new coronavirus cases in England, the reason behind the drastic rise has reportedly been revealed. According to multiple sources, a Microsoft Excel spreadsheet containing laboratory result...

I Love Spreadsheets Mug Is for Digital Masochists

When I worked in the corporate world, I think my time was equally split between sitting in mindless, unnecessary meetings and staring at massive spreadsheets. While I consider myself to now be an expert at manipulating PivotTables and complex Excel macros, I by no means love spreadsheets. It’s just something I learned in order to get my job done. But I’m sure there are some people out there who see something like:

=INDEX(C3:E9,MATCH(B13,C3:C9,0),MATCH(B14,C3:E3,0))

…they get all warm and fuzzy inside. This coffee mug is for those people.

Simply pour your favorite hot beverage into the I Love Spreadsheets mug and it’ll calculate your undying love for endless grids of data – at least up to 65536 rows and columns. Whether you cut your teeth on Microsoft Excel, Google Sheets, or even good old Lotus 1-2-3, this mug is perfect for you. I’m dating myself, but the first spreadsheet I ever used was VisiCalc on an Apple II. Good times. No AutoSum or Conditional Formatting back then. We did our spreadsheets the old fashioned way!

This mug is the perfect gift formula for the accountant or business person on your shopping list. You can grab one over at Firebox for just $9.99, though according to the calculations on my spreadsheet, you’ll pay a bit more for it if you need it shipped to the U.S. from the U.K., which is where Firebox is based.

Someone made a version of ‘Civilization’ that runs in Microsoft Excel

Do you pine for the classic strategy games of the past? For a time when gameplay was more important than graphics? Are you looking to reproduce the Amiga experience at work, where your company blocks access to everything except Microsoft Office? Then...

Microsoft Excel can provide real-time stock data

You might use Excel to track your budget, but your investments? That's less likely when stock prices change from moment to moment. Now, though, you don't have to think much about it. Microsoft has teamed with Nasdaq and market info provider Refini...

XCOM Fan Game Being Made in Excel: EXLCOM

Last year we saw The Legend of Zelda: Link’s Awakening partially ported to Microsoft Excel using Visual Basic for Applications (VBA). Redditor crruzi is also using VBA and Excel to make his own XCOM game.

xcom_microsoft_excel_exlcom_by_crruzi_1zoom in

Crruzi says he just learned to use VBA for work and is making EXLCOM to sharpen his skills. EXLCOM takes place “between the events of XCOM:EW and XCOM 2, where a group of guerilla fighters try to liberate their city from ADVENT control.” Don’t expect 3D graphics here. EXLCOM’s graphical interface is closer to a tabletop RPG than a video game. That said, crruzi is implementing class skills, terrain effects and even a variety of weapons and equipment.

EXLCOM Screenshots

You can download a test build of EXLCOM here. It’s still in alpha though; crruzi has finished only the battle system and even then it’s bound to have bugs.

[via Polygon]

LibreOffice kicks it up to version 4.0, promises leaner performance and greater interoperability

DNP LibreOffice kicks it up to version 40, promises leaner performance, greater interoperability

It's been a little over a week since Microsoft unveiled its big Office 2013 suite (along with that Office 365 subscription option) to the world, and right on cue the Document Foundation has released version 4.0 of open source alternative LibreOffice. The latest update promises to be cleaner and leaner according to devs, but more importantly to you and me is that it brings greater interoperability between different file formats such as DocX and RTF documents. It also integrates better with content and document systems like Alfresco, IBM FileNet P8, OpenText and Microsoft Sharepoint 2010. Other notable improvements include an Android app for controlling presentations, several new features to the Calc spreadsheet app (like chart exports and ODF OpenFormula functions), UI upgrades and a performance boost across the board. For a full run-down on what the new LibreOffice can do, have a gander at the source or download it yourself at the rightmost link.

Filed under:

Comments

Source: The Document Foundation Blog, LibreOffice 4.0

Stop-motion music video relies on OpenOffice and Excel, finds formula for success (video)

Mystery Guitar Man makes stopmotion music video in OpenOffice, finds a real formula for success video

It's already considered a grind to produce stop-motion video -- imagine creating a clip using the spreadsheet app that many dread seeing at work every morning. Joe Penna, better known to the internet as Mystery Guitar Man, isn't afraid. He and his team recorded a performance against a greenscreen, gave the video a mosaic look in After Effects and proceeded to recreate 730 of the frames in OpenOffice (and occasionally Excel)... by hand. We don't want to know how long it took Penna and crew to wrap up their work, but the result is probably the liveliest you'll ever get out of an app meant for invoices and corporate expenses. The fully produced video is above; click past the story break if you want to smash illusions and see how the pixelated rumba came to be.

Continue reading Stop-motion music video relies on OpenOffice and Excel, finds formula for success (video)

Filed under: ,

Stop-motion music video relies on OpenOffice and Excel, finds formula for success (video) originally appeared on Engadget on Sat, 11 Aug 2012 04:42:00 EDT. Please see our terms for use of feeds.

Permalink Microsoft News (Twitter, pulled)  |  sourceMystery Guitar Man (YouTube)  | Email this | Comments