Excel 2016 Functions Tutorial


This book covers the advanced features of Microsoft Excel 2016; It is intended for anyone who knows the basics of Excel and wants to go further by learning the advanced functions of this spreadsheet.

Table of contents

  • Function arguments
  • Required arguments
  • Optional arguments
  • Cell reference
  • Enter a function
  • In a cell or a formula bar
  • Formulas tab
  • Functions to format text
  • Upper,Lower,Proper,Trim,..
  • Calculating functions
  • Sum,Average,Min,Max,..
  • Copy and Past function
  • AutoFill a function
  • Copy and Past function value
  • Name a Cell
  • Round function
  • Count, CountA
  • Convert, Substitute
  • Concatenate




File Size:
781.41 Kb
Submitted On:

Take advantage of this course called Excel 2016 Functions Tutorial to improve your Office skills and better understand Excel Functions.

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

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

Download File

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.


Microsoft Excel 2013

Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners.


Excel 2016 Math with Dates and Times

With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners.


Pivot Tables in Microsoft Excel

The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners.