MS Excel Tutorial

MS Excel is the universal data analysis tool — used by accountants, analysts, project managers, and BSIT students writing capstone Chapter 4 results sections. This hub collects free Excel tutorials covering formulas, pivot tables, VLOOKUP and INDEX/MATCH, conditional formatting, charts, and advanced features like macros (VBA) and Power Query.

What you’ll learn in the Excel tutorial series

Interface and navigation — ribbon, quick access toolbar, name box, formula bar
Cell references — relative, absolute, mixed (the foundation of all formulas)
Essential formulas — SUM, AVERAGE, COUNT, IF, AND, OR, CONCATENATE
Lookup functions — VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP (Excel 365)
Conditional formatting — color-coding cells based on rules
Pivot tables — summarizing large datasets quickly
Charts and graphs — bar, line, pie, scatter, combo charts for reports
Data validation — dropdown lists, input restrictions
Macros (VBA) — automating repetitive tasks with code
Power Query intro — modern data import and transformation

Why Excel matters for BSIT students

Excel is essential for capstone Chapter 4 (Results) sections — you’ll create tables of test results, system performance metrics, user feedback summaries, and statistical analyses. Charts built in Excel become the figures in your documentation. Beyond capstones, Excel is the most-used productivity tool in Philippine offices — mastering it is a marketable skill regardless of your post-graduation path.

Capstone-specific Excel workflows

Test result tables — track test cases, expected vs actual results, pass/fail flags
User acceptance testing — survey response analysis, satisfaction scores
Performance benchmarks — system response times, load test results
Cost-benefit analysis — for Chapter 1 problem statement or Chapter 5 recommendations
Project timeline (Gantt-style) — for Chapter 3 methodology
Charts — export to PNG/JPG for embedding in your Word document