This is a follow up post to our recent post highlighting the new Flash Fill feature in Microsoft Excel 2013. In this post we show you how to use the Concatenate Function when Flash Fill isn’t available if you’re running another version of Microsoft Excel.

Log on to Learn is excited to offer a two webinars in May. These events are short and to the point, and better yet they are 100% free! Setup in a conference room for your team, or attend from your home or office. Great topics covered in 30 minutes!

This short video shows you some very cool new features in Excel. We’ll highlight Excel Templates, show you how to accelerate data insertion via Flash Fill, and show you some Quick Data Analysis tools. The video is at the bottom of this post.

Cisco has recently updated and revamped there Cisco Certified Network Professional (CCNP) Security track and has announced new courses and Exams. KnowledgeWave is pleased to inform you that we’ve keep pace and all new versions of courses are available starting April 7th. Please note that the old certification track will expire on April 22nd, 2014.

Often we know what we want our Excel spreadsheet to do and how it should all work. Save time and precious brain cells by downloading and utilizing pre-formatted templates. In this short and direct video we discus how templates can be used when you use the same worksheet repeatedly.

Interested in a first look of Word 2013 and want to see some of the great features Word 2013 has to offer? We’ve pulled together two videos that will help get you introduced to the newest version of Microsoft Word. These are just the tip of the great content iceberg we’ve created for Word 2013. Our Excel 2013 Essentials Series is now complete and has been posted to Log on to Learn. Check out the topics below the videos. Want to watch one? Take us up on our 7-day, no credit card required trial membership and watch them all!

Microsoft has set the end of life for Microsoft XP and Office 2003 for April 8th, 2014. End of Life has lots of meanings, in tech talk, it means support and updates are going away. There’s no more support or lifelines. Phoning a friend is almost as useless as calling a support line. No more security patches or bug fixes. The countdown is on. Come April 8th, 2014 other vendors will likely discontinue supporting the XP operating systems on new releases of their software too. The end date is near, but the world isn’t coming to end. Let KnowledgeWave and Log on to Learn help you.

Do you have a story where BCC should have been used? Fresh off our Production Schedule. Considering using the BCC Field. In the past few days I've received two messages where BCC should have been used. My email was shared with people I didn't know, and I was forced to receive dozens of useless replies from others that hit the reply to all button. Share this video with the next person that sends you a message that should have used BCC.

Join our expert instructor as they share secrets related to 3D Formulas and Worksheet Management.

Join our expert instructor as they share the power of Sorting and Filter functions in Microsoft Outlook.

KnowledgeWave provides access to an Introduction to Agile Project Management course on an ongoing monthly basis. This course is an excellent starting point for you if you are familiar with the concepts of traditional project management and may have used the concepts to manage multiple projects. However, for projects in which the requirements are continuously changing, you may need a more proactive project management approach. In this course, you will use the Agile project management framework.

Learn how to change selected formatted text back to the default font and paragraph formats easily with the click of a button. In this video, we will select formatted text and use the clear formatting command in the Font group of the Home tab.

How we learn today is changing. Employee training is a $156B industry with 77% of US business providing eLearning options to employees, Log on to Learn is a solution that meets the needs of many multi-generational distributed work environments. Log on to Learn knows eLearning and provides an online community for our members, specialized and customized content and live events. Member companies have a number of Log on to Learn tools and features that appeal to HR and IT, making their employees more productive while tracking their learning advancement.

Believe it or not, this one question is asked more often than most any other in our Instructor-led hands-on Microsoft Outlook courses and let's face it. The world will never go completely paperless. Sometimes a paper copy of one's calendar is far preferable than the one on your screen. Here's how to print your Outlook calendar in your preferred configuration. This short tip is well worth the time.