Sitemap

 

Main

Excel

Sections

Introduction
Basics
Functions
Data Analysis
VBA
Examples

Introduction

Range
Formulas and Functions

Basics

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Templates
Data Validation
Keyboard Shortcuts
Print
Share
Protect

Functions

Count and Sum
Logical
Cell References
Date & Time
Text
Lookup & Reference
Financial
Statistical
Round
Formula Errors
Array Formulas

Data Analysis

Sort
Filter
Conditional Formatting
Charts
Pivot Tables
Tables
What-if Analysis
Solver
Analysis Toolpak

VBA

Create a Macro
MsgBox
Workbook and Worksheet Object
Range Object
Variables
If Then Statement
Loop
Macro Errors
String Manipulation
Date and Time
Events
Array
Function and Sub
Application Object
ActiveX Controls
Userform

Excel Examples

3D-reference
Absolute Reference
Absolute Value
Add a Column
Add or Subtract Time
Address
Advanced Filter
Aggregate
Anova
Area Chart
Array Manipulation
Assignment Problem
AutoFill
AutoFit
Automated Invoice
AutoRecover
Average
AverageIf
Axes
Bar Chart
BMI calculator
Budget
Budget Limit
Bullet Points
CAGR
Calculate Age
Calculated Field/Item
Calendar
Capital Investment
Case-sensitive Lookup
Cell Styles
Center on Page
Chart Sheet
Check Mark
Checkbox
Chop off Decimals
Circular Reference
Closest Match
Cm to inches
Color Scales
Column Chart
Combination Chart
Comments
Compare Text
Compare Two Columns
Compare Two Lists
Comparison Operators
Compound Interest
Concatenate
Conflicting Rules
Consolidate
Contains Specific Text
Copy a Formula
Copy Visible Cells Only
Correlation
Count Blank/Nonblank Cells
Count Cells with Text
Count Characters
Count Errors
Count Unique Values
Count with Or Criteria
Countif
Currency vs Accounting
Custom Lists
Custom Number Format
Custom Sort Order
Customize the Ribbon
Data Bars
Data Form
Data Series
Data Tables
Date Filters
Date and Time Formats
DateDif
Day of the Year
Days between Dates
Days until Birthday
Decimal Places
Default Templates
Delete Blank Rows
Delete Row
Dependent Drop-down Lists
Depreciation
Descriptive Statistics
Developer Tab
Discount
Divide
Drop-down List
Dynamic Arrays
Dynamic Named Range
Embed
Error Bars
Even and Odd
Exponential Smoothing
External References
F-Test
Fibonacci Sequence
FILTER function
Find Duplicates
Find Features
Find
Flash Fill
Floating Point Errors
Forecast
Format Painter
Formula Auditing
Formula Bar
Formula to Value
Fractions
Freeze Panes
Frequency Distribution
Frequency
Function Keys
Gantt Chart
Gauge Chart
Get Sheet Name
GetPivotData
Goal Seek
Group Pivot Table Items
Group Worksheets
Headers and Footers
Heat Map
Hide Columns or Rows
Histogram
Holidays
Hyperlinks
Icon Sets
If Cell is Blank
If
IfError
IFNA
Ifs
Import Access Data
Import/Export Text Files
Index and Match
Indirect
Insert Row
Investment or Annuity
Invoice
IRR
IsError
Kg to lbs
Lambda
Last Day of the Month
Left Lookup
LET function
Line Break
Line Chart
Loan Amortization Schedule
Loans with Different Durations
Locate Maximum Value
Lock Cells
Change Case
Manage Rules
Mark as Final
MaxIfs and MinIfs
Maximum Flow Problem
Meal Planner
Merge Cells
Merge Tables
Microsoft Query
Mod
Mode
Most Frequently Occurring Word
Most Used Functions
Move Columns
Moving Average
Multi-level Pivot Table
Multiply
Name Box
Named Range
Nearest Multiple
Negative Numbers to Zero
Not Equal To
NPV
Number and Text Filters
Numbers to Text
Count Words
Offset
OneDrive
Online
Or
Outlining Data
Page Breaks
Page Numbers
Pareto Chart
Paste Options
Paste Special
PDF
Percent Change
Percentage
Percentiles and Quartiles
Box and Whisker Plot
Pie Chart
Pivot Chart
PMT
Prevent Duplicate Entries
Print Area
Print Gridlines and Headings
Print Titles
Product Codes
Profit Margin
Protect Sheet
Protect Workbook
Quadratic Equation
Quarter
Quick Access Toolbar
Quick Analysis
Random Numbers
Randomize List
Rank
Read-only Workbook
Regression
Reject Invalid Dates
Remove Duplicates
Remove Spaces
Reverse List
Roll the Dice
Rounding Times
Row Differences
ROW function
Running Total
Save As
Save in 97-2003 Format
Scatter Plot
Scroll Lock
Search Box
Search
Sensitivity Analysis
Separate Strings
Shade Alternate Rows
Share Workbooks
Shortest Path Problem
Show Formulas
Skip Blanks
Slicers
Sort by Color
SORT function
Sparklines
Spell Check
Split Cells
Split
Square Root
Standard Deviation
Status Bar
Strikethrough
Structured References
Substitute vs Replace
Substring
Subtotal
Subtract
Sum Every nth Row
Sum Largest Numbers
Sum Range with Errors
Sum with Or Criteria
Sum
Sumif
Sumproduct
Superscript and Subscript
Switch
System of Linear Equations
Table as Source Data
t-Test
Table Styles
Tax Rates
Text to Columns
Text to Numbers
Text
Themes
Thermometer Chart
Time Difference
Time Sheet
Today's Date
Transportation Problem
Transpose
Trendline
Two-column Lookup
Two-way Lookup
Unhide Sheets
Union and Intersect
Unique Values
Update Pivot Table
View Multiple Workbooks
View Multiple Worksheets
Vlookup
Weekdays
Weighted Average
Wildcards
Workbook Views
Wrap Text
Xlookup
XML
Zoom

