Simplicity vs Complexity

We are of two minds: simplicity versus complexity. The tension is everywhere, the movement between them is part of the rhythm of life. Explore with us how this positively and negatively affects us in our organizations and individual lives.

Photo by Hal Gatewood on Unsplash

• Simplicity vs Complexity
  Simplicity versus Complexity. The tension between them is everywhere, but it can be both positive and necessary.
• Simplicity vs Complexity: Part 1 – Organizational Applications
  As growth and development in the human body bring about natural, healthy complexity, so growth of customer base, product lines, and employee count naturally increases complexity of the organization. What is the cost of that complexity and how to manage it?
• Simplicity vs Complexity: Part 2 – Individual Effectiveness
  Individually, it is our experience of complexity and its effect on our focus that can become problematic. Multi-tasking is a myth, but there are focus management tactics that can help.
• Simplicity vs Complexity: Part 3 – Strong Foundations
  We are of two minds: caught living in the tension of engaging with the complex, but always drawn to simplicity.This natural swing of the pendulum affects everything, including the emotional and spiritual areas of our lives. Emotion and spiritual dimensions are the foundation on which the rest of our lives and organizations are built.

Better Together

Question: Would you like to access hundreds of thousands of dollars of additional staff time to advance your mission? The answer is volunteers! Volunteers in Canada currently contribute billions of dollars of value to organizations. What is needed to tap into that value is addressed in the next four articles about designing, implementing, and sustaining an effective volunteer program.

Photo by Anna Earl on Unsplash

A volunteer is a person who does something, especially helping other people, willingly and without being forced or paid to do it
– Cambridge English Dictionary

• Better Together: Introduction
  What motivates people to volunteer? …often volunteering on a regular basis fulfills a desire for significance; to be part of something bigger…
• Better Together: Part 1 – Designing
  Design an effective volunteer program drawing on the deep resources available though Volunteer Canada.
• Better Together: Part 2 – Implementing
  Finding the right volunteer for the right task.
• Better Together: Part 3 – Sustaining
  Build a sustaining work environment that grows into an inspiring legacy.

Excel Re-Imagined

There are many sophisticated reporting and budgeting, forecasting and analysis tools on the market. Much of the marketing messaging around that software challenges us to ditch Excel in favor of their tool. They tell us Excel workbooks are prone to errors, don’t scale well, don’t handle succession well, and are subject to file corruption. It may all be true. But when everybody has left for the day, we still check the numbers in Excel.

Let’s learn to use this tool well to reduce the chance of errors and to make our workbooks scalable and understandable to other users.

Recent updates to Excel provide us with an even more flexible and powerful application. In this series of posts with accompanying demo workbooks for download, we explore some of the recent improvements. Read on….

• Excel Re-Imagined
  An intro to the new functions and capabilities of Excel’s updated calculation engine.
• Excel FILTER Function
  FILTER is used to return a subset from a larger set of data based on specific criteria.
• Excel SORT Function
  SORT does exactly what its name suggests. However, because it updates automatically, it is often a superior choice than a pivot table.
• Excel UNIQUE Function
  One of the most useful dynamic array functions, UNIQUE returns a list of unique values from a longer list. Used in combination with SORT and FILTER, it is useful in a wide variety of situaitons.
• Excel SEQUENCE Function
  SEQUENCE provides the ability to create dynamic sequences of numbers or dates. This function is helpful with setting up amortization tables or forecasting models. It can even be used at the core of a dynamic calendar.
• Excel XLOOKUP Function
  XLOOKUP brings numerous improvements over VLOOKUP: Returning values without regard to column relative position, predictable error handling and the ability to return an array of results.
• Excel LET Function
  Released for Office 365 recently, the new LET function brings clarity and transparency to spreadsheets by assigning names to the results of calculations.