Does Your Team Know How to Interpret Simple Excel Formulas?

Posted by David Thibault  /  January 26, 2017  /  Excel   —   No Comments ↓

While not all of your employees need to be Excel experts, you don't want them to be totally baffled when they open up a spreadsheet.

Read More ›

Tags: Excel

Advanced Microsoft Excel Training That Fits Your Busy Schedule

Posted by Dan St. Hilaire  /  January 4, 2017  /  Excel, Employee Training   —   No Comments ↓

Microsoft estimates that 5 - 10% of users are using more complex features of Excel to create business insights. Some experts have shown that these “super users” are earning more than their colleagues.

So if you like problem solving, data analysis, and the idea of boosting your earning power, maybe it's time to become an Excel power user.

Read More ›

Tags: Excel, Employee Training

Did You Know That Excel Has a Built-In Training Log Template?

Posted by Jennifer Patterson  /  December 7, 2016  /  Excel, Employee Training, templates   —   No Comments ↓

A learning management system (LMS) is a luxury not every organization can afford. Yet maintaining accurate employee training logs is invaluable to your team's growth and development plans.

Read More ›

Tags: Excel, Employee Training, templates

Simple Excel Formulas That Everyone Should Learn

Posted by David Thibault  /  October 11, 2016  /  Excel, Employee Training   —   No Comments ↓

Maybe your company is like ours, and you use Excel to help keep track of many things. Pretty much every department and every employee has to use Excel at least a little bit.

Read More ›

Tags: Excel, Employee Training

7 Pro Tips to Learn Excel Online

Posted by Jennifer Patterson  /  August 11, 2016  /  Excel, Microsoft Office   —   No Comments ↓

When it’s time for your employees to master Excel, or even step up their game a bit, you probably already have a hunch that you can do it completely online.

Read More ›

Tags: Excel, Microsoft Office

Excel Power User Training - 100% Online!

Posted by Dan St. Hilaire  /  August 8, 2016  /  Excel, Courses, Live Remote Training   —   No Comments ↓

Updated: 2/21/17

Microsoft estimates that 5 - 10% of users are using more complex features of Excel to create business insights. Some experts have shown that these “super users” are earning more than their colleagues. So if you like problem solving, data analysis, and the idea of boosting your earning power, maybe it's time to become an Excel power user.

Read More ›

Tags: Excel, Courses, Live Remote Training

4 Simple Excel Date Functions You Should Know

Posted by David Thibault  /  June 23, 2016  /  Excel   —   No Comments ↓

Working with dates in Excel can sometimes be a little confusing. Excel stores dates as sequential numbers that can be used in calculations.

Read More ›

Tags: Excel

10 Microsoft Excel Tips You Need to Know!

Posted by Dan St. Hilaire  /  May 19, 2016  /  Excel, Courses   —   No Comments ↓

Based on our extremely popular webinar on 10 Microsoft Aha Features You Need to Know, KnowledgeWave is excited to provide an online class where you can really master these top Excel tips. You’ll be able to watch, interact and apply these tips with the guidance of our expert certified instructor.

Read More ›

Tags: Excel, Courses

Create an Online Excel Survey

Posted by David Thibault  /  March 17, 2016  /  Excel   —   No Comments ↓

Today’s leaders and top performers are adept at gathering information from others around them and putting it to good use. If you’ve ever used SurveyMonkey in your work, then I’ve got great news for you: using an Excel survey, you can get much better results than what’s offered in the free SurveyMonkey package. Surveys are a great tool for enhancing your managerial communication skills.

Read More ›

Tags: Excel

Create a Visio Org Chart from Excel

Posted by Jon Hood  /  March 10, 2016  /  Excel   —   No Comments ↓

One of the most exciting parts of my job is to coach people, saving them time and making their day a little bit easier. I've found myself saying, "My job is to make you look like the hero!"

I used that phrase today, which inspired me to write about it. I just finished teaching a course on Microsoft Visio and the highlight was the lesson on organization charts, a huge hit among Visio users. Just click on the Organization Chart template to get going.

Read More ›

Tags: Excel

Filtering PivotTables using Timelines in Excel

Posted by David Thibault  /  January 25, 2016  /  Excel   —   1 Comments ↓

Have you ever used Slicers in Excel? Slicers make it easy for users to filter tables, PivotTables, and PivotCharts. Timeline is a new feature to Excel 2013 that is similar to Slicers except it allows users to filter dates interactively. This is a must for anyone reporting using dates. Dates can be easily filtered by days, months, quarters, and years. Follow the steps below to learn how to insert and use a Timeline in your PivotTable in Excel.

Read More ›

Tags: Excel

Take the Guess Work out of Charting in Excel 2013

Posted by David Thibault  /  January 19, 2016  /  Excel   —   No Comments ↓

Microsoft Excel 2013 has a button called Recommended Charts that helps users select from a list of customized charts that will best fit your data. You can have beautiful, easy charts in just a few clicks. Users can hover over the choices to view a live preview of the chart before deciding on which style works. Follow the steps below to view and select one of the available chart options.

Read More ›

Tags: Excel

Using the Days Function in Excel 2013

Posted by David Thibault  /  December 14, 2015  /  Excel   —   No Comments ↓

Microsoft Excel 2013 has a new useful function called Days. It is pretty easy to use and only requires two arguments: an end date and a start date. The results will be displayed as the total number of days between the two dates. Follow the steps below to create the function.

Read More ›

Tags: Excel

Hiding Columns and Rows in Excel the Easy Way

Posted by David Thibault  /  December 8, 2015  /  Excel   —   No Comments ↓

There are several ways to hide and unhide columns and rows in Excel. One thing you might not be aware of: you can hide and unhide more than one column or row, at the same time, even if they are non-contiguous. Better yet, if they are contiguous you can use Excel's Grouping tool. Below I have outlined a couple of time-saving ways to hide and unhide your Excel columns and rows.

Read More ›

Tags: Excel

Excel: PivotTable, a PivotChart and a Slicer on One Sheet

Posted by Jon Hood  /  July 8, 2015  /  Excel   —   No Comments ↓

What is a PivotTable, a PivotChart and a Slicer in Excel? These are features that work very well together to create an interactive separate report. Take raw data and build that report and change the way it looks and analyzes your data. A PivotChart is an interactive chart where you can change the view, suppress things and instantly see your changes. A Slicer is push button interface that allows people to drill down and see specific results from your report. So, how can you create a report with a PivotTable, a PivotChart and a Slicer on one sheet? Check it out!

Read More ›

Tags: Excel