M.
Excel
Spreadsheets, Financial Models & BI Studio
Loading file...
Initializing studio engine...
15%
M.
Excel
âī¸â
Saved to Cloud
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Paste âž
đ
Paste
Ctrl+V
123
Paste Values
fx
Paste Formulas
đ¨
Paste Formatting
đ
Transpose (Rows â Columns)
âī¸
Paste Special...
Cut
Copy
Painter
Clipboard
Segoe UI
Calibri
Arial
Times New Roman
Consolas
Tahoma
9
10
11
12
14
16
18
20
24
28
36
B
I
U
âž
U
Single Underline
U
Double Underline
S
âž
_ Bottom Border
âž Top Border
| Left Border
| Right Border
â No Border
į° All Borders
âģ Outside Borders
âŦ Thick Outside Borders
â Bottom Double Border
âī¸ More Borders...
âž
A
âž
Font
ab
ââž
Angle Counterclockwise
Angle Clockwise
Vertical Text
Rotate Text Up
Rotate Text Down
Horizontal (Reset)
Wrap Text
Merge & Center âž
Merge & Center
Merge Across
Merge Cells
Unmerge Cells
Alignment
General
Number (0.00)
Currency ($)
Accounting
Short Date
Long Date
Time
Percentage (%)
Fraction
Scientific
Text
$ âž
$ English (United States - USD)
âŦ Euro (EUR)
ÂŖ English (United Kingdom - GBP)
ÂĨ Japanese Yen (JPY)
âĢ Vietnamese Dong (VND)
%
,
.00â
â.0
Number
Conditional
Formatting âž
âļ
Greater Than...
â
Less Than...
â
Between...
=
Equal To...
đĨ
Duplicate Values...
đ
Data Bars
đĄī¸
Color Scales
â
Clear Rules
âī¸
Manage Rules...
Format as
Table âž
TABLE STYLES
Light Blue
Light Green
Light Gray
Medium 1
Dark 1
Orange
Purple
Plain Grid
Cell
Styles âž
GOOD, BAD AND NEUTRAL
Normal
Bad
Good
Neutral
Heading 1
Heading 2
Total
Accent 1
Styles
Insert âž
Insert Cells...
Insert Sheet Rows
Insert Sheet Columns
Insert Sheet
Delete âž
Delete Cells...
Delete Sheet Rows
Delete Sheet Columns
Delete Sheet
Format âž
Row Height...
AutoFit Row Height
Column Width...
AutoFit Column Width
Hide Rows
Unhide Rows
Hide Columns
Unhide Columns
Format Cells... (Ctrl+1)
Cells
ÎŖ
AutoSum âž
Sum
Average
Count Numbers
Max
Min
More Functions...
Fill âž
Down
Ctrl+D
Right
Ctrl+R
Up
Left
⥠Flash Fill
Ctrl+E
Clear âž
Clear All
Clear Formats
Clear Contents
Del
Clear Comments & Notes
Sort & Filter âž
Sort A to Z (Ascending)
Sort Z to A (Descending)
Custom Sort...
đĒī¸ Filter
Ctrl+Shift+L
Clear Filter
Find & Select âž
Find...
Ctrl+F
Replace...
Ctrl+H
Go To...
Ctrl+G
Select Formula Cells
Select Constant Cells
Editing
Templates
Library
Templates
PivotTable
Recommended
PivotTables
Table
Tables
Pictures âž
PLACE OVER CELLS
đģ
This Device...
đ
Online Picture URL...
PLACE IN CELL
đĨ
From Device in Cell...
đ
From URL in Cell...
Shapes âž
Lines & Connectors
Rectangles
Basic Shapes
Block Arrows
Flowchart
Stars, Banners & Callouts
Icons âž
QUICK ICONS
đ
đ
đ°
đ
đĨ
â
â
â ī¸
â
đĨ
đ
đ¯
đĻ
đ
đĄ
đ
đ
đ
đ
More Icons & Symbols...
3D Models
Illustrations
Get Add-ins
Add-ins
Recommended
Charts
Column / Bar âž
2-D & 3-D COLUMN
đ
Clustered Column (2-D)
đī¸
Stacked Column (2-D)
đ§
3-D Column
2-D BAR
đļ
Clustered Bar (2-D)
Line / Area âž
LINE & AREA CHARTS
đ
Line with Markers
ã°ī¸
Smooth Line
đī¸
Area Chart
Pie / Doughnut âž
đĨ§
2-D Pie Chart
đŠ
Doughnut Chart
Other Charts âž
â
Scatter (X, Y) + Trendline
đ
Waterfall Chart
đ
Combo Column + Line
âī¸
All Charts & Preview...
Charts
Line
Column
Win/Loss
Sparklines
Slicer
Timeline
Filters
Link
Links
Text Box
Header/Footer
A
WordArt âž
WORDART STYLES
A
Fill - Green Accent
A
Fill - Ocean Blue
A
Gradient - Sunset Gold
A
Fill - Royal Purple
A
Outline - Emerald
A
Glow - Cyber Blue
â
Equation âž
BUILT-IN EQUATIONS
â¯
Area of Circle: A = Īr²
â
Quadratic: x = (-b Âą â(b²-4ac))/2a
đ
Pythagorean: a² + b² = c²
â
Summation: â xáĩĸ
âĢ
Integral: âĢ g(t) dt
âī¸
Insert New Equation...
Ί
Symbol
Text & Symbols
Themes âž
đĸ Office (Default Emerald)
đ Facet (Deep Ocean Blue)
đŋ Integral (Forest & Earth)
⥠Ion (Amber & Violet)
đ Organic (Warm Wood & Gold)
đī¸ Retrospect (Classic Slate)
Themes
Margins âž
Normal (Top:1.9, Bottom:1.9, Left:1.8, Right:1.8)
Wide (Top:2.5, Bottom:2.5, Left:2.5, Right:2.5)
Narrow (Top:1.2, Bottom:1.2, Left:0.6, Right:0.6)
âī¸ Custom Margins...
Orientation âž
đ Portrait
đ Landscape
Size âž
A4 (210 x 297 mm)
Letter (8.5 x 11 in)
Legal (8.5 x 14 in)
A3 (297 x 420 mm)
Print Area âž
Set Print Area
Clear Print Area
Breaks âž
Insert Page Break
Remove Page Break
Reset All Page Breaks
Background
Print Titles
Page Setup
Width:
Automatic
1 page
2 pages
3 pages
Height:
Automatic
1 page
2 pages
3 pages
Scale:
%
Scale to Fit
Gridlines:
View
Print
Headings:
View
Print
Sheet Options
Bring
Forward
Send
Backward
Selection
Pane
Arrange
fx
Insert
Function
ÎŖ
AutoSum âž
â Sum
Average
Count Numbers
Max
Min
More Functions...
Recently
Used âž
SUM
AVERAGE
IF
VLOOKUP
COUNT
MAX
PMT
Financial âž
PMT (Loan Payment)
PV (Present Value)
FV (Future Value)
RATE (Interest Rate)
NPER (Number of Periods)
IRR (Internal Rate of Return)
NPV (Net Present Value)
Logical âž
IF
IFS
AND
OR
NOT
IFERROR
XOR
SWITCH
Abc
Text âž
CONCAT
TEXTJOIN
LEFT
RIGHT
MID
LEN (String Length)
TRIM (Remove Spaces)
UPPER (Uppercase)
LOWER (Lowercase)
PROPER (Title Case)
SUBSTITUTE
Date &
Time âž
TODAY (Current Date)
NOW (Date & Time)
DATE
DAY
MONTH
YEAR
DATEDIF
EDATE
EOMONTH
NETWORKDAYS
Lookup &
Reference âž
VLOOKUP (Vertical Lookup)
HLOOKUP (Horizontal Lookup)
XLOOKUP (Modern Lookup)
INDEX
MATCH
CHOOSE
OFFSET
INDIRECT
Math &
Trig âž
SUM
SUMIF
SUMIFS
ROUND
ROUNDUP
ROUNDDOWN
INT (Integer)
ABS (Absolute Value)
MOD (Modulo)
PRODUCT
POWER
SQRT (Square Root)
More
Functions âž
COUNTIF
COUNTIFS
AVERAGEIF
AVERAGEIFS
LARGE (k-th Largest)
SMALL (k-th Smallest)
RANK
MEDIAN
MODE
Function Library
Name
Manager
Define
Name
Use in
Formula âž
Paste Names...
Create from
Selection
Defined Names
Trace Precedents
Trace Dependents
Remove Arrows
Show
Formulas
Error
Checking
Evaluate
Formula
Watch
Window
Formula Auditing
Calculation
Options âž
â Automatic
âī¸ Manual (Press F9 to Calculate)
Calculate Now (F9)
Calculate Sheet
Calculation
Get Data âž
đ From Text/CSV
đ From Web (URL / REST API)
đ From Table/Range
đī¸ From SQL Database / JSON
From Text/
CSV
From
Web
From Table/
Range
Get & Transform Data
Refresh
All
Queries &
Connections
Queries & Connections
Sort A-Z
Sort Z-A
Custom
Sort...
Filter
Clear
Reapply
Advanced...
Sort & Filter
Text to
Columns
Flash
Fill
Remove
Duplicates
Data
Validation âž
âī¸ Data Validation...
â Circle Invalid Data
â Clear Validation Circles
Consolidate
Data Tools
What-If
Analysis âž
đ Scenario Manager...
đ¯ Goal Seek...
âĻ Data Table...
Forecast
Sheet
Forecast
Group
Ungroup
ÎŖ
Subtotal...
Show Detail
Hide Detail
Outline
Spelling
Thesaurus
Workbook
Statistics
Translate
Proofing & Language
Check
Accessibility
Accessibility
New
Comment
Delete
Previous
Next
Show/Hide
Show All
Comments & Notes
Protect
Sheet
Protect
Workbook
Allow Ranges
Unprotect
Protect
Normal
Page Break
Preview
Page
Layout
Workbook Views
Ruler
Gridlines
Formula Bar
Headings
Show
Zoom
100%
100%
Zoom to
Selection
Zoom
New
Window
Freeze
Panes âž
âī¸ Freeze Panes (At Active Cell)
đ Freeze Top Row (Row 1)
âŽī¸ Freeze First Column (Column A)
âī¸ Unfreeze Panes
Split
Window
â
â
fx
Ready
â Auto-saved
âĻ
âĢ
â¤
-
+
100%
â
Back
đ
Home
đ
New
đ
Open
âšī¸
Info
đž
Save
â
Save & Close Editor
đĨ
Save As
đ¨ī¸
Print
đ¤
Export
â
Close Editor
Format Cells
â
Cut
Ctrl+X
Copy
Ctrl+C
Paste
Ctrl+V
Paste Values
Insert Row
Delete Row
Clear Contents
Del
Format Cells...
Ctrl+1