Tutorial microsoft excel 2010 pdf. Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. Microsoft excel 2010 tutorial 7. Microsoft excel is a commercial spreadsheet application written and distributed by microsoft for microsoft windows and mac os x. In the ms word 2010 manual youll be able to find more information and guidance on.
At the time of writing this tutorial the microsoft excel version was 2010 for microsoft windows and 2011 for mac os x. Version and computer that youre using but microsoft excel will function in the same basic ways. Throughout the class we will progress from learning how to open microsoft excel to actually creating a spreadsheet. As part of your training we provide you with the following tools and resources to support and enhance your learning experience.
Microsoft excel tips tricks for the guru in you. 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. Microsoft excel 2010 basics about this class this class is designed to give a basic introduction into microsoft excel 2010. Microsoft excel 2010 tutorial excel is a spreadsheet program in the microsoft office system.
Using advanced functions and conditional formatting. 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. Your best stl learning tools welcome to your best stl training course. Specifically you can use excel to track data build.
Navigate to microsoft excel figure 2. Excel 2010 advanced microsoft application series. You can use excel to create and format workbooks a collection of spreadsheets in order to analyze data and make more informed business decisions. M y o n l i n e t r a i n i n g h u b.
Opening microsoft excel to begin microsoft excel go to applications microsoft excel figure 1. Creating a new document 1. This means that if you are familiar with ms word then you already know how to use several ms excel features. Thank you for choosing best stl.
Ese can range from simple formulae through to complex functions and mathematical models. You can find more microsoft office training including excel word and outlook video tutorials and. It is impossible in this amount of time to. 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.
Getting started figure 1.