Starz University
AIRFIELD SINKOR
P. O. BOX 1040
MONROVIA, LIBERIA MONROVIA,
LIBERIA
PHONE: 231-886-119104 /
0770166443
EMAIL: CONTACT@[Link] TECHNOLOGY IS OUR PASSION; EDUCATION IS OUR LIFE!
Course Syllabus: Basic computer Excel 2019 Fundamentals
Course Duration: 10 Days
Total Hours: 20 Hours (2 hours/day)
Target Audience: Beginners with little to no experience in
Excel.
Day 1: Introduction to Excel Interface
Topics Covered:
Overview of Excel and its uses
Understanding the Excel interface: Ribbon, tabs, and groups
Navigating a worksheet: Rows, columns, and cells
Saving and opening workbooks
Activities:
Create a simple workbook and save it.
Day 2: Data Entry and Formatting
Topics Covered:
Entering and editing data in cells
Formatting cells: Fonts, colors, and borders
Using number formats (currency, percentage, date)
Aligning text and using wrap text
Activities:
Format a sample data table.
Day 3: Basic Formulas and Functions
Topics Covered:
Introduction to formulas:
Understanding cell references (relative, absolute, mixed)
Using basic functions: SUM, AVERAGE, MIN, MAX
Activities:
Create a budget worksheet using basic formulas.
AT STARZ, TECHNOLOGY IS OUR PASSION; EDUCATION IS OUR LIFE!
Day 4: Advanced Functions
Topics Covered:
Logical functions: IF, AND, OR
Text functions: CONCATENATE, LEFT, RIGHT, MID
Date and Time functions: TODAY, NOW, YEAR, MONTH, DAY
Activities:
Create a report that combines different functions.
Day 5: Data Management Techniques
Topics Covered:
Sorting and filtering data
Using AutoFill for quick data entry
Find and Replace feature
Activities:
Practice sorting and filtering a dataset.
Day 6: Charts and Graphs
Topics Covered:
Creating different types of charts (bar, line, pie)
Formatting charts and adding chart elements (titles,
labels)
Choosing the right chart for data visualization
Activities:
Create a chart based on the budget worksheet.
Day 7: Conditional Formatting
Topics Covered:
Introduction to conditional formatting
Creating rules for highlighting cells
Using data bars, color scales, and icon sets
Activities:
Apply conditional formatting to highlight important data.
AT STARZ, TECHNOLOGY IS OUR PASSION; EDUCATION IS OUR LIFE!
Day 8: Printing and Page Layout
Topics Covered:
Setting print areas and page breaks
Using headers and footers
Print preview and printing options
Activities:
Prepare a worksheet for printing with proper layout.
Day 9: Introduction to PivotTables
Topics Covered:
Understanding PivotTables and their uses
Creating a simple PivotTable
Modifying and formatting PivotTables
Activities:
Create a PivotTable from a dataset.
Day 10: Review and Final Project
Topics Covered:
Review key concepts learned throughout the course
Best practices for using Excel
Time for questions and additional practice
Final Project:
Create a comprehensive budget tracker or simple report
incorporating various skills learned (formulas, charts, and
formatting).
Activities:
Recommended Text: "Excel 2019 for Dummies"
Additional Resources: Microsoft Office tutorials and resources
available online.
Evaluation:
Participation: 20%
Daily Activities: 30%
Final Project: 50%
Notes:
Attendees are encouraged to bring their laptops with Excel 2019
installed.
Ensure that participants have access to sample data files prior
to the course.
AT STARZ, TECHNOLOGY IS OUR PASSION; EDUCATION IS OUR LIFE!
This syllabus provides a structured approach for teaching Excel
2010 fundamentals over a 10-day period, balancing instruction
with practical activities to ensure effective learning
AT STARZ, TECHNOLOGY IS OUR PASSION; EDUCATION IS OUR LIFE!