Guide to Excel

Microsoft-ExcelMicrosoft Excel is the most popular spreadsheet software used by both business and home users worldwide. It offers calculation tools, graphing tools, pivot tables and macros which make it one of the most powerful business applications on the market today.

In this guide, you will find tutorials which will help you leverage the power of Excel to grow your business. You will learn how to use macros, functions, tables, charts, formulas, as well as learn how to import data into Excel. Having problems with the program? Read tutorials and troubleshooting guides that describe how to perform Excel recovery. And for those on a budget, you can also find reviews of the best free alternatives to this popular software. You can find everything you need to know about Microsoft Excel in this guide, right here, at Bright Hub.

Latest Articles on Excel
Copying Only Formatting in Excel 2013

Perhaps you have used some of the Paste options available in Microsoft Excel, but you may not have realized you can copy and paste just the formatting applied to another cell or range...

Sorting by Custom Lists in Excel 2013

Excel 2013 supports multi-tiered sorting rules to arrange data as you prefer, but the default sorting rules only provide alphabetical or reverse-alphabetical ordering. A convenient...

Copying Only Unique Values in Excel 2013

Several Excel functions and tools require knowing the unique values contained in a dataset. The simplest solution is Excel 2013’s Advanced Sort & Filter feature that can copy...

Sorting an Excel 2013 Table on Fill or Text Color

Colors are often overlooked as sorting criteria. Learn how to make sorting in Excel even easier using text or fill colors as criteria....

Most Popular Articles on Excel
  •  
    Using the IF Function in Excel 2007

    If you’re still sorting through spreadsheet data manually, it’s time to learn how some of the functions in Excel can increase your productivity. In this article, we’ll take a look at...

  •  
    General Ledger Templates for MS Excel

    A general ledger is the meat and potatoes of any accounting system. What is posted within a general ledger finds its way to other important financial accounting reports. If Microsoft Excel is your game...

  •  
    Microsoft Excel’s Frequency Function

    The frequency function in Microsoft Excel provides a special way to count items that fall within in a specified range. In this segment, we’ll show how the frequency function can be used to group...

  •  
    Creating a Calendar in Microsoft Excel

    Sometimes you might need a calendar in a spreadsheet to which you can refer or you may want to make a spreadsheet that is a calendar. There are several methods of doing this. Follow this excel tutorial...

  •  
    Excel 2010: How To Make A Thermometer Chart

    You’ve set a goal but now it’s time to start tracking your progress against that goal. One great way to do this is by creating a thermometer chart in Microsoft Excel. This article will show...

More About Excel
Benefits of Using MS Excel

This article shows readers the benefits that using Microsoft Excel provides. These advantages include time and money savings, gained through usage of Excel's extensive set of tools...

Review of Excel for Mac 2011

Excel for Mac 2011 is the latest in a line of Excel products for Mac. Microsoft has perviously tried to do something unique with the Mac version but it never really resembled its counterpart...