Laserfiche WebLink
Being able to harness the power of PivotTable features & create Pivot Charts will help students gain an edge. Not <br />only will students be able to summarize data to analyze, but they can organize the data in a way that can be <br />meaningfully presented to others. <br />Acquired Skills <br />Prepare data for PivotTable reporting and create PivotTables from various data sources. <br />Analyze Data Using PivotTables. <br />Work with Pivot Charts. <br />Excel 2016: Formulas and Charts <br />Description <br />In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets <br />and Workbooks. <br />Acquired Skills <br />Upon successful completion of this course, students will be able to create Intermediate Formulas and Charts using <br />Microsoft Office Excel 2016. <br />Excel 2016: Tables, Pivot Tables and Conditional Formatting Description <br />In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot <br />Tables. <br />Acquired Skills <br />Tables <br />Conditional Formatting <br />Pivot Tables <br />Pivot Charts <br />Summarize PivotTable Data <br />Organize PivotTable Data <br />Filter PivotTable Data <br />Format a PivotTable <br />Refresh and Change a PivotTable <br />Excel 2019 - Part 1 <br />Description <br />This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to <br />eventually become an expert in data manipulation. Excel can help you organize, calculate, analyze, revise, update, <br />and present your data in ways that will help the decision makers in your organization steer you in the right direction <br />It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional <br />pen -and -paper methods or non -specialized software. <br />Acquired Skills <br />Perform calculations. <br />Modify a worksheet. <br />Format a worksheet. <br />Print workbooks. <br />Manage workbooks. <br />Excel 2019 - Part 2 <br />Description <br />This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2019: Part 1 course <br />and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your <br />understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable <br />information from it, and present that information to decision makers is at the foundation of a successful organization <br />that is able to compete at a high level. <br />Acquired Skills <br />Work with functions. <br />Work with lists. <br />Analyze data. <br />