Master Excel: All About Formulas and Functions << Book 2 | Lesson 3 - 4 >>: Volume 2 - Softcover

Clayton, Thomas

Softcover

ISBN 10: 1533001715 ISBN 13: 9781533001719

Publisher: CreateSpace Independent Publishing Platform, 2016

Synopsis

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!

About this title

About the Author

Thomas Clayton is Associate Professor of English and Linguistics at the University of Kentucky, U.S.A., where he teaches classes in applied linguistics and directs the Master of Arts in English with a Concentration in Teaching English as a Second Language Program. Professor Clayton has published more than two dozen articles on language and educational policy issues, often in the Cambodian context, in books and journals. In 1991, Clayton established the first U.S. university educational program in postwar Cambodia, the English Language Teaching Center for the State University of New York at Buffalo at the Cambodia Development Resource Institute. In 2000, he taught at the Faculty of Law and Economics in Phnom Penh as the first-ever Fulbright scholar to Cambodia.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2016
• Language: English
• ISBN 10: 1533001715
• ISBN 13: 9781533001719
• Binding: Paperback
• Edition number: 1
• Number of pages: 28