Laserfiche WebLink
.._=Acquire d Skills _ _Mom&, W n-_.. x <br />Working with Procedures and Functions <br />Understanding Objects <br />Using Expressions, Variables, and Intrinsic Functions <br />Controlling Program Execution <br />Working with Forms and Controls <br />Working with the PivotTable Object <br />Debugging Code <br />Handling Errors <br />Excel 2016 - Part 1 <br />Description <br />Are you looking to become a proficient Excel user? Professional Excel training from can get you on the path to <br />mastering this popular data spreadsheet software. <br />Through completing the introductory Excel 2016 training course, you'll develop foundational data manipulation <br />knowledge and skills that you can build upon through additional training and use. With the Excel 2016 - Part 1 <br />course under your belt, you'll feel confident using one of the world's most powerful applications. <br />Acquired Skills <br />Write a range of fundamental Excel commands <br />Perform worksheet calculations <br />Build custom formulas <br />Amend elements in a worksheet <br />Apply formatting changes to cells <br />Manage workbook properties <br />Excel 2016 - Part 2 <br />Description <br />You've mastered the basics of Excel. In Excel 2016 - Part 2 training, you'll build upon your data manipulation skills <br />and unlock more capabilities within the platform. <br />Deepen your understanding of Excel by learning how to create advanced workbooks and worksheets. With Part 2 <br />training from under your belt, you'll be ready to create custom formulas, apply built-in Excel functions and <br />manipulate data to extract the insights you need. <br />Acquired Skills <br />Perform calculations using functions and formulas <br />Sort, filter and query data <br />Create and format tables <br />Visualize data with charts <br />Create advanced formulas <br />Analyze data with PivotTables and Pivot Charts <br />Excel 2016 - Part 3 <br />Description <br />Excel is a powerhouse spreadsheet software used by companies small and large. Master this popular platform by <br />completing the Excel 2016 - Part 3 course from . <br />This advanced Excel course builds off learnings from Excel 2016 - Parts 1 & 2 and prepares you to complete <br />difficult Excel tasks such as LOOKUPS, macros and more. The course also covers Microsoft Office Specialist exam <br />objectives to help you prep for the certification exam. <br />Acquired Skills <br />Refer to internal and external worksheets <br />Perform LOOKUPS and audit formulas <br />Share and protect workbooks <br />Automate workbook functionality using validation rules and macros <br />Create sparklines and map data <br />Forecast data <br />Excel 201612019: Data Analysis with Pivot Tables <br />