Get Control Training: Time Management, Reinvented View RSS

Get Control - Get More Done!
Hide details



Crazy Useful Excel Tip! (It’s Magic!) Copy 25 Mar 10:40 AM (11 days ago)

A very, very useful excel tip!  How to Separate First Name and Last Name into Separate Columns!

 

Mike Song‘s Videos have been viewed over 5 million times in the past 2 years!

Title: An Incredible and Useful Excel Tip for Efficient Data Entry: Harness the Power of Control + E

Here is a great tip from our Get Control! of Excel Class!  Click here to request a class overview!  You can also take my online class – Get Control! of Excel by clicking here!

Introduction: Excel is a powerful tool widely used for data management, analysis, and reporting. However, when it comes to data entry tasks, such as inputting a large number of names, the process can become time-consuming and tedious. In this blog post, we’ll introduce you to a clever Excel tip that will revolutionize your data entry workflow and save you valuable time. By utilizing the Control + E shortcut, you can magically populate entire columns with just a few simple steps. Let’s dive in!

Step 1: Setting up the Headers The first step is to set up your Excel worksheet with appropriate headers. In this case, we’ll be working with First Name and Last Name. Ensure that these headings are placed in the first row of their respective columns.

Step 2: Copying the First Name In the cell below the First Name header, copy the first instance of the first name from your dataset. To do this, click on the cell containing the first name, press Ctrl + C (or right-click and choose Copy), and then click on the target cell and press Ctrl + V (or right-click and choose Paste). Now you have the first name replicated in the correct position.

Step 3: Populating the First Name Column Here comes the magic! Position your mouse cursor in the second cell under the name you just entered. In our case, it would be the cell directly below the first instance of the first name. Once you’re there, press Control + E simultaneously.

Excel will intelligently recognize the pattern you’re trying to establish and populate the entire column with the first names from your data. It saves you from the tedious process of manually copying and pasting each individual name. The Control + E shortcut enables Excel to extrapolate the pattern and perform the action in a flash.  Isn’t this an incredibly useful Excel Tip? 

Step 4: Repeating for Last Name Following the same process, copy the first instance of the last name from your dataset and paste it in the corresponding cell below the Last Name header. Then, position your mouse cursor in the second cell under the last name and press Control + E. Voila! Excel will populate the entire column with the last names, just like it did for the first names.

Conclusion: By leveraging the power of Control + E in Excel, you can streamline your data entry process and save significant time and effort. This handy tip eliminates the need for repetitive copy-pasting, allowing you to quickly populate entire columns with just a few keystrokes. Whether you’re dealing with a small list or a massive dataset, this trick will undoubtedly boost your productivity and make your Excel experience more efficient.

So, the next time you find yourself faced with the daunting task of entering a long list of names, remember this simple yet incredibly useful Excel tip. Harness the power of Control + E, and let Excel work its magic!

Start using this tip today and revolutionize the way you handle data entry in Excel. You’ll be amazed at how much time and energy you’ll save by employing this clever shortcut. Happy Excel-ing!

The post Crazy Useful Excel Tip! (It’s Magic!) Copy appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Smart AI Prompt Templates via Microsoft Edge 25 Mar 4:56 AM (12 days ago)

Smart Tip: Save Your AI Prompts via Edge!

If you’re using AI tools like Microsoft Copilot, ChatGPT, or Gemini, here’s a simple but powerful productivity tip:
Use Microsoft Edge Collections to organize and store your favorite AI Prompt Templates.


Why This Makes Sense (in Get Control Blue)


How to Activate Collections in Edge

Don’t see the Collections button? Here’s how to turn it on:

  1. Right-click the gear icon in the top-right of your Edge browser.

  2. Choose “Customize Toolbar.”

  3. Right-click the Collections button and select “Show in Toolbar.”

You’ll now see the Collections icon pinned next to your address bar.


How to Create and Use AI Prompt Template Collections

  1. Click the Collections icon in Edge.

  2. Select “Start new collection.”

  3. Name it something useful like “AI Prompt Templates – Copilot” or “ChatGPT for Presentations.”

  4. Add content by clicking “Add current page” or pasting specific prompt ideas as notes.

Use Collections to build a custom prompt library you can access from any device — fast, organized, and right where you work.


Want Help with Copilot or AI Prompt Templates?

Our clients love our practical, fast-paced AI training. We help teams master Copilot, organize their AI Prompts and make smarter tech decisions every day.

 Explore our Copilot Training Series
Or email us at info@getcontrol.net for a team training proposal.

The post Smart AI Prompt Templates via Microsoft Edge appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

