Working with Excel

ebook Refreshing Math Skills for Management

By Priscilla Chaffe-Stengel

cover image of Working with Excel

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Library Name Distance
Loading...

Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well in the electronic environment with raw data.

Although some statistical and financial techniques for analyzing data are sophisticated and require specialized expertise, there are methods that are understandable and applicable by anyone with basic algebra skills and the support of a spreadsheet package. While specialized software packages may be used in a particular business setting, Microsoft Excel is routinely available on computer desktops. Managers who have been in the field any length of time may not be sufficiently familiar with the capabilities of Excel to make optimal use of its functionalities. Prior to undertaking a program to pursue executive training, managers who are refreshed with basic algebra skills and the capabilities of Excel will be prepared to develop a richer understanding from their more advanced work.

The primary foci of this text are:

  • To refresh fundamental mathematical operations that broadly support statistical and financial equations and formulas,
  • To introduce work with equations and formulas in Excel spreadsheets,
  • To expand statistical and financial analysis with the programmed Excel functions readily available through the 'Insert Function' toolbar button and the more advanced Data Analysis Toolkit,
  • To facilitate graphic representations of data, and finally
  • To prepare data mounted in differing file formats.
  • This text is a companion to a series of books that addresses the analysis of sample data, time series data, managerial economics, and forecasting techniques. Together these books will equip the manager and the student with a solid understanding of applied data analysis and prepare them to apply the methods themselves.

    Working with Excel