Microsoft office excel 2010 tutorial for beginners pdf. In this workshop we will learn how to move around and work inside the spreadsheet. Get help organizing and calculating data in this excel 2010 tutorial. Word 2010 i about the tutorial microsoft office word 2010 allows you to create and edit personal and business documents such as letters reports invoices emails and books. The goal of these instructions is to familiarize the user with the basics of excel 2010.
We use a gradebook as an example to help the user visualize how different functions can be used. You can click one row or column and then drag to select additional columns or hold down ctrl as you click on the headers for noncontiguous rows andor columns. Microsoft excel is a spreadsheet program. P a g e 5 to select an entire column click the column header where the letter isthe cursor will be a vertical for columns or horizontal for rows black arrow.
In microsoft office 2007 there was something called the microsoft office button in the top left hand corner. Some commands such as import have been moved to the ribbon in excel 2010. In microsoft office 2010 this has been replaced with a tab in the ribbon called file when you left click on this tab a drop down menu appears. Excel 2010 is the spreadsheet application in the microsoft office 2010 suite.
Ese can range from simple formulae through to complex functions and mathematical models. By default documents saved in word 2010 are saved with the docx extension. Pdf version quick guide resources job search discussion. We use it to create reports that need calculations and charts.
At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Microsoft word can be used for the following purposes. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x. Microsoft excel 2013 for beginner download free microsoft office excel 2013 tutorial course material tutorial training pdf file on 25 pages.
How to use this guide is manual should be used as a point of reference following attendance of the introductory level excel 2010 training. Microsoft excel 2010 basic instructions for beginners. To select an entire row click the row header where the number is. When you click the file tab in excel 2010 you see the same basic commands that were available after you clicked the microsoft office button or the file menu in excel 2007.
Microsoft excel for beginners 20 hours this is a basic computer workshop. This tutorial will cover data entry formatting formulas and f. These basic commands include but are not limited to open save and print.