Integrated Business Projects - PowerPoint PPT Presentation

gualtier-meegan
integrated business projects n.
Skip this Video
Loading SlideShow in 5 Seconds..
Integrated Business Projects PowerPoint Presentation
Download Presentation
Integrated Business Projects

play fullscreen
1 / 19
Download Presentation
Integrated Business Projects
85 Views
Download Presentation

Integrated Business Projects

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