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
Related resources
MS Word Tutorial, for embedding Excel charts in capstone Chapter 4
MS PowerPoint Tutorial, for capstone defense presentations
Final Year Projects Hub, capstone documentation templates
Python Tutorial, for data analysis at scale (pandas)
Scroll down to browse the full Excel tutorial catalog ↓
In this MS Excel Tutorial for Beginners, we will learn the basic and advanced concepts which designed for beginners and professionals considering their requirements in mind. This introduction will tackle …
In this tutorial, we learn to modify rows and columns in excel, as well as its worksheets and cells. We will know how to add delete move and select it. …
In this topic, we will know what Excel subtraction formula is or if it exists in a specific way. Thus different ways to do it, particularly in your worksheet set …
In this tutorial, we will know how to copy format in excel with examples and shortcuts to understand easily. Formatting in excel includes font, data, alignment, bold, italic, color, sizes …
In this tutorial, we learn how to format cells in Excel with examples to understand easily and clearly. Particularly, knowing how to format excel, cell in particular is useful not …
XLOOKUP, dynamic arrays, LET, and Power Query. Excel 2019 works but lacks XLOOKUP, you will need VLOOKUP instead. Free alternatives: LibreOffice Calc (offline, .xlsx-compatible) or Google Sheets (online, real-time collaboration with teammates).A1): when copied, the reference shifts. Copy a formula from B2 to B3 and A1 becomes A2. Absolute (e.g., $A$1): when copied, the reference stays exactly the same. Mixed ($A1 or A$1): only the row or only the column is locked. Use absolute references for things like tax rates, conversion factors, or table headers that should not shift when you fill formulas across cells.