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
excel
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
Download these Excel Calendars for 2012 from Microsoft Office
Hot on the heels of the release of 2012 calendars for Word 2010, the Microsoft Excel team has released a set of Excel Calendars for 2012 that are free for download. These set of free Excel Calendars for 2012 features business calendars, family calendars, student calendars, and a … [Read more...] about Download these Excel Calendars for 2012 from Microsoft Office
How to Insert a Bullet List in Excel Cells
Have you ever had the need to insert a bullet list in an Excel cell? You may want to do that when you want to show a bunch of items having one set of attributes. You can insert a basic bullet point or other characters to add a bit of variety to the bullets. Let's get started … [Read more...] about How to Insert a Bullet List in Excel Cells