Saturday, March 7, 2020

LEARN BASIC EXCEL FOR NURSES


What is Excel? A beginner's overview
Excel is a software program from Microsoft that is part of the Microsoft Office suite of productivity software developed by Microsoft. Excel was originally code-named Odyssey during development at Microsoft, and it was first released on September 30, 1985.
Excel is capable of creating and editing spreadsheets that are saved with a .xls or .xlsx file extension. General uses of Excel include cell-based calculation, pivot tables, and various graphing tools. For instance, with an Excel spreadsheet, you could create a monthly budget, track business expenses, or sort and organize large amounts of data.


What is Excel used for?
Excel is typically used to organize data and perform financial analysis.  It is used across all business functions and at companies from small to large. The main uses of Excel include:Data entry, data management, accounting, financial analysis, charting and graphing, programming, time management, task management, financial modeling, customer relationship management (CRM) and almost anything that needs to be organized.


Why do people use excel?
This software can be used to store and organize many data sets. Using its features and formulas, you can also use the tool to make sense of your data. For example, you could use a spreadsheet to track data and automatically see sums averages and totals. Next best use of MS Excel is that it makes easy for you to solve complex mathematical problems in a much simpler way without much manual effort.


Intro to Excel! 
Below is an example of Microsoft Excel with each of its major sections highlighted. See the formula bar, cell, column, row, or sheet tab links for further information about each of these sections.

Microsoft Excel spreadsheet

How Excel Works?
An excel document is called a Workbook.  A workbook always has at least one Worksheet. Worksheets are the grid where you can store and calculate data. You can have many worksheets stored inside a workbook, each with a unique worksheet name.

What is a workbook?

Once Excel has started, you will see a workbook and several palettes containing commands.This workbook is divided into cells, boxes designed to hold one data entry each. Each cell can be referred to by a letter number address.

Image result for workbook in excel

Major Uses for Excel


1. Entering Data
Entering Data into a cell is easy. Just select the cell you want to start in with the mouse (A1 is fine), and type in your first data entry. When you have finished with the cell press enter (not return.) Notice that your typing is echoed in the console; you can edit the contents of a cell by selecting the cell and then correcting the entry in the console.

2. Excel Formulas
You can create simple and complex formulas in Excel to calculate just about anything.
Excel worksheet

3. Excel Charting

Excel offers a wide array of charts to visualize data.  They range from simple line graphs to bubble and radar charts.  Excel has two main tools for charting:  standard charts and pivot charts.

Excel Pivot Table and Pivot Chart

4. Excel vs Word Tables
A common question is when to use the table layouts in Word, and when to use Excel to present a list.  Both have important features appropriate for specific uses.  Even if you have a Word document where you want to display tabular information, the easiest path may be to embedd an Excel sheet within the Word document. 


Microsoft Excel shortcut key: 
This shortcut keys will helps you work effectively while working with text, numbers, and date information in a relatively open and unstructured way.

Image result for microsoft excel shortcut keys


How to Use Excel:

A Brief MS Excel Tutorial




Understanding Your Main Screen
When you first open Excel in Office 365 or a newer version of Microsoft Office, you’ll see a basic screen. Here are the key features in this view:



1. The spreadsheets
A spreadsheet is a special way of organizing data into rows and columns to make it simpler to read and manipulate. Here's a screenshot of a black spreadsheet.




2: Create a Workbook


A. Basic App Functions: From left to right along this top green banner you’ll find icons to: reopen the Create a Workbook page; save your work; undo the last action performed and display which actions were recorded; redo a step that’s been undone; select which tools appear below.
B. Ribbon:This grey area is called the Ribbon, and contains tools for entering, manipulating, and visualizing data. There are also tabs that focus on specific features. Home is selected by default; click on the Insert, Page Layout, Formulas, Data, Review, or View tab to reveal a set of tools unique to each tab. We’ll cover this more in the “Navigating the Ribbon” section later on.
C. Spreadsheet Work Area: By default the work area is a grid. Along the top are column headers A through Z (and beyond), and along the left side are numbered row headers. Each rectangle in the spreadsheet is called a cell, and they are each named according to their column letter and row number. For example, the cell selected here is A3.
D. Formula Bar: The Formula Bar displays the information contained within a highlighted single cell or range of cells. If in cell A1 you entered “1” as a value, “1” will appear in the Formula Bar. Plain text that you enter in a cell will also appear in the Formula Bar.
There are cases where what you see in the Formula Bar is different than what’s in the cell. For example, let’s say A1 = 1 and A2 = 2. If you create a formula in A3 that equals A1 + A2, then the A3 cell in your worksheet would show “3,” but the Formula Bar would show “=A1+A2.” This is important when you’re trying to move cells to other parts of your worksheet - remember that the display “value” of a cell isn’t necessarily what the cell contains.
E. Search Bar: Simply type the value you want to find to highlight all cells containing that value. It doesn’t have to be an exact match. For instance, if you searched for “o,” a cell labeled “Dogs” would appear among your search results.
F. Sheet Tabs: This is where the different sheets in your workbook can be found. Each sheet gets its own tab, which you can name yourself. These can be useful to separate out data so that one sheet doesn’t get too overwhelming. For example, you might have an annual budget, where each month is a column, and each row is a type of expense. Instead of keeping every single year you track on one sheet and scrolling horizontally, you can make each tab a different year containing 12 months only.
G. Viewability Options: The left icon is Normal which shows the worksheet as it appears in the image above, and the right icon is Page Layout, which divides your worksheet into pages resembling how it would look when printed, with the option to add headers. The slider with the “-” and “+” on it is for scale or zoom-level. Drag the slider left or right to zoom in or out.


