Master Excel: All About Formulas and Functions - Paperback

by Thomas Clayton (Author)

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!