Introduction of excel for the beginners – 2020
Share
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Introduction of excel for the beginners – 2020

Today we are going to discuss about Excel, Microsoft excel tutorial for the beginners – 2020, this topic on Introduction of Excel.

Excel a part of Microsoft Office suite software, is a popular spreadsheet, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data. Microsoft Excel is a spreadsheet developed by Microsoft Corporation in 1985, for Windows, macOS, Android and iOS used for calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.
Microsoft Excel has been around since 1982, first presented as Multiplan, an extremely famous CP/M (Control Program for Microcomputers), yet lost ubiquity on MS-DOS frameworks to Lotus 1-2-3. In 1987, Microsoft presented Excel v2.0 for Windows and by 1988 started to surpass Lotus 1-2-3 and the developing QuatroPro. In 1993, Microsoft discharged Excel v5.0 for Windows which included VBA (Visual Basic for Applications), otherwise known as Macros. This opened up practically boundless prospects in robotization of dreary errands for doing the math, process mechanization, and introducing information for organizations.
Exceed expectations 2016 has 484 capacities. Of these, 360 existed before Excel 2010. Microsoft groups these capacities in 14 classifications. Of the 484 current capacities, 386 might be called from VBA as techniques for the article “Worksheet Function” and 44 have indistinguishable names from VBA capacities.

Properties of excel worksheet:

Number of column = 16,384
Number of Raws = 1,048,576
Each cell in a worksheet can hold up to 32,767 characters

 

Shortcuts of excel:

At first we should find  some general keyboard shortcuts for manipulating worksheets, getting help, and a few other interface-related actions. It may assist you in increasing faster performance.

Shortcuts/ Short keys / Hot keysFunction / Action
Ctrl+NTo create a new worksheet
Ctrl+OTo open an existing worksheet
Ctrl+STo save a worksheet
F1To open the help pane
F2To edit a cell
F3Paste a cell name (if cells are named in the worksheet)
F4To repeat the last command or action
F5To a specific page
F7To check spelling
F9To calculate all worksheets in all open workbooks
F11Create a bar chart based on selected data (on a separate sheet)
F12To open the Save As dialog box
Ctrl+WTo close a worksheet
Ctrl+F4To close Excel
Shift+F11To insert a new worksheet
Ctrl+ZTo undo an action
Ctrl+YTo redo an action
Ctrl+F2Switch to Print Preview
Alt+QGo to the “Tell me what you want to do” box
Shift+F9To calculate active worksheets
Alt or F10Turn key tips on or off
Ctrl+F1Show or hide the ribbon
Ctrl+Shift+UExpand or collapse the formula bar
Ctrl+F9Minimize the workbook window
Alt+F1Create an embedded bar chart based on select data (same sheet)
Ctrl+FSearch in a spreadsheet, or use Find and Replace
Alt+FOpen the File tab menu
Alt+HGo to the Home tab
Alt+NOpen the Insert tab
Alt+PGo to the Page Layout tab
Alt+MGo to the Formulas tab
Alt+AGo to the Data tab
Alt+RGo to the Review tab
Alt+WGo to the View tab
Alt+XGo to the Add-ins tab
Alt+YGo to the Help tab
Ctrl+TabSwitch between open worksheets
Shift+F3Insert a function
Alt+F8Create, run, edit, or delete a macro
Alt+F11Open the Microsoft Visual Basic For Applications Editor
Arrow KeysMove one cell to the right, left, up or down
TabMove one cell to the right
Ctrl+HomeTo beginning file
Ctrl+EndTo end of typed information
HomeBeginning of a line
EndEnd of a line
Page DownDown one screen
Page UpUp one screen
Scroll barsAppear at the right and on the bottom of the screen. You may click the scroll arrows, drag the scroll box or click the scroll bar to move through the document.
Shift+Left/Right ArrowTo Extend the cell selection to the left or right
Shift+SpaceTo Select the entire row
Ctrl+SpaceTo Select the entire column
Ctrl+Shift+SpaceTo Select the entire worksheet
Shift+F2Add or edit a cell comment
Alt+H+D+CDelete column
EscCancel an entry in a cell or the formula bar
EnterComplete an entry in a cell or the formula bar
Ctrl+9Hide the selected rows
Ctrl+0Hide the selected columns
Ctrl+1Open the Format Cells dialog box
Ctrl+5Apply or remove strike through
Ctrl+Shift+$Apply currency format
Ctrl+Shift+%Apply percent format
Ctrl+V or Shift+InsertPaste contents of a cell, selected data, or selected cell range

 

Some Questions on Excel:

What is excel?

Excel definition / Excel meaning:

Excel is a software program developed by Microsoft corporation to organize numbers and data with formulas and functions.

You may check more here

What are the Functions of excel?

By using excel you can perform many tasks like: –

  • Task management
  • Customer relationship management (CRM)
  • Time management
  • Project management
  • Budget
  • Programming
  • Visual representation by chart like gantt chart, linear chart, pivot chart, etc and graphs.
  • Accounting and financial analysis.
  • Data entry and data management.
  • Monthly salary statement
  • Employee management
  • Payslip
  • memo making for products. etc.

At the first step of learning excel what should I do?

At the beginning you should learn to open excel sheet, then try to make a simple summation calculation and multiplication,  substruct, deviation etc. Then you should learn excel formulas. We’ll provide you all excel formulas with example. To learn excel clearly you should watch our videos on excel.

Excel Formulas