3. Navigating the Ribbon

The Home tab is where you manage the formatting and appearance of your sheet, along with some simple formulas you’ll always need.

A. Copy and Paste Tools: Use these tools to quickly duplicate data and format styles in the spreadsheet.
B. Visual Formatting Tools:You can use the formatting tools to change the font, size, and color of typed words, and make them bold, italicized, or underlined. It also has a couple spreadsheet-specific formatting options. 
C. Position Formatting Tools: Align cell data to the top, bottom, or middle of the cell.
D. Multi-cell Formatting Features: This section contains two very important features that solve common problems for new Excel users. The first is Wrap Text,when you enter text into a cell that extends beyond the size of the cell, it spills into the next cell. Then the Merge and Center. There are instances when you may want to combine several cells and have them act as one long cell.
E. Numbers-based Format Settings: A drop-down menu has options for number formatting. Often, you may use these tools on entire columns to make all data in one category behave the same way.
F. Table or Sheet Formatting: Format as Table and Cell Styles allow you to use presets or customize tables (for example, with alternating row colors and highlighted header bars).
G. Row and Column Formatting Tools: The Insert drop-down menu puts cells, rows, or columns before or after a selected area on the sheet, and Delete removes them. The Format drop-down lets you change the height of rows and the width of columns. It also has options for hiding and unhiding certain sections.
H. Miscellaneous Tools:Allows you to select a swath of cells and place the sum in the cell located right below or directly to the right of the last selected data point. You can use the drop-down to change the function to calculate the average, display the maximum, minimum, or the count of numbers selected.

Use the Insert tab to add extra elements to your Excel workbook that go beyond text and colors.
 

A. These tools control PivotTables, an important Excel function. Think of PivotTables as “reports,” a quick way to view all your data, analyze trends, and draw conclusions.
B. This section lets you insert visual elements, like picture files, pre-built shapes, and SmartArt. They’re great for representing what the data says in another place on your workbook. 
C. These tools are for inserting elements from other Microsoft products, like Bing Maps, pre-built information cards about People (from Microsoft accounts only), and add-ins from their store.
D. Use these tools to create charts and graphs. Most of them work only if you select one or more data sets (numbers only, with words for headers or categories).
E. Sparklines are more simplistic graphs that can fit in as little as one cell. You can place them next to data for a small, quick visual representation.
F. Slicers are big lists of buttons that make your data more interactive. You can select a PivotTable you’ve created, and then create a slicer from it - this allows a viewer to click on buttons that correlate to the data they want to filter.
G. This hyperlink tool allows you to make a cell or table into a clickable link. Once a viewer clicks on the affected cell(s), they’ll be taken to whatever website or intranet site you select.
H. Recent versions of Excel allow for better collaboration, insert comments on any cell or range of cells to add more context.
I. A Text Box is useful when you’re creating a report and don’t want typed words to behave like cells. It makes it easy to move your text around, rather than cutting and pasting cells.
J. This section lets you insert Equations and Symbols.  Use equations to write a math equation with fractions, variables, and more that you can place in your sheet like a Text Box.



This tutorial video provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials.



Excel formula cheat sheet:
 Image result for Excel formula cheat sheet:



Uses of Microsoft Excel in Online access

MS Excel can be accessed online from anywhere and everywhere which means that you can access it from any device and from any location whenever you want. It provides the facility of working conveniently which means that if you don’t have laptops then you can use mobile and do your work easily without any problem.

Microsoft Excel for Nursing
Excel can also be used to keep track of medications, prescriptions and other health information.
Some doctors are providing patients with a spreadsheet to keep track of their health records. It’s a very helpful way to ensure that patients who have to take medications on a schedule can follow that plan.
This teaches Nursing professionals and Nursing support staff how to effectively use Microsoft Excel® for analyzing clinical, administrative and financial information. All exercises and examples have been developed by Nursing professionals using real-world scenarios and were created using data from hospitals, long term care facilities, clinics, rehabilitation centers, ambulatory surgical centers, home health organizations, behavioral health organizations, private practices, and other healthcare settings.



Saturday, February 22, 2020







