Excel & Google Sheets

Spreadsheet Management 

I can organize and maintain spreadsheets, enter and clean data, sort and filter information, perform basic calculations, create simple reports, and use charts to present information clearly.

Skills Demonstrated

• Data entry and formatting

• Sorting and filtering

• Data cleaning and accuracy checks

• Basic calculations and formulas

• Tables and data validation

• Conditional formatting

• Charts and simple reports

• PivotTables

Sample: Sales Summary

Regional Sales

• Lagos — ₦250,000

• Abuja — ₦180,000

• Port Harcourt — ₦200,000

• Ibadan — ₦120,000

Total Sales — ₦750,000

Highest Sales — Lagos (₦250,000)
Lowest Sales — Ibadan (₦120,000)

Example: Client Request

“Please review the sales data, identify the highest and lowest performing regions, calculate the total sales, and prepare a simple chart for presentation.”

Completed Tasks

• Reviewed and organized the data.

• Calculated total sales.

• Identified the highest and lowest sales regions.

• Created a simple sales chart.

• Prepared a short summary for easy review.

Sample: Order Management & Sales Analysis 

A practical Excel project demonstrating order data organization, data checking, sales calculations, and PivotTable analysis. 

Google Sheets

I can use Google Sheets to organize information, maintain simple trackers, sort and filter data, apply basic formulas, and collaborate on shared spreadsheets. 

Examples of Tasks

• Updating customer or order records

• Maintaining simple task trackers

• Sorting and filtering information

• Checking data for missing or inconsistent entries

• Sharing and collaborating on spreadsheets

Google Sheets Sample: Order & Customer Tracker