Monday, August 27, 2012

Picks of the Week: August 26 - September 1, 2012

Website of the Week -- FSG
FSG is a nonprofit consulting firm specializing in strategy, evaluation, and research. We were founded in 2000 as Foundation Strategy Group. Today, FSG’s international teams work across sectors by partnering with foundations, corporations, nonprofits, and governments in every region of the globe to develop more effective solutions to the world’s most challenging social issues. The  goal is to help organizations and companies – individually and collectively – achieve greater and more effective social change.  Working with many of the world’s leading corporations, nonprofit organizations and charitable foundations, FSG has completed more than 400 consulting engagements around the world. FSG regularly publishes research reports and papers, and influential articles in Harvard Business Review and Stanford Social Innovation Review. FSG is also frequently featured in The New York Times, Wall Street Journal, Economist, Financial Times, BusinessWeek, Fast Company, Forbes and NPR, amongst others Be sure to check out the Knowledge Exchange, an interactive hub for ideas, research, and discussions about social impact.  Go to: http://www.fsg.org/Default.aspx.

Publication of the Week --  The Face-to-Face Book: Why Real Relationships Rule in a Digital Marketplace by Ed Keller and Brad Fay
From the publisher:  IN 1848 gold was discovered in California, setting off a frenzy that sent men and women from across the American continent flocking to the West Coast in search of fortune. The Gold Rush brought wealth to some, but most left empty-handed. Today, marketing consultants Ed Keller and Brad Fay say social media is unleashing a new kind of frenzy. Blinded by the shiny allure of sites like Facebook and Twitter, companies are spending billions, pinning their hopes on social media marketing without appreciating how social influence truly functions in the marketplace. That’s where Keller and Fay come in. For the past six years, they have undertaken a unique, ongoing study of consumer conversations. The surprising result? Over 90 percent of consumer conversations still take place offline, primarily face to face. The implication is clear: Social media is big and growing, but it is dwarfed by the real world in which people live and interact. Make no mistake. There is a hugely important social wave rolling across the world of business today. New scientific evidence reveals that we humans are fundamentally social beings for whom social influence determines nearly every decision we make. And the greatest impact comes when those conversations happen face to face, as emotions and nonverbal cues are communicated along with words. In The Face-to-Face Book, Keller and Fay offer key insights and recommendations for how businesses, both large and small, can best succeed in today’s socially motivated consumer marketplace by looking at how consumers act in real life as well as online. The authors share their extensive research and the stories of companies—large, such as Apple, General Mills, Kimberly–Clark, and Toyota, as well as innovative small businesses—that have hit pay dirt with a balanced and holistic approach to social marketing.
 


Trend of the Week – Success Factors in Nonprofit Mergers
New research indicates nonprofit mergers can contribute to the stability of the nonprofit environment and that certain factors, when employed in the merger process, add to the mergers' success. Success Factors in Nonprofit Mergers, a study of 41 direct service organization mergers in Minnesota, is now available from MAP for Nonprofits and Wilder Research. Findings include:

  • At least one merger partner in the majority of the mergers studied faced some financial problems pre-merger, however, overall the mergers were pursued for a combination of strategic and survival motives.
  • In the short term, the merged organization’s cash position (current ratios) declined, however, the longer-term financial picture (debt ratios) improved.
  • Nonprofit executives play a key merger role. Eighty-five percent of the mergers had an executive champion and 80 percent of the mergers had a departing executive (for example, a planned retirement.) This finding, combined with an expected wave of executive retirements in the next decade, points to a timely opportunity.
  • Strong working relationships between nonprofit executives prior to merger was found to be a predictor of post-merger outcomes in service preservation, improved image and financial sustainability.
  • Strong board involvement prior to merger was another predictor of positive post-merger outcomes, specifically in image or reputation.
  • Communicating with and involving line staff in merger planning and preparations was positively associated with merger outcomes like service quality and expansion, financial stability, organizational reputation and alignment of staffing with needs.
  • Involving funders in the process was found to result in positive outcomes, such as the preservation of services, financial stability and organizational alignment with client needs.


