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
Advanced Filter
Aggregate
Anova
Area Chart
Assignment Problem
Automated Invoice
AutoRecover
Axes
Bar Chart
Budget
Budget Limit
Calculated Field/Item
Calendar
Capital Investment
Cell Styles
Center on Page
Chart Sheet
Checklist
Chop off Decimals
Circular Reference
Color Scales
Column Chart
Combination Chart
Comments
Compare Text
Compare Two Lists
Compound Interest
Concatenate Strings
Conflicting Rules
Consolidate
Copy Exact Formula
Copy Visible Cells Only
Correlation
Count Blank/Nonblank Cells
Count Errors
Count Logical Values
Count Text Occurrences
Count Unique Values
Count with Or Criteria
Currency vs Accounting
Custom Lists
Custom Number Format
Data Bars
Data Form
Data Series
Data Tables
Date Filters
Date and Time Formats
DateDif
Day of the Year
Days until Birthday
Decimal Places
Default Templates
Delete Blank Rows
Dependent Drop-down Lists
Depreciation
Descriptive Statistics
Developer Tab
Drop-down List
Dynamic Named Range
Embed
Error Bars
Even and Odd
Exponential Smoothing
External References
F-Test
Fibonacci Sequence
Find Duplicates
Find Features
Find vs Search
Flash Fill
Floating Point Errors
Forecast and Trend
Format Painter
Formula Auditing
Fractions
Freeze Panes
Frequency Distribution
Function Keys
Gantt Chart
Gauge Chart
Group Pivot Table Items
Group Worksheets
Headers and Footers
Hide Columns or Rows
Histogram
Holidays
Hyperlinks
Icon Sets
IfError
Ifs
Import Access Data
Import/Export Text Files
Indirect
Investment or Annuity
Invoice
IsError
Last Day of the Month
Left Lookup
Line Chart
Loan Amortization Schedule
Loans with Different Durations
Locate Maximum Value
Lock Cells
Lower/Upper Case
Manage Rules
Mark as Final
MaxIfs and MinIfs
Maximum Flow Problem
Meal Planner
Microsoft Query
Most Frequently Occurring Word
Moving Average
Multi-level Pivot Table
Names in Formulas
Nearest Multiple
Negative Numbers to Zero
Nested If
New Rule
Number and Text Filters
Numbers to Text
Number of Instances
Number of Words
Offset
OneDrive
Online
Outlining Data
Page Breaks
Page Numbers
Pareto Chart
Paste Options
PDF
Percent Change
Percentiles and Quartiles
Pie Chart
Pivot Chart
Prevent Duplicate Entries
Print Area
Print Gridlines and Headings
Print Titles
Product Codes
Protect Sheet
Protect Workbook
Quadratic Equation
Quarter
Quick Access Toolbar
Quick Operations
Random Numbers
Randomize List
Rank
Read-only Workbook
Regression
Reject Invalid Dates
Remove Duplicates
Remove Unwanted Characters
Reverse List
Roll the Dice
Row Differences
Save in 97-2003 Format
Scatter Chart
Search Box
Sensitivity Analysis
Separate Strings
Shade Alternate Rows
Share Workbooks
Shortest Path Problem
Skip Blanks
Slicers
Sort by Color
Sparklines
Spelling
Split
Status Bar
Structured References
Substitute vs Replace
Sum Every nth Row
Sum Largest Numbers
Sum Range with Errors
Sum with Or Criteria
Sumproduct
Switch
System of Linear Equations
t-Test
Table Styles
Tax Rates
Text to Columns
Text to Numbers
Themes
Thermometer Chart
Time Sheet
Transportation Problem
Transpose
Trendline
Two-column Lookup
Two-way Lookup
Union and Intersect
Update Pivot Table
View Multiple Workbooks
View Multiple Worksheets
Weekdays
Workbook Views
XML
Zoom

VBA Examples

Swap Values
Run Code from a Module
Macro Recorder
Use Relative References
FormulaR1C1
Add a Macro to the Toolbar
Macro Security
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
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
Macro Comments
Separate Strings
Reverse Strings
Convert to Proper Case
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
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