Working with Cells and Sheets
Introduction to working with cells and sheets
Introduction to working with cells and sheets
1. Introduction to working with cells and sheets.mp4
Write data in a cell
Write data in a cell
2. Write data in a cell.mp4
Change the format of a cell
Change the format of a cell
3. Change the format of a cell.mp4
Setup automatic formatting of cells
Setup automatic formatting of cells
4. Set up automatic formatting of cells.mp4
Insert new rows
Insert new rows
5. Insert new rows.mp4
Insert new columns
Insert new columns
6. Insert new columns.mp4
Freeze or unfreeze rows and columns
Freeze or unfreeze rows and columns
7. Freeze or unfreeze rows and columns.mp4
Insert and delete individual cells
Insert and delete individual cells
8. Insert and delete individual cells.mp4
Sort your data
Sort your data
9. Sort your data.mp4
Filter your data
Filter your data
10. Filter your data.mp4
Insert a new sheet
Insert a new sheet
11. Insert a new sheet.mp4
Rename a specific sheet
Rename a specific sheet
12. Rename a specific sheet.mp4
Hide or unhide a sheet
Hide or unhide a sheet
13. Hide or unhide a sheet.mp4
Protect sheets and ranges from being edited
Protect sheets and ranges from being edited
14. Protect sheets and ranges from being edited.mp4
Remove gridlines in sheets, charts and graphs
Remove gridlines in sheets, charts and graphs
15. Remove gridlines in sheets, charts, and graphs.mp4
Prevent invalid data entry
Prevent invalid data entry
16. Prevent invalid data entry.mp4
Import data and spreadsheets
Import data and spreadsheets
17. Import data and spreadsheets.mp4
Split pasted text into separate columns
Split pasted text into separate columns
18. Split pasted text into separate columns.mp4
Save, reuse, and share filters
Save, reuse, and share filters
19. Save, reuse, and share filters.mp4
Filter data by condition
Filter data by condition
20. Filter data by condition.mp4
Create an in-cell dropdown list
Create an in-cell dropdown list
21. Create an In-cell Dropdown List.mp4
Automate tasks with macros
Automate tasks with macros
22. Automate tasks with macros.mp4
Edit your macros
Edit your macros
23. Edit your macros.mp4