• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Extending Office Data Analys... > Understanding Office Code: Macros an...

Understanding Office Code: Macros and Procedures

Microsoft data analysis solutions do not need to be complex, nor do they require a lot of effort to deploy. In many cases, a macro (a self-contained piece of code) can automate a data analysis task that involves several steps. For example, you could use macros to automate data analysis tasks such as the following:

  • Sort and filter lists of records in Excel or Access.

  • Insert standard Excel worksheet functions or Analysis ToolPak functions.

  • Conditionally format Excel worksheet cells.

  • Create Excel charts, PivotTable reports, or PivotChart reports from lists of records.

  • Run Access queries.

  • Display Access data tables or reports.

  • Create Office Web Components on Web pages and connect them to a data source.

  • Analyze OLAP data with Microsoft Data Analyzer views.

  • Open and save XML data in Excel.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint