By using expertatexcel.com you agree to our
cookie policy
, We and our partners operate globally and use cookies, for multiple purposes
Close
expertatexcel.com
Home
Macro Intro
What can Excel do?
Learning >
Learning
Excel Books
Basic concepts
Immediate window
Macros 101
Syntax
Use existing code
Hello world
Math
formulas
Functions
Modifying Recorded Macros
Macro Recorder
Selecting
Moving data
Formatting
Clipboard
Range names
Filters
Sorting
Fill
Combining
Hyperlinks
Comments
Options
Vlookup
Conditional Formatting
Data validation
Pivot Tables
Charts
Charts
Macro Programming
Debugging
Strings
Active
This
vba statements
VBA functions
Run stuff
Object Model
Workbook
Sheet
Cells
Rows
Column
Range
Selection
Methods
Properties
Events
Collections
Chart
Software Dev
Variables
Data types
variables/scope
Conditionals
Loops
functions/sub
Arrays
testing
Batch
Software dev techniques
Backup/Recovery
Documentation
Wrappers
webservice
Refactor
Problems
#Errors
Problems
Too Slow/Optimize
Error handling
Problem Solving Method
Someone else's sheet
complex formula
Misc
Date/times
Code Generation
Random
Shortcuts
Forms
Special Chars
Customize your training
Work and learn
Projects/Apps
Reporting
Sample projects
Reconcliation
Adjusting data
Generate Slides
Special Characters
External
Outlook
Web
Database
Files
PPT
Word
API
Objects
Script host
Dos
Bloomberg
JIRA
Input Spreadsheets or files
Learning Tracks
Stocks
Bitcoin
Sports
Job
Productivity
Project Management
Tracking
Health
Games
Programmer
Functions
Excel supports many different functions.
A function is a shortcut which is pass parameter(s) and then returns a result.
For example
A
B
C
D
1
23
2
5523
3
332
4
523
5
1211
6
3223
7
=SUM(A1:A6)
8
10835
9
10
Math
Sum
Average
Count
Max
Min
Introduction to Excel Functions
Top 10 Excel Functions to know