Ebook Excel 2016 Advanced

Excel 2016 Advanced Shelley Fishel Download free books at SHELLEY FISHEL EXCEL 2016 ADVANCED Download free eBooks at bookboon.com 2 Excel 2016 Advanced 1st edition © 2016 Shelley Fishel & bookboon.com ISBN 978-87-403-1199-0 Download free eBooks at bookboon.com 3 EXCEL 2016 ADVANCED Contents CONTENTS About Shelley Fishel 8 About Excel 2016 Advanced 9 1 Apply Conditional Logic in formula 10 1.1 IF Function (IF Statement) 10 1.2 Nested IF Function 11 1.3 Countif Function 13 1.4 Sumif Function 14 2 Create and apply Range Names 16 2.1 Defining a Named Cell or Range of Cells 16 2.2 Using a Named Cell in a formula 17 2.3 Naming a range of cells 20 2.4 Editing and renaming a named range 23 2.5 Define a Name Using the Dialogue Box 25 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 Download free eBooks at bookboon.com Click on the ad to read more 4 EXCEL 2016 ADVANCED Contents 3 Charts 28 3.1 Using Quick Analysis 28 3.2 Recommended Charts 28 3.3 Creating charts with the keyboard 30 3.4 Creating line charts 32 3.5 Creating and editing a column chart 34 3.6 Creating pie charts 35 3.7 Modifying charts using the Ribbon 37 3.8 Modifying charts using icons 43 3.9 Formatting charts – Task Pane 46 4 Apply and manipulate illustrations 50 4.1 Pictures in Excel 50 4.2 Resize the picture – dragging 53 4.3 Modify a picture 55 4.4 Reset a picture 61 5 SmartArt 62 5.1 SmartArt 62 6 Shapes 66 6.1 Inserting shapes into a workbook 66 7 Screenshots 69 7.1 Inserting a screenshot 69 8 Manage comments 72 8.1 Inserting and editing comments 72 8.2 Deleting comments 74 8.3 Show/Hide Comments 75 8.4 Moving between comments 76 8.5 Printing comments 77 9 Sorting data 79 9.1 Databases in Excel – introduction 79 9.2 Sort data 79 9.3 Sort on font colour 84 9.4 Sort on cell colour 85 9.5 Sort on cell icon 86 Download free eBooks at bookboon.com 5 ... - tailieumienphi.vn