Xem mẫu
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 Advanced worksheet Functions 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 Views, Scenarios, goal seek and solver 51 2.1 Goal Seeking and Solving 52 2.2 Views & Scenarios 62
Section 3 Using Excel to Manage Lists 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 Click on the ad to read more Download free eBooks at bookboon.com
Excel 2007 Advanced: Part I Contents
3.4 Filtering a List 82 3.5 List Statistics 100 3.6 Pivottables 103 3.7 Managing Pivottables 118
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 Introduction to Templates Part II
Section 6 Auditing Part II 6.1 Auditing Features Part II
Section 7 Other formatting Part II 7.1 Formatting Cells Part II
Section 8 Other Excel features Part II 8.1 Inserting, Formatting and Deleting Objects Part II 8.2 Reviewing Part II 8.3 Proofing Tools Part II
360° thinking
Discover the truth at www.deloitte.ca/careers
5
Download free eBooks at bookboon.com
© Deloitte & Touche LLP and affiliated entities.
Click on the ad to read more
...
- tailieumienphi.vn
nguon tai.lieu . vn