Microsoft Excel (Level 1)

Participants will develop fundamental Excel skills, including setting up spreadsheets, entering and manipulating data, and using AutoFill to save time. They will also learn how to print spreadsheets correctly, create basic formulas and functions, and edit and format data efficiently. By the end of the course, students will be equipped to manage large workbooks and use Excel’s core features to improve productivity.

Course Dates TBD

Categories: Professional Development, Technology Skill Building

Course Content:

Getting Started with Excel: Navigation and Selection
Using AutoFill
Printing From Excel
Intro to Formulas: Proper Formula Layout, Common Formulas
Intro to Functions: SUM, COUNT, AVERAGE, MAX, MIN
Formatting Worksheets
Managing Large Workbooks
Organizing Worksheets and Different View Settings
Customizing Excel Options

Applications and Hands-On:

Navigate the Excel interface between cells, rows, columns, and worksheets
Select individual or multiple cells, ranges, and entire rows or columns
Extend data patterns such as numbers, dates, and formulas across rows and columns
Set up print areas, adjust page layouts, and preview your worksheet
Create simple formulas, including correct formula syntax, and apply across multiple cells
Perform common functions such as SUM, COUNT, AVERAGE, MAX, and MIN
Format cells, rows, and columns to make your data more readable
Adjust font styles, text alignment, number formatting, borders, and cell shading
Manage large workbooks by organizing multiple worksheets
Utilize different view options (like Page Layout and Normal views)
Navigate quickly through large datasets
Personalize Excel’s settings to suit your preferences

Resources Provided:

Individual computer access
Microsoft Excel software