Resource of the Week – Free Business E-Books from Bookboon.com
Bookboon.com, founded in Denmark in 1988, publishes education related books for business professionals and students. In 2005 the company made a strategic leap and became the first book publishing company in the world to focus 100% on free eBooks. The books are about 50 pages long and they are tailored to be read in two or three hours, which is the available time a reader has on a flight, a train journey, an evening in a hotel or at home after the kids are put to bed. The books have a hands-on approach: you can read them today and use them tomorrow. The books, like many print an online publications, contain some display advertising  To access the 500+ business book collection, go to: http://bookboon.com/en/business-ebooks 

Tech Tip of the Week -- Display the First Name in Excel
Have you ever received an Excel list of names with the first and last name in a single cell?  If you would like to display just the first name, try this:

For example, if your list (for example "NAMES") is in Column A, type this formula in column B (in our example "FIRST NAME"): =LEFT(A2,FIND(" ",A2)-1)

Copy this formula down to each row containing the names. But remember, the first names in column B are still a formula and can’t easily be moved or copied.  You may want to copy the cells containing this formula back to their original position using Paste Special to convert the formula into a value: 

·         Select the column by clicking the column name  
·         Choose Copy 
·         Right click and choose Paste Special from the short-cut menu 
·         Choose Values and click OK 

This tip works in Excel 2007 and 2010. You can also use Text to Columns  to accomplish this.

Monday, August 20, 2012

Picks of the Week: August 19 - 25, 2012

Website of the Week -- DIY Committee Guide
This remarkable website is full of useful resources.. The DIY Committee Guide website is structured around the Code of Good Governance for the Voluntary and Community Sector This site was originally developed in 2005 by the Volunteer Development Agency (now Volunteer Now) in Northern Ireland in partnership with 14 other organizations.  It provides a central point of access to a wide range of practical, user-friendly resources developed by groups across the nonprofit sector in Northern Ireland and beyond. Go to: http://www.diycommitteeguide.org/


Publication of the Week --  From the Top Down: The Executive Role in Successful Volunteer Involvement by Susan J. Ellis
From the publisher:  A bestseller since 1986, this fully revised third edition of FROM THE TOP DOWN has been updated to reflect many changes and trends in the world and in volunteerism. It points the way to success with volunteers by showing how to: *Articulate a vision and strategy for volunteer involvement *Make the most of the connection between money donors and time donors *Avoid tension between volunteers and employees *Tap new community resources, from pro bono service to voluntourism *Budget for and creatively fund volunteer efforts *Find the best person to lead volunteer participation *Manage risk, legal, and insurance issues realistically *Distinguish between the wage replacement cost of volunteer time and its true value *Demonstrate executive commitment on a daily basis Whether an organization is just starting out with a new volunteer initiative or has many years of experience with a well-developed corps of volunteers, FROM THE TOP DOWN provides thought-provoking and thoughtful advice to achieve the maximum impact from the participation of volunteers.

Click topreview this book on Amazon.com.


Trend of the Week – Location of High Performing Nonprofits in America
Where are the most high-performing charities in America? Charity Navigator’s 2012 Metro Market Study reveals the regional differences in the performance of the nation’s largest charities. Not all U.S. cities have equally high performing charities, according to a study by Charity Navigator, America’s largest charity evaluator. The study revealed that large charities in markets such as Portland, Milwaukee and Kansas City have a greater commitment to ethical best practices than those in Detroit, Miami and Atlanta. It is the only comprehensive report on the performance – both financial health and accountability & transparency – of the 30 largest philanthropic marketplaces in America. For more information, go to: http://www.charitynavigator.org/index.cfm?bay=content.view&cpid=1380


Resource of the Week – Leadership Development Toolkit: Creating Your Nonprofit’s Plan A
The Bridgespan Group has prepared a guide to leadership development at nonprofits, Plan A: How Successful Nonprofits Develop Their Future Leaders. This kit features a growing list of materials through which you can explore the topic. The goal is to help you create a proactive, systematic approach to leadership development that can be considered within your nonprofit’s day-to-day operations. To access the leadership development kit, go to:
http://www.bridgestar.org/Library/LeadershipDevelopmentToolkit.aspx.


Tech Tip of the Week -- PowerPoint 2010: Presentations that Pop
This manual is just one of many excellent resources which can be downloaded for free from Tufts University Information Technology Training and DocumentationDepartment.   Following are the topics covered:

