Learn Excel Full Offline

Microsoft Excel中教程脱机内容68从基础到高级

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X.

This tutorial has been designed for computer users who want to learn Microsoft Excel with easy and simple steps. This will be very useful for learners who have no previous exposure to Microsoft applications.

This Tutorial Has 68 Contents :

>Ms Excel Basics<

Home

Getting Started

Explore Window

Backstage View

Entering Values

Move Around

Save Workbook

Create Worksheet

Copy Worksheet

Hiding Worksheet

Delete Worksheet

Close Workbook

Open Workbook

Context Help

>Editing Worksheet<

Insert Data

Selet Data

Delete Data

Move Data

Rows and Columns

Copy and Paste

Find and Replace

Spell Check

Special Symbols

Zoom In/Out

Insert Comments

Add Text Box

Undo Changes

>Formatting Cells<

Setting Cell Type

Setting Fonts

Text Decoration

Rotate Cells

Setting Colors

Text Alignments

Merge and Wrap

Borders and Shades

Apply Formatting

>Formatting Worksheets<

Sheet Options

Adjust Margins

Page Orientation

Header and Footer

Insert Page Breaks

Set Background

Freeze Panes

Conditional Format

>Working with Formula<

Creating Formulas

Copying Formulas

Formula Reference

Using Functions

Bult-in Functions

>Advanced Operations<

Data Filtering

Data Sorting

Using Ranges

Data Validation

Using Styles

Using Themes

Using Templates

Using Macros

Adding Graphics

Cross Referencing

Printing Worksheets

Email Workbooks

Translate Worksheet

Workbook Security

Data Tables

Pivot Tables

Simple Charts

Pivot Charts

Keyboard Shortcuts

Dont Forget Rating *****

Good Luck :)

Dont Forget Rating *****

Good Luck :)