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!
Taking Excel PivotTables & Charts to the Next Level
Posted by Dan St. Hilaire / October 16, 2014 / Webinars — No Comments ↓
Tags: Webinars
An Introduction to PivotTables in Microsoft Excel
Posted by Dan St. Hilaire / October 15, 2014 / Webinars — No Comments ↓
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.
Tags: Webinars
Tackle Two Operations with one Function in Microsoft Excel
Posted by Dan St. Hilaire / October 7, 2014 / Excel — No Comments ↓
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.
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
Office 2013: How to Have an Easy Upgrade
Posted by Jennifer Patterson / August 26, 2014 / KnowledgeWave News — No Comments ↓
Tags: KnowledgeWave News
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