Excel for the New Project Manager

A Primer on Microsoft Excel 2010

De: Doug Hong

Narrado por: Virtual Voice

Learn how to start using Microsoft Excel 2010 like a pro! This book is meant to be a short but information rich introduction on how to use Excel as a new project manager. If you’re an experienced project manager, you may also pick up some tips that could help with your individual projects. But think of this book as an Excel primer for Project Management. You may be running projects that require a tool to help manage or present information. Usually the most common tool is Microsoft Excel because your company provides it or you already have it. And if you don’t have it, the cost is usually manageable (under two hundred dollars - $US). Though it may not have the features of software that’s built specifically for Project Managers, Excel is robust enough to use for most projects. Once you understand what Excel can do, you'll find that it’s a very powerful tool that will probably do the majority of what you want. You just need to figure out how to use it. To really understand Excel you should probably start with the basics (and there’s a lot to learn!). This book gives just enough information to get comfortable and start using Excel to run projects. This book will cover the following: Exploring the Excel 2010 User Interface Understanding the Ribbon A Look at the Backstage view Quick Access Toolbar (QAT) Workbook and Worksheet Basics Primer to Cells, Columns and Rows Exploring different views using Freeze Panes and Split Panes How to Create Formulas and use Functions Use Lists Filters How the Table Feature Works Basics of Charting Formatting Charts Using Styles and Text Formatting Tips on Printing ...and some tips on using Keyboard Shortcuts to speed things up There are a lot of things you can do with Excel and this book should give you the knowledge to understand how it really works. By the end of the book you should feel familiar with using Excel and may also teach others a thing or two.