Excel will auto-detect the perimeter of your table and populate the range. It will also auto-detect headings. If that option isn’t selected (which sometimes happens in the Mac version of Excel ...

If this is wrong, enter (or point) to the correct range; however, if correct, check the box that says My Table Has Headers, then click OK. 5. Excel converts the range into a beautiful color table ...

Excel uses a high contrast combination for the text and background, by default. You can change text color using the Font Color option and choose a different background color from the Fill Color menu.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

How to Do Combination Charts in Excel 2007. ... For example, to change the color of the data series, click the "Design" tab and then click a color in the Chart Styles gallery. Kathryn Hatashita-Lee.