Microsoft Excel - Expert

Course subjects

Open Power Query

• Open Power Query

• Configure Power Query

• Add Power Pivot

• Modify the Quick Access Toolbar

• Configure Power Query

Get Data

• Import Data from:

  • CSV File

  • Excel Table, List, Pivoted Data

  • Folder

  • PDF File

• Type in the Data

• Load the Data to Excel

Transform Data

• Applied Steps

• Deleting Applied Steps

• Adding Applied Steps

• Editing Data using

  • Fill Down

  • Trim

  • Replace Values

• Filters

• Modify the Filter Manually

• Format

• Removing Errors

• Unpivoting Data

Working with Columns

• Deleting Columns

• Renaming Columns

• Adding Columns

• Standard and Custom Date Columns

• Renaming Applied Steps

• Create a Conditional Column

Working with Queries

• Grouping Queries: Creating Query Groups

• Appending Queries

• View the Loaded Queries

• Rename Queries

• Reloading the Queries

• View the Re-loaded Queries

• Stop a Single Data Load

• Stop Multiple Data Loads

• Extended Exercise: Macro

Power Pivot

• Data Model

• Add Tables to a Data Model

• Arrange the Data Model

• Connect the Data Model using Create

• Connect the Data Model using Manage

• Connect the Data Model using Click and Drag

• Pivot Table

• Pivot Table from Excel

• Pivot Table from Power Pivot

• Measure in Power Pivot

• Sum in DAX

• Pivot Table for Measures

• Measure with Filter

Data Types

• Standard Data Types

• Stock Data Type

• Uploading Stock Data Type

• Displaying Extra Data

• Custom Data Type - Get Data

• Custom Data Type - Transform Department Data

• Custom Data Type - Transform Countries Data

• Custom Data Type - Merge Data

• Create Custom Data Type

• Create Custom Report

• Extend the Custom Report

Office Script

• Load file into OneDrive

• Office Script

• Before You Record a Script

• Start Recording

• Edit the Script

• Rename the Script

• Change the Chart Title

• Script a Dynamic Range

• Script a Loop

• Power Automate Online

• Open Power Automate

• Start Power Automate and Select Trigger

• Add an Action

• Add a Second Action

• Check the Flow

• Test the Flow

Power Automate Desktop

• The Setup 104

• Start Desktop from Online

• Working with Excel

• Launch Excel Action

• Read from Excel Action

• Create new List Action

• Write to Excel Worksheet Action

• Working with the Browser

• Get the Converter Page

• Looping Through Currencies

• Create a For Each Action

• Retrieving the Rates

• Using the Recorder

• Edit the Recording

• Copy Actions

• Save Value to a List Action

• Running the PAD

• Run the Actions

• Finding the bug