Advanced Excel – Part 1 Current Status Not Enrolled Price Closed Get Started This course is currently closed Course Content Expand All 4.3.09 Working with External Data: Power Query Editor- The View tab 1 Quiz Expand Lesson Content Working with External Data: Power Query Editor – The View Tab 4.3.10 Working with External Data: Power Query Editor- The Formula Bar 1 Quiz Expand Lesson Content Working with External Data: Power Query Editor – The Formula Bar 5.1 Advance Pivot Table: Grouping options in pivot (Yearly, Quarterly, Date Wise, No slab wise) 1 Quiz Expand Lesson Content Grouping options in pivot (Yearly, Quarterly, Date Wise, No slab wise) 5.2 Advance Pivot Table: Percentage option (Percentage of total, Percentage of column, Percentage of row) 1 Quiz Expand Lesson Content Percentage option (Percentage of total, Percentage of column, Percentage of row) 5.3 Advance Pivot Table: Sorting 1 Quiz Expand Lesson Content Advance Pivot Table: Sorting 5.4 Advance Pivot Table: Filtering 1 Quiz Expand Lesson Content Advance Pivot Table: Filtering 5.5 Advance Pivot Table: Updating 1 Quiz Expand Lesson Content Advance Pivot Table: Updating 5.6 Advance Pivot Table: Formatting 1 Quiz Expand Lesson Content Advance Pivot Table: Formatting 5.7 Advance Pivot Table: Internal and External Source Data 1 Quiz Expand Lesson Content Advance Pivot Table: Internal and External Source Data 6. Refresh Advanced Excel – Part 1-Course Feedback 2 of 2
