Excel basic training pdf. In this workshop we will learn how to move around and work inside the spreadsheet. The purpose of this training is to identify the elements of the excel window to create and format a table to use a few simple calculation formulas and to print a table. To reference a cell use the column and the row name. Also this application includes database and charting features.
Throughout the class we will progress from learning how to open microsoft excel to actually creating a spreadsheet. The boxes are the intersection of columns a b c etc and rows 1 2 3 etc. Specifically you will learn about the following topics. It is impossible in this amount of time to.
Microsoft excel 2016 course for beginners this course is a practical guide excel 2016 level 1 for beginners in pdf to download for free. View options if your workbook contains a lot of content it can sometimes be difficult to compare different sections. Excel is supported by both mac and pc platforms. We use it to create reports that need calculations and charts.
For example you can choose to open a new window for your workbook or split a worksheet into separate panes. 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. For example the cell in the first column and first row is called a1. 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.
Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them. Microsoft excel 2010 basics about this class this class is designed to give a basic introduction into microsoft excel 2010. 90475 kb downloads. Microsoft excel is a spreadsheet program.
Microsoft excel 2013 download free microsoft excel 2013 tutorial a pdf training file under 12 pages for beginners. Understanding the basic concepts of a spreadsheet including. Excel training level 2 page 7 12.