Most of us have some contact with the Microsoft Excel program during our working lives. Whether we simply need to open and read spreadsheets; or build complex workbooks to perform a number of monthly tasks; we sometimes need the confidence that only training can bring. Microsoft Excel does allow the … [Read more...]
Budgets are perfect for Excel manipulation. Raw data has to go through many calculations to give a meaningful result. Rather than typing in the data multiple times, raw data can be typed in once then linked through formulas that specify the location of a data point. So, for example, if cell C2 has … [Read more...]
Over several decades, Microsoft has updated, expanded and tweaked Excel to keep up with both modern technology and the needs of spreadsheet users. Microsoft Office Excel is powerful and widely used software that helps people analyze information to make more informed decisions. Using Office Excel and … [Read more...]
One of the common tasks we perform when working with large Excel worksheets is filtering data in alternate rows. This may be for the purpose of further analysis, or we may just want to delete such data. Whatever the reason, there’s no simple auto filter option that lets you filter alternate rows … [Read more...]
Excel Functions are a great way to do complicated computations, but a lot of us are intimidated by the use and sound of the term. There are a lot of simple activities that can be accomplished quickly using Excel functions and in this tutorial, I’ll show you how to use the SUMPRODUCT function to … [Read more...]
Often, when you work with Excel, you tend to use a number of worksheets so that data related to a particular project stays in one workbook. Soon, you find yourself having ten to fifteen worksheets and struggling to find data from among those several sheets. One quick way to solve this problem is to … [Read more...]
One of the common things we do when working with Excel data is comparing two strings of text. There are several ways to do this, and in this post, I'll share some quick ways to compare data in Excel. These are ones that I frequently use and hope you find use for them in your daily work. Quick Ways … [Read more...]
Using watermarks in Word documents is quite a normal practice. But have you ever used watermarks in your Excel worksheet or workbook? You may find it useful when you need to share a workbook with other users and the data contained therein is either in draft mode or is confidential such as a budget … [Read more...]
When working with Excel, your data may have columns with repeated values or entries. There may be times when you want to view or extract only the unique values in the column. Although you can use the Filter command to check the unique entries, you may want to want to generate a unique list of … [Read more...]
