Learn MS Excel Complete Guide (OFFLINE)

3 (0)

Education | 11.3MB

Description

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
This app has it all so Start Downloading..!

Show More Less

Information

Updated:

Version: 2.0.0

Requires: Android 4.1 or later

Rate

Share by

You May Also Like