Excel 2016 Functions Tutorial

Description:

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
Downloads:
195
Submitted On:
2018-04-02



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.

Download

Microsoft Excel 2013

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

Download

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.

Download

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.

Download