Sunday, March 8, 2020

Want to excel? Use Microsoft Excel!

750 million people!

Excel is used by an estimated 750 million people worldwide and Satya Nadella has proclaimed it as Microsoft’s most important consumer product.


What is Microsoft Excel?

Microsoft Excel is a spreadsheet program that is used to record and analyze numerical data. This application was launched by the Microsoft Corporation on 1985. Excel is a popular spreadsheet system, which organizes data in columns and rows that can be manipulated by formulas that allows the software to perform mathematical functions on data.

How does Microsoft Excel differ from the other Microsoft Application?

Although Microsoft Word, Microsoft Excel and Microsoft Access or even Microsoft Publisher share similarities, they are all suited for different objectives. Much of what one of the application does, the other can also do. However, Microsoft Excel is the most used spreadsheet program in many business activities, classwork and even personal data organization. It is excellent in crunching numbers and handling calculations and formulas. Excel also supports the creation of graphs from available data including data in eternal table.

Application of Microsoft Excel in Healthcare

Excel is a powerful tool for keeping track of patient appointments, scheduling doctors and organizing other information such as contact numbers or insurance data. 


EXCEL FOR NURSES!

Microsoft Excel for Nursing Professionals is a course that teaches Nursing Professionals and Nursing Support staffs how to effectively use Microsoft Excel for analyzing clinical, administrative and financial information. Excel can also be used to track medications, prescriptions, and other health information. Some doctors are providing patients with a spreadsheet to keep track of their health record.



Want to know how?
Before entering the world of Microsoft Excel, it is important to understand the basic components and functions of the application.



Active Cell: A cell which is currently selected. It will be highlighted by a rectangular box and address bar. You can activate cell by clicking on it or by using an arrow buttons. To edit a cell, you double-click on it or use F2 to as well.

Columns: A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identify, from A to XFD. You can select a column by clicking on its header.

Row: A row is a horizontal set of cells. A single worksheet contains 1048576 total rows. Every row has its own number starting from 1 to 1048576. You can select a row by clicking on the row number.

Fill Handle: It’s a small dot present on the lower right corner of the active cell. It helps you to fill numerical values, text series, insert ranges, insert serial numbers, etc.

Address Bar: It shows the address of the active cell. If you have selected more than one cell, then it will show the address of the first cell in the range.

Formular Bar: The formular Bar is an input bar below the ribbon. It shows the content of the active cell and you can also use it to enter a formula in a cell. 

Title Bar: The title bar will show the name of the work book followed by the application name Microsoft Excel.


File Menu: The file menu is a simple menu like all other applications. It contains options like Save, Save As, Open, New, Print, Excel Options, Share, etc.


Quick Access Toolbar: A toolbar to quickly access the options which you frequently use. You can add your favourite options by adding a new options to quick access toolbar.


Ribbon Tab: Ribbon Tabs are bunch of specific options group which further contains the option. 

Worksheet Tab: This tab shows all the worksheets which are present in the workbook. By default you will see, three worksheets in your workbook with the name of Sheet1, Sheet2, Sheet3 respectively.

Status Bar: It is a thin bar at the bottom of the Excel window. It will give you an instant help once you start working in Excel.