VBA Examples

Swap Values
Run Code from a Module
Macro Recorder
Use Relative References
FormulaR1C1
Add a Macro to the Toolbar
Enable Macros
Protect Macro
MsgBox Function
InputBox Function
Path and FullName
Close and Open
Loop through Books and Sheets
Sales Calculator
Files in a Directory
Import Sheets
Programming Charts
CurrentRegion
Dynamic Range
Resize
Entire Rows and Columns
Offset
From Active Cell to Last Entry
Union and Intersect
Test a Selection
Possible Football Matches
Font
Background Colors
Areas Collection
Compare Ranges
Option Explicit
Variable Scope
Life of Variables
Type Mismatch
Logical Operators
Select Case
Tax Rates
Mod Operator
Prime Number Checker
Find Second Highest Value
Sum by Color
Delete Blank Cells
Loop through Defined Range
Loop through Entire Column
Do Until Loop
Step Keyword
Create a Pattern
Sort Numbers
Randomly Sort Data
Remove Duplicates
Complex Calculations
Knapsack Problem
Debugging
Error Handling
Err Object
Interrupt a Macro
Subscript Out of Range
Macro Comments
Separate Strings
Reverse Strings
Convert to Proper Case
Instr
Count Words
Compare Dates and Times
DateDiff Function
Weekdays
Delay a Macro
Year Occurrences
Tasks on Schedule
Sort Birthdays
BeforeDoubleClick Event
Highlight Active Cell
Create a Footer Before Printing
Bills and Coins
Rolling Average Table
Dynamic Array
Array Function
Month Names
Size of an Array
User Defined Function
Custom Average Function
Volatile Functions
ByRef and ByVal
StatusBar
Read Data from Text File
Write Data to Text File
Vlookup
Text Box
List Box
Combo Box
Check Box
Option Buttons
Spin Button
Loan Calculator
Userform and Ranges
Currency Converter
Progress Indicator
Multiple List Box Selections
Multicolumn Combo Box
Dependent Combo Boxes
Loop through Controls
Controls Collection
Userform with Multiple Pages
Interactive Userform