Udemy - Starting Out with Excel 2016
MP4 | Video: 1280x720 | 55 kbps | 44 KHz | Duration: 2 Hours | 171 MB
Genre: eLearning | Language: English
A guide to the basics of Microsoft Excel
Microsoft Excel 2016 for Windows is a very useful & powerful business software tool - it can be challenging if you have never used Excel before. In this course we introduce & cover the following topics
Step-by-step how to create a workbook
Creating new worksheets
How to, enter data
Format cells basic formulas & functions
Set types of cell referencing
Creating headers & footers
Printing & exporting files
This course will prepares your & gets you familiar familiar with all of the basic tools & develops your skills for setting up basic spreadsheets in Excel & 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 & 1 hour of content!
At the end of this course Students will have a basic underst&ing of creating simple Excel 2016 spreadsheets. Students will underst& the basic tools for working with & manipulating data to make decisions using excel tools, functions & formulas
At the end of this course students will be able use the Back stage view to create workbooks, manage their spreadsheet files & access template files.
At the end of this course students will be able to add labels, data & format information in their spreadsheet.
At the end of this course students will underst& the use of Relative, Absolute & Mixed Cell referencing.
At the end of this course students will underst& the use of Math & Excel functions & 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 & Bing map charts.
At the end of this course students will be able to add headers & 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 & the basic tools that are built into Excel 2016.