·        Use the Slide Master to manage the different aspects of multiple slides in a single presentation
·        Insert (embed or link) charts into a presentation
·        Add a video to a presentation
·        Embed a video from a web site such as YouTube into a presentation
·        Add a sound file to a presentation
·        Share slides between presentations
·        Use built-in PowerPoint tools to position elements on a slide
·        Create hyperlinks in a presentation
·        Create a custom slide show
·        Apply techniques to enhance your presentation skills
·        Annotate slides during a presentation

To download this document, go to Presentations that Pop.

Monday, August 6, 2012

Picks of the Week: August 5 - 18, 2012

Website of the Week -- LawForChange
LawForChange is a unique legal resource for people and organizations dedicated to improving lives and bringing about positive social change. This site combines in one place a broad menu of legal information prepared by leading law firms and lawyers and specifically tailored to the needs of social sector organizations in the United States. Its intended audience includes social entrepreneurs and innovators, social enterprises, charities, community organizations, philanthropies, faith-based organizations and all manner of nonprofit organizations. Go to: http://www.lawforchange.org/lfc/About_Us.asp

Publication of the Week --  Nonprofit Asset Management: Effective Investment Strategies and Oversight by Matthew Rice, Robert A. DiMeo and Matthew Porter
From the publisher:  Nonprofit Asset Management is a timely guide for managing endowment, foundation, and other nonprofit assets. Taking you through each phase of the process to create an elegant and simple framework for the prudent oversight of assets, this book covers setting investment objectives; investment policy; asset allocation strategies; investment manager selection; alternative asset classes; and how to establish an effective oversight system to ensure the program stays on track.

  • Takes you through each phase of the process to create an elegant and simple framework for the prudent oversight of nonprofit assets
  • A practical guide for fiduciaries of endowment, foundation, and other nonprofit funds
  • Offers step-by-step guidance for the effective investment management of assets
Created as a practical guide for fiduciaries of nonprofit funds—board members and internal business managers—Nonprofit Asset Management is a much-needed, step-by-step guide to the effective investment management of nonprofit assets.
Click to preview this book on Amazon.com.


Trend of the Week – Major Trends Impacting Nonprofits
In a recent conference presentation in St. Louis, Professor Robert Reich, associate professor of political science at Stanford University, summarized major trends continuing to impact nonprofits. Five macro trends include:

  • Local, state and federal deficits, which can lead to decreased support for some organizations dependent on government funding
  • Comprehensive tax reform, which may depress individuals' incentive to donate since the deduction for charitable contributions might not mean as much.
  • Post-Citizens United world in which some nonprofits are becoming political agents, alienating some donors. Politicized nonprofit organizations can be seen as interest groups, and that can taint the trust of donors.
  • Dysfunctional federal political system, which Reich said "needed no explanation."
  • Blurring of the boundaries between nonprofits and for-profit organizations as nonprofits act like for-profits, and for-profit organizations adopt social missions like nonprofits.
Reich also discussed five more micro trends he believes might affect nonprofit organizations.

  • New modes of giving, especially online giving. Reich said the biggest days for online giving are Dec. 30-31 as the tax year closes.
  • Impact investing: By making seed investments in new start up for-profit organizations that support nonprofit causes, nonprofits can attempt to attract investors and donors.
  • Focus on measurable outcomes: Organizations should track what they are doing so donors know where their money has made the most impact. This will keep donors because they are promised outcomes from their donations.
  • New organizational forms that combine traits from for-profit organizations and nonprofit organizations. An organization uses business tools to create revenue, but it is not required to make a profit for shareholders so it can freely provide social services.
  • Inequality can both increase demand for services but also create a potential source of new donors. Reich said more Americans have the resources to become donors..
Go to: https://www.stlbeacon.org/#!/content/26140/changes_in_charitable_giving


Resource of the Week – Basics in Internal Organizational Communications
This section of the Free Management Library is geared to provide practical suggestions for nonprofit leaders and managers to ensure sufficient communications within their nonprofits. Topics include: common causes of problems in internal communications; key principles to effective internal communications; basic structures/policies to support effective internal communications; supervisor and employee communications; develop a basic communications plan. Go to: http://managementhelp.org/organizationalcommunications/internal.htm#anchor465736.


