Please go to the new and improved web page to get your workbookshttp://markmoorebooks.com/book/mastering-excel-macros-introduction-book-1/
Genesis-Posts
20 Excel Tips for Becoming a Spreadsheet Pro
Quick tips from PC magazine!
http://www.pcmag.com/slideshow/story/327311/20-excel-tips-for-becoming-a-spreadsheet-pro
The Legend of Zelda – In Excel
Here’s another game made in Excel: Excelda!
And here is an article talking about the game and it also has a link where you can download it.
Excelda Article
6 Games Made Entirely in Excel
Now this is pretty creative. This goes to show you how powerful Excel and it’s programming language (VBA) are.
2048: You need to combine tiles to eventually get one that equals 2048
Candy Number Crunch Saga: Not like the similarly named game, but instead a stock trading simulator
Monopoly: The classic game, in Excel
3D Maze: For those days when you feel mired in the rate race
Arena.xlsm: Dungeons & Dragons game
Writer’s Block: Scrabble meets battelship
You can check them out here: http://mashable.com/2014/08/27/microsoft-excel-games/
3 Microsoft Excel Functions Certain To Make Your Company More Productive
I wanted to share this short article talking about three Excel functions that will help you at work.
I was surprised that Conditional Formatting was there and that I did write a lesson on that very topic. The CountIF, AverageIF and all the other conditional functions are super useful to extract information from unorganized data. Paste Special I use every day and I haven’t really covered that in depth. However, I’m not sure there’s enough material to warrant an entire lesson on it.
Here is the article: 3 Microsoft Excel Functions Certain To Make Your Company More Productive
Office 365 and OneDrive
The new Microsoft Office has two purchasing options, you can buy the software outright (as usual) or you can buy Office365 for a monthly fee. Basically, Office 365 if Office (Word, Powerpoint, Excel, etc.) on the cloud. You can install office on your PC, laptop, smartphone, tablet, etc. Well, you aren’t really installing Office. You are installing a program that you can connect through the internet and get to Excel. In essence, Excel is stored in the internet and you can get to it from any device you own.
For people who don’t want to deal with Office upgrades, the yearly fee might be a good choice.
More info here: http://office.microsoft.com/en-us/products/compare-microsoft-office-products-FX104165233.aspx
Files for Office 365 are stored on OneDrive. This is a service like Dropbox. If you haven’t heard of either one, they are folders that look like they are on your pc/laptop/phone/tablet but they are really on the web. The folder can be accessed from any device; it acts as a central storage place where you can always have access to your files (Excel, Word, Powerpoint, pictures etc.). Note that you can use OneDrive with Office 2013 and/or Office365.
The new newsworthy item is that for Office 365 users, Microsoft has agreed to give a free 1 Terabyte of data, everyone else gets 15 Gb. OK trust me on this…1 Terabyte is a HUGE amount of space.
Here is more info on this change from PCWorld.com: http://www.pcworld.com/article/2365911/onedrive-goes-to-a-terabyte.html