What more we need to know about the COVID-19 ?


 OVERVIEW: Coronavirus-2019

                A new strain of coronavirus causing pneumonia-like symptoms was recently identified in Wuhan, China, marking the beginning of the spread of the virus across the globe. Coronaviruses (CoV), so named for their “crown-like” appearance, are a large family of viruses that spread from animals to humans and include diseases like Middle East Respiratory Syndrome (MERS) and Severe Acute Respiratory Syndrome (SARS). Researchers have now confirmed that the virus can spread via human-to-human transmission, though the original source of the virus has not been identified.    
‘’Stanley Perlman, M.D., Ph.D., an American Academy of Microbiology fellow, an ASM member and professor at the University of Iowa, talks about the outbreak of a novel coronavirus, COVID-19.’’ 


How is it different compare to other types of viruses?
            According to ‘’Stanley Perlman, M.D., Ph.D’’ the coronaviruses were studied primarily in domestic and companion animals, until the first outbreak (SARS) in 2003. They don’t know if this novel virus is different from SARS-CoV and MERS-CoV, it does seem to behave more like SARS-CoV but all 3 cause severe human respiratory disease and have higher rates of mortality than the influenza or other respiratory viruses.




When it became a global concern?

      In December, 2019, Wuhan, Hubei province, China, became the centre of an outbreak of pneumonia of unknown cause, which raised intense attention not only within China but internationally. Chinese health authorities did an immediate investigation to characterise and control the disease, including isolation of people suspected to have the disease, close monitoring of contacts, epidemiological and clinical data collection from patients, and development of diagnostic and treatment procedures. By Jan 7, 2020, Chinese scientists had isolated a novel coronavirus (CoV) from patients in Wuhan.


On the 30th January 2020,  the World Health Organization (WHO) of the United Nations declared the epidemic a public health emergency of international concern.

Official Timeline of COVID-19





COVID-19 UPDATE: 

DAILY GLOBAL SITUATION (DATA AS OF 21 FEBRUARY 2020)
Global
76,769 confirmed (1,021 new)

China
75,569 confirmed
(894 new)
Outside
China
1,200 confirmed
(127 new)









As of Febuary 22 the Global death toll rises to 2,458 as Hubei province in China reports more deaths!

Updated 11:09 p.m. ET, February 22, 2020

  • The global number of confirmed coronavirus cases now exceeds 78,572, with the vast majority of cases in mainland China.
  • There are 40,127 patients hospitalized in Hubei, including 1,845 who are in critical condition, according to the health authority, and 15,299 patients have been discharged.
  •  The Hubei report brings the total number of deaths in mainland China to at least 2,441. The global death toll is at least 2,458, with 17 deaths outside of mainland China.
  • Iran has reported five deaths from the coronavirus, while Japan has reported three deaths, and Hong Kong, Italy and South Korea reach reported two deaths.
  •  Taiwan, the Philippines, and France have each reported one death.




       UPDATES ON NOVEL CORONAVIRUS DISEASE 
(COVID-19)

     When did coronavirus reach the Philippines?
       The first case of novel coronavirus (2019-nCoV, now Covid-19) in the Philippines was confirmed on 30 January 2020, in a 38-year old woman who arrived from Wuhan. Two days later, the Philippines recorded the first death outside China on 01 February 2020.By 

As of Sunday, February 23, the DOH said it has probed 608 patients. There is still no recorded case of local transmission in the country.

Out of this number:
131 - admitted to hospitals
474 - discharged from hospitals
3 - confirmed cases

Of the 3 confirmed cases in the Philippines, one died due to severe pneumonia because of COVID-19, the disease caused by the new virus, while the other two have since recovered and are already out of the hospital.

-----------------------------------------------------------------------------------------


2019-nCoV infection cannot be distinguished clinically from other causes of pneumonia, an important differentiator is a history of close contact with a diagnosed case or history of recent travel (within 14 days) to an affected areas.


Most common complication is acute respiratory distress syndrome; other reported complications includes,

Septic shock
Acute kidney injury
Myocardial injury
Secondary bacterial and fungal infections
Multiorgan failure




What can you do to protect yourself?


PREVENTION is the KEY!!!

o   There is no vaccine against 2019-nCoV. Prevention depends on standard infection control measures.
o   Avoid close contact with people who are sick.
o   Frequent hand washing at least 20 seconds with soap and water after all contact and use alcohol-based hand sanitizer.
o    Avoid touching your eyes, nose, and mouth.
o   DO NOT!  share personal items such as towels, dishes, or utensils before proper cleaning.
o   A person who cares for a patient should wear face masks, gowns, and gloves then remove and discard all when leaving the room.


Responding to such epidemics requires not only an immense public health and medical response. We have to be aware of the challenge and concerns brought by 2019-nCoV to our community and insert effort to understand, prevent and control this disease to spread further. Extra precaution could be helpful. IT’S TIME TO ACT NOW!!!


LEARN BASIC EXCEL FOR NURSES What is Excel? A beginner's overview Excel is a software program from Microsoft that is part of th...