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

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.