Excel is a great resource for teaching students many important skills, like data visualization, data organization and information restructuring, filtration, quick calculations, data interpretation, and tabulation,
Home
Comprises options like font size, font styles, font colour, background colour, alignment, formatting options and styles, insertion and deletion of cells and editing options
Insert
Comprises options like table format and style, inserting images and figures, adding graphs, charts and sparklines, header and footer option, equation and symbols
Page Layout
Themes, orientation and page setup options are available under the page layout option
Formulas
Since tables with a large amount of data can be created in MS excel, under this feature, you can add formulas to your table and get quicker solutions
Data
Adding external data (from the web), filtering options and data tools are available under this category
Review
Proofreading can be done for an excel sheet (like spell check) in the review category and a reader can add comments in this part
View
Different views in which we want the spreadsheet to be displayed can be edited here. Options to zoom in and out and pane arrangement are available under this category
Comprises options like font size, font styles, font colour, background colour, alignment, formatting options and styles, insertion and deletion of cells and editing options
Comprises options like table format and style, inserting images and figures, adding graphs, charts and sparklines, header and footer option, equation and symbols
Themes, orientation and page setup options are available under the page layout option
Since tables with a large amount of data can be created in MS excel, under this feature, you can add formulas to your table and get quicker solutions
Adding external data (from the web), filtering options and data tools are available under this category
Proofreading can be done for an excel sheet (like spell check) in the review category and a reader can add comments in this part
Different views in which we want the spreadsheet to be displayed can be edited here. Options to zoom in and out and pane arrangement are available under this category
10 spreadsheet tips and tricks to maximize Google sheets
Freeze rows and columns
Use conditional and alternative formatting
Use add-ons
Use a template
Learn how to use comments and notes
Use Google forms with google sheets
Check the version History
Find and replace
Create Filters
Protected sheets and ranges
Note: Refer to the 5:02 to 8:48 of the video to learn more about the Microsoft excel