In this webinar Excel expert David H. Ringstrom will guide you on extracting PDFs with Power Query, exploring Power Query properties, enhancing external data security, creating Excel tables, adding total rows, filtering tables with slicers, utilizing functions such as IF, nested IF, VLOOKUP, IFNA, and MATCH, as well as INDEX/MATCH functions, XLOOKUP for horizontal lookup, automating tasks with macros, creating macro icons, applying conditional formatting for greater than scenarios, utilizing data bars, managing scenarios effectively, and summarizing Scenario Manager features.

Learning Objectives:
• State which XLOOKUP argument causes an alternate value to be displayed in lieu of #N/A.
• Identify the items that can be added to a PivotTable from the PivotTable field list.
• Recall the section of the Excel Options dialog box where the AutoRecover setting resides that controls how often Excel creates a back-up copy of your workbooks.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Upon course completion a course evaluation form is provided for your feedback.

You have 1 year from the time of purchase/enrollment to complete the course.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/