Excel 2010 Basic Tutorial Pdf

This tutorial will cover data entry formatting formulas and f.

Excel 2010 basic tutorial pdf. Microsoft excel is a spreadsheet program. Insert a new worksheet. We use a gradebook as an example to help the user visualize how different functions can be used. Throughout the class we will progress from learning how to open microsoft excel to actually creating a spreadsheet.

Try grouping and ungrouping worksheets. If you want you can use this example. Microsoft excel is one of the most popular spreadsheet applications that helps you manage data create visually persuasive charts and thought provoking graphs. When launched excel sits in its own window the box that surrounds the application elements.

In this workshop we will learn how to move around and work inside the spreadsheet. Understanding the basic concepts of a spreadsheet including. Open an existing excel 2010 workbook. Try freezing and unfreezing columns and rows.

Introduction to the excel spreadsheet preparing a gradesheet learning outcomes this tutorial will help you understand what a spreadsheet is and where a spreadsheet might come in useful for classroom management. By default documents saved in excel 2010 are saved with the xlsx extension whereas. It is impossible in this amount of time to. Microsoft excel 2010 basics about this class this class is designed to give a basic introduction into microsoft excel 2010.

E window can be moved sized closed minimised and. Microsoft excel for beginners 20 hours this is a basic computer workshop. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them. Change the name of a worksheet.

Part i 10 the basics windows concepts excel is an application that runs under the windows graphical user interface. 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 excel is a spreadsheet tool capable of performing calculations analyzing data and integrating information from different programs.

Specifically you will learn about the following topics. The goal of these instructions is to familiarize the user with the basics of excel 2010.