Tech Tip of the Week -- Combining Text from Two Cells in Excel
In Microsoft Excel you can combine the text in two or more cells into a single text string by using “concatenation”.  The result is displayed in the cell where you type the formula.

For example, If you have a worksheet that contains the First name in cell A1 and the Last name in cell B1, enter the following expression in cell C1 to create a text string that displays the values of the First and Last names separated by a space:  =A1&" "&B1

Be sure to put a space between the double quotes in the expression. Copy this formula down to each row containing the names. Then copy the cells containing this formula back to their original position using Paste Special to convert the formula into a value:

·         Select the column by clicking the column name
·         Choose Copy
·         Right click and choose Paste Special from the short-cut menu
·         Choose Values and click OK

This tip works in Excel 2007 and 2010 as well as earlier versions.

Sunday, July 29, 2012

Picks of the Week: July 29 - August 4

Website of the Week -- Institute for the Future of Aging Services
Welcome to the Institute for the Future of Aging Services, a policy research institute housed within the American Association of Homes and Services for the Aging. Our mission is to create a bridge between the practice, policy and research communities to advance the development of high-quality health, housing and supportive services for America’s aging population. The Institute provides a forum for professionals, policymakers and the public to explore and foster policies and programs that will meet the needs of an aging society through the development of healthy aging communities. http://womenshealth.gov.

Publication of the Week --  Managing Nonprofit Organizations by Mary Tschirhart and Wolfgang Bielefeld
From the publisher:  This essential resource offers an overall understanding of nonprofits based on both the academic literature and practitioner experience. It shows how to lead, manage, govern, and structure effective and ethical nonprofit organizations. Managing Nonprofit Organizations reveals what it takes to be entrepreneurial and collaborative, formulate successful strategies, assess performance, manage change, acquire resources, be a responsible financial steward, and design and implement solid marketing and communication plans.
Click topreview this book on Amazon.com.


Trend of the Week – Nonprofit Trends
Nonprofit Trends is a blog by Steve MacLaughlin and covers a wide range of topics around the nonprofit sector with a focus on the trends shaping the nonprofit sector. Steve is the Director of Internet Solutions at Blackbaud and is responsible for leading how the company provides online solutions for its clients. Steve has spent more than 14 years building successful online initiatives with a broad range of Fortune 500 firms, government and educational institutions, and nonprofit organizations across the world. He is a frequent speaker at conferences and events including the Association of Fundraising Professionals (AFP), Association for Healthcare Philanthropy (AHP), Council for Advancement and Support of Education (CASE), Direct Marketing Fundraisers Association (DMFA), Institute of Fundraising, National Association of Independent School (NAIS), Nonprofit Technology Network (NTEN), and other nonprofit organizations. Go to: http://www.nptrends.com/about-nonprofit-trends.html.


Resource of the Week –  Annie E. Casey Foundation Knowledge Center
The purpose of the Knowledge Center is to provide advocates, policymakers, practitioners, the media, researchers, and community members with a range of Foundation resources developed either by Casey or one of our grantees. These resources capture the experience and learning of the Foundation in our efforts to improve outcomes for vulnerable children, youth, families, and communities  The Annie E. Casey Foundation is one of the largest private foundations in the nation, with assets of more than $2.3 billion. The Foundation provides about $190 million in grants each year and is ranked among the top philanthropies for charitable giving. Established in 1948 by Jim Casey, one of the founders of UPS, the Foundation’s primary mission is to foster public policies, human services, and community supports that more effectively meet the needs of vulnerable children and families. Go to: http://www.aecf.org/KnowledgeCenter.aspx.


Tech Tip of the Week -- Using Screenshot in Office 2010
Screenshot -- a new feature in Office 2010 -- allows you to capture images from your screen.

·         Click the document that you want to add the screenshot to
·         Click the Insert tab on the Ribbon
·         In the Illustrations group, click Screenshot
·         To add the whole window, click the thumbnail in the Available Windows gallery
·         To add part of the window, click Screen Clipping, and when the pointer becomes a cross, press and hold the left mouse button to select the area of your screen that you want to capture
·         If you have multiple windows open, click the window you want to clip from before clicking Screen Clipping. When you click Screen Clipping, the program you are working in is minimized and only the window behind it is available for clipping
·         After adding a screenshot, you can use the tools on the Picture Tools tab to edit and enhance the screenshot

