Microsoft InfoPath 2010 Level 1

Modules

Hide all

Lesson 1: Creating Macros (6 topics)

• Creating a Macro
• Comparing Relative and Absolute Macros
• Running a Macro
• Editing a Macro
• Assigning Shortcuts to Macros
• Macro Security

Lesson 2: Collaborating With Others (3 topics)

• Protected Views
• Tracking Changes
• Workbook Merging

Lesson 3: Using Form Controls (3 topics)

• Creating a Form
• Creating a Custom Form
• Protecting Controls and Linked Cells

Lesson 4: Analysing Data (5 topics)

• Creating a Single Input Data Table
• Creating a Two-Variable Data Table
• Creating Scenarios
• What If Analysis using Goal Seek
• Consolidating Data

Lesson 5: Data Validation (5 topics)

• Number Validation
• Data List Validation
• Message Prompts and Alerts
• Conditional Data Validation
• Data Validation Errors

Lesson 6: Creating PivotTables, PivotCharts and Slicers (9 topics)

• Creating a PivotTable
• Amending the fields in a PivotTable
• Updating the PivotTable
• Adding Calculations to a PivotTable
• Add Grouping to a PivotChart
• Creating a PivotChart
• Slicers
• PivotTable Timelines
• Creating from Tables and Related Tables

Lesson 7: Import and Export Data (3 topics)

• Exporting Excel Data
• Importing Delimited Text
• Importing a Web Query

Lesson 8: Power Views (3 topics)

• Inserting a Power View Sheet
• Modifying the Power View Fields and Filters
• Adding Additional Visualisations