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.

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 ...

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.

Dashboard Series: Creating Combination Charts In Excel I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know.

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.

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 ...