Learn MS Excel Complete Guide (OFFLINE) 2.0.0

ABOUT Learn MS Excel Complete Guide (OFFLINE)

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 spreadsheet 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 computer 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 mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations. Microsoft Excel is a very versatile tool and can be used for almost anything that you can imagine: Agendas Budgets Calendars Cards Charts and Diagrams Financial Tools (Loan calculators etc.) Flyers Forms Inventories Invoices Lists and to-do checklists Planners Plans and proposals Reports Schedules Timesheets We combine a complete step by step guide to learn Microsoft Excel. From Formulas to Setting Margins From Setting Dependencies to Basic Operations in Excel Chapters Included are : MS Excel Basics Excel - Getting Started Excel - Explore Window Excel - Backstage Excel - Entering Values Excel - Move Around Excel - Save Workbook Excel - Create Worksheet Excel - Copy Worksheet Excel - Hiding Worksheet Excel - Delete Worksheet Excel - Close Workbook Excel - Open Workbook Excel - Context Help Editing Worksheet Excel - Insert Data Excel - Select Data Excel - Delete Data Excel - Move Data Excel - Rows & Columns Excel - Copy & Paste Excel - Find & Replace Excel - Spell Check Excel - Zoom In-Out Excel - Special Symbols Excel - Insert Comments Excel - Add Text Box Excel - Undo Changes Formatting Cells Excel - Setting Cell Type Excel - Setting Fonts Excel - Text Decoration Excel - Rotate Cells Excel - Setting Colors Excel - Text Alignments Excel - Merge & Wrap Excel - Borders and Shades Excel - Apply Formatting Formatting Worksheets Excel - Sheet Options Excel - Adjust Margins Excel - Page Orientation Excel - Header and Footer Excel - Insert Page Breaks Excel - Set Background Excel - Freeze Panes Excel - Conditional Format Working with Formula Excel - Creating Formulas Excel - Copying Formulas Excel - Formula Reference Excel - Using Functions Excel - Bultin Functions Advanced Operations Excel - Data Filtering Excel - Data Sorting Excel - Using Ranges Excel - Data Validation Excel - Using Styles Excel - Using Themes Excel - Using Templates Excel - Using Macros Excel - Adding Graphics Excel - Cross Referencing Excel - Printing Worksheets Excel - Email Workbooks Excel- Translate Worksheet Excel - Workbook Security Excel - Data Tables Excel - Pivot Tables Excel - Simple Charts Excel - Pivot Charts Excel - Keyboard Shortcuts