tailieunhanh - Ebook Excel 2016 Advanced

Ebook Excel 2016 Advanced presentation on the main contents: Apply conditional logic in formula, create and apply range names, charts, apply and manipulate illustrations, smartart, shapes, screenshots, manage comments inserting and editing com, sorting data, filtering data, format as table, filter a table, grouping and outlining, subtotals, apply conditional formatting, sparkline charts, text functions, quick analysis, macros. | Excel 2016 Advanced Shelley Fishel Download free books at SHELLEY FISHEL EXCEL 2016 ADVANCED Download free eBooks at 2 Excel 2016 Advanced 1st edition © 2016 Shelley Fishel & ISBN 978-87-403-1199-0 Download free eBooks at 3 EXCEL 2016 ADVANCED Contents CONTENTS About Shelley Fishel 8 About Excel 2016 Advanced 9 1 Apply Conditional Logic in formula 10 IF Function (IF Statement) 10 Nested IF Function 11 Countif Function 13 Sumif Function 14 2 Create and apply Range Names 16 Defining a Named Cell or Range of Cells 16 Using a Named Cell in a formula 17 Naming a range of cells 20 Editing and renaming a named range 23 Define a Name Using the Dialogue Box 25 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 4 Click on the ad to read more EXCEL 2016 ADVANCED Contents 3 Charts 28 Using Quick Analysis 28 Recommended Charts 28 Creating charts with the keyboard 30 Creating line charts 32 Creating and editing a column chart 34 Creating pie charts 35 Modifying charts using the Ribbon 37 Modifying charts using icons 43 Formatting charts – Task Pane 46 4 Apply and manipulate illustrations 50 Pictures in Excel 50 Resize the picture – dragging 53 Modify a picture 55