Subscribe
Tutorial search

Excel Basics Tutorials


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

Sort by:
Managing Projects with MS Project and Microsoft Excel
Managing Projects with MS Project and Microsoft Excel
Are you a project manager? If so, learning how to use Microsoft`s Excel and MS Project can be pivotal to your success.
Difficulty:
Excel Solver
Excel Solver
Excel has a clever and handy tool called solver that helps you find optimal solutions for many decision-based problems in your spreadsheets.
Difficulty:
How to Utilize an Action Item List in Excel
How to Utilize an Action Item List in Excel
Excel article on creating an action item list in Excel.
Difficulty:
Excel What-If Analysis
Excel What-If Analysis
This tutorial teaches you how to perform what-if analysis in Excel.
Difficulty:
Locking Specific Cells
Locking Specific Cells
Microsoft Excel allows you to restrict users’ ability to modify the contents of an entire workbook, a sheet, or particular cells.
Difficulty:
How to Find Data in Excel
How to Find Data in Excel
Finding data is very useful when you have to deal with a lot of data on a worksheet.
Difficulty:
How to insert cells in Excel
How to insert cells in Excel
When we work with spreadsheet sooner or later we will need to insert Cells into existing sheet.
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:
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 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 Tables
Excel Tables
Excel tables allow you to analyze your data in Excel very easily.
Difficulty:
Total Tutorials in Category: 131