How to Take Great Meeting Notes 9 Oct 2023 9:53 AM (last year)

 How to Take Great Meeting Notes
A OneNote Zip Tip by Mike Song

Mike Song | CEO | Get Control Training

          Mike Song

Hi and welcome to the Get Control Webinar site!  I’m Mike Song and you are going to love today’s OneNote Zip Tip. This tip is for anyone who attends meetings and wants to learn how to take great meeting notes. OneNote has an amazing template tool that allows you to take structured and effective meeting notes. The BIG MEETING OUTCOME allows you to summarize the meeting. Next, the Action Items are at the top making them really easy to find and follow up on. The general meeting notes are bullet-pointed below so that they are easy to read. This will help you take 40% more effective notes each time!

Create your meeting notes template:

  1. Open OneNote and type the BAM template
  2. Click on Insert.
  3. Click on Page Templates > Page templates (again)
  4. Click on Save current page as a template and name it
  5. Click on your BAM template.

Access your OneNote template:

  1. Click Insert
  2. Click Page Templates
  3. Select your BAM template

Taking exceptional meeting notes is an invaluable skill for administrative professionals, salespeople, and managers alike. Admin professionals rely on accurate records to keep operations running smoothly, while salespeople use them to close deals and meet client needs. Managers need comprehensive notes to make informed decisions and delegate tasks effectively. In an age where information is currency, these professionals must excel at capturing key insights, action items, and outcomes during meetings. OneNote’s template tool can be a game-changer, enhancing their ability to streamline processes, boost productivity, and deliver exceptional results. Mastering the art of note-taking is a non-negotiable for success in these roles.

Click here for a complete training brochure or click here if you’d like to chat about training for a team at your organization. 

Mike Song | info@getcontrol.net

 

The post How to Take Great Meeting Notes appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Microsoft Teams Speaker Coach Tip 11 Jul 2023 6:35 AM (last year)

 How to Use Microsoft Teams Speaker Coach
A Zip Tip by Mike Song

Hi and welcome to the Get Control Webinar site!  I’m Mike Song and you are going to love today’s Zip Tip. Microsoft Teams Speaker Coach is a great way to improve your speaking skills in meetings. It provides real-time feedback on your pace, volume, and use of filler words. You can also get a summary report after the meeting with more detailed feedback.

Here are the steps on how to turn on and use Speaker Coach:

  1. Start a meeting in Microsoft Teams.
  2. Click on the three dots in the bottom right corner of the meeting window.
  3. Select Turn on Speaker Coach.
  4. Speak as you normally would during the meeting.
  5. Speaker Coach will provide feedback in real-time.
  6. After the meeting, you can view a summary report of the feedback.

Here are some of the things that Speaker Coach will provide feedback on:

  • Your pace
  • Your volume
  • Your use of filler words
  • Your use of inclusive language
  • Your use of active voice
  • Your use of pauses

Speaker Coach is a great way to improve your speaking skills in meetings. It’s easy to use and provides valuable feedback.

Here are some additional tips for using Speaker Coach:

  • Speak naturally. Don’t try to change your speaking style too much.
  • Pay attention to the feedback. Speaker Coach’s feedback can help you identify areas where you can improve.
  • Use the summary report. The summary report provides more detailed feedback that you can use to track your progress.

I’ve been providing incredible Microsoft 365 tips like this for the past 20 years. Check out my blog for more tips and our website for more info.

Mike Song | info@getcontrol.net

 

The post Microsoft Teams Speaker Coach Tip appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Enhance Communication in MS Teams with Closed Caption Translation: A Zip Tip by Mike Song 19 Jun 2023 10:25 AM (last year)

Enhance Communication in MS Teams via Closed Caption Translation:
A Zip Tip by Mike Song

Hello, fellow MS Teams users! Mike Song here, bestselling author of the renowned book, “The Hamster Revolution.” Today, I’m excited to share an amazing feature in MS Teams that will revolutionize the way you communicate with your teammates, clients, and partners. Get ready to turn on Closed Caption translation in your own language! This feature will not only improve inclusivity but also foster better understanding during meetings and conversations. So, let’s dive right in!

Step 1: Open MS Teams and navigate to Settings:

Firstly, launch your MS Teams application. You can find it in your app menu or simply search for it. Once it’s open, take a moment to look at the top-right corner of the screen. You’ll find a profile picture or initials. Click on it and select “Settings” from the drop-down menu.

Step 2: Access the Accessibility Settings:

Next, within the Settings menu, scroll down and click on “Accessibility” on the left-hand side. This section allows you to customize various accessibility features to suit your needs.

Step 3: Enable Closed Caption Translation:

