People have been using it for last 30 years and throughout these years, it has been upgraded with more and more features. Microsoft office access 2010a relational databaseis made up of groups of related data stored in individual tables. If you have questions about powerpoint 2007, please let your instructor know for more information on the library and programs, visit. Introduction to microsoft excel 2010 this handson course will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. Excel defaults to saving the active worksheet only.
Your professional instructor will talk you through excel 2010 s features, starting with the basics, from creating files to editing existing documents. Microsoft excel is one of the most powerful and widely. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. May, 2020 introduction to microsoft excel 2010 this handson course will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently.
The use of several of the most commonly used functions e. The new microsoft office 2010 ribbon changes the microsoft office button for a file tab. At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. If you are new to the ribbon interface or the backstage view, excel starter gives you an opportunity to get accustomed to the new interface before upgrading to excel 2010. Microsoft excel for beginners university of florida. Think of a spreadsheet as a collection of columns and rows that form a table. Another great addition is the excel is using the entire screen to view and access all the possible options. Microsoft powerpoint 2007 looks different, but works the exact same way. Tip you can also save a workbook as a pdf or xps document by clicking the.
The the name box tells you the namecoordinates of the cell selected. The worksheet is a grid of columns designated by letters and rows designated by numbers. Microsoft excel 2010 basics about this class this class is designed to give a basic introduction into microsoft excel 2010. Introduction to microsoft word 2010 nashua public library. Join researchgate to discover and stay uptodate with the latest research from leading experts in microsoft office excel and. Some user initially believed that it was just a decoration. If you have multiple worksheets and want to save all of them in the same pdf file, click options. During this introductory course on using microsoft excel 2010, well teach the basics of using microsoft excel 2010. In excel, worksheets are kind of like sheets of paper in a notebook with graph paper. Introduction to microsoft excel 2010 this class is designed to cover the following basics. Introduction to ms excel 2010 page 4 2011 centre for educational technology, university of cape town getting started with microsoft excel microsoft excel and microsoft word have a lot in common, since they both belong to the ms office suite of programs. Heggan free public library microsoft word is a program called a word processor word processor refers to a program in which the user inputs text which is formatted to create a readable document. Introduction to microsoft office 2010 syllabus page 5 of 6 120 modifying an excel worksheet. Microsoft excel is one of the most popular spreadsheet applications that helps you manage data, create visually persuasive charts, and thoughtprovoking graphs.
This class is designed to give a basic introduction into microsoft excel 2010. After you save the first time, you can c lick the save icon on the quick access toolbar. Essential fundamentals of excel 2010 page 9 of 19 introduction to cells and cell content cells are the basic building blocks of a worksheet. An introduction to microsoft word 2010 microsoft word is a word processing program similar but better than the antiquated word perfect or the microsoft works word processor. A cell is a container for data and each little rectangle you see in the worksheet is a cell. Each workbook you create is temporary unless you save it as a file with a unique name or location. Microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Use the name box to go to a cell, assign a name to. Microsoft excel 2010 product guide microsoft download center.
Microsoft excel can be used to organize, calculate, and analyze your data. Users can selectively combine pieces information from any or all of those tables through a process known as querying. The basics of microsoft excel vanderbilt university. The project plan file acts as a repository for all projectrelated information. Now excel will be in the start menu or on your desktop, respectively. Introduction to microsoft excel 2010 page 2 microsoft excel 2010 layout excel is a spreadsheet program that manipulates, graphs, and analyzes numeric data. Microsoft excel can also be used to balance a checkbook, create an expense report, build formulas, and edit them. Introduction to microsoft word 2010 microsoft word is a word processing program you can use to write letters, resumes, reports, and more. After reading this ebook you will be able to understand the differences between excel 2010 formulas and functions. For those of you who are upgrading to microsoft excel 2010 from an earlier version of the program, this introduction summarizes the new features in excel 2010.
A spreadsheet is the computer equivalent of a paper ledger sheet. Computer program used to enter, store, analyze, and present quantitative data. Excel 20 has some of the great features of excel 2010, but has expanded and improved upon some as well. In this introduction to microsoft excel training course, you gain the knowledge and skills to create and edit worksheets, use formulas and functions, sort and filter detail data visually and present summary information in a consumable and professional format. Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. Microsoft is now offering microsoft excel in an ondemand cloud service. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
More at this is the introduction to our full microsoft excel tutorial for beginners. Scroll to find microsoft office in program list and 4. Now that the picture of the chart is on your clipboard, you can paste it into a word document. Microsoft excel 2010 tutorial part 00 of 12 introduction. You can select a range of adjacent cells by clicking on the first one, and then dragging the mouse over the others. In this workshop we will learn how to move around and work inside the spreadsheet. This workshop will teach you the basic functions of excel.
Powerpoint is on the left and microsoft excel has just launched and appears to the right, with sample chart data displayed. Mar 18, 2020 microsoft excel is a spreadsheet program that is used to record and analyse numerical data. Unlike manual systems, your spreadsheet environment can become a responsive and dynamic work. Pdf ms excel advanced tutorial pdf free pdf download.
Introduction october 15, 2012 1 microsoft excel 2010 lesson 1. What you can do with excel excel ribbon moving and selecting cells formatting cells adding worksheets, rows and columns resizing rows and columns freezing panes formulas functions sorting charts autofill styles microsoft excel 2010. Excel has been around for a very long time since 1982. Excel 2010 makes it possible to analyze, manage, and share information in. Create and manipulate delivery methodworksheets and workbooks. Basic computer skills module 5 introduction to microsoft. Just like any other word processing program, you use ms word to view and edit formatted text within a document. Introduction to microsoft excel there are numbers of spreadsheet programs but from all of them, excel is most widely used. An introduction to microsoft word 2010 universalclass. Excel handout page 8 winter 2011 of the copy button. Emphasis will be placed on file naming and file management conventions.
It is used primarily to enter, edit, format, sort, perform mathematical computations, save, retrieve and print numeric data. If you want to learn about formulas, functions and formatting, download the first part of the excel 2010 introduction ebook. Select the number of the row to select an entire column. Excel 2010 printing when you want a hard copy of worksheet data, excel gives you many tools for choosing how that printout will look. Microsoft office 2010 improves the ribbon interface that was introduced in microsoft. Anything you can create with a typewriter, you can create with word. Microsoft project is a project management application that contains a set of tools to help managers plan, schedule, and control projects. Home microsoft excel online tutorial for beginners introduction to microsoft excel. Heggan free public library last revised 10192012 page 1 introduction to microsoft excel margaret e. Each tab relates to a type of activity, such as formatting or laying out a page. Excel 2010 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions.
You can do this by clicking on start, all programs, microsoft office and microsoft excel. Throughout the class, we will progress from learning how to open microsoft excel to. Excel organizes a data sheet by numbering the rows and lettering the columns. You can use excel to create business forms, such as invoices and purchase orders, among many other useful documents. Select entire workbook from the options dialog box, then click ok. Introduction to microsoft project 2010 this document provides an introduction in using microsoft project 2010. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future. Introduction to microsoft excel what is excel and how to. You can make your documents more appealing and easier to read by applying formatting to text. F2 edits the active cell and positions the insertion point at the end of the cell contents.
Microsoft excel 2010 excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. Home ribbon wrap text to fit text neatly in one cell merge and center multiple cells filter your data extra paste options when copying and pasting, you can choose different paste options, such as keeping column widths. Introduction microsoft excel is an electronic spreadsheet application. This handout corresponds to a premade excel workbook used during the class. Each value can have a predefined relationship to the other values. This data can be anything, but excel is most useful when managing quantitative, or. About the tutorial microsoft excel is a commercial spreadsheet application, written and distributed by microsoft for microsoft windows and mac os x. Data analysis and business modeling reference is a cell or range of cells from which the offset begins. We use it to create reports that need calculations and charts.
This allows for closer collaboration among colleagues and supports the move toward more remote work and increased mobility. If you specify a range of cells, the cells must be adjacent to each other. An introduction to microsoft excel 2007 spreadsheets. Microsoft excel starter 2010 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to do items. Learn to efficiently use excel at work and to get a job 25 videos excelisfun top 25 excel 2016 tips and tricks. Microsoft excel 2010 layout excel is a spreadsheet program that manipulates, graphs, and analyzes numeric data. Microsoft excel is the spreadsheet component of the microsoft office suite. Excel 2010 the introduction learn microsoft office at. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics. Introduction to microsoft excel 2010 microsoft excel.
Join researchgate to discover and stay uptodate with the latest research from leading experts in microsoft office excel. Data for powerpoint charts is actually entered in excel. Powerpoint 2010 i about the tutorial microsoft powerpoint is a commercial presentation application written and distributed by microsoft for microsoft windows and mac os x. These can range from simple formulas through to complex functions and mathematical models. Introduction microsoft excel is a spreadsheet program that enables us to organize and make calculations with large amounts of data. Throughout the class, we will progress from learning how to open microsoft excel to actually creating a spreadsheet. Excel starter 2010 is very similar to microsoft excel 2010 in appearance. You could query gws payroll database, which lists the salary of.
The point where a column and a row meet is called a cell. Cells can contain a variety of content such as text, formatting attributes, formulas, and functions. Introduction to microsoft excel 2010 free download as powerpoint presentation. It includes many powerful tools that can be used to organize and manipulate large amounts of. This means that if you are familiar with ms word, then you already know how to. Introduction to microsoft excel learn microsoft excel.
Commands are organized in logical groups, which are collected together under tabs. Excel is a great program to use for putting together budgets, lists for mail merges and other tasks that involve data. Each excel file is a workbook that can hold many worksheets. Free excel tutorial introduction to microsoft excel 2010. Microsoft excel is a spreadsheet program that is used to record and analyse numerical data. Introduction to microsoft word 2010 created 6 2010 3 word will automatically use the first line of the document as the f ile name. Introduction to spreadsheets excel 20 375 table 1 excel elements element description name box the name box is an identifier that displays the address of the current cell in the worksheet. By default, excel 2010 workbooks are saved in the excel workbook format which has the.
Excel starter is part of microsoft office starter 2010, and comes preloaded on your computer. An introduction to microsoft excel 2007 spreadsheets made easy. This is a free ebook for students sign up for free access download free textbooks as pdf or read online. Microsoft excel 2010 is a spreadsheet program that is used to manage, analyze, and present data. When you open excel, you will see something like this picture. Additionally, it gives professionals with an expert knowledge of the software the ability to work like freelance software developers if they choose. Introduction to microsoft excel 2010 utica public library. Heggan free public library microsoft excel is a spreadsheet program used for organizing and managing data. The ribbon the ribbon is designed to help you quickly find the commands that you need to complete a task. Introduction to microsoft excel 2016 screen elements the ribbon the ribbon is designed to help you quickly find the commands that you need to complete a task.
Excel starter 2010 is very similar to microsoft excel 2010 in. Smart tags, first introduced in microsoft office xp, make it easier for you to complete some of the. Basically, its a spreadsheet program used to store, organize, and analyze data. F1 displays the microsoft office excel help task pane. Today, we will be using microsoft powerpoint 2003 to explore the program. All the previous commands that were under the office button are now under the file tab. Office excel 2010 faces the same challenge that microsoft office word 2010 takes on. By default, documents saved in excel 2010 are saved with the. Powerpoint is on the left and microsoft excel has just launched and appears to the right, with.