Intermediate Excel

by M L Humphrey

Overview

An intermediate guide to Microsoft Excel that walks users through how to use pivot tables, charts, conditional formatting, functions such as CONCATENATE, IF, COUNTIFS, SUMIFS, and TEXT, as well as a number of other intermediate-level Excel tricks. Written using Excel 2013.

Product Details

ISBN-13:	9781950902712
Publisher:	M.L. Humphrey
Publication date:	07/30/2019
Series:	Excel Essentials , #2
Pages:	110
Product dimensions:	7.50(w) x 9.25(h) x 0.31(d)

About the Author

M.L. Humphrey is a former stockbroker with a degree in Economics from Stanford and an MBA from Wharton who has spent close to twenty years as a regulator and consultant in the financial services industry.

Table of Contents

Introduction, Basic Terminology, Conditional Formatting, Inserting Symbols, Pivot Tables, Subtotaling and Grouping Data, Charts – Discussion of Types, Charts – Editing, Removing Duplicate Entries, Converting Text to Columns, The CONCATENATE Function, The IF Function, The COUNTIFS Function, The SUMIFS Function, The TEXT Function, Limiting Allowed Inputs Into a Cell, Locking Cells or Worksheets, Hiding a Worksheet, Creating a Two-Variable Analysis Grid, What I Haven’t Covered and How To Learn It On Your Own, Conclusion