Now, in the Accessibility settings, you’ll find a section called “Closed captions.” Look for the option “Translate captions into my language.” Toggle the switch to the “On” position. This action will enable closed caption translation in your preferred language.

Step 4: Choose Your Preferred Language:

Afterward, click on the drop-down menu labeled “Choose your language.” Here, you’ll see a list of available languages. Scroll through the options and select your preferred language for closed caption translation.

Step 5: Save the Changes:

Lastly, don’t forget to click on the “Apply” or “Save” button to ensure that your selected settings are saved. With this, you’ve successfully turned on closed caption translation in MS Teams!

Conclusion:

Congratulations! You’ve just unlocked a powerful feature in MS Teams that will greatly enhance your communication experience. Closed caption translation in your own language will help bridge language barriers, making meetings and conversations more inclusive and efficient.

Remember, embracing accessibility features like this is a key aspect of creating an inclusive and productive work environment. So, make sure to share this Zip Tip with your teammates, friends, and colleagues to help them leverage the power of closed caption translation in MS Teams.

To learn more about MS Teams and discover additional tips and tricks, I highly recommend visiting the comprehensive MS Teams training page provided by Get Control. You can access it here.

Thank you for joining me on this journey to empower effective communication in MS Teams. Stay tuned for more Zip Tips, and until next time, happy collaborating!

Mike Song | info@getcontrol.net

 

The post Enhance Communication in MS Teams with Closed Caption Translation: A Zip Tip by Mike Song appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

See PowerPoint Notes During a Teams Presentation 22 May 2023 10:35 AM (last year)

How to Use PowerPoint Live in Teams to See Slide Notes and
Your Audience Sees Only the Presentation

Mike Song

Hi there, I’m Mike Song, and I’m here to show you how to use PowerPoint Live in Teams to give presentations that are both engaging and informative. This tip is from our Present Like a Rock Star class – you can download our training brochure here.

What the Heck is PowerPoint Live? Great question.

PowerPoint Live is a feature in Microsoft Teams that allows you to present your PowerPoint slides in a live, interactive way. When you use PowerPoint Live in Teams, your audience will only see the slides, while you can see your notes, speaker notes, and other information on your own screen. This gives you the freedom to focus on your presentation and interact with your audience without having to worry about flipping through slides or reading from a script. 

Here are the steps.

  1. Open the PowerPoint presentation that you want to present.
  2. In the top right corner of the presentation, click the Share button.
  3. Under Share content, select PowerPoint Live.
  4. If you want to start presenting on a specific slide, select that slide from the list.
  5. Click Share.

Your Teams audience will now see the slides of your presentation, while you will see your notes, speaker notes, and other information on your own screen with PowerPoint Live. You can use the controls at the bottom of the screen to move through the slides, zoom in and out, and interact with your audience. 

Tips for Using PowerPoint Live

Here are a few tips for using PowerPoint Live to give great presentations:

  • Use your notes and speaker notes to help you stay on track.
  • Use the laser pointer to highlight important points.
  • Use the chat feature to interact with your audience.
  • Ask questions and get feedback from your audience.

Conclusion

PowerPoint Live is a great way to give engaging and informative presentations. By using PowerPoint Live, you can focus on your presentation and interact with your audience without having to worry about flipping through slides or reading from a script.

I hope this blog post has been helpful. If you’d like more info on Team Training, just click here and let us know what you need!

Keywords: How to use PowerPoint Live in Teams, PowerPoint Live tips, PowerPoint Live presentation tips

 

Your Digital Skills Training Experts,

Mike Song | info@getcontrol.net

 

The post See PowerPoint Notes During a Teams Presentation appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Unlocking the Power of Exact Search: Outlook Email Search Tips 17 Apr 2023 12:35 PM (last year)

Unlocking the Power of Exact Search: Outlook Email Search Tips

Mike Song

As a professional, you probably spend a lot of time searching through your emails, documents, and other digital files to find the information you need. But have you ever found yourself frustrated by the sheer number of search results that come up when you type in a simple keyword or phrase? If so, you’re not alone. Fortunately, there is a simple trick that can help you streamline your searches and find what you need more quickly and easily. That trick is exact search, and it’s a game-changer when it comes to search efficiency.  Ready? This is one of my favorite Outlook email search tips.

So, what exactly is exact search? Essentially, it’s a way of telling your search engine to look for a specific phrase or word exactly as you type it, rather than returning results that contain variations or partial matches of the term. You can execute this Outlook email search tip by enclosing your search term in quotation marks. For example, if you want to search for emails that contain the phrase “out of the office,” you would type “out of the office” (with quotation marks) into the search bar.

