English | 19 Jun. 2018 | ISBN: 1983213667 | 141 Pages | MOBI

We’ve all been there before, staring at a computer screen with no idea what to do — don’t worry Fundamentals of Excel 2016 is here to help.

We’ll guide you through the ins and outs of Microsoft Excel, we’ll take a look at the ribbon menus and where to find all your tools.

We’ll go through entering data, manipulating data, formatting spreadsheets, adding formulas and functions.

We’ll build data analysis scenarios and analyse data, create pivot tables, charts and reports. As well as data validation rules and techniques.

Finally, a look at working with Excel workbooks, opening sheets, copying data between them, printing sheets, formulas, charts, and more…