Book excerpt: Appending worksheets from a workbook

One of the most common scenarios of working with Excel files is the existence of workbooks that have multiple worksheets of the same format. But, can all worksheets from a workbook be appended into a single table? Can new worksheets automatically be appended in the next refresh? For answers, read this excerpt from Gil Raviv’s…

0

Creating charts and objects

In this sample chapter from MOS 2016 Study Guide for Microsoft Excel, learn about exam objectives related to presenting data in charts and enhancing worksheets through images, business diagrams, and text boxes.

0

Date and date functions in Excel 2016

In this chapter from Microsoft Excel Data Analysis and Business Modeling, 5th Edition, author Wayne Winston explores the most commonly used month-day-year formats in Microsoft Excel 2016.

0

Lookup functions in Excel 2016

In this chapter from Microsoft Excel Data Analysis and Business Modeling, 5th Edition, author Wayne Winston discusses the syntax of lookup functions in Microsoft Excel 2016.

0

ebook deal of the week: Microsoft Excel Data Analysis and Business Modeling, 5th Edition

Save 50%! Buy here. This offer expires Sunday, January 22 at 7:00 AM GMT. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide will help you apply Excel 2016’s most valuable innovations for data analysis and business modeling. It’s packed with realistic problems and solutions to help you gain mastery—including over 150 that are new or…

0