How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
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 !
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.
Quick Access Toolbar
If you use an Excel command frequently you can add its icon to the Quick Access Toolbar.
Making a calendar in Excel is easy. Instead of creating your own calendar from scratch, you can create a calendar from a template.
Excel External References
An external reference (also called link) is a reference to a cell or range of cells in another Excel workbook.
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.
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.
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.
This tutorial teaches you how to conditionally sum a range using the Sumif function.
Excel Conditional Formatting
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
How to use a Scroll Bar in Excel
How to use a scroll bar in Excel to create a scrollable list. Great for dashboards.
Excel Pivot Charts
A pivot chart in Excel is the visual representation of your pivot table.
Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
Excel What-If Analysis
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
Excel Sparklines are graphs that fit in one cell and give you information about the data.
Total Tutorials in Category: 585