Discover the advanced features of creating and working with PivotTables and PivotCharts. This webinar is recommended for those who have attended, Look at Your Data in a Whole New Way with PivotTables in Microsoft Excel 2010. In this advanced PivotTable webinar we will show you how to build PivotTables from external databases, customize PivotTables, work with subtotals, and how to use advanced PivotCharts features. This session will truly take your PivotTables to the next level!

Grab a comfortable seat and we’ll walk you through a 30 minute Webinar on the basics of creating PivotTables. Find out what PivotTables are, how they work and how to create your own. Wondering how to change your PivotTable field settings? How to understand the lingo used in PivotTable reports? We’ll cover all that, too, in one mind-expanding half-hour. The next time you need to see comparisons, reveal patterns or analyze trends, you’ll know exactly what to do. We won't make you wait long for the next steps, as a follow up webinar showing you how to take your PivotTables to the next level, is offered on the 30th of October.

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?

Training will help maintain - and increase - your team's productivity after an upgrade.

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.