PDFtutorial
Free courses and tutorials to download for free as PDF files
You are here : Home > Office > Excel > Excel Formula & Functions Quick Reference

Excel Formula & Functions Quick Reference in pdf

  • Formula & Functions Basics
  • Checking for formula
  • Building a formula to add
  • Autosum to add row or column totals
  • Building a formula to subtract
  • Building a formula to multiply or divide
  • Useful keyboard Shortcuts
  • Use insert function (formula builder) to make formulae easier
  • Autofill to copy formula to other cells
  • Relative cell references
  • Absolute references for common variables
  • Mixed cell references
  • Flash Fill (Excel 2013 & 2016 only)
  • To split the contents of a column into 2 columns
  • Colour all cells containing a formula (Excel 2013 only)
  • Recommended PivotTables (Excel 2013 and 2016)

Course, tutorial Summary Excel Formula & Functions Quick Reference

Course material to download for free on Excel Formula & Functions Quick Reference category Excel.
This course is intended for a strictly personal use, the file is of format pdf level Beginner , the size of this file is 251.55 KB.

The site also offers courses in Excel 2007, 2010, 2013, 2016, charts, PivotTables and PivotCharts, Formulas, Data and Statistics, Pivot Tables, VLOOKUP, and IF functions and many other tutorials. You have to come and see our Excel. You will find your happiness without problem!


Download the file

List of courses

Basic HTML elements: Quick Reference

This document is intended to be used in conjunction with Introduction to web page creation in XHTML (document web-t3) and can also be used as a quick reference guide - type of file pdf and size 49.54 KB, tutorial for level Beginner .

Excel 2013 Quick Start

Microsoft Excel 2013 looks different from previous versions, so we created this guide to help you minimize the learning curve. - type of file pdf and size 208.45 KB, tutorial for level Beginner .

Quick Guide for Excel 2013 Basics

Download free Quick Guide for Excel 2013 Basics course material and tutorial training, a PDF file by http://ipfw.edu/training. - type of file pdf and size 183.18 KB, tutorial for level Beginner .

Microsoft Excel 2016 Quick Start Guide

New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics. A PDF file by Microsoft - type of file pdf and size 251.31 KB, tutorial for level Beginner .

Formulas & Functions in Microsoft Excel

Download tutorial Formulas & Functions in Microsoft Excel, free PDF ebook by Department of Biostatistics Vanderbilt University. - type of file pdf and size 109.44 KB, tutorial for level Beginner .

Excel Functions Full List

Download Microsoft Excel Functions Full List, free PDF file by westernsydney.edu.au. - type of file pdf and size 136.09 KB, tutorial for level Beginner .

Categories

More downloads

Partner sites PDF Tutorials (English) | PDF Manuales (Spanish) | Cours PDF (French)