How to Use Excel is a Series of Excel Tutorials designed with the absolute beginner in mind. These tutorials include step by step examples and will show you how to use Excel to produce a basic spreadsheet.
If you are looking for tutorials on how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how to do it. Each tutorial includes a step by step example on how to create a formula that will carry out one of the four basic math operations in Excel.
This tutorial covers the basics of how to enter datainto an Excel spreadsheet. Items such as the importance of planning your spreadsheet before you enter data, widening columns, the types of data that can be entered, and editing cells to change data, are covered in this tutorial.
Formulas, and functions are two of the most frequently used features in Excel. This tutorial covers using formulas and functions in more detail than the basic tutorial listed above. The tutorial includes step by step examples to show you how to create and use a variety of formulas and functions in Excel.
A graph, or a chart as it is known in Microsoft Excel, is a visual representation of worksheet data. A chart often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.
This list of step by step tutorials covers how to create the most commonly used charts in Excel - column chart (bar graph) pie chart, line graph, and even how to use the Sparklines - which are new to Excel 2010.
Use the print options in Excel to print entire spreadsheets or just selected areas. You can also choose to change the worksheet's orientation before you print or adjust the size of your printout so that it fits on one page.
Since adding rows and columns of numbers is one of the most common operations in Excel, Microsoft has included a shortcut to make the job easier. This step by step tutorial walks through how to use Excel's SUM function.
It’s a rare occasion when a spreadsheet doesn’t need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows.
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers the most commonly used date functions used in Excel.