Excel Interview Workbook
by Norman Ling /
2016 / English / PDF
22.7 MB Download
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
