## How to Use Microsoft Excel Online MS Excel Tutorial shortcut keys Excel Formulas with Examples functions

**How to Use Microsoft Excel**- How to Use Excel is a

**Series of Excel Tutorials**designed with the beginner in user mind.

Entering Data in Excel Sheet tutorial all the basics of how to enter data into an Excel spreadsheet.

**Basic Calculations in Excel Spreadsheets**- How to do calculations in excel, In MS excel - User can enter simple formula calculations to multiply, add, subtract, divide two or more numeric values. we can enter a formula uses for sum functions (AutoSum) to total a series of values without having to enter any of them manually in a formula.

**MS Excel Tutorial - Microsoft Excel Formulas Beginners Tutorial**

**Formula in MS Excel**

### SUM

Formula: =SUM(2,2) or =SUM(C1,D1) or =SUM(C1:D4)

In Excel sum formula to add 2 or more numbers together.

### COUNT

Formula: =COUNT(C1:C5) -The Excel count formula counts the number of cells/rows in a range that have numbers.

### COUNTA

Formula: =COUNTA(A1:A10)

Counts the number of non-empty cells in a range. Excel count cells that have numbers and any other characters in them.

### LEN

Formula: =LEN(F1)

The LEN formula counts the number of characters in a cell. Be careful though!

### TRIM

Formula: =TRIM(D1)

Gets rid of any space in a cell, except for single spaces
between words. I’ve found this formula to be extremely useful because
I’ve often run into situations where you pull data f### RIGHT, LEFT, MID

Formulas: = RIGHT(text, number of characters), =LEFT(text, no of characters), =MID(text, start number, no of characters).

### VLOOKUP

Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

### IF Statements

Formula: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)

### SUMIF, COUNTIF, AVERAGEIF

Formulas: =SUMIF(range, criteria, sum_range), =COUNTIF(range, criteria), =AVERAGEIF(range, criteria, average_range)

### CONCATENATE

### More Excel Formulas

There is so much more that I use on a regular basis such as
Time formulas (NOW, TODAY, MONTH, YEAR, DAY, etc.), other formulas like
AND and OR, along with many others.

###
**MS Excel tips and tricks**

MS Excel Tips website is the place to find easy-to-use, Answers to your questions about Microsoft Excel.
The site contains thousands of articles and Excel tips, categorized across scores of
topic areas.

**What is a spreadsheet**

A spreadsheet is the computer of a ledger sheet.
It consists of a grid made from columns and rows.

**MS excel shortcut keys**

| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

Trying to do Strikethrough, Ctrl+5, in Excel Online using the Chrome browser does not work. The browser takes you to the 5th open tab.

ReplyDeleteIs there another way to do Strikethrough?