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: 2384
Created: 2017-09-24

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others Excel 2016 Tutorials

Microsoft Excel 2016 Tutorial

Microsoft Excel 2016 Course for Beginners

Quick guide to Microsoft Excel 2016

Excel 2016 Shortcuts

Excel 2016 PivotTables and PivotCharts

Others related eBooks about Microsoft Excel 2016 Academic Course

Publisher 2016 tutorial pdf

Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....

Office 365

Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....

Introduction to Microsoft Word 2013

This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....

Commonly Used Excel Functions

Here are some basic formulas that are easy to do and that can give some life to an Excel sheet!, download free PDF training document under 17 pages....

How to use formulas in Excel calculation

With this PDF tutorial you will learn how to use the Formulas in Excel to compile, claculate and manage data, free training document by OWL....

Basic Formulas in Excel

Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....

Formulas & Functions in Microsoft Excel

Download Formulas and Functions in Excel PDF tutorial, free training document by Theresa Scott....

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

Excel Fundamentals

Excel Fundamentals, it's a free PDF download about Microsoft Excel intended to beginners, document in 60 pages created by St. George’s Information Services....

Microsoft Excel Tips & Tricks

These are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....