Russell's ebook Library
home

Russell's ebook Library

40 Incredible Excel Tricks
Computergaga
Alan Murray (Computergaga) describes 40 Excel tricks.
7 Steps to Creating Professional Quality VBA Applications
Paul Kelly
7 Steps to creating professional quality VBA applications.
Balanced Scorecards and Operational Dashboards With Microsoft Excel
Ron Person
Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel.
Excel 2013 for Scientists
Dr. Gerard Verschuuren
With examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data.Scientists can learn the tips and techniques of Excel — and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more.Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency and it is updated to include all new functions in Excel 2010 and Excel 2013.
Excel VBA: Step by Step Guide to Learn Excel VBA Programming With Screenshots and Example Code
Anton Melnyk
Get started learning Microsoft Excel VBA Programming today with screenshots, code examples, and step-by-step instructionsVBA Programming in Microsoft Excel is a powerful method for automating all kinds of complex and time-consuming tasks, but only if you know how to use VBA to its full potential!Want to learn to program using VBA in Excel the easy way, with screenshots, code examples, and step-by-step instructions?Microsoft Excel can be used for so much more than simple spreadsheets. When you understand how to use VBA in Excel, you unlock a world of programing power and possibilities. Get the most out of Excel simply by following the easy instructions and code examples fully explained inside this guide. It doesn’t matter if you have never programmed in Excel VBA before. This step-by-step guide gives you everything you need to know to do more with Excel and VBA than you ever thought possible!The easiest way to learnThis step-by-step manual takes you by the hand and shows you exactly how to program VBA in Excel using screenshots and code examples. Boost your productivity and accomplish tasks you didn’t know Excel could do for you!Here is a preview of what you will learn in this guide:* Working with the Visual Basic Editor* Objects in Visual Basic for Application* Subs and Functions in Visual Basic for Application* Macro Recorder tool in Visual Basic for Application* Important Language Elements in Visual Basic for Application* Range objects in Visual Basic for Application* Workbook objects in Visual Basic for Application* Worksheet objects in Visual Basic for Application* OLEObject objects in Visual Basic for Application* Worksheet Functions in Visual Basic for Application* Control Program Flow and Making Decisions in Visual Basic for Application* Events in Visual Basic for Application* Error Handling in Visual Basic for Application* Communication with users in Visual Basic for Application* Add-ins in Visual Basic for Application* Tips and Tricks used in Visual Basic for Application* Code examples used in Visual Basic for Application* And so much more!Neither just a vague primer or an overly theoretical slog like so many other programming books on the market, this guide hits the sweet spot and shows you how to program in Excel VBA using easy to follow instructions with screenshots and code examples. Even if you have no background in programming, you can learn Excel VBA Programming quickly and easily when you grab this guide now!
Guerilla Data Analysis Using Excel
Bill Jelen
This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.
How to AcE the 21 Most Asked Questins in VBA
Paul Kelly
How to Ace the 21 most common questions in VBA.
Mastering Excel: User Forms
Mark Moore
Mastering Excel: User Forms
Microsoft Excel Dashboards and Reports
Michael Alexander and John Walkenbach
The go to resource for how to use Excel dashboards and reports to better conceptualize data.Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an "Excel Report." What they don't offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualizationDescribes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the flyShows how to automate redundant reporting and analysesPart technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr. Spreadsheet's Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that's both visually attractive and effective.
Monte Carlo Methods: A Hands-On Computational Introduction Utilizing Excel
Sujaul Chowdhury
This book is intended for undergraduate students of Mathematics, Statistics, and Physics who know nothing about Monte Carlo Methods but wish to know how they work.All treatments have been done as much manually as is practicable. The treatments are deliberately manual to let the readers get the real feel of how Monte Carlo Methods work.Definite integrals of a total of five functions 𝐹(𝑥), namely Sin(𝑥), Cos(𝑥), e𝑥, loge(𝑥), and 1/(1+𝑥2), have been evaluated using constant, linear, Gaussian, and exponential probability density functions 𝑝(𝑥). It is shown that results agree with known exact values better if 𝑝(𝑥) is proportional to 𝐹(𝑥). Deviation from the proportionality results in worse agreement.This book is on Monte Carlo Methods which are numerical methods for Computational Physics. These are parts of a syllabus for undergraduate students of Mathematics and Physics for the course titled "Computational Physics."Besides the three referenced books, this is the only book that teaches how basic Monte Carlo methods work. This book is much more explicit and easier to follow than the three referenced books. The two chapters on the Variational Quantum Monte Carlo method are additional contributions of the book.Pedagogical features: After a thorough acquaintance with background knowledge in Chapter 1, five thoroughly worked out examples on how to carry out Monte Carlo integration is included in Chapter 2. Moreover, the book contains two chapters on the Variational Quantum Monte Carlo method applied to a simple harmonic oscillator and a hydrogen atom.The book is a good read; it is intended to make readers adept at using the method. The book is intended to aid in hands-on learning of the Monte Carlo methods.
Professional Financial Computing Using Excel and VBA
Donny C. F. Lai and Humphrey K. K. Tung and Michael C. S. Wong
Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application.The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit.Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs.
The VLOOKUP Book - Definitive Guide to Microsoft Excel Lookup Formulas
Purnachandra Rao Duggirala
Learn how to lookup, fetch and analyze any data using Excel. A comprehensive guide to VLOOKUP & other lookup formulas in Excel. These days, any kind of work involves understand data & answering questions. Whether you are a school teacher or drilling site manager, you are always answering questions like, “What is the GPA of Sam in Grade 6?”, “Who dug the hole number 6925?”. And how do we answer these questions? Using Excel of course. And this is where the ubiquitous VLOOKUP formula comes in to picture. Along with few other formulas like MATCH, INDEX & SUMIFS, VLOOKUP can let you answer almost any data related question you have. And my latest book helps you do this better. The vlookup book is a no-nonsense guide to demystifying VLOOKUP formula and its cousins, so that you can answer any question related to your data without wasting too much time.