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

Others Excel 2016 Tutorials

Excel 2016 Shortcuts

Excel 2016 PivotTables and PivotCharts

Excel 2016 Math with Dates and Times

Microsoft Excel 2016 Tutorial

Microsoft Excel 2016 Course for Beginners

Others related eBooks about Microsoft Excel 2016 Academic Course

PowerPoint Presentation

This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....

Basic Excel Skills

This course is not intended to serve as a beginner's tutorial on Excel. Those who are new to Excel and who need a tutorial should work through abook or a CD, or take an online course....

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

Excel 2016 PivotTables and PivotCharts

Learn how to use PivotTable and PivotCharts in Microsoft Excel 2016, free training document for download....

Basic Formulas in Excel

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

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

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

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

Microsoft Word 2016 free tutorial

Download free Microsoft Word 2016 course material and training (PDF file 214 pages)...

Excel 2016 Functions Tutorial

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