You can use Screenshot in Word 2010, PowerPoint 2010 and Excel 2010


Sunday, July 15, 2012

Picks of the Week: July 15 - 28, 2012

Website of the Week --  Management Assistance Group (MAG)
The Management Assistance Group (MAG) strengthens visionary social justice organizations, leaders, and networks to create a more just world. For thirty years, MAG has strived to meet its mission by: (1) evolving and utilizing innovative approaches to strengthening organizations, leaders, and networks, (2) conducting research on critical organizational issues faced by social justice organizations, and (3) sharing insights and experiences with the social justice sector and the nonprofit organizational development field. Since 1980, MAP has partnered with thousands of organizations, leaders, networks, movements, and funders to create powerful social justice efforts and lasting change. Go to: http://www.managementassistance.org.

Publication of the Week --  Organization of the Future 2: Visions, Strategies, and Insights on Managing in a New Era
From the publisher:  The world has changed dramatically since the best-selling The Organization of the Future was published in 1999. More than ever before, organizations and leaders need guidance for meeting the challenges of today's complex environment in order to thrive in the future. Filled with wisdom and insight on the most important issues facing organizations today, the twenty six chapters in The Organization of the Future 2 offer the wisdom of some of the most recognized thought leaders of our day. These experts share their unique vision of what the organization of the future should look like and what organizational leaders must do to survive in the tumultuous twenty-first century. The contributors offer varied and diverse views on the organization of the future—for entrepreneurs to large corporations, nonprofits, and universities—including three different yet complementary approaches to inclusion, integration, and horizontal organization. The final section of the book focuses on the leaders of the organizations of the future and shows how they can make a critical difference in the success of their enterprises.


Trend of the Week – Foundation Growth and Giving Estimates
Giving by U.S. foundations totaled an estimated $46.9 billion in 2011, surpassing the $46.8 billion pre-recession peak recorded in 2008. Yet, after accounting for inflation, contributions by the nation's more than 76,600 foundations were down slightly from 2010. According to Foundation Growth and Giving Estimates (2012 Edition), if the Bill & Melinda Gates Foundation were excluded from the totals, 2011 giving would actually have gone down by roughly 3 percent after inflation. Key 2011 findings include: 
·         Independent and family foundations — which represent the vast majority of U.S. foundations — increased their charitable contributions by less than 2 percent to $33.1 billion before inflation.
·         Corporate foundation giving rose 6 percent to $5.2 billion before inflation, surpassing other types of foundations.
·         Community foundation giving declined slightly and totaled $4.2 billion before inflation

To download the report at no charge, go to: http://foundationcenter.org/gainknowledge/research/pdf/fgge12.pdf


Resource of the Week – Certified Nonprofit Accounting Professional (CNAP)
Wegner CPAs, based in Wisconsin is partnering with The FMA Institute to bring CNAP (Certified Nonprofit Accounting Professional), an on-line training course, to nonprofit financial professionals. The Certified Nonprofit Accounting Professional (CNAP) is sponsored by member firms of the National Association of Nonprofit Accountants & Consultants (NPAC). CNAP is a national initiative developed by the member firms of NPAC designed to recognize excellence in the nonprofit industry through comprehensive qualification, training, and examination. Through a minimal time commitment, nonprofit financial managers will receive intensive training from individuals dedicated to serving nonprofit organizations. They do not have to be a CPA to achieve this designation. The CNAP on-line training will be offered for 7 sessions beginning on September 27, 2012. Each session will be held from 1:00 pm to 2:45 pm CST. All the details about the training and registration information can be found at: www.wegnercpas.com/CNAP.pdf.

Tech Tip of the Week -- Change Text Case in Word
To change the case of text in Word, try this:

  • Select text
  • Press Shift + F3 until it changes to the desired case style
Pressing Shift + F3 toggles the text case between sentence case, UPPERCASE, lowercase, and capitalize each word. Be sure to hold down the Shift WHILE you press F3.  Also, it works in all versions of Word. However, if you include text with punctuation at the end, it will skip the option to capitalize each word. You can also try this in PowerPoint.

Tuesday, July 10, 2012

Picks of the Week: July 8 - 14, 2012

