Build-a-Tool Series
()
About this series
This is the second book in the “Build-A-Tool’ series of books for learning Microsoft® Excel while creating fully functional Project Management tools (which, with a little ingenuity, can be applied to other fields of study). The process of this book will start with blank worksheets and develop them into sophisticated Project Management tools called the ‘Executive Summary” and Scope” documents. There are three bonus tools included in this module: “The Cover Sheet”, the “Charter’, and the “Cost Baseline”. Together, these five documents provide the foundation for the Prospectus package to be presented to executive management for project approval.
Do not be alarmed if you are not a Project Manager, these tools can be used in other realms, limited only by your imagination. At the very least, this exercise will illustrate the capabilities of Excel and teach some valuable techniques in the process. There is no need to learn Visual Basic for Applications (VBA) or macro programming; everything is accomplished with readily available Excel functions.
The book assumes the reader knows little or nothing about Excel and progressively elaborates upon each exercise and technique, building knowledge while providing insights into how to make Excel work for you. It will not overpower you with advanced techniques and vague tips that you may never use.
Each subsequent chapter will build on previous work so that by the end of the book, you will have a fully functional (and modifiable) Cover Sheet, Executive Summary, Scope, Charter, and Cost Baseline and an understanding of how they work.
The concepts learned here will be valuable in any context.
The final chapter will be a discussion of how to combine other “Build-A-Tool” modules into a ‘master’ template
Titles in the series (2)
- Learn Excel: Executive Summary & Scope
This is the second book in the “Build-A-Tool’ series of books for learning Microsoft® Excel while creating fully functional Project Management tools (which, with a little ingenuity, can be applied to other fields of study). The process of this book will start with blank worksheets and develop them into sophisticated Project Management tools called the ‘Executive Summary” and Scope” documents. There are three bonus tools included in this module: “The Cover Sheet”, the “Charter’, and the “Cost Baseline”. Together, these five documents provide the foundation for the Prospectus package to be presented to executive management for project approval. Do not be alarmed if you are not a Project Manager, these tools can be used in other realms, limited only by your imagination. At the very least, this exercise will illustrate the capabilities of Excel and teach some valuable techniques in the process. There is no need to learn Visual Basic for Applications (VBA) or macro programming; everything is accomplished with readily available Excel functions. The book assumes the reader knows little or nothing about Excel and progressively elaborates upon each exercise and technique, building knowledge while providing insights into how to make Excel work for you. It will not overpower you with advanced techniques and vague tips that you may never use. Each subsequent chapter will build on previous work so that by the end of the book, you will have a fully functional (and modifiable) Cover Sheet, Executive Summary, Scope, Charter, and Cost Baseline and an understanding of how they work. The concepts learned here will be valuable in any context. The final chapter will be a discussion of how to combine other “Build-A-Tool” modules into a ‘master’ template
Ronald N. Goulden, MBA, PMP
Ronald Goulden has written novels and stories for thirty years. Having served in Viet Nam as a Translator/Interpreter, He quickly adapts to new cultures and sees a story or an adventure everywhere. He has ‘dabbled’ in witchcraft, though he is not a witch. All of his novels and stories have interconnecting threads that link them into a larger universe, spanning space and time. Some of the links are obvious, while others are very subtle. Some of the events in the stories are based on real life, while others are pure fiction. The distinction between fact and fiction is up to the reader. Having studied witchcraft many years earlier, it had always been in my mind. When I became an IT Director for the Farm Credit bank system in Wichita, I observed the ‘power’ a small group of ladies expressed over others in the bank and their general disdain for many of the men. I had also researched the BTK Killer during his spree and developed a program that allowed me to ‘predict’ his next attacks. As such, I saw the potential for violence in anyone. After being treated rather rudely by the band of bank beauties, I decided to write a story to explain their odd and overbearing personalities. Using newspaper stories and personal experiences, I settled on baby sacrifices and Satanism. While the personalities and physical attributes are based upon real people I knew at the time, their involvement is this story is purely fiction. There are many ‘links’ in this story to the other novels I’ve written over time, essentially building an alternate universe.
Related to Build-a-Tool
Related ebooks
The Engineers' Metric Data Manual and Buyers' Guide Rating: 0 out of 5 stars0 ratingsPlanned Preventive Maintenance A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratings3D Printing for Prototyping The Ultimate Step-By-Step Guide Rating: 0 out of 5 stars0 ratingsJourneyman Plumber: Passbooks Study Guide Rating: 0 out of 5 stars0 ratingsProject Engineer A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsAuto Maintenance Coordinator: Passbooks Study Guide Rating: 0 out of 5 stars0 ratingsHigh Performance Loudspeakers Rating: 4 out of 5 stars4/510th use: Giant Rating: 0 out of 5 stars0 ratingsOdyssey Presents: Gallery Rating: 0 out of 5 stars0 ratingsPolitical Power: Michele Bachmann Rating: 0 out of 5 stars0 ratingsFlying Saucers Vs. the Earth #3 Rating: 0 out of 5 stars0 ratingsOMWG Oh, My Wonderful God!: A Tribute in Verse to Our Lord and Savior Rating: 0 out of 5 stars0 ratings20 Million Miles More Rating: 1 out of 5 stars1/5Rock and Roll Comics: Joan Jett Rating: 0 out of 5 stars0 ratingsLittle Miss Kitty Rating: 0 out of 5 stars0 ratingsMy Best Friend, Maximum Rating: 0 out of 5 stars0 ratingsVincent Price Presents: Black & White #2 Rating: 0 out of 5 stars0 ratingsLegend of Isis Gallery #2 Rating: 0 out of 5 stars0 ratingsLegend of Isis #10: Volume 2 Rating: 0 out of 5 stars0 ratingsVincent Price Presents: Volume #03 Rating: 0 out of 5 stars0 ratingsThe Way of Courage Rating: 0 out of 5 stars0 ratingsLazar & Jingles and Bunson in Holiday Gifts Rating: 0 out of 5 stars0 ratingsMessages from the Heart of Love - Spirituality Basics in 144 Empowering Quotes Rating: 0 out of 5 stars0 ratingsThe Itsy and Bitsy Birdie Book Rating: 0 out of 5 stars0 ratingsAdventures with Oakie the Other Heroes Rating: 0 out of 5 stars0 ratingsVincent Price Presents #04 Rating: 0 out of 5 stars0 ratingsVincent Price Presents: Phibes Rating: 0 out of 5 stars0 ratingsFAME: Lady Gaga: Giant-Sized Rating: 0 out of 5 stars0 ratingsWhispers From The Word Rating: 0 out of 5 stars0 ratings
Business For You
The Richest Man in Babylon: The most inspiring book on wealth ever written Rating: 5 out of 5 stars5/5Set for Life: An All-Out Approach to Early Financial Freedom Rating: 4 out of 5 stars4/5Carol Dweck's Mindset The New Psychology of Success: Summary and Analysis Rating: 4 out of 5 stars4/5Summary of J.L. Collins's The Simple Path to Wealth Rating: 5 out of 5 stars5/5Financial Words You Should Know: Over 1,000 Essential Investment, Accounting, Real Estate, and Tax Words Rating: 4 out of 5 stars4/5The Intelligent Investor, Rev. Ed: The Definitive Book on Value Investing Rating: 4 out of 5 stars4/5Your Next Five Moves: Master the Art of Business Strategy Rating: 5 out of 5 stars5/5The Hard Thing About Hard Things: Building a Business When There Are No Easy Answers Rating: 4 out of 5 stars4/5Emotional Intelligence: Exploring the Most Powerful Intelligence Ever Discovered Rating: 5 out of 5 stars5/5Crucial Conversations: Tools for Talking When Stakes are High, Third Edition Rating: 4 out of 5 stars4/5Tools Of Titans: The Tactics, Routines, and Habits of Billionaires, Icons, and World-Class Performers Rating: 4 out of 5 stars4/5Becoming Bulletproof: Protect Yourself, Read People, Influence Situations, and Live Fearlessly Rating: 4 out of 5 stars4/5Law of Connection: Lesson 10 from The 21 Irrefutable Laws of Leadership Rating: 4 out of 5 stars4/5Collaborating with the Enemy: How to Work with People You Don’t Agree with or Like or Trust Rating: 4 out of 5 stars4/5How to Get Ideas Rating: 5 out of 5 stars5/5Lying Rating: 4 out of 5 stars4/5Robert's Rules Of Order Rating: 5 out of 5 stars5/5Confessions of an Economic Hit Man, 3rd Edition Rating: 5 out of 5 stars5/5Leadership and Self-Deception: Getting out of the Box Rating: 4 out of 5 stars4/5Robert's Rules of Order: The Original Manual for Assembly Rules, Business Etiquette, and Conduct Rating: 4 out of 5 stars4/5How to Grow Your Small Business: A 6-Step Plan to Help Your Business Take Off Rating: 4 out of 5 stars4/5Capitalism and Freedom Rating: 4 out of 5 stars4/5Summary of Tiffany Aliche's Get Good with Money Rating: 4 out of 5 stars4/5Nickel and Dimed: On (Not) Getting By in America Rating: 4 out of 5 stars4/5Thank You for Being Late: An Optimist's Guide to Thriving in the Age of Accelerations Rating: 4 out of 5 stars4/5
Related categories
Reviews for Build-a-Tool
0 ratings0 reviews