In this blog post we will show you a very handy mathematical function that performs two operations in one, multiplication and addition. Using =SUMPRODUCT() allows you to return the sum of the products of corresponding ranges or arrays. In our example below we show you how to use the SUMPRODUCT Function to get a grand total. Our Video below shows you how you may currently be calculating your grand total, and we also show you exactly, step-by-step how to use this function.

Students and educators from select schools can use their .edu email accounts to get the Microsoft Office 365 Software Suite for free and waive the yearly subscription fee for as long as they are enrolled at their school at the Microsoft Store. A yearly subscription to Office 365 would normally cost $279.96 over 4 years. Office 365 includes Word, Excel, PowerPoint, OneNote, Outlook, Access and Publisher, as well as cloud support, SkyDrive online storage space and 60 minutes of Skype calls per month. Only select schools qualify for this deal. Check to see if your school is listed.

Have you ever wanted to make your PowerPoint presentation pop and stand out from the rest? Often, bulleted lists on a PowerPoint slide can be less than exciting. Keeping the attention of your audience with this powerful graphic tool will certainly transform and enhance your presentation into a masterpiece. In this video, our PowerPoint Presentation Wizard will show you exactly how easy it is to use what is called SmartArt. SmartArt graphics are pre-defined templates that allow for very easy insertion of graphics of all types that contain text and even images that will enhance your information.

For many of us, our planning revolves around our calendar AND outside conditions. Outlook 2013 offers a handy new bar that provides the 3 day weather forecast for up to three locations! This may be something that you didn’t know existed, but may not be able to live without once you activate it! Before scheduling meetings, you may want to know the weather, especially if you’re traveling to a different city. Knowing the weather can be helpful when planning for travel to a conference or even a vacation! Do I need a sweater, shorts, an umbrella, or is a big storm coming in that will delay flights or close down roads?

When you add a table to a document it is automatically inserted with plain black borders around it and around every cell in the table. These plain thin black lines are fine to work with when you are filling in your table’s content, but sometimes it helps to dress things up a little. Here’s how to make your table borders stand out and look great!

Excel's Camera Tool is a very cool feature that is hidden in the nooks and crannies of the application. Have you ever had multiple sheets in your workbook and wanted them printed on the same sheet? The camera tool allows you to do just that! Also, watch your charts and data update instantly as changes are made.

One of these days you will need to create a document as part of a team. The folks at Microsoft realized that people often need to work together when creating documents, so they included some features in Word that enable several people to work together to create and update a document. This webinar will explore various ways to collaborate with others to create a Word document.

Creating charts to show off your data visually is one of the most common uses of Microsoft Excel. If you’ve ever spent a lot of time developing that perfect chart consisting of style, flow and graphic enhancements, you might like to reuse it at some point! This video shows you how to save and utilize chart templates, saving you time and guesswork as you recreate your masterpiece with new or existing spreadsheet data.

Ah July! Weekend trips to the beach. More time outdoors than inside. Going on family vacations. Throwing backyard parties. Expanding one’s Word and Excel skills… If one of those things seems out of place to you, we can’t relate because we enjoy creating valuable new video content as much as a backyard barbecue! Regardless of the season, we never stop working to create high quality training materials to keep your skills on an upward trajectory, just like an amazing fireworks display!

A Brief Explanation of the Difference Between an Event, an Appointment, and a Meeting in Microsoft Outlook.

Ever have a WOW or ah-ha moment? If you haven’t experienced that feeling in the world of application software use, we hope to give you just that feeling when you watch the below video. Often times we are faced with not knowing what we don’t know. I’ve personally worked with images within a Microsoft Word environment for years. I’ve used tables and other options to try and line up an image in the way I’d like them to display. “I know how I want it to display, but Word doesn’t let me…” Not anymore. This great 4 minute video could shave a considerable amount of time off your next project!

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.