Category: Uncategorized (Page 1 of 36)

It’s Meaningful May!

There are a lot of ways to live with purpose, even in difficult times. So, this month let’s focus on the little things that make life meaningful. The Meaningful May calendar is full of little actions that make life feel bigger and better. Give it a try and share it with others too.

 

 

If you like the Meaningful May calendar and are interested in prioritizing happiness, check out Action for Happiness. There you’ll find loads of ideas shared by people taking action to create a happier and kinder world, together.

Srini’s Tech Tip: Insert a Picture in a Cell – Excel 2021 & 365

Traditionally, people have inserted pictures or Logos in an Excel worksheet. Unfortunately, the method used is tedious and does not provide any dynamic change for the picture (i.e., the picture is static). One would have to replace the picture manually and resize it again to make it fit once more.

Imagine a circumstance where you would want a picture or a logo to change on demand.  For example, based on a value entered in a cell (or calculated value in a cell), you want the picture to change automatically.

Scenario:

In our example, a person enters a number in a cell (D3), and the picture at the top of the worksheet needs to change automatically.   The example shows only 5 numbers associated with 5 pictures, but this situation could easily be a larger number, like a team of people.  While the feature in this example is mainly to show the ability to Insert a Picture in a Cell directly, the lookup and automation is performed using a VLOOKUP function (taught in Excel Level 2 at L&OD).

 

 

 

 

Picture Automation using the VLOOKUP Function:

  1. Convert the range of Numbers & the Picture cells (F5:G10) into a Table (CatTable)
  2. In Cell D3, enter a 1 for a default number to start with as the starting Input Value
  3. Resize Cell H1 where the target Picture will Change automatically
  4. Enter a VLOOKUP formula in Cell H1, to lookup the value entered in cell D3, and load the picture into cell H1, the target cell

    Syntax: =VLOOKUP(D3,CatTable,2,FALSE) – Formulas must begin with an equal sign, must not contain any spaces, arguments must be separated by commas

 

Srini’s Tech Tip: Using the Navigation Pane in Excel 365 and Excel 2021

As you get more advanced in your Excel skills, you will inevitably have many data sheet tabs in a workbook. While it is easy to click on a few visible tabs, or even use keyboard shortcuts to navigate to each tab, these two methods are very cumbersome when you have many sheet tabs.  Scrolling within a sheet for multiple objects or items can also become a time intensive task.

The good news is, in Excel 365 and Excel 2021, there is a new feature to navigate the sheet tabs and the contents within, whether titles, tables or charts. The new feature is the Navigation Pane. Just enable the Navigation Pane, and you can click on a sheet name and the contents within.

Step 1: Enable the Navigation Pane

  • Click on the View tab, then click on Navigation in the drop-down menu.

 

Step 2: Working with items in the Navigation Pane

  • In the Navigation Pane, click on the sheet name to switch to the sheet tab in the workbook.
  • Use the Expand/Collapse arrows to the left of the name to expand and display the contents of the selected sheet.
  • Click on a sub item/content name to go to the specific item or object in the worksheet, instead of scrolling.

 

The Navigation Pane displays all the items in a list, like a Table of Contents page, or a Bookmark Windowpane in a lengthy Adobe PDF document.  The Expand/Collapse arrows are useful when navigating a long list of worksheet contents.  The Search Bar at the top of the Navigation Pane allows you search for a sheet name, which further minimizes scrolling within the pane itself.

 

Why Perfectionism Can Lead to Poor Performance

You’ve heard it before: You shouldn’t let perfection get in the way of progress. But you also want to excel at work and perfection may seem like the best pathway for career growth. However, perfection can be a barrier to getting ahead—in some surprising ways. It’s to your advantage to let go of the pursuit of perfection and find ways to be excellent without being ideal.

Some aspects of perfectionism—setting high standards and working toward goals proactively — can be good for your career, but perfectionism has a significant downside. Obsessing about making mistakes or letting others down or holding yourself to impossibly high standards can have negative consequences. According to research examining 43 different studies over 20 years by York St. John University, perfectionism is linked to burnout as well as depression, anxiety and even mortality.

‌Perfectionism is demotivating. Striving for excellence and pushing yourself are wonderful motivators, but you’ll reduce your engagement if you carry these too far. With ideals which are unattainable, you’ll never feel like you’re good enough and you’ll miss out on rewards of accomplishment. When you’re down or disheartened, it will be tough to put your energy into your work and you’ll detract from your own effectiveness.

Demotivating perfectionism often results in:

  • Anxiety and depression
  • Physical health problems

Perfectionism distances you from others. If you fall into the trap of believing you’re close to perfect, you run the risk of intimidating others who know they aren’t. They will want to avoid the overwork or overthinking which become your hallmark. Further, if you avoid admitting mistakes, you’ll come across as inauthentic.

Signs that your perfectionism is creating distances from others:

  • Strained relationships
  • Not being present

Perfectionism reduces your effectiveness. Know when enough is enough and be satisfied with delivering on a project where you’ve performed well, if not flawlessly. Rather than waiting to release your work until it’s perfect, get comfortable with incremental improvement over time, and the career benefits of continuous learning.

Indicators of reduced effectiveness due to perfectionism:

  • Decreased productivity
  • Increased vulnerability

 

 

So how might you shift from your perfectionist tendencies? Whether you’re a confirmed perfectionist or a personality who is always driving for too much, you can change. Here are some suggestions.

Change your thinking. Recognize that you’re limiting yourself and seek to think differently—taking the pressure off of yourself to be all things to all people all the time. Know you can’t possibly do it all and reassure yourself that whatever you do well is a contribution to the community and to your colleagues.

Find a friend. Find a trusted colleague with whom you can compare notes and who can give you feedback and validate your efforts, as well as challenge you when you’re getting stuck. The process of reflecting with a friend and feeling understood can help you make progress.

Be selective. Another way to manage perfection is by assessing what’s most important for your performance and growth. There may be tasks which are less important or less consequential—and you can put less into those—while other tasks demand a higher level of effort.

Set deadlines. Work expands to fit available time, so set deadlines for your projects. Give yourself a timeframe for your work, and when you hit the limit, call the outcome good enough. Strive to do your best and be ready to say something is good enough when it’s time to complete the task.

Adopt a mantra. Sometimes it can be helpful to adopt a saying which will help you stay focused on your goal. For example, tell yourself, “Done is better than perfect.” Or, “Don’t confuse excellence with perfection.” Keep these in mind as you seek to change your beliefs and your behaviors.

Excellence is certainly linked with career advancement, but perfection is not. For all kinds of reasons, perfection can limit you—in terms of your performance, relationships, happiness and wellbeing. No human is perfect, but you can reimagine “perfect” as embracing your imperfections. Be truly you—own it—your talents and strengths as well as your limitations.

 

References:
Forbes (2022, April 3) Tracy Brower, PhD: Perfectionism is Bad for Your Career: 3 Most Important Things to Know
WebMD (2021, August 17) Dan Brennan, MD: Perfectionism: 6 Consequences to Watch For

« Older posts