Author: Michelle Jones (Page 3 of 47)

How to Keep Learning When You’re Feeling Drained

Staying relevant in your career requires continuous learning, but when you’re already feeling drained, finding the energy to improve your skills can feel overwhelming. So how can you keep learning when you’re exhausted?

Start by challenging your belief that you can’t learn when you’re tired. When you’re feeling depleted, you may start to identify so much with the fatigue that you forget your agency over your thoughts and beliefs. In this condition, every exclamation of “I’m so tired,” teaches your mind to believe that it’s probably impossible to learn anything when you’re exhausted. Instead try observing your fatigue without judgment or a desire to get rid of it and get curious about what’s possible even with such constraints. Making space for the fatigue enables a more mindful response and one from which you can creatively challenge unhelpful beliefs you’ve been holding onto while in that state.

Next, focus on learning topics that solve urgent problems in your work. Instead of laboring through subjects that don’t feel urgent or pertinent to you, begin with topics that relate to existing challenges and expand on your current knowledge to gather momentum fast. This will create momentum and make the process feel more rewarding

Don’t limit yourself to formal programs. Mentorship, peer-to-peer learning, or even quick tutorials can be more effective and easier to fit into your schedule. Seek out learning opportunities that align with your personal values and goals so they feel meaningful rather than like another obligation. When you emotionally connect with what you’re learning, it’s more likely to become part of your routine.

Finally, work with your brain, not against it. Use techniques like spaced repetition (reviewing information at increasing intervals over time) and self-testing (quizzing yourself to reinforce what you’ve learned) to retain information more effectively. Break learning into small, manageable chunks and revisit them regularly to build long-term retention.

In today’s fast-paced world, continuous learning is the key to having lasting influence in your career, yet already feeling overwhelmed by your daily workload makes it hard to stay consistent. By using these strategies, you can develop a lifelong learning journey that not only elevates your skills but lifts you out of exhaustion by moving closer to your highest potential.

 

Reference:
Harvard Business Review (2024, September 24) Nihar Chhaya: How to Keep Learning at Work – Even When You Feel Fried

Srini’s Tech Tip: Flash Fill to Extract or Combine Data

When working in Excel, the data is not always numbers, but text. While numeric data is great for calculations, when it comes to text data, you may need to know how to manipulate it to produce the results. It could be as simple as extracting (aka “parsing”) data or combining (aka “concatenating”) data.

While there are TEXT functions, such as LEN, CONCATENATE, RIGHT and LEFT, that are very useful and powerful, knowing how to use those functions is not always common knowledge, or the syntax for the formulas involving multiple nested functions (a function within a function) is quite complex, and even cumbersome.

Fortunately, the Flash Fill feature helps you to extract or combine pieces of embedded data, to produce the results.

Scenario:

In our example, there are 17 rows of employee data, that have 4 individual pieces of data all combined together into a single string (a single piece of data in a cell). Your objective is to “parse” the data into several individual columns, and also create a new one – Last Name, First Name, Department, and a new Email Address column. Use the Flash Fill feature to help you complete all the individual columns, including the last Email Address column.

** Dates cannot be extracted using Flash Fill.

 

FLASH FILL STEPS:

STEP 1.  In Cell B4, begin typing the Last Name of the employee (“Kling” in this example), and press the ENTER key.

