Subscribe
Tutorial search

Excel Tutorials


We hope that you will enjoy our Excel tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel tutorial to our site. Thank you !

Sort by:
Excel formulas and functions.
Excel formulas and functions.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Difficulty:
Quick Access Toolbar
Quick Access Toolbar
If you use an Excel command frequently you can add its icon to the Quick Access Toolbar.
Difficulty:
Excel Calendar
Excel Calendar
Making a calendar in Excel is easy. Instead of creating your own calendar from scratch, you can create a calendar from a template.
Difficulty:
Excel External References
Excel External References
An external reference (also called link) is a reference to a cell or range of cells in another Excel workbook.
Difficulty:
Adding Numbers using Autosum
Adding Numbers using Autosum
Autosum feature is used to make summing operation as fast as possible. I presented a few ways you can use Autosum.
Difficulty:
Autofill
Autofill
Autofill is a useful feature that will help you insert data such as days, months, etc. It will also let you create your own custom lists.
Difficulty:
Excel Drop-Down List
Excel Drop-Down List
Drop-down lists are helpful if you want to be sure that users select an item from a list, instead of typing their own values.
Difficulty:
Excel Sumif
Excel Sumif
This tutorial teaches you how to conditionally sum a range using the Sumif function.
Difficulty:
Excel Conditional Formatting
Excel Conditional Formatting
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
Difficulty:
Excel Date & Time Functions
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
Difficulty:
How to use a Scroll Bar in Excel
How to use a Scroll Bar in Excel
How to use a scroll bar in Excel to create a scrollable list. Great for dashboards.
Difficulty:
Excel Pivot Charts
Excel Pivot Charts
A pivot chart in Excel is the visual representation of your pivot table.
Difficulty:
Excel Solver
Excel Solver
Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
Difficulty:
Excel What-If Analysis
Excel What-If Analysis
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
Difficulty:
Excel Sparklines
Excel Sparklines
Excel Sparklines are graphs that fit in one cell and give you information about the data.
Difficulty:
Total Tutorials in Category: 585