There are 16 free training skills of how to use office suite for Spreadsheet
Split the screen for data comparison
01:21Refresh pivotTable and change data source
01:28Print out tables
02:43How to convert numbers into percentages
01:08Page setup and print-out for spreadsheets
02:07Set the Table Header and Footer
02:10INDEX MATCH formulas
02:11Use IFS function to check whether multiple conditions are met
02:47Conditional Formatting for data virtualization
01:23Use formula to set the conditional formatting
01:28The INDEX function
03:50Conditional Formatting to highlight top three items
01:37Use color scales to make the temperature chart
00:43Use VLOOKUP function to create dynamic charts
03:44Skillfully use Conditional Formatting to highlight performance
01:21Create the double-layer doughnut chart
03:22