A good command over computers and software is an invaluable attribute for any business leader. While you might be the best project manager/site manager in the world, but there is only such information you can store and juggle in your mind. Using technology allows you to visualize … [Read more...] about How To Make Important Business Decisions Using Excel
excel
New Features in Excel 2013
Microsoft Office 2013 is the latest version of the popular Office suite that has been released for public consumption. If you have been using Office 2010, you may be a trifle disappointed about having to think about upgrading to the next version, especially, just when you were … [Read more...] about New Features in Excel 2013
Advanced Excel Courses and Their Application in the Business World
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 … [Read more...] about Advanced Excel Courses and Their Application in the Business World
3 Excel Tips for Better Department Budget Management
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 … [Read more...] about 3 Excel Tips for Better Department Budget Management
How to Remove All Hyperlinks from an Excel Sheet
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. … [Read more...] about How to Remove All Hyperlinks from an Excel Sheet
How to Filter Alternate Rows in Excel
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 … [Read more...] about How to Filter Alternate Rows in Excel
Quick Ways to Compare Data in Excel
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 … [Read more...] about Quick Ways to Compare Data in Excel
How to Insert Page Numbers in Multiple Worksheets in Excel 2010
There may be instances where you have more than a couple of worksheets in Your Excel 2010 workbook and you might want to number the worksheets in a single go rather than have to do it individually for each worksheet. This is possible by using the grouping feature, which lets you … [Read more...] about How to Insert Page Numbers in Multiple Worksheets in Excel 2010