The benefits of using exact search are numerous. First and foremost, it allows you to find the information you need more quickly and easily, as you can eliminate irrelevant results that may contain only part of your search term or related words. This can save you a lot of time and frustration, especially when searching through large amounts of data. Additionally, this Outlook email search tip can help you to avoid mistakes, such as accidentally sending an email to the wrong recipient because you didn’t notice a similar-sounding name in the search results.

But exact search isn’t just limited to Outlook. It can be used in a variety of platforms and search engines, including Gmail, Google, and Teams. Here’s a list of some of the most commonly used platforms and search engines where exact search is available:

  • Outlook
  • Gmail
  • Google
  • Teams
  • Slack
  • OneDrive
  • SharePoint
  • Dropbox
  • Evernote
  • Trello

It’s worth noting, however, that exact search may not work in all search engines or platforms. For example, it may not work in the search bar of some websites, or in the search function of some software applications. Additionally, some search engines may have different ways of implementing this Outlook email search tip, such as using the “+” sign instead of quotation marks.

In conclusion, if you’re looking to improve your search efficiency and productivity, exact search is a simple but powerful tool that you should definitely be using. By enclosing your search term in quotation marks, you can eliminate irrelevant results and find the information you need more quickly and easily. And with its availability in a wide range of platforms and search engines, there’s no reason not to start using it today. So go ahead and give it a try – you’ll be amazed at how much time and frustration it can save you in the long run.

 

Your Digital Skills Training Experts,

Mike Song | info@getcontrol.net

 

The post Unlocking the Power of Exact Search: Outlook Email Search Tips appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

You Can Use Delay Send in Outlook to Boost Productivity 13 Mar 2023 12:11 PM (2 years ago)

LEADER TIP:  Use Delay Send in Outlook!

Why Leaders Must Use Delay Send in Outlook.

How to Use Delay Send in Outlook

As corporate professionals, we’re all familiar with the stress that comes with managing our inboxes. The constant barrage of emails can be overwhelming, and it can be tough to strike the right balance between being responsive and maintaining boundaries around our work-life balance. One tool that can help with this challenge is the Delay Send feature in Outlook. In this blog post, we’ll explore how to use Delay Send to take control of your email timing, boost your productivity, and reduce stress.

What is Delay Send in Outlook? First, let’s define what Delay Send is and how it works. Delay Send is a feature in Microsoft Outlook that allows you to write an email and schedule it to be sent later. This means that you can draft your message whenever inspiration strikes, but delay the sending until a more appropriate time, such as during work hours. With Delay Send, you can ensure that your messages get the attention they deserve while also being considerate of your colleagues’ time.

How to use Delay Send in Outlook now that we know what Delay Send is and why it’s useful, let’s dive into how to use it. The steps for using Delay Send differ slightly between the desktop version of Outlook and the mobile app, but the overall process is simple and easy to master.

To use Delay Send in Outlook mobile app, follow these steps:

  • Open the email you want to send
  • Address it and type your message as usual
  • Tap the three-dot button icon in the top right corner
  • Select “Schedule Send”
  • Choose the date and time you want the email to be sent
  • Hit “Send”

To use Delay Send in the Outlook desktop version, follow these steps:

  • Compose your email as usual
  • Click on the “Options” tab in the top menu
  • Select “Delay Delivery”
  • Choose the date and time you want the email to be sent
  • Hit “Close”
  • Hit “Send”

Now that we know how to use Delay Send, let’s explore the benefits of this feature. By using Delay Send, you can:

  • Avoid disturbing your colleagues on weekends or outside of work hours
  • Reduce the chances of important emails getting lost in a flood of incoming messages
  • Optimize the timing of your messages for maximum impact and effectiveness
  • Regain control over your email inbox and reduce stress

With the right tools and strategies, managing your email inbox can become less of a source of stress and more of a productivity booster. By mastering this tip, you can take control of your email timing and enjoy greater success at work and in life. We hope this post has been helpful in explaining how to use Delay Send and highlighting its many benefits. To see a video tutorial on how to use Delay Send in Outlook, click here. If you’re interested in learning more about digital skills training for your team, please reach out to us at info@getcontrol.net. Thanks for reading!

 

Your Digital Skills Training Experts,

Mike Song | info@getcontrol.net

 

The post You Can Use Delay Send in Outlook to Boost Productivity appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Transform an Email Into a Teams Chat 8 Feb 2023 8:51 AM (2 years ago)

PC Users: For the best view, click the expand button in the lower-right corner of the video ⇑

Try This Transformer Tip!

