Mike Song, organization, tech quotient, TQ

Can you imagine a friend who helped you to relax and thrive at work? And what if this “friend” also helped you get a big raise and a great promotion! Well TQ (Tech Quotient) is that friend! TQ is the ability to strategically learn, leverage, and share technology. Technology skills matter more than ever because technology has invaded every facet of modern life! That’s why we created the Get Control! of TQ class.

Excel, Mike Song, organization

Best Excel Tips Video: Create Excel Charts, Graphs, and Tables These insights are considered to be the best excel tips ever.  Create creating stunning visuals and turning boring spreadsheets into valuable knowledge. Hi!  I’m Mike Song, author of The Hamster Revolution and the Get Control! of Excel class.  And now we are going to help make your spreadsheets more informative via the smart use of stunning visuals.Amazing Tables  Tables make data easier to read.  They come formatted with colored rows and filters.  Place your mouse at the top right corner of your data.  Click Insert > Table > Select the table area > and Click OK.  At this point, you can select from a variety of table designs by clicking on the table and looking under Design for options. Dynamic Dropdowns: Dropdown lists help users select from a consistent group of options.  Create your list items in another part of your spreadsheet.  Then, click on the cell in which you want your dropdown list to appear.  From the Data Tab click on Data Validation in the Data Tools Area and select Data Validation again.  Click on the drop-down menu below Allow: and select List. Click on the Source area >Select the cells that contain the info that you want to appear in your dropdown list > Click OK. Freeze Panes:   If you scroll down in a spreadsheet and can’t see the headers, it can be hard to know what is actually in each column.  However, if you freeze the top header row, you can always see what is in each column as you scroll down.  The titles are visible!   To freeze a row select the entire row below the row or rows that you want to freeze. Click the View Tab on the ribbon and select the Freeze Panes command > Click Freeze Panes.  The rows now freeze at the gray horizontal line. You can also use this process to freeze a column. To unfreeze a row or column click on View > Freeze Panes Command > Unfreeze Panes. Smart Sort:  Let’s say we want to sort this data set to see which sales rep had the biggest Total Sales number for the year.  Click anywhere in the data area and select Control + A.  That will select all the data in the area really fast.  Now, click Data and Sort.  Make sure that the box next to My data has headers is checked because our data does include headers.  Now, next to Sort by, select the column that you would like to sort on.  I will select Total Sales. Under Order, I will leave  Largest to Smallest as my selection and click OK.  And now I can clearly see that Pam had the biggest sale of the year because I was smart about sorting. Friendly Filters: The Filter feature allows you to select what information you do and don’t see.  Isolating a specific kind of data in a column provides useful information.  The Filter feature is much easier to use when a worksheet contains headers or titles. Click into any cell in the source data that you want to filter.  Select Data > Filter and Filter Arrows will appear next to your headers.  Click on the Filter Arrow for any column and the Filter Menu will appear.  Uncheck the box next to Select All to deselect all items.  Then selectively check the boxes of the items you want to see in that column and click OK.  Now you are looking at a subset of your information which is incredibly useful when working on larger spreadsheets. I want to isolate sales of the Falcon2000 Drone.  I simply uncheck Select All and check Falcon2000 and there you go! I could even filter two columns.  For example, by clicking on the salesperson filter, I can isolate Jim’s sales of the Falcon2000. Conditional Formatting:   Conditional formatting automatically applies icons, data bars, or colors to data cells based on the value of that cell.  It is one of the best excel tips ever! If you had sales info and wanted your top sales month to be in Green and your worst sales month to be red, you can do it with Conditional Formatting. Select the cells where you want to apply conditional formatting.  From the Home Tab, click on Conditional Formatting > Hover your mouse over the preferred conditional formatting type.  There are a ton of options! Click on your format type and presto – now you can see patterns and highlights in the data.  For example, it looks like Carlos, our number one sales rep started the year with excellent sales—lots of green — but is trending downwards in Q2 as signified by the red color here. Chill Charts Charts:  They provide a colorful, informative representation of data contained within spreadsheets.  Select the data in a worksheet that you want to use for a chart. Include the column and row descriptions or headers.   Click Insert > Click your preferred chart category and then click your preferred chart type. There are many great options here.   I often click on Recommended Charts to see what options Excel will offer.  I really like this line chart as it shows the sales trends for each rep.  Notice Pam’s sales are rising steadily throughout the first half of the year?  Interesting! Simplify a Chart: In many cases, the chart will be easier to understand if you delete the features that make it look busier including lines and labels that do not add value.  If you click on the chart, you will see the modification options on the upper right side of the chart.  Starting with Excel 2013, users can more easily use three design tools to modify charts. The Green Plus Sign allows you to remove elements from your charts like Data Labels or grid lines. The paint brush lets you set a chart style, and color scheme and the Filter Icon lets you edit what data appears in your chart.  That’s it!  These are the best excel tips ever! Our training is available in all formats including live, keynote, webinar, and e-learning.  Email me today for more info or complete the contact form on this page for more info!   We offer annual subscriptions to all our content.  Just contact us for more info on an enterprise or team license at info@getcontrol.net Effective business communication will help every member of your team become more productive! Get Control! will help us all get better at Excel!  They have the best Excel tips ever!https://www.getcontrol.net/best-excel-tips-video/

