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 keys||Function / Action|
|Ctrl+N||To create a new worksheet|
|Ctrl+O||To open an existing worksheet|
|Ctrl+S||To save a worksheet|
|F1||To open the help pane|
|F2||To edit a cell|
|F3||Paste a cell name (if cells are named in the worksheet)|
|F4||To repeat the last command or action|
|F5||To a specific page|
|F7||To check spelling|
|F9||To calculate all worksheets in all open workbooks|
|F11||Create a bar chart based on selected data (on a separate sheet)|
|F12||To open the Save As dialog box|
|Ctrl+W||To close a worksheet|
|Ctrl+F4||To close Excel|
|Shift+F11||To insert a new worksheet|
|Ctrl+Z||To undo an action|
|Ctrl+Y||To redo an action|
|Ctrl+F2||Switch to Print Preview|
|Alt+Q||Go to the â€œTell me what you want to doâ€ box|
|Shift+F9||To calculate active worksheets|
|Alt or F10||Turn key tips on or off|
|Ctrl+F1||Show or hide the ribbon|
|Ctrl+Shift+U||Expand or collapse the formula bar|
|Ctrl+F9||Minimize the workbook window|
|Alt+F1||Create an embedded bar chart based on select data (same sheet)|
|Ctrl+F||Search in a spreadsheet, or use Find and Replace|
|Alt+F||Open the File tab menu|
|Alt+H||Go to the Home tab|
|Alt+N||Open the Insert tab|
|Alt+P||Go to the Page Layout tab|
|Alt+M||Go to the Formulas tab|
|Alt+A||Go to the Data tab|
|Alt+R||Go to the Review tab|
|Alt+W||Go to the View tab|
|Alt+X||Go to the Add-ins tab|
|Alt+Y||Go to the Help tab|
|Ctrl+Tab||Switch between open worksheets|
|Shift+F3||Insert a function|
|Alt+F8||Create, run, edit, or delete a macro|
|Alt+F11||Open the Microsoft Visual Basic For Applications Editor|
|Arrow Keys||Move one cell to the right, left, up or down|
|Tab||Move one cell to the right|
|Ctrl+Home||To beginning file|
|Ctrl+End||To end of typed information|
|Home||Beginning of a line|
|End||End of a line|
|Page Down||Down one screen|
|Page Up||Up one screen|
|Scroll bars||Appear 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 Arrow||To Extend the cell selection to the left or right|
|Shift+Space||To Select the entire row|
|Ctrl+Space||To Select the entire column|
|Ctrl+Shift+Space||To Select the entire worksheet|
|Shift+F2||Add or edit a cell comment|
|Esc||Cancel an entry in a cell or the formula bar|
|Enter||Complete an entry in a cell or the formula bar|
|Ctrl+9||Hide the selected rows|
|Ctrl+0||Hide the selected columns|
|Ctrl+1||Open the Format Cells dialog box|
|Ctrl+5||Apply or remove strike through|
|Ctrl+Shift+$||Apply currency format|
|Ctrl+Shift+%||Apply percent format|
|Ctrl+V or Shift+Insert||Paste 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
- 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
- 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.
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.
Excel formulas & functions with examples
=AVERAGEIF(A2:A10, D3, B2:B10)
|To find out how many cells in column C contain numbers|
|To count all non-empty cells in column C|
|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”)
|AND remarks TRUE if all conditions are met, FALSE otherwise|
=IF(AND(B2>50, B2>50), “Good”, “Bad”)
|OR remarks TRUE if any conditions are met, FALSE otherwise|
=IF(OR(B2>50, B2>50), “Good”, “Bad”)
=CONCATENATE(A2, ” “, B2)
Today’s Date & Time
|=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: