Free Practic Excel Exercises * { box-sizing: border-box; margin: 0; padding: 0; font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; } body { background-color: #f8f9fa; color: #333; padding: 20px; } .container { max-width: 1200px; margin: 0 auto; } /* Hero Section */ .hero { text-align: center; padding: 20px 20px; background: #107c41; /* Microsoft Excel Green */ color: #fff; border-radius: 10px; margin-bottom: 20px; } .hero h1 { font-size: 2.2rem; margin-bottom: 10px; color: #fff } .hero p { font-size: 1.1rem; opacity: 0.9; margin-bottom: 10px; } .search-box { width: 100%; max-width: 500px; padding: 12px 20px; border: none; border-radius: 25px; font-size: 1rem; outline: none; box-shadow: 0 2px 5px rgba(0,0,0,0.1); } /* Filter Buttons */ .filter-container { display: flex; justify-content: center; gap: 10px; flex-wrap: wrap; margin-bottom: 30px; } .filter-btn { background: #e9ecef; border: none; padding: 10px 18px; border-radius: 20px; cursor: pointer; font-weight: 600; color: #495057; transition: 0.2s; } .filter-btn:hover, .filter-btn.active { background: #107c41; color: #fff; } /* Template Cards Grid */ .grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(300px, 1fr)); gap: 25px; } .card { background: #fff; border-radius: 10px; border: 1px solid #e0e0e0; overflow: hidden; display: flex; flex-direction: column; box-shadow: 0 4px 6px rgba(0,0,0,0.05); transition: transform 0.2s; } .card:hover { transform: translateY(-5px); } .card-img { width: 100%; height: 160px; background-color: #e2e8f0; display: flex; align-items: center; justify-content: center; font-weight: bold; color: #64748b; object-fit: cover; } .card-body { padding: 20px; display: flex; flex-direction: column; flex-grow: 1; } .badge { align-self: flex-start; background: #e6f4ea; color: #137333; padding: 4px 10px; border-radius: 12px; font-size: 0.75rem; font-weight: bold; margin-bottom: 10px; text-transform: uppercase; } .card h3 { font-size: 1.2rem; margin-bottom: 8px; } .card p { font-size: 0.9rem; color: #666; margin-bottom: 20px; flex-grow: 1; } /* Button Group */ .btn-group { display: flex; gap: 10px; } .btn { flex: 1; padding: 10px; border-radius: 6px; font-weight: 600; text-align: center; cursor: pointer; border: none; text-decoration: none; font-size: 0.9rem; transition: background 0.2s; } .btn-preview { background: #e9ecef; color: #495057; } .btn-preview:hover { background: #dee2e6; } .btn-download { background: #107c41; color: #fff; } .btn-download:hover { background: #0b5c30; } /* Modal Styles */ .modal-overlay { position: fixed; top: 0; left: 0; width: 100%; height: 100%; background: rgba(0,0,0,0.7); display: none; justify-content: center; align-items: center; z-index: 1000; padding: 20px; } .modal-overlay.active { display: flex; } .modal-content { background: #fff; border-radius: 10px; max-width: 950px; width: 100%; max-height: 92vh; overflow-y: auto; position: relative; padding: 20px; display: flex; flex-direction: column; } .modal-header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 15px; padding-right: 30px; } .modal-close { position: absolute; top: 15px; right: 20px; font-size: 1.8rem; background: none; border: none; cursor: pointer; color: #888; } .modal-close:hover { color: #000; } .excel-frame { width: 100%; height: 480px; border: 1px solid #ccc; border-radius: 6px; background: #fdfdfd; margin-bottom: 15px; } .modal-footer { display: flex; justify-content: space-between; align-items: center; gap: 10px; margin-top: 10px; } .modal-desc { font-size: 0.95rem; color: #555; }

Free Practic Excel Exercises

Download free practice files, dynamic dashboards, and business trackers.

Preview Image
Basic Formilas

VLOOKUP , HLOOlUP & XLOOKUP Practice Sheet

Master lookup functions with hands-on practice tables and step-by-step guidelines.

Download
Preview Image
Basic Formilas

VLOOKUP , HLOOlUP & XLOOKUP Practice Sheet

Master lookup functions with hands-on practice tables and step-by-step guidelines.

Download
Preview Image
Intermediate

Pivot Table Raw Sales Dataset

Over 1,000 rows of retail sales data to practice dynamic summaries and slicers.

Download
Preview Image
Intermediate

Pivot Table Raw Sales Dataset

Over 1,000 rows of retail sales data to practice dynamic summaries and slicers.

Download
Preview Image
Business

Automated Invoice Generator

Calculate taxes, line totals, and final amounts automatically with built-in formulas.

Download
Preview Image
Business

Automated Invoice Generator

Calculate taxes, line totals, and final amounts automatically with built-in formulas.

Download
Preview Image
Advanced

Executive KPI Dashboard

Interactive chart dashboard powered by dynamic arrays, slicers, and conditional formatting.

Download
Preview Image
Advanced

Executive KPI Dashboard

Interactive chart dashboard powered by dynamic arrays, slicers, and conditional formatting.

Download
let activeCategory = 'all'; // Combined Filter Logic (Search + Category) function applyFilters() { const query = document.getElementById('searchInput').value.toLowerCase(); const cards = document.querySelectorAll('.card'); cards.forEach(card => { const title = card.querySelector('h3').innerText.toLowerCase(); const desc = card.querySelector('p').innerText.toLowerCase(); const category = card.getAttribute('data-category'); const matchesSearch = title.includes(query) || desc.includes(query); const matchesCategory = activeCategory === 'all' || category === activeCategory; if (matchesSearch && matchesCategory) { card.style.display = 'flex'; } else { card.style.display = 'none'; } }); } // Category Filter Trigger function filterCategory(category, btn) { document.querySelectorAll('.filter-btn').forEach(b => b.classList.remove('active')); btn.classList.add('active'); activeCategory = category; applyFilters(); } // Search Input Trigger function filterTemplates() { applyFilters(); } // Excel Live Preview Logic function openExcelPreview(title, fileUrl, description) { document.getElementById('modalTitle').innerText = title; document.getElementById('modalDesc').innerText = description; document.getElementById('modalDownloadBtn').href = fileUrl; // Microsoft Office Web Viewer API const encodedFileUrl = encodeURIComponent(fileUrl); const viewerUrl = `https://view.officeapps.live.com/op/embed.aspx?src=${encodedFileUrl}`; document.getElementById('excelViewer').src = viewerUrl; document.getElementById('previewModal').classList.add('active'); } function closePreview() { document.getElementById('previewModal').classList.remove('active'); // Reset iframe to stop loading resources in the background document.getElementById('excelViewer').src = ''; } // Close modal when clicking outside backdrop window.onclick = function(event) { const modal = document.getElementById('previewModal'); if (event.target === modal) { closePreview(); } }
Scroll to Top