"Bullets of sweat are running down my face as I glance at the clock at the bottom right corner of my screen. I’m interviewing for my first job out of college, and I’m struggling through the Excel assessment. I'm trying to concentrate, but the seeming impossibility of the challenge has sent me into a spiral of self-doubt and exasperation. I had thought that four years of economics and math would have prepared me for this. Yet here I was, stuck on a formula.
Do you have an upcoming interview involving an Excel assessment? Are you looking to sharpen up your Excel skills? Are you looking to land that prestigious corporate position that will jump start your career? Whether you are a college student or a seasoned professional, Excel Interview Workbook will teach you exactly what you need to know, leaving out the unnecessary details and esoteric nuances.
Having been a consultant, project manager, and analyst, I am intimately familiar with the most important Excel skills that you’ll need to be comfortable with. Knowing those skills may mean the difference between landing that important job or getting rejected. Unlike the overwhelming majority of Excel books and interview guides available, I teach you how to APPLY the most important features and functions to analyze data, work efficiently, and generate actionable recommendations.
I am not aware of any other resource out there that provides the type of information contained in this book. It is a culmination of years of both work experience and interview experience. My goal is to help you succeed in your job search.
You can purchase Excel Interview Workbook for $9.99 through Amazon here. Note that this book is an electronic textbook, rich with images, charts, and screenshots. You'll either need a Kindle Fire or computer to consume the book's contents. In addition, downloadable practice exercises and data can be found on this page. If you are just getting started with Excel, I highly recommend that you start by reading this page since my book is not a beginner's guide to Excel.
See Some Examples
Downloads by Chapter
If you are just getting started with Excel, I highly recommend that you start by reading this page since my book is not a beginner's guide to Excel.
Chapter 3 - Filtering and Sorting
Chapter 4 - Tables
Chapter 5 - VLOOKUP and HLOOKUP
Chapter 6 - PivotTables
Chapter 7 - If-Statements
Chapter 8 - SUMIFS, AVERAGEIFS, COUNTIFS
Chapter 9 - COUNT and COUNTA
Chapter 10 - Formatting and Conditional Formatting
Chapter 11 - Charts
Chapter 12 - Selecting Special Cells
Chapter 13 - Basic Text Functions
Excel Interview Framework
I have created an interview framework that neatly ties together the various pieces you need to know. It will give you a good high-level view of what your interviewers are looking for, and provide you a general idea of how to tackle the problems you may be given. If you are interested in obtaining a copy, send an e-mail to firstname.lastname@example.org.