018760 a2200301 4500 20231115100100.0 | |c l|1| |a || 002-16-2 49 Intellezy Business eng COM084000 https://covers.odilo.io/public/Excel_2016_Intermediate/Excel2016.jpg https://covers.odilo.io/public/Excel_2016_Intermediate/Excel2016_225x318.jpg Edward McCrae 156027 Excel 2016 Intermediate Intellezy Business 240 This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. Customizing Excel, Linking Workbooks and Worksheets, Working with Range Names, Analyzing Data with Common Logical Functions, Analyzing Data with Common Lookup Functions, Sorting and Filtering Range Data, Analyzing and Organizing with Tables, Using Conditional Formatting, Outlining with Subtotals and Grouping, Displaying Data Graphically, Understanding PivotTables and PivotCharts and Filtering with Slicers, Working with Flash Fill, Working with Date and Time Functions, Working with Common Text Functions Computers / Desktop Applications Computing & information technology https://login.zproxy.cun.edu.co/login?url=https://bibliotecacun.odilotk.es/opac?id=00758162 item ddc E-BOOK 58377 58377