Excel Interview Workbook by Norman Ling
English | 22 Jan. 2016 | ASIN: B01AZN9KVQ | 169 Pages | PDF (True) | 22.71 MB                                                

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, accountant, 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.

Not only do you get a book full of screenshots and examples, the accompanying website includes practice exercises and sample data for download. These practice exercises will help you hone your skills so that you will be well prepared for your interview.

Table of Contents (161 pages)
Chapter 1 Introduction
Chapter 2 Cell, Column, and Row Manipulations
Chapter 3 Filtering and Sorting Data
Chapter 4 Tables
Chapter 5 VLOOKUP and HLOOKUP
Chapter 6 Pivot Tables
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
Chapter 14 Excel Shortcuts
Chapter 15 Macros