1、i About the Tutorial Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X. Microsoft Excel is a spreadshe
2、et tool capable of performing calculations, analyzing data and integrating information from different programs. By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls. Audience This tutorial has been designed for c
3、omputer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications. Prerequisites Before proceeding with this tutorial, you should have a basic understanding of Computer peripherals like
4、 mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations. Copyright & Disclaimer Copyright 2017 by Tutorials Point (I) Pvt. Ltd. All the content and graphics published in this e-book are the property of Tutoria
5、ls Point (I) Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republish any contents or a part of contents of this e-book in any manner without written consent of the publisher. We strive to update the contents of our website and tutorials as timely and as precis
6、ely as possible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt. Ltd. provides no guarantee regarding the accuracy, timeliness or completeness of our website or its contents including this tutorial. If you discover any errors on our website or in this tutorial, ple
7、ase notify us at ii Table of Contents About the Tutorial . i Audience . i Prerequisites . i Copyright & Disclaimer . i Table of Contents . ii 1. EXCEL GETTING STARTED . 1 2. EXCEL EXPLORE WINDOW . 4 File Tab . 4 Quick Access Toolbar . 4 Ribbon . 5 Title Bar . 5 Help . 5 Zoom Control . 5 View Button
8、s . 5 Sheet Area . 6 Row Bar . 6 Column Bar . 6 Status Bar . 6 Dialog Box Launcher . 6 3. EXCEL BACKSTAGE . 7 Sheet Information . 9 Sheet Properties . 9 Exit Backstage View . 10 iii 4. EXCEL ENTERING VALUES . 11 5. EXCEL MOVE AROUND . 13 Moving with Mouse. 14 Moving with Scroll Bars . 15 Moving with
9、 Keyboard . 16 Moving with Go To Command . 17 6. EXCEL SAVE WORKBOOK . 18 Saving New Sheet . 18 Saving New Changes . 19 7. EXCEL CREATE WORKSHEET . 21 Creating New Worksheet . 21 8. EXCEL COPY WORKSHEET . 23 Copy Worksheet . 23 9. EXCEL HIDING WORKSHEET . 28 Hiding Worksheet . 28 Unhiding Worksheet
10、. 28 10. EXCEL DELETE WORKSHEET . 30 Delete Worksheet. 30 11. EXCEL CLOSE WORKBOOK . 32 Close Workbook . 32 12. EXCEL OPEN WORKBOOK . 34 13. EXCEL CONTEXT HELP . 36 iv 14. EXCEL INSERT DATA . 38 Inserting Data . 38 Inserting Formula . 38 Modifying Cell Content . 39 15. EXCEL SELECT DATA . 41 Select
11、with Mouse . 41 Select with Special . 41 16. EXCEL DELETE DATA . 44 Delete with Mouse . 44 Delete with Delete Key . 44 Selective Delete for Rows . 45 17. EXCEL MOVE DATA . 46 18. EXCEL ROWS AND COLUMNS . 48 Row and Column Basics . 48 Navigation with Rows and Columns . 48 Cell Introduction . 49 19. E
12、XCEL COPY AND PASTE . 50 Copy Paste . 50 Copy Paste using Office Clipboard . 50 Copy Paste in Special way . 51 20. EXCEL FIND AND REPLACE . 54 Find and Replace Dialogue. 54 Exploring Options . 56 v 21. EXCEL SPELL CHECK . 57 Spell Check Basis . 57 Exploring Options . 58 22. EXCEL ZOOM IN/OUT . 59 Zo
13、om Slider . 59 Zoom In . 59 Zoom Out . 60 23. EXCEL SPECIAL SYMBOLS . 61 Using Symbols . 61 Using Special Characters . 62 24. EXCEL INSERT COMMENTS . 63 Adding Comment to Cell . 63 Modifying Comment . 64 Formatting Comment . 65 25. EXCEL ADD TEXT BOX . 66 Text Boxes . 66 Adding Text Boxes . 66 Formatting Text Box . 67 26. EXCEL UNDO CHANGES . 68 Undo Changes . 68 Redo Changes . 69 27. EXCEL SETTING CELL TYPE . 70 Formatting Cell . 70 Various Cell Formats .
