Excel 2013 - Building Your Skills: Efficiency and Effectiveness in Excel (Clearer Courses - Excel)

Clearer Courses/ Clewett, Tricia/ Stewart, Donna

ISBN 10: 107827990X / ISBN 13: 9781078279901

Published by Independently published, 2019

About this Item

215 pages. 11.69x8.27x0.54 inches. In Stock.

Seller Inventory # zk107827990X

Bibliographic Details

• Title: Excel 2013 - Building Your Skills: Efficiency and Effectiveness in Excel (Clearer Courses - Excel)
• Publisher: Independently published
• Publication Date: 2019
• Language: English
• ISBN 10: 107827990X
• ISBN 13: 9781078279901
• Binding: Paperback
• Condition: Brand New

About this title

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.