Intermediate Excel

by M L Humphrey

Overview

Microsoft Excel is an amazing tool. Once you've mastered the basics, it's time to learn a few tips and tricks to take things to the next level.

In this guide you'll learn how to create pivot tables, chart your data, apply conditional formatting, and many other more advanced tools for getting the most out of Excel. (Including probably more than you ever wanted to know about nested IF functions.)

If you're comfortable with the basics of Excel and ready to take it to the next level, this is the guide for you.

Product Details

ISBN-13:	9781950902019
Publisher:	M.L. Humphrey
Publication date:	05/09/2019
Series:	Excel Essentials , #2
Pages:	110
Product dimensions:	7.50(w) x 9.25(h) x 0.23(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