Microsoft Excel 2016 Course for Beginners


This course is a practical Guide Excel 2016 Level 1 for Beginners in PDF to download for free. The purpose of this training is to identify the elements of the Excel window, to create and format a table, to use a few simple calculation formulas and to print a table.

Table of contents

  • Excel Basics
  • Opening/Closing the file
  • Saving the file
  • Installing the “Analysis ToolPak” for PC
  • Installing the “Analysis ToolPak” for Mac
  • Entering data into Excel
  • Simple cell formatting
  • Entering data into cells
  • Spreadsheet Organization
  • Subscripts and superscripts
  • Widening/condensing column widths
  • Merge and center
  • Wrapping Text
  • Cell type
  • Autofill with patterns
  • Sorting data
  • Using formulas and functions
  • Built-in Functions
  • Absolute and relative referencing
  • Data visualization
  • Inserting a scatter plot
  • Gridlines and border styles
  • Extracting tables and graphs
  • Regression Tool in the Analysis ToolPak for PC/Mac
  • Using the Analysis ToolPak for PC/Mac
File Size:
824.82 Kb
Submitted On:

Take advantage of this course called Microsoft Excel 2016 Course for Beginners to improve your Office skills and better understand Excel 2016.

This course is adapted to your level as well as all Excel 2016 pdf courses to better enrich your knowledge.

All you need to do is download the training document, open it and start learning Excel 2016 for free.

Download File

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.


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.


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 2016 PivotTables and PivotCharts

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


Excel 2016 Shortcuts

With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners.


Microsoft Excel 2016 Tutorial

Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages