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

Excel 2016 Math with Dates and Times

Excel 2016 PivotTables and PivotCharts

Microsoft Excel 2016 Course for Beginners

Quick guide to Microsoft Excel 2016

Others related eBooks about Microsoft Excel 2016 Academic Course

Microsoft Excel 2007 : Essential Guide

The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....

Microsoft Excel 2007 Advanced - Tutorial

Download free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners....

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

Microsoft Word 2103 Step by Step

This PDF tutorial provides invaluable handson experience for who want to learn about new features in Word 2013 .It's a free and complet training document under 576 pages for download....

Microsoft Office 365

Download free course Microsoft Office 365, pdf file on 337 pages by Katherine Murray....

Quick guide to Word 2010

A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...

Beginning Microsoft® Excel®

This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and...

Advanced Microsoft Excel 2013

Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners....

PowerPoint 2010 Advanced

Download advanced tutorial in PDF about PowerPoint 2010, free course under 201 pages by Stephen Moffat....

Quick guide to PowerPoint 2010

This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....