Adv Microsoft Excel AND Macro

FREE LAPTOP

Advance Microsoft Excel 2016 - 2021

Using a Pivot Table Filtering and Sorting Data Grouping Data INPUT TABLES One

- Input Data Tables Two

- Input Data Tables CHARTS Combin ed Line and Column Chart

• Adding a Secondary Axis
• Changing the Chart Type For a Data Series
• Adding a Data Series to a Chart
• Removing a Data Series from a Chart
• Modifying the Chart Title,
• Legend & Data Labels Chart Axis Scales
• Inserting Images Into Chart Columns
• Formatting the Chart Area HYPERLINKS
• Inserting a Hyperlink Editing a Hyperlink
• Removing a Hyperlink
• IMPORTING TEXT FILES Importing a Delimited Text File
• LINKING AND EMBEDDING
• Linking Data within a Worksheet
• Linking Cells between Worksheets within a Workbook
• Linking Data between Workbooks
• Linking Data from Excel to a Word Document
• Linking an Excel Chart to a Word Document
• Updating, Locking and Breaking
• Links SORTING AND FILTERING DATA
• Sorting Data by Multiple Columns Custom Sorts
• SORTING AND FILTERING cont..
• Customized List AutoFilter Top 10 AutoFilter Advanced Filter Criteria Sub - Totalling Removing Subtotals Expanding and Collapsing Outline Detail TRACKING AND REVIEWING CHANGES Enabling or Disabling 'Track Changes' Sharing, Comparing and Merging Worksheets SCENARIOS Scenario Manager and Summary Reports