Microsoft Office Tutorials and References
In Depth Information
External Database Connections
External Database Connections
Data for an Excel table or PivotTable report can come from a variety of sources, including
SharePoint lists, external databases in almost any format, other worksheets in other
workbooks, and even from web pages. You can make a direct connection to an external data
source and then sort, filter, or summarize the data in Excel. You can also extract data from
an external source, save it in an intermediate format, and import the data into an Excel
worksheet. We describe the most common import/export and data connection strategies in
“Importing, Exporting, and Connecting to Data Sources” on page 415.
Formatting and Using Tables
Earlier, we explained how to convert a range into a table. In this section, we dig into the
nuances of formatting a table, expanding its size in either direction, and adding totals.
Formatting Tables with Table Styles
Table styles apply formatting—colors, fonts, borders, and shading—to the region that
makes up a table. Excel offers a selection of 60 options in the Table Styles gallery, divided
into Light, Medium, and Dark groups that correspond to the intensity of the colors used.
You can choose from the entire list in either of two ways:
Click Format As Table in the Styles group on the Home tab. If the current range or
region has not already been defined as a table, this option displays the Format As
Table dialog box after you make a selection.
Click the arrow to the right of the Table Styles gallery (or below the Quick Styles
button) in the Table Styles group on the Table Tools Design tab.
Figure 12-3 shows the Quick Styles gallery in operation. Note that as you point to an
option in the gallery, the formatting in the table changes to preview that selection.
A ScreenTip shows the name of each style. The colors and fonts associated with that style
vary depending on the theme used for the current worksheet. If you change the theme, any
existing table formats change to pick up the color schemes and fonts from the new theme.
For more on how themes allow you to apply consistent formatting, even in different Office
programs, see “Using Office Themes” on page 185.
If you’ve applied manual formatting to fonts, font colors, cell shading, and so on within a
table region, your formatting is preserved when you apply a table style. To clear any
manual formatting and use only the formatting specified in the table style, right-click the style
from the Table Styles gallery, and then click Apply And Clear Formatting.
Search JabSto ::




Custom Search