How To Use Pivot Table In Excel: Complete And Easy Guide
What is a Pivot Table in Excel? A pivot table in Excel allows you to arrange data in various ways with just a few clicks. It automatically analyzes, summarizes, sorts, …
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
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 ↓
Parts of Excel Window 2026: Complete Guide with Labeled Diagram [Free PDF]
This tutorial will provide a complete guide to different parts of the Excel window. It is designed to help you become an expert in no time. If you like these …
How to Delete a Pivot Table in Excel Easily
A pivot table is a powerful feature in Excel that allows users to quickly analyze large quantities of data. However, we can’t avoid the possibility that we might have to …
How To Refresh A Pivot Table In Excel In Just Seconds
Refreshing a pivot table in Excel is simple either manually or automatically. Just a few clicks, and then we’re good. What is a Pivot Table? A pivot table is an essential …
How to Use the Excel Show Formulas Shortcut? 3 Methods
What is the Excel Show Formulas Shortcut? The Excel show formulas shortcut is the command that allows you to show formulas instead of their calculated results. It is useful because …
Enhance Productivity With Excel Keyboard Shortcuts
What is Excel Keyboard Shortcuts? Excel keyboard shortcuts are key combinations that accomplish a particular purpose. They are created to help Excel users quickly access the features that they want …
Ultimate Mac Excel Keyboard Shortcuts That You Should Know
Not just Windows has keyboard shortcuts in Excel; Macs have Excel shortcuts too, and that’s what we’re going to show you in this tutorial. These are the most useful Mac …
Assimilate The Excel Autofit Column Width Shortcut
In this tutorial, we will be able to master the shortcut for Excel autofit column width. This feature is invaluable for organizing data clearly and concisely. Knowing the shortcuts in Excel allows …
How To Use Excel Fill Color Shortcut: A Quick And Easy Guide
Are you looking for a keyboard shortcut that fills colors in Excel? You are lucky enough because this tutorial will explain and show you how to use the Excel fill …
Discover The Power Of Excel Autofill Shortcut
In this tutorial, we will discover the shortcut for Excel’s Autofill feature. This feature is invaluable, especially when we are working with a large quantity of data. Knowing the shortcuts in …
Shortcut Of Format Painter In Excel: Keyboard Shortcut
In this tutorial, we will learn the keyboard shortcut for Format Painter in Excel. This article will provide you with the complete information you need for this feature. Knowing the shortcuts …
Shortcut For Merge And Center In Excel: Complete Guide
Learn the shortcut for how to merge and center cells in Excel using this simple tutorial. This guide will provide you with the complete information you need for this feature. As workers …
How To Use An Excel Shortcut To Save As: An Easy Guide
The Excel shortcut to save as or to save is a nice way to get the job done quickly and easily. Sometimes it can be difficult to find the right …
Frequently Asked Questions
Which Excel version should I use?
For 2026, use Microsoft 365 (subscription, always latest) or Excel 2021 (one-time purchase). Both include modern features like
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).VLOOKUP vs INDEX/MATCH vs XLOOKUP: which should I use?
XLOOKUP is the modern best option: easier syntax than VLOOKUP, can look up to the LEFT, no fragile column-index numbers. Use it if you have Excel 2021 or Microsoft 365. INDEX/MATCH is the classic powerful combo: works in all Excel versions, can look up in any direction. Use if you need to support older Excel. VLOOKUP is the simplest but most limited: only looks up to the right, breaks when columns are inserted. Avoid for new work if better options are available.
How do I create a pivot table from scratch?
Select your data (header row + data rows). Insert tab, PivotTable, New worksheet, OK. In the PivotTable Fields pane: drag fields to Rows (groups), Columns (sub-groups), Values (aggregates like Sum/Average/Count), Filters (slice the data). Pivot tables are Excel's most powerful tool for summarizing large datasets, essential for any capstone Chapter 4 data analysis.
What's the difference between relative and absolute cell references?
Relative (e.g.,
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.How do I build a chart for my capstone Chapter 4?
(1) Select your data including header row. (2) Insert tab, Recommended Charts: Excel suggests the best chart type. (3) Pick one (bar for comparisons, line for trends, pie for parts-of-whole). (4) Customize: chart title, axis labels, data labels (Chart Design tab). (5) Right-click then "Copy as Picture" or use the Camera tool for high-quality export. Paste into your Word document. For capstones, use simple charts: bar and line dominate. Avoid 3D charts because they look unprofessional in academic work.
How do I share an Excel file with my team for collaboration?
Best option: upload to OneDrive or SharePoint and open in Excel for the Web for real-time collaboration like Google Sheets. Alternative: save to Google Drive and use Google Sheets for editing (export back to .xlsx when done). Avoid emailing .xlsx files back and forth: you will end up with 5 versions of "FinalReport_v2_REVISED_FINAL.xlsx" and nobody knows which is current. Use cloud sync from day 1.