STEP 2.  In Cell B5, begin typing the next last name “Willis”, and Excel brings up a “gray” list of names suggested for the remainder of the employees (Excel is essentially asking if you want the “Flash Fill” to complete the rest of the last names. The more unique the last names, the quicker Flash Fill will recognize the Pattern of all the Last Names. Sometimes, you may need type a few entries before Excel recognizes and suggests the pattern.

STEP 3.  Press the ENTER key (to complete the list of Last Names).

 

STEP 4.  Repeat the steps 1 to 3 for First Name and Department:

  • Type the first name “Sara” in Cell C4, press enter; Begin typing the first name “Sean” in cell C5, and when you see the “Grey” suggestions, press the ENTER key to complete.
  • Type the department name “Sales” in cells D4 to D7 manually, as they are not unique. When you begin typing the next department name “Development” in cell D8, Excel recognizes the pattern and suggests the gray Flash Fill pattern completion; press the ENTER key to complete.

 

Flash Fill will not pickup dates. You have to use a TRIM and RIGHT text functions for extracting the date from the right side of the data. The RIGHT functions extracts specified number of characters from the right, the TRIM function removes additional Spaces. Text functions are taught in Excel Level 2 Intermediate.

STEP 5.  Using the TRIM and RIGHT functions to Extract Date from the Right side of Employee Data:

  • Type “=TRIM(RIGHT(A4,11))” in Cell E4 and press ENTER.
  • Copy down the Formula into the other cells below.

 

STEP 6.  Continue using Flash Fill to complete the Email Addresses:

  • Type the first email address in cell F4 manually, “sara.kling@duke.edu”, for example
  • When you begin typing the next email address “sean.willis@duke.edu”, Excel Flash Fill recognizes the pattern; press ENTER to complete the email addresses

 

 

** Flash Fill, Text To Columns, and Text Functions/Formulas are the most common methods for Extracting and Combining data.

Create a Schedule That Allows You to Work Smarter

The amount of work we need to get done seems to grow daily. To avoid becoming overwhelmed, we have to become more productive than ever. Being busy doesn’t automatically equate to doing important work. Instead of filling your calendar with busywork that will burn you out or stunt your career growth, be more intentional with your time.

Working smarter, not harder, means finding ways to use your energy and time at work more efficiently. To do this, you can use various strategies to help you prioritize your work, helping you identify the most important tasks. Besides increasing productivity, here are some other benefits of learning to work smarter: 

  • Saving energyWorking in short bursts, for example, allows you to accomplish challenging tasks with more energy and produce better results.
  • Increasing motivationIt can create feelings of positivity about your job, colleagues and yourself.
  • Making you more valuableOrganizations often look for ways to get more accomplished with less effort, and being able to do this can allow you to become a more important employee.
  • Increasing self-esteemWorking smarter allows you to create a better-quality product with less effort, which can boost your self-esteem.

Here are some ways high-achieving workers can build a smarter schedule.

Don’t overcommit. When your calendar is packed with back-to-back meetings, it’s a sign that you have too many priorities. You should intentionally leave space in your schedule to decompress and process your work. Aim to commit to only 80% of the opportunities and responsibilities presented to you. This also forces you to consider and name your priorities.

Be intentional about your time. You control your schedule; your schedule doesn’t control you—or at least it shouldn’t. For example, if you decide you’ll work all afternoon because you have meetings all morning—despite the afternoon being the time of day when you typically hit a creative wall—then you’re letting your schedule guide you. Instead of accepting this, make a change, and let the people in your professional and personal life know what you need to be at your best.

Measure your results, not your time. Keep an ongoing list of everything you accomplish during the day. This can help you feel motivated and accomplished. This list makes it easy to celebrate your accomplishments and better anticipate how long similar tasks may take in the future.

Set short deadlines. Setting deadlines for your work can help you focus and increase your efficiency. This can leave you with more time during your day to focus on other tasks or allow you to clean your office space before leaving for the day.

Use productivity tools. Many programs or applications can help you automate tasks and better track your work productivity. Letting a program track this data for you saves you time from doing it yourself, which can allow you to focus on more priority items.

Working smarter, not harder, can improve your productivity and performance while increasing your overall job satisfaction. It also can make you a valuable asset to your organization, increasing job security and potentially helping you earn a higher salary. Learning about some strategies to work smarter can help you be more successful throughout your career.

 

References:
Harvard Business Review: HBR IdeaCast (2024, April 2) Curt Nickisch and Laura Mae Martin: Treat Email Like Laundry – and Other Tips from Google’s Productivity Expert
Indeed (2023, October 13) Jamie Birt: 17 Ways to Work Smarter, Not Harder (With Benefits)

Develop Your Observation Skills to be a Better Leader

The practice of observation and the discipline to be a more observant leader (defined as the ability to effectively interpret the world around us), is an overlooked skill. Observation is a skill that is especially important for understanding and operating in the highly connected and ever-changing world in which we operate.

Too often, executive leaders focus on “doing” their jobs through the lens of task and execution. Making the conscious choice and actively seeking to understand the many facets of our world by being present, and engaging “in person” without a filter, bias, or assumption, takes effort. Observation reveals itself through intentional action and behavior, and a leader’s ability to be present and connected during in-depth conversation.

Being a more observant leader can make a meaningful difference in the following ways:

A heightened sense of awareness. By paying close attention to dynamic connections in your environment, and the behaviors, attitudes, and needs of various stakeholder groups, you are better able to identify trends and anticipate challenges. You will also develop a greater sense of and foster empathy and understanding.

Improved decision-making and problem-solving skills. By carefully observing situations, you gather relevant data in the moment, identifying patterns, and recognizing underlying causes. You are more apt to consider multiple perspectives before making critical choices.

Continuous learning and innovation. By encouraging your team to be curious, observe, question, and explore, you unlock or discover how the gifts of others, as new perspectives or creative insights, are raised.

Stronger relationships. By keenly observing individual styles and behaviors, you can provide targeted guidance that supports growth. Combined with the power to listen attentively, you foster trust and open lines of communication.

Now that you know the benefits of being a more observant leader, how do you groom your skills?

  1. Cultivate a mindset of curiosity and openness.
  2. Practice active listening and non-verbal observation.
  3. Develop situational awareness.
  4. Encourage feedback.

As an executive leader, honing your observation skills to better support and serve the stakeholders you lead and partner with is an essential trait for your ever evolving leadership toolkit.

 

References:
Medium (2023, June 28) Steve Schloss: Observation: An Often-Overlooked Leadership Trait

« Older posts Newer posts »