Skip to main content

Introduction

This section is for users with no knowledge of Excel.
Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.

1 Range: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

2 Formulas and Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

Comments

Post a Comment

Popular posts from this blog

Know about Excel Tables

23 things to know about Excel Tables by Dave Bruns | May 17, 2018 Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables. 1. Creating a table is fast You can create an Excel Table in less than 10 seconds. First, remove blank rows and make sure all columns have a unique name, then put the cursor anywhere in the data and use the keyboard shortcut Control + T. When you click OK, Excel will create the table. 2. Navigate directly to tables Like named ranges, tables will appear in the namebox dropdown menu. Just click the menu, and select the table. Excel will navigate to the table, even if it's on a different tab in a workbook. 3. Tables provide special shortcuts When you convert regular data to an Excel Table, almost every shortcut you know works better. For example, you can select rows with shift + space, and columns with control
Post a Comment
Read more

Microsoft Excel Keyboard Keys

You could learn here about MS excel basis and some advance sort keys. Formatting sort keys. CTRL+1                    Format Box ALT+E+S+T             Copy Format ALT+H+0                 Increase Decimal ALT+H+9                 Decrees Decimal  CTRL+SHIFT+7     Boxing ALT+O+C+A            Fit Column Width ALT+H+O+R            Change Sheet Tab Name ALT+W+F                (Un)Split Panes ALT+W+S                 (Un)Freeze Panes SHIFT+CTRL+#       Date format SHIFT+CTRL+S      $ Dollar format SHIT+CTRL+%       % Percentage format ALT+"="                   Sum function With CTRL Shortcuts. CTRL+A       Select All CTRL+B         Bold (only selected cell or range) CTRL+C         Copy(only selected cell or range) CTRL+D         Fill down(Select non blank cell or range) CTRL+E          Flash Fill CTRL+F          Find CTRL+G         Go To Special CTRL+H         Replace CTRL+I           Italic CTRL+K          Insert Hyperlink CTRL+L          Create Table C
1 comment
Read more

Why Learn Excel?

A nalysts, consultants, marketing professionals, bankers, and accountants all use Excel on a consistent basis. You might even find that other random professionals like graphic designers and engineers are working away with the powerful formulas and charts that come with Excel.   Seeing as how Excel is so prominent in the workforce, it pays to learn all about it and put that experience on your resume. You might find that your current degree isn’t yielding any job prospects, so getting into Excel could get you a job in the meantime. Developing your Excel skills using online resources could improve your employment prospects without the need to spend a lot of money on college courses. Learning Excel might even improve your job opportunities if you lack educational experience. People who didn’t go to college can get into coding, of course, but the same can be said about Microsoft Excel. Upon completing the right training, you automatically make yourself more valuabl
1 comment
Read more