Meta Excel (M.Excel) User Guide & Spreadsheet Templates | MetaFile Cloud
High-Speed Cloud Spreadsheets with 400+ Formulas, KPI Charts & AI Financial Analytics.
Overview
Meta Excel (M.Excel) is a high-performance cloud spreadsheet application designed for corporate financial modeling, budget planning, statistical calculation, and business intelligence reporting. Running entirely in the browser, M.Excel features a comprehensive calculation engine compatible with standard Microsoft Excel formulas (including VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, and NPV). Users can manage multiple tabs, freeze panes, build colorful KPI charts, and leverage the AI Assistant to automatically write complex formulas, parse messy data sets, or generate revenue projections from plain English descriptions.
Core Capabilities & Features
Full Formula Library (400+ Functions)
Execute mathematical, statistical, financial, logical, text, and date functions with auto-complete suggestions and syntax parameter hints.
Multi-Sheet Workbook Management
Create, rename, reorder, and link multiple sheet tabs within a single workbook. Cross-sheet references (e.g. Sheet2!B4) recalculate automatically in real time.
Interactive Chart & KPI Generation
Transform raw numeric columns into executive charts with a single click. Select from Column, Bar, Line, Pie, Area, and Scatter plots with custom color palettes.
AI Spreadsheet Copilot
Ask AI: "Calculate a 3-year ARR projection starting at $100K with 15% quarterly growth" and M.Excel will populate columns, apply formulas, and format currencies automatically.
Step-by-Step User Guide (How to Use)
Follow these simple steps to start working productively with M.Excel:
Create a Blank Sheet or Select a Financial Model
Open M.Excel from your workspace or pick our SaaS Financial Model template to get started with pre-built MRR/ARR cohorts, gross margin formulas, and EBITDA summaries.
Enter Data & Let AI Generate Formulas
Type numbers into cells or prompt the AI Copilot: "Generate an annual department budget with categories for R&D, Marketing, and Operations". The AI creates properly structured rows and sum formulas.
Visualize Trends & Export to XLSX
Select your summary rows, click "Insert Chart > Line Chart" to visualize quarterly trajectories, and save to your private workspace or download an XLSX file for external sharing.
Interface & Ribbon Toolbar Reference
Detailed explanation of every button, menu action, and tool available on the interface:
| Tool / Action | Shortcut / Access | Detailed Functionality & How to Use |
|---|---|---|
| Formula Bar (fx) | Enter / F2 | Inspect and edit the raw formula or numeric literal stored inside the currently active cell. |
| AutoSum | Alt + = | Automatically detects adjacent numeric cells above or to the left and inserts a =SUM() range formula. |
| Number Formats | Format Menu | Format cell numbers as Currency ($/VND/EUR), Percentage (%), Date, or Scientific notation. |
| Sort & Filter | Ctrl + Shift + L | Enable column filter dropdowns to sort data ascending/descending or filter by specific criteria. |
| Tool / Action | Shortcut / Access | Detailed Functionality & How to Use |
|---|---|---|
| Insert Chart | Insert Tab | Select a cell range and render an interactive ECharts visualization with legend and tooltips. |
| Cell Borders & Fill | Home Tab | Add header background fills, grid line borders, and bold totals to highlight financial summaries. |
| Freeze Panes | View Tab | Keep top header rows or left identifier columns visible while scrolling through thousands of rows. |
Template Library (storage.template)
Explore standardized, professionally pre-designed templates stored in storage.template. You can click Preview (Read-Only) to inspect any template in view-only mode, or click Use / Edit Template to duplicate it directly into your private workspace.
SaaS Financial Model & ARR Forecast (Q1–Q4)
Multi-sheet financial model with MRR/ARR cohort projections, burn rate, gross margin, and EBITDA automated formulas.
Keyboard Shortcuts Reference
| Keystroke | Action Executed |
|---|---|
| Ctrl + S | Save spreadsheet to cloud workspace |
| Alt + = | Insert AutoSum formula for current range |
| Ctrl + D / R | Fill Down or Fill Right from adjacent cell |
| Ctrl + Shift + $ | Apply Currency format to selected cells |
| Ctrl + Shift + % | Apply Percentage format to selected cells |
| F2 | Enter in-cell editing mode |
Frequently Asked Questions
Yes. You can write formulas like =SUM(Q1_Sales!B2:B20) + SUM(Q2_Sales!B2:B20) to roll up numbers across tabs seamlessly.
M.Excel focuses on core calculations, formulas, styling, and charts. VBA macros are safely ignored during import, while all data, formulas, and visual layouts are preserved.