Excel Advanced Tip: Tell your formulas how to behave with absolute references in formulas using ‘$’

In Excel, if you write a formula in a cell, it is common for it to contain a cell reference, which means the formula points to a value in one or more other cells. In the example below, the formula in cell E2 references cells B2, C2 and D2. It determines the total number of phone cards requested during the quarter by adding together the requests in April (B2), May…

COVID-19 utility moratorium ends Sept. 30; state leaders urge customers who are behind on energy and water bills to contact utilities and make a plan to keep services on

COVID-19 utility moratorium ends Sept. 30; state leaders urge customers who are behind on energy and water bills to contact utilities and make a plan to keep services on

More than half a million Washingtonians are at risk of having electricity, natural gas or water services shut off OLYMPIA, WA — The emergency proclamation preventing shut-off of water, electricity or natural gas services is slated to end Sept. 30. It is among the many emergency measures enacted by Gov. Jay Inslee in the wake of COVID-19. State leaders and utility operators estimate more than 500,000 Washingtonians have overdue bills…

Commerce Clean Energy Fund awards grants to 18 innovative electricity grid modernization projects benefitting Washington communities

Commerce Clean Energy Fund awards grants to 18 innovative electricity grid modernization projects benefitting Washington communities

Grants fund electricity grid projects that will expand renewable energy use and support community resilience.  OLYMPIA, WA – The Washington State Department of Commerce today announced approximately $3.9 million in grants from the state’s Clean Energy Fund for 18 electricity grid modernization projects across the state. As Washington’s utilities advance towards the state’s goal of 100% clean electricity by 2045, the projects will advance a variety of renewable energy technologies…

New report: Staggering staff turnover rate emphasizes urgent need to support child care workforce in order to increase access and affordability of quality care

New report: Staggering staff turnover rate emphasizes urgent need to support child care workforce in order to increase access and affordability of quality care

Washington’s Child Care Collaborative Task Force releases strategy that builds on historic Fair Start for Kids Act investments, calls for focus on growing the child care workforce. OLYMPIA, WA – Washington state’s Child Care Collaborative Task Force released a comprehensive new strategy that emphasizes the urgency of bolstering the child care workforce amidst a staggering turnover rate of 43 percent. The new Washington State Child Care Access Strategy makes clear…

As businesses look to COVID-19 reopening and recovery, Commerce announces new public-private Flex Fund loan program for Washington small businesses and nonprofits

As businesses look to COVID-19 reopening and recovery, Commerce announces new public-private Flex Fund loan program for Washington small businesses and nonprofits

Program works with and through trusted local lending institutions to support historically underserved businesses OLYMPIA, WA — Small business owners and nonprofits across Washington can start applying today for low interest loans of up to $150,000 through the newly-launched Small Business Flex Fund. The Fund is a public-private partnership aimed at helping small businesses and nonprofits – particularly those in low-income communities – recover and grow as communities across the…

$2.2 million awarded to 31 Washington state Veteran Service Organizations

$2.2 million awarded to 31 Washington state Veteran Service Organizations

Nonprofit Community Recovery grants assist organizations that provide gathering places and services to veterans and their families throughout the state. OLYMPIA, Wash. –The Washington State Department of Commerce and Washington State Department of Veterans Affairs (WDVA) have awarded $2.2 million in Nonprofit Community Recovery Grants to assist nonprofit Veteran Service Organizations (VSOs) as they continue supporting veterans during the pandemic.  VSOs provide vital services in communities throughout the state for…

Three new sessions of ScaleUp: The Rebuild Edition free business trainings scheduled

Three new sessions of ScaleUp: The Rebuild Edition free business trainings scheduled

More than 350 growth-oriented small businesses helped during pandemic OLYMPIA, WA – “ScaleUp: The Rebuild Edition,” an education and training partnership between the Washington State Department of Commerce and Thurston Economic Development Council, has scheduled three new eight-week course tracks for small businesses interested in achieving exponential growth as the economy reopens. Each interactive course is two hours long and held once a week for eight weeks. The ideal participant…

Nonprofit Community Relief grant program open for eligible Washington state veteran service organizations

Nonprofit Community Relief grant program open for eligible Washington state veteran service organizations

OLYMPIA, Wash. – The Washington State Department of Commerce is partnering with the Washington State Department of Veterans Affairs (WDVA) to administer $1.25 million in Nonprofit Community Recovery (NCR) grant funding to nonprofit veteran service organizations (VSOs). The grant focuses on statewide VSOs with networks of local chapters. Additional information and application forms are available at dva.wa.gov/ncrgrant. All applications received by 11:59 p.m. on May 24, 2021 will be considered. “As we look…

Can we land the world’s largest firefighting airtanker here in WA?

Can we land the world’s largest firefighting airtanker here in WA?

Last week, I joined Department of Natural Resources Commissioner Hilary Franz, Congressman Dan Newhouse, Reps. Tom Dent and Judy Warnick and several other local leaders in Moses Lake for a demonstration of the Global Supertanker. Once a commercial aircraft, it’s now the world’s largest firefighting airtanker. Our state is hoping to make a home for it at Moses Lake where it can not only be readily deployed to combat increasingly…

Washington’s leaders focus on opening up international trade opportunities for small businesses

Washington’s leaders focus on opening up international trade opportunities for small businesses

Commerce now has in-country representation in 10 countries helping our state’s small businesses grow through exporting and international business partnerships The math speaks for itself. Export opportunities are a winning opportunity for Washington businesses. Jobs: At least one in four jobs in Washington state is connected to exports. The state’s economy is more closely aligned with international trade than any other state. Markets: More than 80% of the world’s purchasing…