Learn Excel 2016 Part - 2
This video includes information on:
• Freezing and unfreezing rows and columns
• Opening a new window for a workbook
• Splitting worksheets
This video includes information on:
• Types of sorting
• Sorting sheets and ranges
• Creating a custom sort
• Adding levels
This video includes information on:
• Filtering data
• Applying multiple filters
• Clearing filters
• Using advanced text, number, and date filters
This video includes information on:
• Adding and editing headers, which appear in the top margin
• Adding and editing footers, which appear in the bottom margin
• Adding and editing page numbers to a document
• Restarting page numbering
This video includes information on:
• Formatting data as a table
• Adding rows or columns to a table
• Changing the table style and modifying table style options
• Removing a table
This video includes information on:
• Understanding and inserting charts
• Switching row and column data
• Changing chart types
• Moving and updating charts
This video includes information on:
• Understanding conditional formatting
• Creating a conditional formatting rule
• Using preset conditional formatting
• Removing conditional formatting
This video includes information on:
• Turning on Track Changes
• Reviewing tracked changes
• Adding, editing, showing, hiding, and deleting comments
This video includes information on:
• Using the Document Inspector
• Protecting your workbook
This video includes information on:
• Using PivotTables to answer questions
• Creating PivotTables
• Adding columns
• Changing rows and columns
This video includes information on:
• Adding filters
• Adding slicers
• Creating a PivotChart
This video includes information on:
• Using GoalSeek
• Other types of What-If Analysis
SHARE THE COURSE WITH YOUR CLASSMATES
WE HOPE YOU ENJOY !