You can save time when you transform things in the world of Microsoft 365. To transform an email into a Teams chat, just click the Share to Teams icon, and just like that, the email is transformed into a Teams message. You can also send this email to OneNote by clicking the Send to OneNote button. You can then guide this message to a specific page.

Transform an Email into a Teams Chat in a Flash!

Open the email > Click the Share to Teams icon > Share To Type in Name or Group > Click Share.

When You Get an Email – Transform it into a OneNote Page.

Open the email > Click the Send to OneNote icon > Select the Section or Page > Click OK

Transform your email into a Scheduled Action.

Left-click and drag the email to the calendar icon > Select a date/time > Click Save & Close

Now that you are a transformer, you can save a great deal of time and get control of your digital day with this amazing time management practice. Isn’t that an excellent tip?  Why not share it with your team?

Complete the Form and Get More Done!

For more Teams, Excel, and Outlook tips and tricks, complete the form on this page. If you meet with us to discuss Team Training — you will receive a free copy of our bestselling book Zip Tips: The Fastest Way to Get More Done.

Your Digital Skills Training Experts,

Mike Song | info@getcontrol.net

 

The post Transform an Email Into a Teams Chat appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Outlook Email Tip: Reply to Multiple Questions 4 Apr 2022 6:31 PM (3 years ago)

Reply to Multiple Questions via AutoCorrect

A great tip from our Get Control of Email Class!

Title: Streamline Your Email Responses: Create an Autocorrect in Outlook to Reply to Multiple Questions

Introduction:
In today’s fast-paced world, effective communication is essential, especially when it comes to handling emails. Often, we receive emails with multiple questions that require thoughtful and organized responses. To ensure clarity and avoid confusion, it can be beneficial to differentiate your responses from the sender’s questions. In this blog post, we will guide you through the process of creating an autocorrect in Microsoft Outlook that automatically adds “Your Name Answer:” as a prefix to your responses, making it easier for recipients to identify your replies.

Step 1: Accessing Autocorrect Options in Microsoft Outlook:
1. Open Microsoft Outlook on your computer.
2. Click on the “File” tab located in the top-left corner of the screen.
3. From the dropdown menu, select “Options.”

Step 2: Configuring Autocorrect Settings:
1. In the Outlook Options window, click on “Mail” located on the left sidebar.
2. Scroll down until you find the “Compose messages” section.
3. Click on the “Spelling and Autocorrect…” button.

Step 3: Adding Autocorrect Entries:
1. In the Editor Options window, select the “Proofing” tab.
2. Click on the “AutoCorrect Options…” button.

Step 4: Creating Autocorrect Entry:
1. In the AutoCorrect window, locate the “Replace” field.
2. In this field, enter a unique keyword that you will use as a trigger for the autocorrect. For example, you can use “@@@”.
3. In the “With” field, enter “Your Name Answer:” or any other text that you prefer to use as a prefix.
4. Click on the “Add” button, followed by “OK” to save the autocorrect entry.

Step 5: Utilizing the Autocorrect Feature:
1. Start composing a new email or reply to an existing one.
2. Whenever you want to answer a question or respond to a specific point, type the unique keyword you defined in the “Replace” field (e.g., “@@@”).
3. Once you finish typing the keyword, Outlook will automatically replace it with “Your Name Answer:” or your chosen prefix.
4. Proceed to provide your response to the respective question or point.

Benefits of Using Autocorrect for Multiple Questions:
1. Improved clarity: By differentiating your responses from the sender’s questions, recipients can quickly identify and comprehend your answers.
2. Enhanced organization: Autocorrect helps structure your email responses, making it easier for both you and the recipients to navigate and reference specific questions and answers.
3. Time-saving: With the autocorrect feature, you don’t have to manually type the response prefix each time, saving you valuable time and effort.

Conclusion:
Managing email communication effectively is crucial for maintaining professional relationships and avoiding misunderstandings. By creating an autocorrect in Microsoft Outlook that adds a distinct prefix to your responses, such as “Your Name Answer:”, you can streamline your email exchanges and ensure clarity when answering multiple questions. Implementing this simple autocorrect feature will help you stay organized and enhance your overall communication experience in the digital realm.

When you receive an email with multiple responses, this tip will allow you to hit reply and respond to each question using a custom autotext.

The example shown in the video is when I type MSA and Mike Song Answer: pops out. This helps your recipient know precisely where your responses can be found. I even show you how to choose a special color for your text to make it easier to process and read your answers.

Interested in team training? Please email us at info@getcontrol.net.

The post Outlook Email Tip: Reply to Multiple Questions appeared first on Get Control Training: Time Management, Reinvented.

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?