How do you create a Microsoft account using any email address? Is it required to have a Microsoft email address to sign in to Windows or use apps? No it isn’t!

You can use one email address to sign in everywhere!

Why do you get errors such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM! and #NAME when you know the formula is correct? What is IFERROR? The IFERROR function is an easy way to fix or change the way an error message is displayed in a cell.

There's no denying that data is not the most inherently pretty thing to behold. An Excel spreadsheet, after all, is not exactly a Monet. Even if you have a thoroughly organized spreadsheet, there are definite benefits to making it more visually appealing. Beyond simply adding color or editing fonts, this effort should be focused on making your data more digestible for your audience. This way it can be easily shared with and understood by your higher-ups and end users, and in turn they can use it to drive actions and provide the basis for smart decisions. Enter: PowerPivot.

Get the look, flow and feel you want with your spreadsheet my making your own rules! Excel has seriously powerful and useful tools that can apply formatting rules to specific sections of your spreadsheet. Conditional Formatting does just what its name implies. First, a certain criteria is set for a data range (i.e. values greater than 1000). Then users can define the formatting characteristics (i.e. bold and red text). Once you’ve set conditions and formatting, Excel finds the values matching our criteria and applies the appropriate formatting.

Join KnowledgeWave, and our Excel expert David Thibault, for our specialized Excel 2013 Power User for CPA's course schedule for May 21st. After you’ve exported data from QuickBooks to Excel what’s next? In this custom course, students will learn the advanced skills necessary to create business applications using Conditional Formatting, various Functions, Formulas and PivotTables. This is a great class for the Excel user looking to boost there skills to Power User status. This session is eligible for 7 CPE credits for Certified Public Accountants.

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.

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.

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.

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.

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.

Often we know what we want our Excel spreadsheet to do and how it should all work. Save time and precious brain cells by downloading and utilizing pre-formatted templates. In this short and direct video we discus how templates can be used when you use the same worksheet repeatedly.

In this video, you will learn how to determine the interest rate of a loan based on the amount of the loan, the number of payment periods, and the amount of the payments. Log on to Learn offers 100's of these types of Excel videos. Learn a topic quickly and apply the knowledge immediately.

Fridays just feel like a day for rewards. It’s the end of the week, we’ve put in a good effort and we’re looking ahead to the weekend. Well, we’d like to give you something else on Fridays. That’s why we’re introducing, Function Fridays. Every Friday we’re going to post a new video tip on an Excel function… for free. These short tutorials get right at the heart of how to use the functions that can make your Excel life easier. Now, that sounds perfect for a Friday.

Calculating the number of workdays between two distinct dates can be a pain to do, manually. However, Excel has a great function that will help you accomplish this. It involves using the NETWORKDAYS function.

In this session, we will show you how to Freeze and Split panes in Excel 2010. Freeze panes allow you to freeze columns and rows making them visible as you scroll within a worksheet. Split panes allow you to split your worksheet into multiple views, letting you scroll in one pane of the worksheet, while other panes remain static.