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

Excel 2016 PivotTables and PivotCharts

Microsoft Excel 2016 Course for Beginners

Excel 2016 Math with Dates and Times

Quick guide to Microsoft Excel 2016

Excel 2016 Shortcuts

Others related eBooks about Microsoft Excel 2016 Academic Course

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

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

Excel Basics: Microsoft Office 2013

This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....

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 2013 Tutorial

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages intended to beginners....

Microsoft Word 2013

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

Guide PowerPoint 2013

Guide of Microsoft Powerpoint 2013 in PDF a quick references card to learn the basics of PowerPoint,a free tutorial for download and training document under 2 pages designated to begginers....

Introduction to Microsoft Publisher

Download Introduction to Microsoft Publisher in PDF, free training document about how to create a perform basic tasks and creating business and greeting card....

Tutorial Access 2016 in PDF

Download free Tutorial in PDF about Microsoft Access 2016 (course, exams and exercises), a complet training document course on 322 pages for beginners by MARY LEMONS....

Microsoft Excel 2016 Course for Beginners

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