Microsoft Excel 2016 Step by Step by Curtis Frye

Microsoft Excel 2016 Step by Step by Curtis Frye PDF

The quick way to learn Microsoft Excel 2016!

Microsoft Excel 2016 – This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers–brisk lessons and full-color screen shots show you exactly what to do, step by step.

  • Quickly set up workbooks, enter data, and format it for easier viewing
  • Perform calculations and find and correct errors
  • Filter, sort, summarize, and combine data
  • Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
  • Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
  • Build data models and use them in business intelligence analyses
  • Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
  • Look up just the tasks and lessons you need

Book Review by Bob W

Excellent soup to nuts guide to Excel

I disagree with most of the other reviewers. I am an experienced EXCEL user. I work with it daily. Like most Microsoft Office prodcucts, Excel has amazing depth of functionality. Most of this value is hidden from most of us. This isn’t intentional obfuscation; it’s the result of a lot of people working to make the product better for many years. A book like this is necessary to begin to plumb these depths.

It’s true that the book starts at the beginning and uses a very clear, assume-the-reader-knows-nothing attitude. I skipped the basics and went straight for the pivot charts and data manipulation including macros. I appreciated the down-to-earth style in those rarefied areas. I needed step-by-step examples to understand what to do.

My point is that any book about software is going to embrace a style that might not appeal to everyone. Step By Step is a manual. It isn’t a novel. You don’t really need to start at chapter one and read to the end. It’s very easy to find the stuff you need to learn. Once you find it, the book does its job and teaches you. That’s great!

If you are a rank beginner at Excel, this book is useful for you but is probably overkill. There are less expensive guides to the basics. But if you, like me, are a regular user, then this book will help fill in the knowledge gaps and make strong users into power users. It’s easy to read and accurate. As far as the downloadable examples go, I never bothered with them. I got what I needed from the book, which now permanently sits next to my work computer.

We also Recommend

About the Author

Curtis Frye is the author of more than 30 books, including Microsoft Excel 2013 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for, including Excel for Mac 2016 Essential Training and Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.