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.
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.
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.
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.
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.
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.
Working with dates in Excel can sometimes be a little confusing. Excel stores dates as sequential numbers that can be used in calculations.
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.
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.
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.
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.
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.
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.
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.
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!