External

Beginning Excel

This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2019, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before. This textbook includes instructions for Excel for Mac also.

Information Technology Workforce

Author: Barbara Lave, Diane Shingledecker, Julie Romey, Noreen Brown, & Mary Schatz
Publisher: Portland Community College
Source: LibreTexts
License: CC BY-NC-SA
Language: EN

Read online Download PDF (open licence)

Contents· 41 sections

01: Fundamental Skills
1.01: Overview of Microsoft Excel
1.02: 1.2-Entering Editing and Managing Data
1.03: 1.3-Formatting and Data Analysis
1.04: Printing
1.05: Chapter Practice
1.06: Scored Assessment
02: Mathematical Computations
2.01: Formulas
2.02: Introductory Statistical Functions
2.03: Functions for Personal Finance
2.04: Preparing to Print
2.05: Chapter Practice
2.06: Chapter Scored
03: Formulas Functions Logical and Lookup Functions
3.01: More on Formulas and Functions
3.02: Logical and Lookup Functions
3.03: Conditional Formatting
3.04: Preparing to Print
3.05: Chapter Practice
3.06: Chapter Scored
04: Presenting Data with Charts
4.01: Choosing a Chart Type
4.02: Formatting Charts
4.03: Using Charts with Microsoft Word and Microsoft PowerPoint
4.04: Preparing to Print
4.05: Chapter Practice
4.06: Scored Assessment
05: Tables
5.01: Table Basics
5.02: Intermediate Table Skills
5.03: Preparing to Print
5.04: Chapter Practice
5.05: Scored Assessment
06: Multiple Sheet Files
6.01: Multiple Sheet Basics
6.02: Formulas with 3-D References
6.03: Templates
6.04: Preparing to Print
6.05: Chapter Practice
6.06: Scored Assessment