My Wish Lists Login / Join

Master Excel

All about Formulas and Functions >

By: Thomas Clayton

Write A Review

Paperback | 1 May 2016

Sorry, we are not able to source the book you are looking for right now.

We did a search for other books with a similar title, however there were no matches. You can try selecting from a similar category, click on the author's name, or use the search box above to find your book.

FREE BONUS - Download Now!

Learn How to Use Microsoft Office Excel Step by Step!

#2 of the MASTER EXCEL series. Lesson three and four!

This collection has been conceived like a course and every manuscript like a lesson. By the end of this course you will be able to use Excel commanding this program like a real expert!

- Sorting and Filtering Data

Sorting: Naming cells, Naming rows and columns, Defining names, Creating names with the new name dialogue box, Managing named content, Creating column and row headings, Creating a table, Formatting tables, Creating a dropdown list, Text, Formatting Options, Custom
Filtering Data

- All about Formulas and Functions

To enter functions or formulas, To switch between relative cell references and absolute cell references, To quickly enter common functions, Conditional functions, Function to add and subtract units of time, Function to determine a running balance, Function to determine the average, mean, median and mode, Function to subtract, Function to multiply, Function to divide, Function to raise a number to the power of x, Function to find the biggest or smallest number in the range, The COUNTIF function, >Function won't calculate, Formula won't update

ENJOY!

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.