Excel Fundamentals

Microsoft Excel Fundamentals
Course Overview
Microsoft Excel is one of the world’s most widely used business applications. Whether you’re tracking expenses, maintaining employee lists, managing schedules, or analyzing data, Excel provides powerful tools to organize information and make better decisions.
This hands-on course introduces participants to the essential features of Excel and helps build the confidence needed to create professional worksheets and perform common business tasks.
Participants will learn through practical exercises and real-world examples that can be applied immediately in the workplace.
Who Should Attend
This course is designed for:
• New Excel users
• Administrative professionals
• Customer service staff
• Coordinators and support personnel
• Managers and supervisors
• Anyone who works with spreadsheets and wants to improve their Excel skills
Prerequisites
Participants should be comfortable using Windows, including:
• Using a mouse and keyboard
• Opening and saving files
• Navigating folders and File Explorer
No prior Excel experience is required.
Topics Include
Getting Started with Excel
• Understanding workbooks and worksheets
• Navigating the Excel interface
• Working with the Ribbon
• Creating, opening, and saving files
Working with Data
• Entering and editing information
• Selecting cells, rows, and columns
• Copying and moving data
• Using AutoFill for repetitive entries
Creating Formulas
• Understanding formula basics
• Using mathematical operators
• Building simple calculations
• Understanding relative references
Working with Functions
• SUM
• AVERAGE
• MIN
• MAX
• COUNT
Formatting Worksheets
• Font formatting
• Cell alignment
• Number formatting
• Borders and shading
• Cell styles
Managing Data
• Sorting information
• Filtering records
• Finding and replacing data
Creating Charts
• Understanding chart types
• Creating basic charts
• Modifying chart layouts
• Communicating data visually
Printing Worksheets
• Page setup options
• Headers and footers
• Page orientation
• Print preview
• Print titles
Learning Outcomes
After completing this course, participants will be able to:
• Navigate Excel efficiently
• Create and save workbooks
• Enter and edit worksheet data
• Create formulas and calculations
• Use common Excel functions
• Format worksheets professionally
• Sort and filter information
• Create basic charts
• Prepare worksheets for printing and sharing
Lighthouse Training Difference
Lighthouse Training focuses on practical, real-world Excel skills rather than memorizing software features. Participants learn through hands-on exercises and business scenarios that mirror tasks they encounter every day.
Shining a guiding light on technology.