Excel 2013 - Building Your Skills: Efficiency and Effectiveness in Excel - Couverture souple

Clearer Courses; Clewett, Tricia; Stewart, Donna

Couverture souple

ISBN 10 : 107827990X ISBN 13 : 9781078279901

Editeur : Independently published, 2019

Synopsis

This book is aimed at anyone who uses Excel and wants to delve a little deeper. It assumes that you know how to enter data into an existing spreadsheet but are less confident about setting up your own. In a step-by-step way with lots of illustrations, examples and exercises to try, we will walk you through: Extended Paste Features; Creating and Using Hyperlinks; Protecting Your Worksheets and Workbooks; Establishing Linked sheets in 3-Dimensional Tables; Analysing Data in Tables using Filters and Subtotals; An Introduction to PivotTables; Advanced Charting using Wider Range of Chart Types and Sources; How Formulas Work; Conditional Processing including Conditional Formatting and IF statements; Lookup Tables and Quick Analysis Features.You can work through the book systematically or just focus on the things you need for your job. Each section starts with a description of what's going on and ends with a summary so that you can easily navigate to the things that matter most to you. If you do work through it all, you will be able to: •Create more complex formulas and functions including those based on specific values•Connect and link different documents together using special paste features, 3-D links and hyperlinks•Analyse data using tables and filters and pivot tables•Protect data against both accidental errors and intentional harm.And if that all sounds a bit too complicated, maybe you should start with our Excel 2013 - Mastering the Essentials, available on Kindle for just £9.99.

Détails de l'édition

• Éditeur: Independently published
• Date d'édition: 2019
• Langue: anglais
• ISBN 10: 107827990X
• ISBN 13: 9781078279901
• Reliure: Broché
• Nombre de pages: 215
• Coordonnées du fabricant: Manufactured by Amazon on behalf of the author; https://www.amazon.fr/hz/contact-us; ; c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy; Luxembourg; L-1855; Luxembourg