Introduction to Microsoft Excel (Level 1)

Course Description

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

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