Tutorial On Microsoft Excel Pdf

Navigate to microsoft excel figure 2.

Tutorial on microsoft excel pdf. In this workshop we will learn how to move around and work inside the spreadsheet. In excelthe calculation can be specied using either a formula or a function. Microsoft excel is a spreadsheet program. Participant guide 7 8.

Also this application includes database and charting features. Click on the start button. Microsoft for microsoft windows and mac os x. Calculation graphing tools pivot tables and a macro programming language.

Click on microsoft excel. In either case all formulas and functions are entered in a cell and must begin with an equal sign. You can configure data validation to prevent users from entering data that is not valid. Opening microsoft excel to begin microsoft excel go to applications microsoft excel figure 1.

Excel is composed of rows and columns and uses a spreadsheet to display data. Figure 9 data validation data validation is an excel feature that you can use to define restrictions on what data can or should be entered in a cell. We use it to create reports that need calculations and charts. Microsoft excel is a powerful electronic spreadsheet program you can use to automate accounting work organize data and perform a wide variety tasksof excel is designed to perform calculations analyze information and visualize data in a spreadsheet.

The excel screen name box standard toolbar formula bar active cell menu bar title bar select all button status bar tab scrolling buttons sheet tabs worksheet scroll bars minimize buttons restore buttons close. Microsoft excel tutorial handout opening microsoft excel 1. This course aims to give students the basics of microsoft excel tips and trics. Microsoft excel is a spreadsheet application that is commonly used for a variety of uses.

When opened a dailouge box on the screen showing you a few templates and blank excell sheets figure 2 if this does not happen click file new workbook. Using the autofill handle drag the formula down to f10. Microsoft excel for beginners 20 hours this is a basic computer workshop. Formulas are self dened instructions for performing calculations.

Change for excel 2007 use the formatting tools on the home tab of the ribbon or for excel 2003 use the formatting icons on the toolbar. In contrast functions are pre dened formulas that come with excel. Select the range of cells columns or rows hover your. Microsoft excel is a spreadsheet tool capable of performing calculations analyzing data and integrating information from different programs.

Move column row or cells. At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Creating a new document 1. The beginners guide to microsoft excel this is a free excel pdf tutorial in 11 chapters and 23 pages.