Website of the Week -- Alberta Association of Services for Children and Families
The Alberta Association of Services for Children and Families (AASCF) is a membership association of agencies providing services to children and families in Alberta. The AASCF formed in 1967 as a network of agencies with common interests. The Association has compiled an extensive resource library for non-profit resources applicable to agencies, organizations and associations in the Human Service sector. You can access these resources at www.aascf.com. The link to the resource library is in the left margin.

Publication of the Week --  Do More Than Give: The Six Practices of Donors Who Change the World by Leslie R. Crutchfield, John V. Kania, and Mark R. Kramer
From the publisher:  How donors change the world through the six catalytic practices of high-impact philanthropy. Do More Than Give provides a blueprint for individuals, philanthropists, and foundation leaders to increase their impact. Based on Forces for Good, this groundbreaking book demonstrates how the six practices of high-impact nonprofits apply to donors aiming to advance social causes. Rather than focus on the mechanics of effective grantmaking, reporting, or evaluation, this book instead proposes that donors can become proactive catalysts for change by rising to meet the challenges of our increasingly interdependent world. Key principles include: going beyond check writing/traditional volunteering; advocating for change; leveraging business; forging peer networks; empowering individuals; leading adaptively; and developing learning organizations.
·         Contains robust case studies depicting every type of philanthropy (corporate, community, operating, specialized, and large private and family foundations)
·         Includes easy to use "Key Takeaways" tailored for donors at the "beginner" and "experienced" levels of catalytic philanthropy
·         Authors are internationally-acclaimed philanthropic, nonprofit, and corporate social responsibility strategy experts who frequently speak and train on high-impact philanthropy

Click topreview this book on Amazon.com.


Trend of the Week – Growth in Giving Slows

American philanthropic giving rose in 2011 to more than $298.4 billion, up from a revised estimate of $286.9 billion in 2010, reflecting gains across the economy, according to Giving USA 2012, the annual report on philanthropy released by the Giving USA Foundation and its research partner, the Center on Philanthropy at Indiana University. Key findings include:

·         Individual giving increased by 0.8 percent in inflation-adjusted dollars. Personal, disposable income rose 0.7 percent from 2010 compared to a 2 percent increase between 2009 and 2010. Individuals gave an average of 1.9 percent of their disposable income each year over the past two years, indicating that people generally remain committed to philanthropy despite possible fluctuations in personal income.
·        In inflation-adjusted dollars, foundation giving fell 1.3 percent largely due to reduced asset growth resulting from the continuing American housing market weakness, European debt crisis, rising oil prices and other various economic and political factors.
·      Corporate giving remained flat compared to 2010 levels. Corporate pre-tax profits only rose 4.2 percent in 2011, compared to a 25 percent increase in the previous year. The S&P 500 index also experienced a 3 percent decline in real dollars after two consecutive years of growth (10.9 percent in 2010 and 23.8 percent in 2009).

For more information, go to: http://www.givingusareports.org/


Resource of the Week – Continuity Of Operation Plan For Nonprofit Human Services Providers
This document is intended to be a guideline for developing a Continuity Of Operation Plan (COOP) plan for nonprofits. It is strictly a template to guide one through the steps needed to begin the process of developing a comprehensive COOP plan for the organization. Much of this template model can be attributed to Miami-Dade County’s Office of Emergency Management’s Guidelines for Developing an All Hazards Continuity of Operations Plan for Businesses, the Bay Area Emergency Preparedness Coalition for Seniors & People with Disabilities, and the U.S. Department of Homeland Security’s Sample Emergency Plan. Go to: http://www.virtualcap.org/downloads/US/IT_Plan_for_Emergencies.pdf


Tech Tip of the Week -- Saving your PowerPoint 2010 Presentation as a Video
There are a number of new features in PowerPoint 2010 which allow you to enhance your presentations with video, images and animations.  Create a Video is one of these new features. Here’s how it works

·         Create your presentation
·         Save the presentation
·         Click the File tab
·         Click Save & Send in the left pane
·         Under File Types, click Create a video
·         Make changes in the right pane, if necessary
·         Click the Create Video button

·         After you create a video, you can share it with others by:
·         Sending it as an e-mail attachment
·         Burning it to a DVD disc
·         Uploading it to a video sharing Web site such as YouTube
·         Posting it on your website or other shared location

