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.
Dan St. Hilaire
Recent Posts
Tackle Two Operations with one Function in Microsoft Excel
Posted by Dan St. Hilaire / October 7, 2014 / Excel — No Comments ↓
Tags: Excel
Students Get Microsoft Office 365 Free!
Posted by Dan St. Hilaire / September 23, 2014 / Industry News — No Comments ↓
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.
Tags: Industry News
PowerPoint 2013: Creating SmartArt Diagrams
Posted by Dan St. Hilaire / September 10, 2014 / PowerPoint — No Comments ↓
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.
Tags: PowerPoint
Add the 3-day Weather Forecast to Outlook 2013
Posted by Dan St. Hilaire / September 3, 2014 / Outlook — No Comments ↓
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?
Tags: Outlook
Word 2013: Enhance Tables with Borders in Microsoft Word
Posted by Dan St. Hilaire / August 13, 2014 / Word — No Comments ↓
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!
Tags: Word
Excel 2013: Use The Camera Tool To Print Multiple Sheets On A Single Page
Posted by Dan St. Hilaire / July 29, 2014 / Excel — No Comments ↓
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.
Tags: Excel
Microsoft Word Webinar: Collaborating on Documents with a Team
Posted by Dan St. Hilaire / July 21, 2014 / Webinars — No Comments ↓
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.
Tags: Webinars
Reuse a Favorite Chart in Excel by Using a Chart Template!
Posted by Dan St. Hilaire / July 16, 2014 / Excel — No Comments ↓
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.
Tags: Excel
Word 2013: The Magic of Columns
Posted by Dan St. Hilaire / July 1, 2014 / Word — No Comments ↓
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!
Tags: Word
The Difference Between Events, Appointments and Meetings (Outlook '13)
Posted by Dan St. Hilaire / June 24, 2014 / Outlook — 7 Comments ↓
A Brief Explanation of the Difference Between an Event, an Appointment, and a Meeting in Microsoft Outlook.
Tags: Outlook
An Ah-Ha Moment with Microsoft Word 2013
Posted by Dan St. Hilaire / June 3, 2014 / Word — 1 Comments ↓
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!
Tags: Word
Using the Concatenate Function in Microsoft Excel - Video Tip
Posted by Dan St. Hilaire / May 28, 2014 / Excel — No Comments ↓
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.
Tags: Excel
Be Ready for Anything-Use Excel Scenarios to Plan for the Future & Headers, Footers & Page Numbering from Simple to Elaborate
Posted by Dan St. Hilaire / May 12, 2014 / Webinars — 2 Comments ↓
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!
Tags: Webinars
Excel 2013: Let Flash Fill Do the Work! + Other Tips!
Posted by Dan St. Hilaire / April 7, 2014 / Excel — No Comments ↓
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.
Tags: Excel
Cisco CCNP Security Track Updates and Adds Cybersecurity Certification
Posted by Dan St. Hilaire / March 11, 2014 / Industry News — No Comments ↓
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.
Tags: Industry News