Control+T ---- Create a table
Data/ Tbale-Remove Duplicates. ----- Remove duplicate rows
Text Filter in the filter in each column-----Filter
Number in the filter in each column-----Number Filter/ Select TOP 10
Structured referencing
=Average(table 1[expense ratio]), we can use this to select column data.
=AVERAGEIF([Category],[@Category],[Total Return 2019])
[Category] tells Excel to use the entire range of categories (column M)
[@Category] tells it to use just the single value in the current row
Using Get And Transform
Mac doesn't have the full function of getting data source, we can only import the data Excel file.
Initials
Go to Data click get data power Query
Cleaning the data by using Replace value or replace errors in Transform Tab
Transform the data by using Standard in Transform Tab
Close and load the data by using Close and load in Home Tab
Sorting
Sort Descending
add a column by using index column in add column Tab
Filter the index column by using less than
Start an Excel table
Control+T ---- Create a table Data/ Tbale-Remove Duplicates. ----- Remove duplicate rows Text Filter in the filter in each column-----Filter Number in the filter in each column-----Number Filter/ Select TOP 10
Structured referencing
=Average(table 1[expense ratio]), we can use this to select column data.
Using Get And Transform
Initials
Sorting
Sort Descending add a column by using index column in add column Tab Filter the index column by using less than
Repeating Queries
By using the right bar