Microsoft Excel is a powerful spreadsheet program that is widely used in various industries. This course is designed to provide beginners with a solid foundation in Excel, teaching them the essential skills and techniques needed to navigate, create, format, and analyze data effectively. Through hands-on exercises and practical examples, learners will gain confidence in using Excel to solve real-world problems, make data-driven decisions, and improve productivity.

Here are some specific benefits of taking this course:

Learn the basics of Excel, including how to create and format spreadsheets, enter and edit data, and use formulas and functions.
Gain hands-on experience with Excel by working on real-world projects.
Improve your productivity by learning how to automate tasks and use Excel to analyze data.
Make data-driven decisions by learning how to use Excel to create charts and graphs.

Who should take this course?

If you are interested in learning more about Microsoft Excel, this course is a great place to start. The skills you learn will be valuable in any career, and you will be able to use Excel to solve real-world problems and improve your productivity.

Course Duration: 4 weeks (8 sessions)

Course Outline:

Introduction to Excel and Formatting Technique

Introduction to Microsoft Excel and its features
Excel interface and navigation
Workbook and worksheet basics
Entering and editing data
Formatting cells, rows, and columns
Using borders and shading
Conditional formatting

2. Working with Formulas and Functions

Understanding cell references
Basic arithmetic operations
Common functions (SUM, AVERAGE, MIN, MAX, COUNT) and formula tools
Absolute and relative cell references

3: Data Manipulation and Analysis

Sorting data
Filtering and advanced filtering
Using data validation
Data consolidation
Subtotaling and grouping data

4: Working with Charts and Graphs

Creating basic charts (column, line, pie)
Modifying chart elements (titles, legends, axes)
Formatting chart objects
Using chart templates
Advanced charting techniques (trendlines, secondary axes)

Class starts: Sunday, June 11th, 2023.

Nosa osawe