Excel 2010 Tutorial Pdf

If you dont see the excel icon on your desktop youll.

Excel 2010 tutorial pdf. Excel is supported by both mac and pc platforms. Tabs at the bottom of the screen identify the different worksheets available to you ill show you a little later how to give them meaningful names. How to use this guide is manual should be used as a point of reference following attendance of the introductory level excel 2010 training. Throughout the class we will progress from learning how to open microsoft excel to actually creating a spreadsheet.

Ese can range from simple formulae through to complex functions and mathematical models. At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Microsoft excel 2010 tutorial excel is a spreadsheet program in the microsoft office system. Excel 2010 tutorial 7.

To open the program point to excels icon on the desktop with your mouse and double click on it with the left mouse button. Xp new perspectives on microsoft excel 2010 2 objectives use the if function use the and function use the or function use structured references in formulas nest the if function. Nomas training consultancy ltd excel 2010 analysing data using formulae pivot tables page 2 moving around your spreadsheet a spreadsheet is made up of a matrix of columns and rows into which text dates and numbers can be entered. It is impossible in this amount of time to.

To get started with microsoft excel often called excel you will need to locate and open the program on your computer. Using advanced functions and conditional formatting. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x. Microsoft excel is one of the most popular spreadsheet applications that helps you manage data create visually persuasive charts and thought provoking graphs.

Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them. Specifically you can use excel to track data build.

You can use excel to create and format workbooks a collection of spreadsheets in order to analyze data and make more informed business decisions. Introduction to ms excel 2010 page 5 2011 centre for educational technology university of cape town in the excel 2010 window the title bar displays the name of your current workbook.