Learn how to work confidently with spreadsheets in this beginner-friendly online Level 1 Excel course. You will explore how to organize information, perform simple calculations, and create clean, functional worksheets. The class is taught using Excel 2019 and is fully compatible with Microsoft 365. Participants must have Excel installed before the course begins.
Materials Needed: A computer with Microsoft Excel 2019 or Microsoft 365 installed. Basic familiarity with Windows is expected.
Course Overview: Excel offers a wide range of tools to help you turn raw data into valuable insights. This course introduces the fundamental features that allow you to structure data, analyze information, and prepare professional-quality worksheets. You will learn how to navigate the interface, build formulas, format content, and prepare files for sharing or printing. By the end of the course, you will be ready to create and manage spreadsheets with confidence.
Course Objectives: After completing this course, you will be able to set up new workbooks, enter and organize data, apply essential formatting, perform basic calculations, adjust worksheet layouts, and manage file options.
Who Should Enroll: This class is ideal for anyone new to Excel or anyone who wants a solid foundation in building and working with electronic spreadsheets using Excel 2019 or Microsoft 365.
Course Content
Lesson 1: Getting Started
Topic A: Explore the Excel interface
Topic B: Use commands and ribbon tools
Topic C: Create and save new workbooks
Topic D: Enter and edit cell data
Topic E: Access Excel help resources
Lesson 2: Performing Calculations
Topic A: Create formulas manually
Topic B: Insert and use functions
Topic C: Copy, adjust, and reuse formulas
Lesson 3: Modifying a Worksheet
Topic A: Insert, remove, and resize cells, rows, and columns
Topic B: Locate and replace content
Topic C: Use proofing and reference tools
Lesson 4: Formatting a Worksheet
Topic A: Format text for readability
Topic B: Apply number formatting to data
Topic C: Adjust alignment and spacing
Topic D: Use themes and styles
Topic E: Apply basic conditional formatting
Topic F: Create and work with templates
Lesson 5: Printing Workbooks
Topic A: Preview and print worksheets
Topic B: Set up page layout and scaling
Topic C: Add headers and footers
Lesson 6: Managing Workbooks
Topic A: Organize worksheets within a file
Topic B: Adjust workbook and worksheet views
Topic C: Update workbook details and properties
Additional Information
This course is held in Mountain Time. A dependable internet connection and a device with a working camera and microphone are required. Classes are delivered through Microsoft Teams. The instructor will reach out one day before the session to confirm attendance and provide assistance with Teams setup if needed.
