Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Starting Out with Excel 2016 to your Wishlist.

Add to Wishlist

Starting Out with Excel 2016

A guide to the basics of Microsoft Excel
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
39 students enrolled
Created by Prof. Tom Duda
Last updated 7/2015
English
$10 $20 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
At the end of this course Students will have a basic understanding of creating simple Excel 2016 spreadsheets. Students will understand the basic tools for working with and manipulating data to make decisions using excel tools, functions and formulas
At the end of this course students will be able use the Back stage view to create workbooks, manage their spreadsheet files and access template files.
At the end of this course students will be able to add labels, data and format information in their spreadsheet.
At the end of this course students will understand the use of Relative, Absolute and Mixed Cell referencing.
At the end of this course students will understand the use of Math and Excel functions and will be able to use them in creating formulas in a spreadsheet.
At the end of this course students will be able to create basic pie charts, bar charts and Bing map charts.
At the end of this course students will be able to add headers and footers an Excel worksheet.
At the end of this course students will be able to print documents or save them as an Acrobat or XPS file format.
View Curriculum
Requirements
  • Students will need to have a copy of either Excel 2013, Excel 365, or Excel 2016 preview.
Description

Microsoft Excel 2016 for Windows is a very useful and powerful business software tool - it can be challenging if you have never used Excel before. In this course we introduce and cover the following topics

  1. Step-by-step how to create a workbook
  2. Creating new worksheets
  3. How to, enter data
  4. Format cells basic formulas and functions
  5. Set types of cell referencing
  6. Simple charting
  7. Creating headers and footers
  8. Printing and exporting files

This course will prepares your and gets you familiar familiar with all of the basic tools and develops your skills for setting up basic spreadsheets in Excel and started quickly in developing your own spreadsheets or using some of the predeveloped templates that are already available through Office 2016.

Who is the target audience?
  • This is an introductory course for students that are not familiar in using spreadsheets or not comfortable in using basic Excel formulas, functions and the basic tools that are built into Excel 2016.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 18 Lectures Collapse All 18 Lectures 01:04:20
+
Start Out with Excel 2016
18 Lectures 59:20

Welcome to my course and this is a course for people that are new to Excel 2016 or have very little experience using Excel. It covers all of the basics that you need to become a functional user of Microsoft Excel 2016. If you still have Excel 2013 the material covered in this course should also work with the previous version of the software. If you have questions along the way please post your questions in the discussion board.

Preview 01:54

In this lesson we cover the following topics.

1.Back Stage View
2.Creating a Blank Work Book
3.Templates
4.Info menu
5.Open-Save –Save As
6.Print-Share-Export
7.Account-Options=Close
Preview 05:28

This lessons covers the use of templates. We look at the many different types of templates and how to access the thousands of templates that are accessible form the Microsoft web site.

Preview 02:33

In this lesson we cover the following topics.

1.Labels
2.Data
3.Formatting Data
4.Freezing Cells Ranges
Entering and Formatting Labels and Data
06:31

The included challenge helps you learn and practice how to create a work sheet, and using templates.

Self Test 1 Using Worksheets and Templates
2 pages

In this lesson we cover the following topics.

1.Relative Reference
2.Absolute Reference
3.Mixed Reference
4.Referencing Cell Location
Preview 04:59

In this lesson we cover the following topics.

1.Adding a New Sheet
2.Naming a New sheet
3.Color coding Tabs
Creating a Worksheet
05:04

In this lesson we focus on the use of absolute cell referenceing.

Absolute & Mixed Referencing
04:11

In this lesson we cover the following topics.

1. Working with Math
2. Sum
3. Average
4. Min-Max
5. Count

Creating Basic Formulas
05:34

In this lesson we focus on the use of using common built Excel functions such as SUM, AVERAGE, MIN, MAX and other basic functions.

Functions
03:23

This self test allows you to practice how to use math, functions and cell referencing.

Self Test 2 Entering Data-Cell Referencing-Math and Fuctons
1 page

In this lesson we cover the following topics.

1. Text
2. Tables

Formatting Spreadsheets
03:40

In this lesson we focus on formatting spreadsheet using Themes and colors using the cell style formatting.

Themes and Table Formatting
05:52

In this lesson we cover the following topics.

1. Basic Pie Chart
2. Basic Bar Chart
3. Bing Map Chart

Creating Simple Charts
04:03

In this lesson we cover the following topics.

1. Page setup
2. Printing
3. Exporting as a PDF
4. Saving to Other File Formats


Printing & Exporting Files
03:41

This is a self test to test your skills of formatting a spreadsheet

Self Test 3 Formatting and creating a Simple Chart
1 page

Attached below is a completed version of the challenges.

Self Test 4 Adding Headers/Footers & Printing
1 page

In this lesson we cover the following topics.

1. Setting Headers
2. Setting Footers

Preview 02:27
About the Instructor
4.6 Average rating
8 Reviews
150 Students
2 Courses
Associate Professor Computer Science

30 years of business experience

Background in manufacturing, sales, and consulting

24 years as an Associate Professor of Computer Science focusing on programming, web design and development, and database management.

I have been an online instructor at the college level since 2001. My online courses include Intro to Programming with Visual Basic, Advanced Web Design. Advanced Visual Basic, and other computer related classes.

I have had great success in my college courses by providing students with short to the point videos on programming topics and techniques, followed by sample project videos that demonstrate the topic and requiring my students to complete programming challenges to learn and practice the skills that they have learned from the video presentations.

Report Abuse