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....
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 specifi...
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...
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 d...
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 th...
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 de...
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 bla...
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...