Managing HealthCare Data
Microsoft Excel for Beginners
Understanding how to manage patient data
Understanding how to manage patient data
Loading...
Lesson ObjectivesLoading...
Getting Started with Microsoft Excel In this course you will:
Loading...
1. Navigate the Excel user interface2. Use Excel commands
3. Create and save a basic workbook
4. Enter cell data
5. Use Excel Help.
Loading...
Excel ElementsLoading...
Title Bar Displays the workbook file nameRibbon Provides you access to the most commonly used commands for
working with Excel workbooks and worksheets.
Formula Bar Displays the contents of the currently selected cell in a worksheet.
Column Identify each separate column with a unique letter of letter
Header combination.
Row Identify each separate row with a unique number.
Header
Cells The cell is where you enter data
New Sheet Is where you can add additional worksheets
Loading...
Spreadsheets, Worksheets, and Workbooks - OverviewLoading...
As we navigate this course think about the importance of data and healthcare for the future. Please click the following link: https://youtu.be/XrxXEIFtfoQ
Create and save a basic workbook
Please view the 3-minute video on steps to saving your excel workbook file.
https://www.youtube.com/watch?v=O5YJ4bn-5kY
https://www.youtube.com/watch?v=O5YJ4bn-5kY
Open Excel and Enter the information from the example below using column and row data only. This lesson will teach you the following:
1. Create and Save a Basic Workbook
2. Enter Cell Data
1. Create and Save a Basic Workbook
2. Enter Cell Data
Activity 1-2 - Using Excel Commands
Scenario
You are now familiar with the overall general layout of the Excel environment. You'd like to focus on discovering where some of the commonly used commands are. You decide to use screen tips to help you begin to identify some of the commands you've been wondering about. You also want to look over one or two of the dialog boxes to see what commands are available there.
1. Use screen tips to identify common commands.
a) Ensure the HOME tab is selected.
b) In the Font group, point the mouse pointer at several
of the commands to view their screen tips.
c) Do the same for several commands in each of the other groups.
2. Examine the commands in a dialog box.
a) Select the HOME tab.
b) In the Font group, select the dialog box launcher.
c) Verify that the Format Cells dialog box is opened.
3. Add data to a cell.
a) Select cell C12
b) Type And day after and press Enter
c) In cell C13, type Consider NY's Eve and press Enter
Scenario
You are now familiar with the overall general layout of the Excel environment. You'd like to focus on discovering where some of the commonly used commands are. You decide to use screen tips to help you begin to identify some of the commands you've been wondering about. You also want to look over one or two of the dialog boxes to see what commands are available there.
1. Use screen tips to identify common commands.
a) Ensure the HOME tab is selected.
b) In the Font group, point the mouse pointer at several
of the commands to view their screen tips.
c) Do the same for several commands in each of the other groups.
2. Examine the commands in a dialog box.
a) Select the HOME tab.
b) In the Font group, select the dialog box launcher.
c) Verify that the Format Cells dialog box is opened.
3. Add data to a cell.
a) Select cell C12
b) Type And day after and press Enter
c) In cell C13, type Consider NY's Eve and press Enter
Workbook
Worksheet
Spreadsheet