Đang chuẩn bị liên kết để tải về tài liệu:
Ebook Excel 2007 Advanced: Part 1

Ebook Excel 2007 Advanced - Part 1 presentation on the main contents: advanced worksheet functions; views, scenarios, goal seek and solver; using excel to manage lists. Invite you to consult the document details. | Excel 2007 Advanced: Part I Stephen Moffat, The Mouse Training Company Download free books at Stephen Moffat, The Mouse Training Company Excel 2007 Advanced Part I 2 Download free eBooks at bookboon.com Excel 2007 Advanced: Part I © 2012 Stephen Moffat, The Mouse Training Company & bookboon.com ISBN 978-87-403-0033-8 3 Download free eBooks at bookboon.com Excel 2007 Advanced: Part I Contents Contents Introduction 6 Section 1 dvanced worksheet Functions A 8 1.1 Names 9 1.2 Using Names 15 1.3 Conditional & Logical Functions 19 1.4 AND, OR, NOT 25 1.5 Lookup Functions 27 1.6 Other Useful Functions 35 1.7 Data consolidation 47 Section 2 iews, Scenarios, goal seek and solver V 51 2.1 Goal Seeking and Solving 52 2.2 Views & Scenarios 62 Section 3 sing Excel to Manage Lists U 71 3.1 Excel Lists, List Terminology 72 3.2 Sorting Data 73 3.3 Adding Subtotals to a List 79 www.sylvania.com We do not reinvent the wheel we reinvent light. Fascinating lighting offers an infinite spectrum of possibilities: Innovative technologies and new markets provide both opportunities and challenges. An environment in which your expertise is in high demand. Enjoy the supportive working atmosphere within our global group and benefit from international career paths. Implement sustainable ideas in close cooperation with other specialists and contribute to influencing our future. Come and join us in reinventing light every day. Light is OSRAM 4 Download free eBooks at bookboon.com Click on the ad to read more Excel 2007 Advanced: Part I 3.4 Filtering a List 3.5 Contents 82 List Statistics 100 3.6 Pivottables 103 3.7 118 Managing Pivottables Section 4 Charts Part II 4.1 Introduction to Charting Part II 4.2 Formatting Charts Part II Section 5 Templates Part II 5.1 Part II Introduction to Templates Section 6 Auditing Part II 6.1 Part II Auditing Features .