An easy-to-use and practical guide on how to get the most out of the world's most popular spreadsheet application. Packed with essential information, Step-by-step guides, Program jargon explained, Basic use and working with large spreadsheets, Calculations, PivotTables, charts, printing, formulas, 'Excel on the Go' - smartphones, tablets, online, Up-to-date but still applicable to older versions and Macs, Packed with screenshots and everyday case studies, Troubleshooting for typical problems, Clear, concise and accessible
About the Author
Roger Laingis a writer, journalist and tweeter who covers all things business and technology-related. He has written and edited many books and magazines on social media, PCs, the Internet, web design and information technology – as well as travel. He has an MA in Experimental Psychology from Oxford University.
Mark Mayne. (series foreword) He is Editor of T3.com, the UK's leading consumer tech lifestyle website, and has been writing on technology-related subjects for many years. His background is in daily national news and pureplay digital publishing, copywriting, consultancy with specialist knowledge on consumer technology, SEO, social media and b2b technology.
Table of Contents
Series Foreword 5
What is Excel?: Find out what all that spreadsheet jargon means and follow our no-nonsense instructions on using workbooks 8
Working with Excel: Discover quick techniques for working with cells as well as entering, deleting and editing data 32
Carge Spreadsheets: Excel's tools for dealing with large amounts of data - from freezing panes and multiple views to subtotals and PivotTables 56
Advanced Excel: The best techniques and step-by-step guides to running calculations, creating charts and printing out your spreadsheets 80
<$$$> How to avoid some common problems in Excel and resolve them if they do occur 114
<$$$> Using mobile apps or Excel Online to create and edit your spreadsheets 116
<$$$> Websites and Further Reading 126