Today we are going to learn excel with excel meaning by this excel tutorial for the beginners where we shall gain knowledge about basic concept of excel at 2020.

Excel a part of Microsoft Office suite software, is a popular spreadsheet, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data. Microsoft Excel is a spreadsheet developed by Microsoft Corporation, for Windows, macOS, Android and iOS used for calculation.

In this tutorial looking is going to discuss about excel basics, how to use excel sheet, how to use conditional formatting excel, how to remove duplicates in excel, merge cells in excel, how to calculate standard deviation in excel, excel functions, excel sumif, excel vba, excel shortcuts, how to use excel what kind of tasks you can perform help with excel etc. By watching this video it will also help to learn excel for dummies.

You may ask for Microsoft excel free download but it’s not free to download. But you can buy some disk on it from your local market. You can download it from here.

DOWNLOAD MICROSOFT EXCEL 2020

 

 

 

Excel formulas & functions with examples

Excel basic formulas and functions with example
SLFORMULA TYPEFORMULA
1

SUM

=SUM(B2:B10)

=SUM (B2:H10)

2

AVERAGE

=AVERAGE(B2:B10)

=AVERAGEIF(A2:A10, D3, B2:B10)

3

MAX

=MAX(B2:B10)
4

MIN

=MIN(B2:B10)
5

COUNT

To find out how many cells in column C contain numbers

==COUNT(C:C)

6

COUNTA

To count all non-empty cells in column C

=COUNTA(C:C)

7

IF

IF formula ask Excel to test a certain condition and return one value or perform one calculation if the condition is met, and another value or calculation if the condition is not met.

=IF(D2<>””, “Yes”, “No”)

 

8

AND

AND remarks TRUE if all conditions are met, FALSE otherwise

=IF(AND(B2>50, B2>50), “Good”, “Bad”)

9

OR

OR remarks TRUE if any conditions are met, FALSE otherwise

=IF(OR(B2>50, B2>50), “Good”, “Bad”)

10

CONCATENATE

=CONCATENATE(A2, B2)

=CONCATENATE(A2, ” “, B2)

11

Today’s Date & Time

Today: =TODAY()

TIME: =NOW()

12

Date Breakdown

=WEEKDAY(D5, 1)
13

BETWEEN

=IF(AND(C2>=MIN(A2,B2),C2<=MAX(A2,B2)), “Yes”, “No”)

=IF(C7=MEDIAN(A7:C7), “Yes”, “No”)

 

 

To learn more about Introduction of excel:- Excel Tutorial for the beginners – basic concept – excel 2020 please watch the video.

INTRODUCTION OF EXCEL….. TO BE CONTINUED

 

Related Keywords for Introduction of excel:

Introduction of excel for the beginners – 2020, excel, google excel, Microsoft excel, excel online, vlookup excel, excel formulas, excel definition, excel spreadsheet, pivot table excel, download free excel, excel vlookup, excel drop down list, countif excel, excel pivot table, how to merge cells in excel, standard deviation excel, gantt chart excel, how to make a graph in excel,excel download, microsoft excel online, if function excel, how to use excel, free excel, excel templates, sumif excel, goal seek excel, amortization schedule excel, excel budget template, excel macros, excel tutorial, how to lock cells in excel, how to subtract in excel, can i download microsoft excel for free, excel if statement, how to remove duplicates in excel, conditional formatting excel, excel meaning, merge cells in excel, excel conditional formatting, how to calculate standard deviation in excel,
excel sheet, is there a free version of excel, how to multiply in excel, microsoft excel free, excel functions, excel sumif, excel vba,excel synonym, how to freeze a row in excel, how to make a line graph in excel, microsoft excel training, pmt function excel, excel shortcuts, excel solver, find duplicates in excel,how to sort in excel, how to combine cells in excel, microsoft excel download,

 

Excel Tutorial for the beginners – basic concept – excel 2020, Microsoft Corporation, excel, Microsoft Excel, excel basics, excel tutorial, conditional formatting excel, excel if statement, how to remove duplicates in excel, merge cells in excel, how to calculate standard deviation in excel, excel meaning, excel sheet, Microsoft excel free, excel functions, excel sumif, excel vba, excel shortcuts, how to use excel, help with excel, excel help, excel for dummies, learn excel, using excel, beginner’s excel, for the beginners, looking, ms excel, Windows, macOS, Android, iOS

 

#excel #microsoft #microsoftexcel #googleexcel #excelonline #lookingx #introduction-of-excel

You may also like this post:

Five Ingenious Ways You Can Do With Backlinks

HTML Tutorial For the beginners- 2020

Earn money – Earn $100 a day $3000 per month

Written by admin

This article has 2 comments

  1. William Robert Reply

    I think this is awesome post. Specially shortcut of excel is very important. Now I’m waiting for all the formulas. Please include all the formulas, I badly need this.

    Thanks.

  2. Preston Reply

    On the registered electors of this City of Buchanan, two (two ) seats for a four (4) year term to the town Commission will soon be voted on during the General Election,
    Tuesday November 3, 2020. In case you are interested in becoming
    a Buchanan City Commissioner, the last day to record Nominating Petitions at the City
    Clerk’s Office is Tuesday, July 2 1, 20 20 in 4:00 p.m.
    Nominating Petitions, that shall contain less than 6 or more than 20 signatures of qualified registered electors in the metropolis,
    are available by appointment at City Hall, 302 N Redbud Trail, Buchanan, MI.
    Speak to the Town Clerk at

Leave a Comment

Your email address will not be published. Required fields are marked *