Excel Gurus Gone Wild – Do the IMPOSSIBLE with Microsoft Excel

Posted on July 26th, 2009

Drawn from actual excel conundrums posted on the author’s website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL’s, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other questions have produced results that have even surprised the Excel development team
Read More ……

Tags: excel, gone, Gurus, Wild
Filed under E-books | No Comments »

Checkbook For Excel v5.2d

Posted on July 3rd, 2009

Checkbook For Excel v5.2d Regged-BLiZZARD
Checkbook for Excel is a full featured software application written for Microsoft Excel and is completely compatible with Excel 97/2000/XP/2003/2007. Checkbook for Excel retains the same intuitive yet powerful interface from the earlier versions and provides all the necessary features for managing your financial accounts and accounting ledgers without all the excess baggage and gratuitous advertising associated with the popular personal finance packages. This makes it faster and easier to use. Checkbook for Excel provides exactly what you need; a simple, powerful, easy way to track, maintain and balance your bank accounts, credit cards and other business and personal expenses

Tags: Checkbook, excel, for, v5.2d
Filed under Software | No Comments »

MS Press Microsoft Excel 2003 Programming Inside Out

Posted on June 28th, 2009

Product Description
Hey, you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of time-saving solutions, troubleshooting tips, and handy workarounds in concise, fast answer format. Work smarter with core functions such as using worksheets and charts, analyzing data, and creating databases—and quickly advance your expertise by building PivotTable reports, creating macros, using custom functions, and automating Microsoft Excel with Microsoft Visual Basic® for Applications. Also learn how to link and embed Excel data in other Microsoft Office applications, and how to capture, reuse, and share data by exploiting XML features. On the companion CD you get an eBook of Microsoft Office Excel 2003 Inside Out, along with Insider Extras from the authors, a trial version of the Spreadsheet Assistant add-on, a collection of Microsoft resources for learning about Office, a catalog of 3rd-party Excel resources, and two additional e-books: the Microsoft Computer Dictionary, Fifth Edition, and the Insider’s Guide to Microsoft Office OneNote 2003. With INSIDE OUT, you’ll discover the best and fastest ways to perform everyday tasks—and challenge yourself to new levels of Excel mastery!

Tags: 2003, excel, inside, microsoft, ms, out, Press, Programming
Filed under E-books | No Comments »

Learn Excel from Mr. Excel: 277 Excel Mysteries Solved

Posted on February 8th, 2009

learn excel
Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case