Complete MS Excel Guide : Formulas to Fromatting

Ingin mempelajari dasar-dasar MS Excel dengan cepat dan tepat? Gunakan aplikasi kami untuk menikmati belajarnya

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and 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 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.

Chapters-

Getting Started

Explore Window

Backstage

Entering Values

Move Around

Save Workbook

Create Worksheet

Copy Worksheet

Hiding Worksheet

Delete Worksheet

Close Workbook

Open Workbook

Context Help

Editing Worksheet

Insert Data

Select Data

Delete Data

Move Data

Rows & Columns

Copy & Paste

Find & Replace

Spell Check

Zoom In-Out

Special Symbols

Insert Comments

Add Text Box

Undo Changes

Formatting Cells

Setting Cell Type

Setting Fonts

Text Decoration

Rotate Cells

Setting Colors

Text Alignments

Merge & 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

Builtin 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

Excel- Translate Worksheet

Workbook Security

Data Tables

Pivot Tables

Simple Charts

Pivot Charts

Keyboard Shortcuts