Excel 2013 - Building Your Skills: Efficiency and Effectiveness in Excel - Brossura

Clearer Courses; Clewett, Tricia; Stewart, Donna

Brossura

ISBN 10: 107827990X ISBN 13: 9781078279901

Casa editrice: Independently published, 2019

Riassunto

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.

Dettagli dell?edizione

• Editore: Independently published
• Data di pubblicazione: 2019
• Lingua: Inglese
• ISBN 10: 107827990X
• ISBN 13: 9781078279901
• Rilegatura: Copertina flessibile
• Numero di pagine: 215
• Contatto del produttore: non disponibile