Excel for Business: How to Use Excel to Make Optimal Business Decisions, Manage Money Better and Advance Your Career

Description of the Book
This book is not about learning all the powerful functionalities of Excel. It will not make you a guru on Excel. In fact, it covers a rather small subsets of functions in Excel.

Rather, this book aims to help you become a better decision maker. A better manager or executive. A better homemaker or entrepreneur. A better thinker.

This introductory series on business analytics is designed for readers who are interested in building analytics skills and applying them into business situations such as:

-How to model demand for a new drug?
-How to predict stock prices? Price stock options?
-How to evaluate risk and uncertainty?
-How to detect sex discrimination from compensation data?
-Does it pay to invest long-term?

It will help you build a set of essential analytics skills such as:

-Finding information efficiently;
-Using commonly used math, statistical, and financial functions;
-Building a correct and clear model this can be understood easily and updated by others;
-Scenario analysis to make decision under uncertainty;
-Summarizing information (e.g., with pivot tables);
-Finding patterns among data;
-Simulation and analyzing risks;
-Optimization for better decision making.

Some key feature of this multimedia series:
1. Each key lesson is accompanied by a how-to video
2. Templates and answers for each example are downloadable
3. Hyperlinks are provided throughout for quick referencing and feedback
4. Built for both Mac and PC
5. FREE lifetime updates of new videos, templates and modules.

Excel for Business: How to Use Excel to Make Optimal Business Decisions, Manage Money Better and Advance Your Career (Series: A Multimedia Introduction to Business Analytics with Excel Book 1) has seven modules:

1: Basic Skills
2. Model Building
3. Power Analytics with Data Tables and Pivot Tables
4. Visualizing data
5. Pattern Finding,Curve Fitting, and Regression
6. Problem Solving and Optimization
7. Simulation

Whether you read (or watch or listen to) this book on a computer, a tablet, or a smartphone, you will find this new learning experience exciting, rewarding and fun. Happy learning!

MELTING THE ICE: Lessons from China and the West in the Transition to Electric Vehicles: The Critical Role of Public Charging Infrastructure by [Z. Justin Ren, Peter Fox-Penner, David Jermain]MELTING THE ICE: Lessons from China and the West in the Transition to Electric Vehicles: The Critical Role of Public Charging Infrastructure 

We all love the concept of electric vehicles but the complexities of delivering the vision make us wonder if a book on the subject would be a fantasy or science fiction. Happily this book is full of practical detail and real world experience of pioneering cities that bring the vision to life. It is a gripping read and, like a good novel, is full of great stories and ideas.”

— Fiona Woolf, Lord Mayor of the City of London in 2013–14

About the Book

A decade after the launch of the contemporary global electric vehicle (EV) market, most cities are ill-prepared for the tidal wave of change that will soon reach them as EV adoption rates accelerate. Some cities, and the leaders who shape them, are meeting and even leading demand for EV infrastructure. This book aggregates deep, groundbreaking research in the areas of urban EV deployment for city managers, private developers, urban planners, and utilities who want to understand and lead change.

About the Editors

  • Peter Fox-Penner, Ph.D. Dr. Fox-Penner is director of the Institute for Sustainable Energy (ISE) at Boston University (BU). He is also professor of the practice at BU’s Questrom School of Business. His research and writing focuses on electric power strategy, regulation, and governance; energy and climate policy; and the relationships between public and private economic activity, including corporate social responsibility. He is the author of Smart Power (2010), a book widely credited with foreshadowing the transformation of the power industry. Smart Power is now used and cited all over the world, as are other books in this area written by Fox-Penner. He also teaches courses on sustainable energy and electric power at the Questrom School of Business. The work of the BU Institute for Sustainable Energy and Peter’s projects through the Institute can be viewed there. In addition, since 2014 he has been a senior policy scholar at the Georgetown Center for Business and Public Policy. From 1994 to 1996, Peter was principal deputy assistant secretary at the US Department of Energy’s Energy Efficiency and Renewable Energy unit (EERE) and a senior advisor in the White House Office of Science and Technology Policy (OSTP).
  • Z. Justin Ren, PhD.  Z. Justin Ren is an associate professor of business administration at Boston University’s Questrom School of Business, and a faculty researcher at the Boston University Institute of Sustainable Energy (ISE). He was also a research affiliate at Massachusetts Institute of Technology (MIT) Sloan School of Management (2009–2014).  Professor Ren’s current research focuses on Electric Vehicles (EV) and infrastructure for clean energy transition.
  • David O. Jermain.  Mr. Jermain is a senior research scientist and senior fellow at Boston University’s Institute for Sustainable Energy (ISE). Also, he is an adjunct professor at Boston University’s Questrom School of Business. For nearly 40 years, he has held senior energy sector executive positions and served in several consulting capacities for large and small consultancies as well as firms he has founded. He served as head of strategic planning for Pacific Power & Light where he helped drive execution of the first major utility merger in the United States in fifty years.