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
$19
$20
5% off
Take This Course
  • Lectures 18
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course 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.

What are the requirements?

  • Students will need to have a copy of either Excel 2013, Excel 365, or Excel 2016 preview.

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Start Out with Excel 2016
01:54

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.

05:28

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
02:33

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.

06:31

In this lesson we cover the following topics.

1.Labels
2.Data
3.Formatting Data
4.Freezing Cells Ranges
2 pages

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

04:59

In this lesson we cover the following topics.

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

In this lesson we cover the following topics.

1.Adding a New Sheet
2.Naming a New sheet
3.Color coding Tabs
04:11

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

05:34

In this lesson we cover the following topics.

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

03:23

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

1 page

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

03:40

In this lesson we cover the following topics.

1. Text
2. Tables

05:52

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

04:03

In this lesson we cover the following topics.

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

03:41

In this lesson we cover the following topics.

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


1 page

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

1 page

Attached below is a completed version of the challenges.

02:27

In this lesson we cover the following topics.

1. Setting Headers
2. Setting Footers

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Prof. Tom Duda, 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.

Ready to start learning?
Take This Course