action items, meeting tip, Mike Song, organization, Save Time

Meeting Tip: Complete Action Items 4 Critical Steps to Getting Action Items Done Welcome!  Click below to watch a video that will help you complete action items.  Our Get Control! of Meetings class teaches your entire team how to do just that!  Complete the form on this page or the Contact Us page for a free brochure on our team training, keynote talks, e-learning and webinars! Email us at info@getcontrol.net for more info.Many teams struggle to complete action items. When busy professionals leave a meeting they enter into a world of email overload, surprise tasks, and endless interruptions.  This video from our popular Get Control! of Meetings seminar will help you and your team get all action items completed!4 Critical Steps to Complete Action Items Complete actions on a single document that can easily be shared with the team. Over-describe each task to avoid procrastination when you revisit the action days or weeks later. Review action items as a team so that your action list is clear, complete, and fully approved by every team member.  Use Office 365 or Google docs to share the tasks and track progress.  (Free template at www.getcontrol.net/free)Another great idea is to always list the action items at the top of your document preceded by an asterisk.  Each action item should contain the Who, What, and When the the task.  Make sure that you discuss these insights with your team and get everyone’s agreement.  You will be thrilled when you see your team’s performance lifting off!This class is available in all formats including live, keynote, webinar, and e-learning.  Email me today for more info or complete the contact form on this page for more info!   We offer annual subscriptions to all our content.  Just contact us for more info on an enterprise or team license.  Effective business communication will help every member of your team become more productive!We Must Complete Action Items! https://www.getcontrol.net/complete-action-items/

Email, gmail, Mike Song, organization, outlook

Clean Up Your Outlook and Gmail Inbox Here is a great tip from our Get Control! of Email class. Time Management author and speaker Mike Song demonstrates a quick and easy way to cut inbox volume by 20%! Our enterprise training could save every colleague 15 days a year! Complete the form on the right for more info.https://www.getcontrol.net/clean-up-your-outlook-and-gmail-inbox/

blog article, Mike Song, organization, Powerpoint

PowerPoint Presentation Tip: Animate Your Bullets! This PowerPoint Presentation tip will help you better engage your audience! PowerPoint Presentation Tip Video: Our new Get Control! of Presentation Skills class has amazing PowerPoint presentation tips for anyone seeking to become a more engaging, more confident presenter. In this video I show you how to boost engagement via a simple animation.  If this video helps you become a better presenter — then contact us at info@getcontrol.net for more info on how we can train your entire organization.PowerPoint Presentation Tip: Most presenters show all of their bullet points on every slide.  The audience reads ahead and becomes incredibly bored.  I would estimate that 80-90% of the presentations I am asked to evaluate are set up with static bullets. Powerpoint and other presentation tools are incredibly easy to adjust so that your bullets come in one at a time — at exactly the right time.  This will make you feel more confident and your audience will be attracted by the motion on the screen as each bullet flys in. One of my favorite PowerPoint engagement tips is to have the audience guess at a statistic and then advance the slide to see the answer.  Your audience will be twice as engaged if you do this 2-3 times during a 30 minute presentation. So watch the video above and you’ll see that you are instantly better at engaging an audience.  Then contact us for more info on our ground-breaking time management, email, meeting, and presentation skills training. Our training is available in all formats including live, keynote, webinar, and e-learning.  Email me today for more info or complete the contact form on this page for more info!   We offer annual subscriptions to all our content.  Just contact us for more info on an enterprise or team license at info@getcontrol.net Effective business communication will help every member of your team become more productive! This is a fantastic Get Control! PowerPoint Presentation Tiphttps://www.getcontrol.net/powerpoint-presentation-tip/