Bill Jelen eBooks

Get comfortable with the latest versions of Microsoft Excel, Microsoft Excel Starter, and the Excel Web App. Don't just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book, you get online access anywhere with a web connectionno books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you'll ever needwhere you want, when you want! learn fast, learn easy, using web, video, and audio Show Me video walks through tasks you've just got to seeincluding bonus advanced techniques Tell Me More audio delivers practical insights straight from the expe...

AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010's most powerful new features. Learning advanced ...

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the n...

This updated edition of Excel 2007 Miracles Made Easy features the amazing new upgrades offered in Excel 2010 and prepares users to transition to it. Covering only the revised components in Excel 2010, this manual shows how to navigate the ribbon interface and leverage the new business-intelligence tools within. With information on everything from using pivot tables tocalculating Texas Hold Em probabilities, this indispensable reference features instructions for utilizing all of thenew capabilities of Excel 2010....