Download
excel sections 6 8 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Excel Sections 6-8 PowerPoint Presentation
Download Presentation
Excel Sections 6-8

Excel Sections 6-8

107 Views Download Presentation
Download Presentation

Excel Sections 6-8

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Excel Sections 6-8 • Materials to be covered • Section 6 through Section 8 • Topics to be covered: • Formatting a Worksheet • Using Excel Functions • Using Logical Functions

  2. Formatting a Worksheet • Files Needed: • Sales #2 • Exam Scores • Purchase Order #3 • Operations Covered: • Cell Alignment • Font Options

  3. Formatting a Worksheet (cont.) • Operations Covered (cont.): • Number Format of Cells • Borders and Shading of Cells

  4. Using Excel Functions • Files Needed: • Sales Summary #1 • Sales Summary #2 • Quarterly Budget #1 • Monthly Sales • Staff Listing • Quarterly Budget #2

  5. Using Excel Functions (cont.) • Operations Covered: • Functions • SUM Function

  6. Using Excel Functions (cont.) • Inserting Functions

  7. Using Logical Functions • Files Needed: • Proposed Budget • April Sales • Profit Forecast #1

  8. Using Logical Functions (cont.) • Operations Covered • IF Functions and Nested IF Functions