If you think that getting creative with Excel means the underhanded tweaking of numbers, think again. Excel Hacks shows even the most experienced users how to do things with Excel they might never have thought of doing--and lets them have a little fun while they're at it.Microsoft Excel is not just the dominant spreadsheet in the world; it's also one of the most popular applications ever created. Its success lies not only in its power and flexibility, but also in its streamlined, familiar interface that casually conceals its considerable capabilities. You don't need to know everything that Excel can do in order to use it effectively, but if you're like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path.With this book, Excel power users can bring a hacker's creative approach to both common and uncommon Excel topics--"hackers" in this sense being those who like to tinker with technology to improve it. The "100 Industrial Strength Tips and Tools" in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language.This resourceful roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. Excel Hacks will help you increase productivity with Excel and give you hours of "hacking" enjoyment along the way.
A guide to online investing covers such topics as screening investments, using Excel for financial analysis, analyzing company information, executing trades, mutual fund investments, managing a portfolio, and financial planning.
Author: David Allen
Publisher: Piper ebooks
Release Date: 2015-05-20
Eigentlich sollte man längst bei einem Termin sein, doch dann klingelt das Handy und das E-Mail-Postfach quillt auch schon wieder über. Für Sport und Erholung bleibt immer weniger Zeit und am Ende resigniert man ausgebrannt, unproduktiv und völlig gestresst. Doch das muss nicht sein. Denn je entspannter wir sind, desto kreativer und produktiver werden wir. Mit David Allens einfacher und anwendungsorientierter Methode wird beides wieder möglich: effizient zu arbeiten und die Freude am Leben zurückzugewinnen.
Author: Michael Schmalz
Publisher: O'Reilly Media, Inc.
Release Date: 2006
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing "Integrating Excel and Access," the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to: Utilize the built in features of Access and Excel to access data Use VBA within Access or Excel to access data Build connection strings using ADO and DAO Automate Excel reports including formatting, functions, and page setup Write complex functions and queries with VBA Write simple and advanced queries with the Access GUI Produce pivot tables and charts with your data With "Integrating Excel and Access," you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.
Want to calculate the probability that an event will happen? Be able to spot fake data? Prove beyond doubt whether one thing causes another? Or learn to be a better gambler? You can do that and much more with 75 practical and fun hacks packed into Statistics Hacks. These cool tips, tricks, and mind-boggling solutions from the world of statistics, measurement, and research methods will not only amaze and entertain you, but will give you an advantage in several real-world situations-including business. This book is ideal for anyone who likes puzzles, brainteasers, games, gambling, magic tricks, and those who want to apply math and science to everyday circumstances. Several hacks in the first chapter alone-such as the "central limit theorem,", which allows you to know everything by knowing just a little-serve as sound approaches for marketing and other business objectives. Using the tools of inferential statistics, you can understand the way probability works, discover relationships, predict events with uncanny accuracy, and even make a little money with a well-placed wager here and there. Statistics Hacks presents useful techniques from statistics, educational and psychological measurement, and experimental research to help you solve a variety of problems in business, games, and life. You'll learn how to: Play smart when you play Texas Hold 'Em, blackjack, roulette, dice games, or even the lottery Design your own winnable bar bets to make money and amaze your friends Predict the outcomes of baseball games, know when to "go for two" in football, and anticipate the winners of other sporting events with surprising accuracy Demystify amazing coincidences and distinguish the truly random from the only seemingly random--even keep your iPod's "random" shuffle honest Spot fraudulent data, detect plagiarism, and break codes How to isolate the effects of observation on the thing observed Whether you're a statistics enthusiast who does calculations in your sleep or a civilian who is entertained by clever solutions to interesting problems, Statistics Hacks has tools to give you an edge over the world's slim odds.
Author: Bill Jelen
Publisher: Que Publishing
Release Date: 2013-01-08
Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features. Then, learn how to Build more trustworthy, error-resistant, flexible, extensible, intelligent, and understandable spreadsheets Get more productive with Excel 2013’s new Start Screen and Timelines Create formulas, charts, subtotals, and pivot tables faster with new Flash Fill and Analysis Lens Quickly apply attractive, consistent formats Master every function you’ll ever need,- including powerful new web services functions Solve real-world business intelligence analysis problems Create amazing PowerPivot data mashups that integrate information from anywhere Use Power View to generate stunningly intuitive maps, dashboards, and data visualizations Share workbooks on the Web and social networks Leverage the improved Excel Web App to create highly interactive web pages and online surveys Automate repetitive functions using Excel macros Supercharge your workbooks with new apps from the Excel App Store Like all In Depth books, Excel 2013 In Depth delivers complete coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Whatever you intend to do with Excel 2013, this is the only book you’ll need!
Author: Joseph Adler
Publisher: "O'Reilly Media, Inc."
Release Date: 2006-01-31
Baseball Hacks isn't your typical baseball book--it's a book about how to watch, research, and understand baseball. It's an instruction manual for the free baseball databases. It's a cookbook for baseball research. Every part of this book is designed to teach baseball fans how to do something. In short, it's a how-to book--one that will increase your enjoyment and knowledge of the game. So much of the way baseball is played today hinges upon interpreting statistical data. Players are acquired based on their performance in statistical categories that ownership deems most important. Managers make in-game decisions based not on instincts, but on probability - how a particular batter might fare against left-handedpitching, for instance. The goal of this unique book is to show fans all the baseball-related stuff that they can do for free (or close to free). Just as open source projects have made great software freely available, collaborative projects such as Retrosheet and Baseball DataBank have made great data freely available. You can use these data sources to research your favorite players, win your fantasy league, or appreciate the game of baseball even more than you do now. Baseball Hacks shows how easy it is to get data, process it, and use it to truly understand baseball. The book lists a number of sources for current and historical baseball data, and explains how to load it into a database for analysis. It then introduces several powerful statistical tools for understanding data and forecasting results. For the uninitiated baseball fan, author Joseph Adler walks readers through the core statistical categories for hitters (batting average, on-base percentage, etc.), pitchers (earned run average, strikeout-to-walk ratio, etc.), and fielders (putouts, errors, etc.). He then extrapolates upon these numbers to examine more advanced data groups like career averages, team stats, season-by-season comparisons, and more. Whether you're a mathematician, scientist, or season-ticket holder to your favorite team, Baseball Hacks is sure to have something for you. Advance praise for Baseball Hacks: "Baseball Hacks is the best book ever written for understanding and practicing baseball analytics. A must-read for baseball professionals and enthusiasts alike." -- Ari Kaplan, database consultant to the Montreal Expos, San Diego Padres, and Baltimore Orioles "The game was born in the 19th century, but the passion for its analysis continues to grow into the 21st. In Baseball Hacks, Joe Adler not only demonstrates thatthe latest data-mining technologies have useful application to the study of baseball statistics, he also teaches the reader how to do the analysis himself, arming the dedicated baseball fan with tools to take his understanding of the game to a higher level." -- Mark E. Johnson, Ph.D., Founder, SportMetrika, Inc. and Baseball Analyst for the 2004 St. Louis Cardinals
Author: Jeremy Lane
Release Date: 2018-02-17
This text addresses the need for people who are attempting to gain a familiarity with Excel VBA programming to help them in academics or professional careers by offering more than 300 subroutines and functions for mathematical and statistical calculations. Algorithms span many topics in mathematics, beginning with introductory algebra and continuing through calculus, linear algebra and differential equations. Included in this text are algorithms for polynomial theory, double and triple integrals, matrix decompositions, and finite difference methods. Also available are algorithms for Minisum Method, phase portraits and slope fields, cobweb diagrams, Rossmo's geographic profile algorithm and many more.
Excel occupe une place à part dans le domaine de la bureautique et offre un éventail de fonctionnalités étonnamment puissantes, mais rarement exploitées à fond. Nombreux sont les utilisateurs qui font les choses à la main et voient leurs efforts ruinés à chaque mise à jour de leurs données. Saviez-vous par exemple que vous pouviez alterner la couleur des lignes dans un tableau grâce à la mise en forme conditionnelle, sans que l'ajout et la suppression de données viennent tout bouleverser ? Vous est-il arrivé de pester contre le logiciel qui refusait obstinément d'appliquer le bon format à vos données, ou encore vous demandait de sauvegarder un fichier que vous n'aviez pas modifié ? Vous rêvez de changer dans une seule cellule le taux de TVA, et voir tous vos tableaux mis à jour automatiquement ? Cet ouvrage, qui sort des sentiers battus, vous aidera à tirer pleinement parti d'un logiciel quasi incontournable. Si vous n'avez jamais utilisé VBA, vous verrez qu'il suffit de saisir quelques lignes pour vous simplifier la tâche. Les auteurs évitent les explications fastidieuses sur le pourquoi et le comment et vous livrent 100 recettes pour optimiser l'analyse, le traitement et la présentation de vos données. Vous apprendrez notamment comment : • établir un environnement de travail personnalisé ; • créer des graphiques qui vont bien au-delà de ceux proposés par l'assistant graphique ; • définir des plages dynamiques qui varient en fonction des données et les utiliser dans des formules et des graphiques ; • écrire des macros fiables pour automatiser des tâches répétitives ; • partager des tableaux croisés dynamiques sans affecter les données sous-jacentes ; • formater les dates automatiquement en fonction de règles pré-établies ; • charger, importer et exporter des données XML ; • accéder à des services web SOAP directement depuis Excel. Pour tous ceux qui ont envie d'aller plus loin, mais n'ont pas le temps de consacrer des heures à la lecture d'un manuel d'apprentissage, voici une approche originale qui part des besoins de l'utilisateur et offre des solutions directement applicables.
Author: Joshua Paul
Publisher: "O'Reilly Media, Inc."
Release Date: 2005-05-27
Genre: Games & Activities
Since the dawn of film, novices and experts have used quick-and-dirty workarounds and audiovisual tricks to improve their motion pictures, from home movies to feature films. Today, the tools have certainly changed, as have the quality and scope of the results. With digital video, the hacking possibilities are now limitless, for both amateurs and professional artists. From acquiring footage, mixing, editing, and adding effects to final distribution, Digital Video Hacks provides unique tips, tools, and techniques for every stage of video production. You'll learn how to: Get your projects started right using creative preparation tools and techniques,from making your own steadicam, boom, or dolly to effective storyboarding, timecoding, and tape labeling Troubleshoot common shooting problems, including using stop-motion and time-lapse techniques, lighting effects, colored screens and gels, and household objects to establish mood or otherwise wow an audience Create stunning visual effects, such as satellite zooming, surreal scenes, Matrix-like bullet-time, and green screen illusions Fool your audience with audio tricks, replacing flubbed dialogue, smoothing over cuts, and covering missing audio with room tone Add professional features with post-production tricks, including color correction, soundtrack cleanup, opening sequences, and DVD bookmarks Distribute final content in a variety of creative ways, from exporting to basic videotape or DVD to streaming over the internet or even via cell phone Use the web to provide interactivity and dynamic content, attend a remote conference, or vlog your life. Whether you're looking for a new technique to include in your next project, a solution to a common problem, or just a little inspiration, this book reintroduces you to the digital video you only thought you knew.
On the surface, it doesn't appear as if much in Excel 2003 has changed. There are a handful of new objects and the user interface is largely the same. But beyond a superficial glance, you'll see that there are fundamental shifts implied by the new features: Lists, XML, web services, .NET, and InfoPath build a framework for entirely new ways to exchange data with Excel. In fact, that's much of what Excel 2003 is all about--solving problems that deal with teamwork-- collecting and sharing data, programming across applications, and maintaining security. The latest in our Developer's Notebook series, this guide introduces intermediate to advanced Excel VBA programmers to the newest programming features of Excel 2003,--focusing just on what's new--so you can get up to speed quickly. Light on theory and long on practical application, the book takes you directly to the topics you'll want to master through a series of hands-on projects. With dozens of practical labs, you'll be able to decide for yourself which new aspects of Excel will be useful or not in your own work. And best of all, you won't have to buy an expensive revision of a legacy Excel programming tutorial to learn about the new features--if they're covered there at all. Excel 2003 Programming: A Developer's Notebook shows you how to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath. Each chapter is organized into a collection of labs, each of which addresses a specific programming problem. You can follow along to complete the lab on your own, or jump ahead and use the samples the author has built for you. The new Developer's Notebooks series from O'Reilly covers important new tools for software developers. Emphasizing example over explanation and practice over theory, they focus on learning by doing--you'll get the goods straight from the masters, in an informal and code-intensive style that suits developers. If you've been curious about Excel 2003, but haven't known where to start, this no-fluff, lab-style guide is the solution.