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.
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.
