1 / 19

Integrated Business Projects

Integrated Business Projects. Part 2 Accounting. Project 12 Performing Statistical Analyses. Project 12 Objectives. Create a form with Form and ActiveX controls Adjust the properties of an ActiveX control Use functions Install an Add-in application Use Analysis ToolPak

gualtier-meegan
Télécharger la présentation

Integrated Business Projects

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Integrated Business Projects Part 2 Accounting Project 12 Performing Statistical Analyses

  2. Project 12 Objectives • Create a form with Form and ActiveX controls • Adjust the properties of an ActiveX control • Use functions • Install an Add-in application • Use Analysis ToolPak • Prepare various types of charts

  3. Project 12 Jobs • Job 12-1: Design Customer Evaluation Form • Job 12-2: Use Functions to Analyze Data • Job 12-3: Use Analysis ToolPak to Analyze Data • Job 12-4: Create Worksheet Charts • Job 12-5: Create Integrated Report

  4. Job 12-1: Design Customer Evaluation Form Jobs List • Using group box and option button form controls • Adding a scrollable Textbox ActiveX control • Adjusting properties for an ActiveX control

  5. Insert Form Controls Jobs List Developer/Controls/Insert 1. Developer tab 2. Controls group 3. Insert button Continued

  6. Insert Controls(continued) Jobs List Click a control Draw with precision pointer

  7. Insert ActiveX Controls Jobs List Developer/Controls • Make sure Design Mode is activated. • Click the Insert button. 1. Developer tab 2. Controls group 3. Insert button Continued

  8. Insert Controls(continued) Jobs List Click a control in the ActiveX Controls gallery Click the More Controls button to display additional control options

  9. Job 12-2: Use Functions to Analyze Data Jobs List • Analyzing evaluation data • Using Excel functions • Filtering records

  10. Filter Data Jobs List Data/Sort & Filter/Filter • Select the column and column heading on which you want to filter. • Click the Filter button. • Click the arrow on the column heading and choose the filtering option. 1. Data tab 2. Sort & Filter group 3. Filter button

  11. Job 12-3: Use Analysis ToolPakto Analyze Date Jobs List • Installing the Analysis ToolPak add-in application • Using Analysis ToolPak • Adding data bars

  12. Descriptive Statistics Jobs List Data/Analysis/Data Analysis 3. Data Analysis button 1. Data tab 2. Analysis group

  13. Conditional Formatting Jobs List Home/Styles/Conditional Formatting Home tab Conditional Formatting button Data Bars option

  14. Job 12-4: Create Worksheet Charts Jobs List • Using various chart types to summarize data • Changing chart styles and layouts • Adding and deleting chart labels and legends • Changing shape styles and shape outlines

  15. Insert Charts Jobs List Insert/Charts 1. Insert tab 2. Charts group

  16. Using Chart Tools Jobs List Click on the chart to display the contextual Chart Tools tabs (Design, Layout, Format)

  17. Job 12-5: Create Integrated Report Jobs List • Formatting a report from a draft document • Adding Excel charts to a Word Document • Working with track changes

  18. Insert Text Box Jobs List Insert/Text/Text Box 3. Text Box button 1. Insert tab 2. Text group

  19. Track Changes Jobs List END SHOW Review/Changes/Accept or Reject 1. Review tab 2. Changes group 3. Accept/Reject buttons

More Related