Microsoft excel 2010 complete tutorial pdf. 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. P a g e 5 to select an entire column click the column header where the letter isthe cursor will be a vertical for columns or horizontal for rows black arrow. Pdf version quick guide resources job search discussion.
At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. You can find more microsoft office training including excel word and outlook video tutorials and. Mark dodge and craig stinson authors of microsoft office excel 2010 inside out recommend these as their favorite new features. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x.
Microsoft excel 2010 tutorial excel is a spreadsheet program in the microsoft office system. Use page layout view to see how your worksheet will be distributed between pages to switch quickly between portrait and landscape modes and to enter headers and footers directly on the worksheet. Microsoft excel tips tricks for the guru in you. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them.
M y o n l i n e t r a i n i n g h u b. Microsoft excel is available on both pcs and macs so what you learn in class today should be. How to use this guide is manual should be used as a point of reference following attendance of the introductory level excel 2010 training. You can click one row or column and then drag to select additional columns or hold down ctrl as you click on the headers for noncontiguous rows andor columns.
To complete feedback forms and to view our full schedule handouts and additional tutorials visit our website. 27032010 ddd dd mmm yyyy sat 27 mar 2010. 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. Ese can range from simple formulae through to complex functions and mathematical models.
Excel is supported by both mac and pc platforms. 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.