Wednesday 11 December 2013

How to Use Microsoft Excel Online Tips MS Excel spreadsheet Tutorial shortcut keys Excel Formulas with Examples

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. 
ms excel shortcut keys pdf

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

Combining data in 2 (or more) different cells into one cell. This can be done with the Concatenate excel formula or it can be done by simply putting the & symbol in between the two cells.
  • 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
ShortcutDescription
F2Edit the selected cell
F3After a name has been created F3 will paste names.
F4Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
F5Go to a specific cell. For example, C6.
F7Spell check selected text or document.
F11Create chart from selected data.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Alt + Shift + F1Insert New worksheet
Alt + EnterWhile typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
Shift + F3Open the Excel formula window.
Shift + F5Bring up search box.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 1Change the format of selected cells.
Ctrl + 5strikethrough highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F3Open Excel MS Excel
Ctrl + F9minimize current window.
Ctrl + F10maximize currently selected window.
Ctrl + F6Switch between open workbooks or windows.
Ctrl + Page upMove between Excel work sheets in the same Excel document.
Ctrl + Page downMove between Excel work sheets in the same Excel document.
Ctrl + TabMove between Two or more open Excel files.
Alt + =Create a formula to sum all of the above cells
Ctrl + 'Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !Format number in comma format.
Ctrl + Shift + $Format number in currency format.
Ctrl + Shift + #Format number in date format.
Ctrl + Shift + %Format number in percentage format.
Ctrl + Shift + ^Format number in scientific format.
Ctrl + Shift + @Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + SpaceSelect entire column
Shift + SpaceSelect entire row
Ctrl + - Delete the slected column or row.
Ctrl + Shift + =Insert a new column or row.
Ctrl + HomeMove to cell A1.
Ctrl + ~Switch between showing Excel formulas or their values in cells.



1 comment:

  1. 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.
    Is there another way to do Strikethrough?

    ReplyDelete