MS Excel 2016 for Beginners

Microsoft Excel 2016 for Beginners

By Fatimah Moore

Table of Contents

Introduction . . . . . . . . . . . . . . . . . .

Course Overview . . . . . . . . . . . . . .

Course Structure . . . . . . . . . . . . . .

Lesson 1 . . . . . . . . . . . . . . . . . . . . .

Navigate Excel User Interface . . .

Using Excel Commands . . . . . . . .

Create and Save a Workbook . . .

Enter Cell Data. . . . . . . . . . . . . . . .

Scenario Assessment . . . . . . . . . .

Table of Contents

Introduction . . . . . . . . . . . . . . . . . .

Course Overview . . . . . . . . . . . . . .

Course Structure . . . . . . . . . . . . . .

Lesson 1 . . . . . . . . . . . . . . . . . . . . .

Navigate Excel User Interface . . .

Using Excel Commands . . . . . . . .

Create and Save a Workbook . . .

Enter Cell Data. . . . . . . . . . . . . . . .

Scenario Assessment . . . . . . . . . .

04

06

08

10

12

14

16

13

Loading...

Introduction

Loading...

Welcome Students!

This Microsoft Excel 2016 is a Step-by-Step course designed for beginners. The objective is a gradual and methodical process to build upon those learned skills and apply the new tools on the job as well as for personal use. If for work, most organizations rely on complete information to make sound decisions in all matters of affairs. With the complex amount of available data that grows on a daily basis, one needs to make sense of it. The power of Microsoft Office Excel 2016 can help you in all matters of financial, personal, and work affairs.

Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you and or the decision-makers come to the best decisions. It will also make these tasks much easier for you to accomplish, and in much less time.

Finally, this course aims to provide you with a foundation for Excel knowledge and skills. With these new tools, you can build upon them to eventually become an expert in data manipulation.

Loading...

Back to Table of Content

Loading...

Introduction

Loading...

Welcome Students!

This Microsoft Excel 2016 is a Step-by-Step course designed for beginners. The objective is a gradual and methodical process to build upon those learned skills and apply the new tools on the job as well as for personal use. If for work, most organizations rely on complete information to make sound decisions in all matters of affairs. With the complex amount of available data that grows on a daily basis, one needs to make sense of it. The power of Microsoft Office Excel 2016 can help you in all matters of financial, personal, and work affairs.

Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you and or the decision-makers come to the best decisions. It will also make these tasks much easier for you to accomplish, and in much less time.

Finally, this course aims to provide you with a foundation for Excel knowledge and skills. With these new tools, you can build upon them to eventually become an expert in data manipulation.

Loading...

Next to Course Overview

Overview and Purpose

Overview and Purpose

Students should be familiar with using personal computers and comfortable working in the Windows 10 environment.
The student should feel comfortable navigating tasks comfortably including:

* Opening and closing applications
* Navigating basic file structures
* Managing files and folders

This course will present various
views on understanding the basic fundamentals of excel, including:

* PowerPoint presentations
* YouTube videos
* Articulate Storyline Presentations
* Rise 360 Assessments

Back to Table of Content

Overview and Purpose

This course is intended for students who wish to gain a foundational understanding of Microsoft Office Excel 2016.
It is also with the understanding that the student will be creating and working with electronic spreadsheets.

Click Next
Structure and Format

➊ Acrynous Course. This class is an asynchronous course. All instructions will be delivered through this portal.

➋ Office Hours. Office hours are Mon - Thur (1 to 3 pm) via the zoom link. If you require a special time please email me. I will do my best to accommodate.

➌ Contact via email. Please send an email with questions you may have. I should respond at my earliest convenience, usually within the same day. If you prefer to have your reply come to your personal email, please cc both your personal and school email.

➍ Group Collaboration. A Student Discussion Forum (SDF) will be available for students to interact with each other. This SDF is provided for you to ask questions, provide information, and collaborate with each other.
This SDF is different from the Discussion forum where you will be submitting assignments. This is also an opportunity for students to take advantage of a community of interacting with their fellow online students.

➎ Zoom Conference. There will also be a required zoom meeting with each student twice during the course. The date and time will be provided at a future date.

➏ Breakout Sessions. Teams are chosen to collaborate throughout the semester. These teams will work on scenario-based problems. Each student in each group will have a separate role in solving the scenario. Your online meetings will happen via zoom link. These exercises will be used in your final grade.

➐ Course Netiquette. Netiquette document

Return to TOC

Structure and Format

➊ Acrynous Course. This class is an asynchronous course. All instructions will be delivered through this portal.

➋ Office Hours. Office hours are Mon - Thur (1 to 3 pm) via the zoom link. If you require a special time please email me. I will do my best to accommodate.

➌ Contact via email. Please send an email with questions you may have. I should respond at my earliest convenience, usually within the same day. If you prefer to have your reply come to your personal email, please cc both your personal and school email.

➍ Group Collaboration. A Student Discussion Forum (SDF) will be available for students to interact with each other. This SDF is provided for you to ask questions, provide information, and collaborate with each other.
This SDF is different from the Discussion forum where you will be submitting assignments. This is also an opportunity for students to take advantage of a community of interacting with their fellow online students.

➎ Zoom Conference. There will also be a required zoom meeting with each student twice during the course. The date and time will be provided at a future date.

➏ Breakout Sessions. Teams are chosen to collaborate throughout the semester. These teams will work on scenario-based problems. Each student in each group will have a separate role in solving the scenario. Your online meetings will happen via zoom link. These exercises will be used in your final grade.

➐ Course Netiquette. Netiquette document

Structure and Format

Lesson 1

Lesson 1
Getting Started with Microsoft Office Excel 2016

Lesson Introduction

In order to take advantage of everything Excel has to offer, you must first understand the "lay of the land."

* How do you interact with Excel?
* What, exactly can it do?
* How do you get Excel to do these things for you?

It is precisely these types of questions this lesson aims to answer.

EXTENDED CAPTION You could add a video here by recording directly onto the page, uploading your own or embedding from YouTube.

Back to TOC

Click to view

Getting Started with Microsoft
Office Excel 2016