Course Overview
Course Overview
Embedded Files
In this self-paced online course, participants will explore the basic features of Microsoft Excel. Professional learning topics for this session include worksheet basics, cell basics, formatting cells, saving, simple formulas, and modifying columns, rows, and cells.
All FWISD educators are welcome to attend this beginner-level session.
Level: Beginner
FLEX ELECTIVE CREDIT: 1
CPE CREDIT: 1
Please note that there may be some practice steps included below. These are not required to receive credit for this course. Credit is granted to participants who score a minimum of 80% on the Course Assessment.
Please note that there may be some practice steps included below. These are not required to receive credit for this course. Credit is granted to participants who score a minimum of 80% on the Course Assessment.
Course Objectives
Course Objectives
By the end of this course, you will be able to...
By the end of this course, you will be able to...
access Excel through FWISD LaunchPad Office 365.
define key parts of an Excel Workbook.
enter data into a cell and manipulate the cell.
apply the sum and average formulas.
Guiding Questions
Guiding Questions
How do you access Excel through the Office365 application?
What is the difference between a Workbook and a Worksheet?
What is the difference between a column and a row?
How do you start an equation in the cell?
Watch the video to learn how to access Excel through the Office365 application.
Watch the video to learn how to create a workbook and to learn more about some of the basic terms used in this course.
Create your own workbook.
Rename your workbook
Explore the tabs and groups of buttons in your ribbon
Read the instructions for how to resize columns and rows.
Practice in your workbook:
Enter data in some of your cells.
Resize a column.
Resize a row.
How to Change the Column Width or Row Height
How to Change the Column Width or Row Height
To Resize Rows:
Select a row or group of rows.
On the Home tab, in the Cells group, select Format>Row Height.
Type the Row Height and select OK.
You may also choose to AutoFit Row Height, which will automatically adjust the row height of the selected cells to fit the contents within.
To Resize Columns:
Select a column or range of columns.
On the Home tab, in the Cells group, select Format>Column width.
Type the Column Width and select OK.
You may also choose to AutoFit Column Width, which will automatically adjust the column width of the selected cells to fit the contents within.
To watch a video of this process, click the link: Microsoft Excel: Resizing Columns & Rows
To learn more about formatting cells, go to Microsoft's Excel Help & Training site.
Watch the video to learn more about how to format your cells.
Practice in your workbook:
Change the border on your cells.
Change the fill color on your cells.
Merge cells.
Change the text wrapping on your cells.
Watch the video to learn how to use the filter, sort, and find functions in Excel.
Practice in your workbook:
Add a filter, and use it to limit the data you see.
Sort your data.
Use the find function to find a particular word.
Use the replace function to change that word.
Complete the tutorials to learn how to freeze cells and use basic formulas.
Practice in your workbook:
Freeze the first column in your workbook.
Use the sum formula.
Use the average formula.
See all the steps for this tutorial in one stream by clicking HERE.
To learn more about freezing cells and basic Excel formulas, watch this video.
Watch the video to learn how to access the workbooks you have created and share them with collaborators.
You must answer all questions correctly and receive a score of at least 80% to receive credit for this course.
👉You may retake the assessment as many times as you need in order to score 80%👈
NOTE:
You must be logged into your FWISD Google Account in order to take this assessment. In another browser window, navigate to www.fwisd.org/myfwisd and log in. If you have not used your FWISD Google Drive before, you must click on Google Drive within your MyFWISD portal in order to activate your FWISD Google connection. Once you have initiated that connection, you will be able to return to this page and click on the image above to take the assessment.
Before taking the assessment, can you answer these guiding questions?
Before taking the assessment, can you answer these guiding questions?
How do you access Excel through the Office365 application?
What is the difference between a Workbook and a Worksheet?
What is the difference between a column and a row?
How do you start an equation in the cell?
Page updated
Report abuse