Skip to main content

Posts

Showing posts from September, 2019

Why I started this Excel Blog?

Why I started this Excel Blog? Hello Friends… Currently, I am a working professional in MIS Field, where you can not survive without Excel knowledge. So, I always try to learn new Excel tricks which will help me in my profession. I observe something related to Excel needs in today’s era, so want to share with you. In today’s time, you can analyze that Excel becomes an essential and eternal part of   every organization like- Telecom, IT Firm, Finacial Firm, etc. Also, Excel is not limited to any specific department, it’s a part of every department like- HR, Administration, Sales, Reception etc. Every organization either its small business entity or the bigger, every organizations are using Excel according to their uses & perspectives. Also, It’s not only limited to organizations, even it becomes habitual in Colleges, Hospitals, Houses for project completion, daily expenses analysis, product analysis, etc. In short, Excel has become a part of our daily as well as pro

Microsoft Excel Basic Components

Microsoft Excel Basic Components:- Before starting any task, you should understand the function of all the instruments that will be used for that task accomplishment. Excel Components So, Before starting your journey to be an Excel expert, you should understand the importance and function of the major components, which are as follows- Row : A row is like a data series that laid out horizontally in a table or spreadsheet. In Excel, Every row has its own number for identity. Rows are labeled using numbers (eg- 1 to 1,048,576). Note: To highlight a row in Excel, move to a cell in the row you want to highlight and press & hold the Shift Key and press Spacebar. Column : A column is like a data series that laid out vertically in a table or spreadsheet. In Excel, Every column has its own alphabet for identity. Columns are labeled using alphabets (eg- A to XFD). Note: To highlight a column in Excel, move to a cell in the column you want to highlight and press

How to Start Microsoft Excel?

How to Start Microsoft Excel? Follow the below steps to start the Excel application in your PC/Laptop:- 1.       Click on Start Menu 2.       Click on “All Programs” option from Menu. 3.       Select the Microsoft Office Option from the Sub Menu and click it. 4.       Search for Microsoft Excel (which edition installed) from Sub Menu and click it. Now, the Microsoft Excel the application will be launched and the Excel window will be displayed on your PC/Laptop Screen. There are some alternate ways to open Excel, which are as follows- Alternate Method 1:- 1.       Click on Start Menu 2.       Open Search Bar & search for “Excel”. All programs related to your typed search item will be displayed. 3.       Click on Microsoft Excel (which edition installed). Alternate Method 2:- 1.       Right Click on Desktop 2.       Go to New option from Sub Menu and click it. 3.       Click on Microsoft Excel (which edition installed) from opened Sub M

What is Microsoft Excel & its uses?

Microsoft Excel is an electronic  spreadsheet program that is used for storing, organizing, computing and manipulating data. Microsoft Excel provides worksheets that are comprised of rows and columns. Like A Microsoft Word Table, you can store the data in a spreadsheet, but we can do a lot of functions and computations with the stored by using Excel functions and formulas. This is the utility of Excel that separates it from the Microsoft Word Table. Microsoft Excel is used to perform the calculation, analysis, and visualization of data and information.  In  Excel, Users can do various kinds of mathematical, financial, logical calculation, data manipulation, data analysis, and visualization of information in less time and efficient ways. It's used to create a network of text, numbers, and formulas performing calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and summarize the