Udemy – Starting Out with Excel 2016

A guide to the basics of Microsoft Excel

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

Step-by-step how to create a workbook
Creating new worksheets
How to, enter data
Format cells basic formulas and functions
Set types of cell referencing
Simple charting
Creating headers and footers
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?

Over 18 lectures and 1 hour of content!
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.