Monday, July 2, 2012

Picks of the Week: July 1 - 7, 2012

Website of the Week -- GiveMN
GiveMN was designed and launched by the Minnesota Community Foundation in 2009 in partnership with 14 other funders. They were inspired by trailblazing e-philanthropy ventures such as Kiva and DonorsChoose that were using technology to create powerful, personal giving experiences for donors. GiveMN’s founders wanted to leverage technology to increase giving in Minnesota. In just two years, GiveMN has dramatically changed charitable giving in Minnesota. Since its launch in November 2009, GiveMN has facilitated more than $48 million in donations to 6,100 Minnesota nonprofits. Nearly half of all Minnesota nonprofits report that GiveMN is their primary online giving vehicle. And in GiveMN’s 2010 donor survey, 68% of donors reported that online giving was their preferred method of giving compared to 46% in 2009. The same survey showed that the percentage of those preferring to give by check dropped from 83% to 30%. GiveMN is now one of the nation’s leading web portals for charitable giving, actually outpacing the amount of donations made on Facebook Causes. Although there are many national online giving platforms for people to choose from, GiveMN is unique. GiveMN believes that its success is not in spite of the fact that it is local but rather because it is local. Go to: http://givemn.razoo.com


Publication of the Week --  Give Smart: Philanthropy that Gets Results by Thomas J. Tierney and Joel L. Fleishman

From the publisher:  A decade ago, Thomas J. Tierney cofounded The Bridgespan Group, a nonprofit focused on helping donors and nonprofit leaders to develop and execute strategies to accelerate social change. In Give Smart, Tierney pools his hands-on knowledge with Duke professor Joel L. Fleishman’s expertise to create a much-needed primer for philanthropists and the nonprofit organizations they support. Drawing from personal experiences, research spanning twentieth- and twenty-first-century philanthropy, contemporary interviews, and Bridgespan’s extensive field work, Give Smart presents the definitive guide to engaged philanthropy.


Show Mo
Trend of the Week – Involving Millennials in Nonprofits
The third annual Millennial Impact Report has just been issued and it is full of important data. The report is issued by Achieve and Johnson Grossnickle Associate and funded by the Case Foundation. The data used to develop the report is quite extensive and drawn from over 6500 surveys completed and focus groups of “Millennial Professionals”aged 20 – 35. 95% of the participants were college graduates. The goal of the study is to develop a better understanding of successful strategies for nonprofits to engage Millennials. Because it included both surveys and focus groups in Indianapolis, Seattle, and Washington D.C it has both breadth and depth. Each section features “Takeaways” Here are some key overall findings and assessments from the report: Millennials want to be taken seriously as donors, volunteers, and leaders for causes they care about. Young donors are fully immersed in technology, but they are also invested in timeless values. They want to give and to serve. They want involvements that engage their minds as well as their hands. Most important they are interested in building authentic, personal relationships with nonprofits. Millennials have high expectations o for themselves and the nonprofits they support. To download the full report, go to: http://themillennialimpact.com

Show Less
Resource of the Week – Grantsmanship Center Magazine Archive of Articles
The Grantsmanship Center, Inc. (TGCI) was founded in 1972 to offer grantsmanship training and low-cost publications to nonprofit organizations and government agencies. At first a local project in Los Angeles, TGCI expanded rapidly and today, TGCI conducts some 200 workshops annually in grantsmanship, enterprise development and fundraising. TGCI is also active in publishing. The Grantsmanship Center Magazine is mailed to the staff of 200,000 nonprofit and government agencies in the U.S. and 58 other countries. An archive of articles organized into 10 categories is accessible at no charge at http://www.tgci.com/magazine.shtml.


Tech Tip of the Week -- View Formulas that Reference a Cell in Excel
Last week we covered how to view cells referenced by a formula.  Another useful tool when debugging a worksheet is doing the reverse -- viewing formulas referenced by a cell.  Here’s how:

·         Select the cell
·         Press Ctrl + ] (Ctrl + close square bracket)
·         Excel moves the to the first formula that references the cell
·         Each time you press Enter the selection moves to the next formula that references the cell

This tip appears to work in the new Office 2007 or 2010 as well as earlier versions.