Microsoft Excel 2016 Academic Course

To work efficiently in Microsoft Excel, you need to become familiar with its primary user interface.

You can open Microsoft Excel 2016 in Windows 10 by moving to the lower-left corner of your screen, clicking on Start, clicking All apps, and then clicking Excel 2016.

Table of contents

  • Overview
  • Starting Excel create a workbook
  • Working in the Excel window customize the quick access toolbar
  • Changing workbook and window views
  • Change workbook views
  • Change window views
  • Working with an existing workbook
  • Working with Microsoft Excel 2016
  • Creating workbooks create a workbook
  • Saving workbooks save workbooks in alternative file formats
  • Inspect a workbook for compatibility issues.
  • Entering and editing basic data in a worksheet replace data
  • Adjust row height and column width.
  • Fill cells by using auto fill.
  • Insert and delete cells.
  • Using data types to populate a worksheet apply number formats
  • cutting, copying, and pasting data cut, copy, or paste data
  • editing a workbook’s properties
  • using office backstage
  • Printing with backstage set a print area.
  • Print all or part of a workbook
  • Set print scaling
  • Modify page setup
  • Changing the Excel environment customize the quick access toolbar
  • Accessing and using Excel templates create a workbook
  • Using basic formulas
  • Using functions
  • Perform calculations by using the sum function
  • Perform calculations by using the count function
  • Perform calculations by using the average function
  • Perform calculations by using the min and max functions
  • Formatting cells and ranges
  • Formatting worksheets
  • Managing Worksheets
  • Working with data and macros
  • Using advanced formulas
  • Working with rows and columns
  • Inserting headers and footers
  • Preparing a document for printing
  • Securing and sharing workbooks
  • Creating charts
  • Adding pictures and shapes to a worksheet
Size : 194.54 Kb
File type : pdf
Downloads: 2374
Created: 2017-09-24

Others Excel 2016 Tutorials

Excel 2016 Math with Dates and Times

Quick guide to Microsoft Excel 2016

Excel 2016 Shortcuts

Microsoft Excel 2016 Tutorial

Excel 2016 PivotTables and PivotCharts

Others related eBooks about Microsoft Excel 2016 Academic Course

Word 2013 Keyboard Shortcuts

Free Microsoft Word 2013 Keyboard Shortcuts in PDF for download ,a free training document under 20 pages to make Word easy to use and understand....

How to Create Professional Reports and Documents in Microsoft Word

This is a free Microsoft Word PDF tutorial in 10 chapters and 39 pages. This course aims to give students the basics of Microsoft Word concepts. ...

Excel 2016 Functions Tutorial

Download Excel 2016 Functions Tutorial, free PDF document intended to anyone wants to learn the basics of Excel functions....

Download Publisher 2016 PDF tutorial

Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners....

Advanced Word 2013

With this PDF tutorial you will be familiar with the basic functionality of Microsoft Word 2013 and you will learn how to write document with ease....

Microsoft Word 2013

Download courses Microsoft Word 2013 in PDF ,a free training document under 15 pages for beginners....

Office 365

Written for the IT professional and business owner, this book provides the business and te..., download free Office tutorial in PDF (680 pages) created by Don Crawford ....

Microsoft Excel 2016 Course for Beginners

Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....

How to Use Microsoft® Excel®

How to Use Microsoft® Excel® The Careers in Practice Series is an textbook appropriate for a course covering Microsoft Excel at a beginner to intermediate level. It is geared toward and will be accommodating for students and instructors with little to no experience in using Microsoft Excel...

Quick guide to Microsoft Excel 2016

Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....