80 likes | 216 Views
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. Formatting a Worksheet. Files Needed: Sales #2 Exam Scores Purchase Order #3 Operations Covered: Cell Alignment
E N D
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
Formatting a Worksheet • Files Needed: • Sales #2 • Exam Scores • Purchase Order #3 • Operations Covered: • Cell Alignment • Font Options
Formatting a Worksheet (cont.) • Operations Covered (cont.): • Number Format of Cells • Borders and Shading of Cells
Using Excel Functions • Files Needed: • Sales Summary #1 • Sales Summary #2 • Quarterly Budget #1 • Monthly Sales • Staff Listing • Quarterly Budget #2
Using Excel Functions (cont.) • Operations Covered: • Functions • SUM Function
Using Excel Functions (cont.) • Inserting Functions
Using Logical Functions • Files Needed: • Proposed Budget • April Sales • Profit Forecast #1
Using Logical Functions (cont.) • Operations Covered • IF Functions and Nested IF Functions